Font size
WorksheetsAccounting 1 (1.03 Quiz)
Total questions: 13
Worksheet time: 8mins
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
In Figure 1, choose the correct entry to calculate the AMOUNT 1,595.00.
=B7*E7
=F5 X F6
=SUM(F5*F6)
=E7 X F5
Which tab in Excel is used to change the orientation of a spreadsheet from landscape to portrait?
Formulas Page
Insert Page
Page Layout
Review
Match the following:
SUM
function used to add
589 used to identify row data
Numeric Label
Word used to identify column data
Label, Header, Title
=
Must begin all formulas or functions
$ 5890.00
Accounting Format
