Excel Functions and Features Quiz

What is the intersection of a row and a column called?

• Table

• Cell

• Grid

• Sheet

Which function is used to add a group of numbers in Excel?

• AVERAGE

• SUM

• COUNT

• MAX

A cell reference that adjusts when copied is called:

• Absolute Reference

• Relative Reference

• Mixed Reference

• Static Reference

Which function gives the largest value in a range?

• SUM

• AVERAGE

• MAX

• MIN

Which symbol is used to start a formula in Excel?

• @

• $

• #

• =

What does the COUNT function do?

• Counts text entries

• Adds numbers

• Counts numeric values

• Finds errors

What is an Absolute Cell Reference?

• B2

• B$2

• $B2

• $B$2

What is the purpose of Freeze Panes?

• To keep rows/columns visible while scrolling

• To sort data

• To merge cells

• To apply filters

Which function finds the smallest value?

• MAX

• AVERAGE

• COUNT

• MIN

Which key is used to edit a cell?

• F1

• F2

• F2

• Esc