KLGREENS Excel Basic Assessment

How can you quickly highlight all the BLANK cells in the table shown in image?

• CTRL A -> F5 -> Special -> Blanks

• Press CTRL, select every blank cells

• Press SHIFT, select every blank cells

• CTRL F -> Find blank data

Holding down the __________ key and scrolling the mouse wheel backward will zoom out.

• TAB

• SHIFT

• CTRL

• ALT

This is the Zoom Slider in Excel. How can you use this to zoom in/out?

Multiple answers

• Click on the - | + icons

• Drag the slider left | right

• Place you mouse cursor on the slider line and scroll forward | backward

• It is just to show the zoom level, cannot use it to change zoom level

Entering formula in Excel is the most required skill for any Excel users. Refer to the diagram

• Insert an equation

• Show the sum, count, or average of the selected cells

• Toggle between the 5 primary Excel functions

• Insert a function

There are 3 different cell reference types in Excel: Relative, Absolute, and Mixed. Refer to the diagram

• Because the reference to the task duration in hours is absolute, whereas it should be relative

• Because the reference to the hourly rate is relative, whereas it needs to be absolute

• It will

• Because you can't copy formula down to adjacent cells in an Excel worksheet

Worksheet navigation is an important skill in Excel. Refer to the diagram

• Right-click on the arrows to the left of SHEET1

• Double-click on any of the worksheets

• You can't

• Click on the + symbol to the right of the worksheets

Data visualization using chart is an essential product of using Excel. Refer to the diagram

• Annotations

• Value captions

• Legend entries

• Data labels

You are given data as shown in the image and your manager wants you to present it in a chart. Which one is the most suitable chart type?

• Treemap

• Pie chart

• Waterfall

• Line chart

• Column chart

What is the purpose of Filters area in the diagram?

• Slicing the overall data

• Organizing data horizontally

• Organizing data vertically

• Performing calculations on the data

What is the purpose of Columns area in the diagram?

• Slicing the overall data

• Organizing data horizontally

• Organizing data vertically

• Performing calculations on the data