BA10 1.03

Data can be entered into a cell as a numeric label (used to identify or name information) by first entering which character?

• : Colon

• + plus sign

• ' Apostrophe

• $ Money

Tameka wants to change the orientation of her spreadsheet from landscape to portrait. On which tab of the Excel ribbon will this command be found?

• Page Layout

• Insert Bar

• Home

• Formula Bar

Samantha needs to total the values in cells A1 to A10. What is the most efficient method to find the answer?

• Function (ex: =SUM(A1:A10)

• Formula (ex: =A1+A2+A3+A4+A5+A6+A7+A8+A9+A10)

• Data Sort

• Label

The formula in G5 is =E5/$E$12. Using the fill handle to copy this formula down to G6, the copied formula will read as:

• =E6/$E$12.

• =E7/$E$13.

• =E8/$E$12.

• =E10/$E$12.

Samantha needs to total the values in cells A1 to A10. Which should she enter to find the answer?

• =SUM(A1:A10)

• SUM(A1+A10)

• =TOTAL(A1:A10)

• TOTAL(A1+A10)

In an Excel spreadsheet, what is the correct formula to multiply the value in B6 by the value in C12?

• (C12 X B6)

• =B6*C12

• =B6 X C12

• (C12*B6)

The data in A7 through A11 was entered preceded by an apostrophe (Ex: '28734). This data is identified as being which of the following?

• Numeric Label

• Value

• Label

• Range

In the formula =MAX(G4:G19), the cell references are an example of which term?

• Cell Location

• Label

• Value

• Cell Range