Accounting 1 (1.03 Quiz)

Which of the following is the correct way to write a function in a spreadsheet?

• =SUM(A1-A5)

• =SUM A1+A5

• SUM (A1:A5)=

• =SUM(A1:A5)

The contents in cells A1 through A6 are 6, 3, 4, 7, 9, and 7. What function would return the answer 6?

• =MAX(A1:A6)

• =MIN(A1:A6)

• =AVERAGE(A1:A6)

• =SUM(A1:A6)

After entering the number of sales for the first quarter, where will they align in a spreadsheet?

• Right

• Left

• Centered

• Justified

If you need to change a cell containing to 358.98887 to 358.99 what command is needed?

• increase decimal

• decrease decimal

• increase indent

• decrease indent

A numeric decimal needs to be changed to what format in Accounting worksheets?

• Percentage

• General

• Currency

• Accounting

Which symbol must be used to turn numeric data into labels?

• • + plus

• ' apostrophe

• = equals

• ~ tilda

Paul has to enter a unit price for a product. How will this data be classified?

• Label

• Value

• Formula

• Function

Which term refers to the column letter and row number in a spreadsheet?

• Cell address

• Cell content

• Formula bar

• Chart title

Which of the following formulas in Figure 1 was used to calculate the 6% tax of the SUBTOT?

• =3,192.60 X 6%

• =F11*.06

• =6%/F11

• =F11*F12

In Figure 1, INVOICE was positioned over multiple cells using which command?

• Wrap Text

• Format Painter

• Middle Align

• Merge & Center