Excel Skills Quiz

Labels (text) are aligned at the _________________ edge of the cell.

• Left

• Right

• Top

• Bottom

You can complete a cell entry by pressing:

• Enter

• Tab

• An arrow key

• All of the above

If you choose a larger font size, the height of the row is automatically made taller.

• True

• False

Which button allows you to copy cell formats from one cell to another?

• Enter

• Autofit

• Format painter

• Esc

All formulas in Excel begin with the following symbol:

• +

• =

• %

• #

Which formula below will add the value of B2 to the value of C3?

• =B2+C3

• =B2+B3

• =2+3

• =B+C

Which of the following option is a formula?

• Add A1 - A5

• Subtract the numbers from A1 to A5

• A1 = A5

• =SUM(A1:A5)

A selection of mulitple cells is called a:

• Range

• Group

• Reference

• Package

In the following IF Statement, =IF(A3=0,"YES","NO"), what is the value if the statement is false?

• 0

• YES

• NO

• A3

In the following IF Statement, =IF(A3=0,"YES","NO"), what is the value if the statement is true?

• 0

• YES

• NO

• A3