Ms. Excel - Final Quiz

What is the purpose of the SUM function in Excel?

• To find the average

• To add numbers together

• To count cells

• To find the maximum value

How do you start a formula in Excel?

• With an equals sign (=)

• With a plus sign (+)

• With a minus sign (-)

• With a colon (:)

Which function would you use to find the average of a range of numbers?

• SUM

• AVERAGE

• COUNT

• MAX

How can you quickly sum a column of numbers?

• Use the SUM function

• Use the MAX function

• Use the MIN function

• Use the AVERAGE function

What does the MIN function do?

• Adds numbers

• Finds the smallest number

• Counts cells

• Finds the largest number

Which function returns the highest value in a range?

• MAX

• MIN

• SUM

• AVERAGE

What is the purpose of the COUNT function?

• To count the number of cells with numbers

• To add numbers

• To find the average

• To find the maximum value

How do you refer to a cell in Excel?

• By its row number only

• By its column letter only

• By its row number and column letter

• By its cell color

What is the default alignment for text in Excel cells?

• Left

• Right

• Center

• Justify

What is the default alignment for numbers in Excel cells?

• Left

• Right

• Center

• Justify