ACC 1.03 Create Spreadsheets

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)
• $ (dollar sign)

Refer to the spreadsheet below. Most of the totals in C13 through G13 were formatted using which number style?

• comma style
• accounting
• general
• number

Refer to the spreadsheet below. To get all the labor hours in column B to look consistent, what command format should be used?

• General
• Percentage
• Increase Indent
• Increase Decimal

Refer to the spreadsheet below. Which formula is used to calculate the 6% tax of the SUBTOT?

• =3,192.60 X 6%
• =F11*.06
• =6%/F11
• =F11*F12

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

• formula
• function
• label
• value

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?

• Formulas Page
• Insert Page
• Page Layout
• Review

Which cell addresses contain numeric labels?

• A3:F3
• A5:A8
• B5:B8
• E5:F8

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:

• =E5/$E$12.
• =E6/$E$12.
• =E6/$E$13.
• =E5/$E$13.

In the spreadsheet below, the data in A7 through A11 was entered preceded by an apostrophe. This data is identified as being which of the following?

• Numeric Label
• Label
• Range
• Value

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)