CL - MS Excel Part 3

What would be a correct formula for SUM in excel?

• =SUM(B3:B9)
• =SUMB3+B9
• SUM(B3:B9)
• =ADD(B3:B9)

Which function finds the largest value of a range of cells?

• MAX

• MIN

• LARGE

• SUM

Which function finds the smallest value of a range of cells?

• MAX

• MIN

• SMALL

• SUM

Which symbol must all formulas begin with?

• =

• +

• (

• @

Which Ribbon option puts 2 or more cells together and centers the data?

• Merge & Center

• Center & Align

• Merge & Adjust

• None of these

Absolute cell references change when copied from cell to cell.

• True

• False

Which Ribbon option can be used to show the formulas in a worksheet?

• Display Formulas

• Show Formulas

• Make Formulas Visible

• View Formulas

What do you call a reference to the active cell when entering a formula?

• Circular Reference

• Loop

• Cell Looping

• None of these

What number type is used in the format values such as social security numbers or phone numbers?

• Date

• Long Data

• Special

• Custom

Which number format is represented by 04/27/2021?

• Long Date

• Special Date

• Short Date