Excel Functions and Formulas

What is the default reference type in Excel?

• Absolute reference

• Relative reference

• Mixed reference

In Excel, how can you create an absolute reference?

• By using the $ symbol before the column and row

• By using the % symbol before the column and row

• By using the & symbol before the column and row

• By using the # symbol before the column and row

Fill in the blank: A relative reference corresponds to a cell location in a workbook and changes when users move the formula to another _______.

• cell

• sheet

• workbook

• file

The purpose of using different cell reference types in a workbook is to:

• allow dynamic updating of formulas when copied

• restrict changes to specific cells

• enhance the visual appearance of the workbook

• improve the speed of calculations

Which is an example of a structured reference formula?

• =SUM(A1:A10)

• =SUM(Table1[Sales])
• =AVERAGE(A1:A10)

Label the following statement as true or false: Blank cells and zeros do not count against an average.

• True

• False

Which function in Excel counts only the blank cells within a range of data?

• COUNT

• COUNTA

• COUNTBLANK

• SUM

What is the purpose of the COUNT function in Excel?

Use a count function to count the number of grades greater than 70 in cells B4:M4. What function should you use?

• COUNTIF

• COUNTA

• COUNTBLANK

• COUNTIFS

Use a count function in cell U4 to count the number of grades in cells B4:M4. What function should you use?

• COUNT

• SUM

• AVERAGE

• MAX