Excel Functions and Features Quiz

Which Excel function returns the smallest number in a range from B2 to B20?

• =LOW(B2:B20)

• =MIN(B2:B20)

• =SMALL(B2:B20)

• =LOWEST(B2:B20)

In Excel, pressing F4 after selecting a cell reference in a formula will:

• Convert it to an absolute reference

• Delete the cell content

• Refresh the worksheet

• Open the Format Cells dialog

Which of the following is an example of Application Software?

• Linux

• Microsoft Excel

• BIOS

• Device Driver

Which Excel chart type displays vertical bars for comparing data across categories?

• Line Chart

• Clustered Column Chart

• Pie Chart

• Area Chart

Which tool in Excel automatically completes text entries when it detects a pattern?

• Data Validation

• Flash Fill

• Format Painter

• AutoCorrect

What is the purpose of Axis Titles in a chart?

• To identify the data series

• To label the horizontal or vertical axes

• To format the chart background

• To filter chart data

Which Excel feature allows you to split the worksheet window into multiple panes?

• Freeze Panes

• Page Break Preview

• Split Window

• Arrange All

In Excel, which symbol is used for division in formulas?

• ÷

• /

• \

• DIV

Which shortcut key is used to undo the last action in Windows?

• CTRL + Y

• CTRL + Z

• CTRL + U

• CTRL + Q

Which function counts all cells containing numbers in a range?

• COUNTA

• COUNTIF

• COUNT

• SUM