Excel Functions and Data Handling Quiz

Which function would you use to add up only the cells that meet a certain condition?

• SUMIF

• COUNTIF

• AVERAGEIF

• CONCATENATE

Which function would you use to add up all the sales figures in a month?

• SUM

• MAX

• ROUND

• COUNT

Which function would you use to find the highest test score in a class?

• SUM

• MAX

• ROUND

• COUNT

If you want to count all the cells that are not empty, which function should you use?

• COUNT

• COUNTA

• MAX

• ROUND

Which function would you use to round a number to the nearest whole number?

• ROUND

• SUM

• MAX

• COUNT

When you need to keep labels or titles in view at the top or left edge of the worksheet as you scroll through it, you can ________ them in place.

• Lock

• Freeze

• Hide

• Move

When worksheet data will not fit on one page, Excel inserts automatic ________.

• Page breaks

• Margins

• Headers

• Footers

The CONCATENATE function requires a text argument.

• True

• False

Which function allows you to count cells based on multiple criteria?

• COUNT

• COUNTIF

• COUNTIFS

• COUNTA

Which function calculates the average of cells that meet a specified condition?

• AVERAGEIF

• SUMIF

• COUNTIF

• MEDIAN