NEW
Font size
S
M
L
XL
WorksheetsSpreadsheet Items Quiz 2
Total questions: 25
Worksheet time: 13mins
Name
Class
Date
1.
In the formula =$A1+B1, $A1 is an example of a/an
a)
absolute reference
b)
mixed reference
c)
range
d)
relative reference
2.
What procedure should be followed to ensure that an object does NOT change in a word processing document when it is edited in the spreadsheet of its original creation?
a)
Embed
b)
Import
c)
Link
d)
Target
3.
Which function can an accounting department use in Cell A2 that will result in the current date?
a)
Count
b)
CountA
c)
Days360
d)
Now
4.
Which function can a credit card company use to determine the time that has elapsed since a customer's payment was received?
a)
Count
b)
CountA
c)
Days360
d)
Now
5.
What function will calculate the total cost of merchandise plus the tax calculated at a rate of 7.5%of the total merchandise cost?
a)
Average
b)
Max
c)
Min
d)
Sum
6.
Ernie uses a spreadsheet to maintain inventory at his store and wants to use a formula that will automatically reorder items when they reach a certain quantity. Which formula should he use?
a)
If
b)
LookUp
c)
Max
d)
Min
7.
What function will display the word "Yes" when the value in Cell A! is greater than the value in Cell B1 and "No" when otherwise?
a)
If
b)
LookUp
c)
Max
d)
Min
8.
What function should Eva use to calculate her final grade if her exam counts 25%, her test grades count 25%, and her daily work counts 50%?
a)
Average
b)
If
c)
Max
d)
Min
9.
Purchase discounts are awarded as follows: 3% for sales of $300. 5% for sales of $500, and 9%for sales of $900 or more. What function is used to determine which discount is allowed based on the purchase price?
a)
Count
b)
Fill Series
c)
List
d)
LookUp
10.
A spreadsheet is created with drop down items that a user can select from. This is an example of which function?
a)
Count
b)
Fill Series
c)
List
d)
Lookup
11.
What formula will divide the value in Cell E5 by the value in Cell E6?
a)
=E5/E6
b)
=E5:E6
c)
=E6/E5
d)
=E6:E6
12.
The number of hours worked is recorded in Cell D7. Hourly rate is recorded in Cell E7. Overtime hours occur anytime the number of hours worked is greater than 40. Which formula correctly determines how many (if any) overtime hours have occured
a)
=IF(D7<40),1.5*E7
b)
=IF(D7>40,D7-40)
c)
=MAX(D1:D7)*1.5
d)
=OVERTIME(D7*E7)
13.
In the Middle School Band Spreadsheet, what formula will calculate the total cost per year fro the saxophone?
a)
=B2*C2/10
b)
=B2/10*C2
c)
=C2/D2
d)
=C2*D2
14.
In the Middle School Band spreadsheet, what format has been applied to Cells C1 and D1?
a)
Border
b)
Merge
c)
Shade
d)
Wrap
15.
In the Middle School Band spreadsheet, what formula is used to calculate the total cost of the clarinet?
a)
=B3*C3
b)
=C3*D3
c)
=C3/D3
d)
=E3/C3
16.
In the Middle School Band spreadsheet, what formula is used to calculate the Total Rental Fee?
a)
=SUM(C2:E6)
b)
=SUM(D2:D6)
c)
=SUM(E2:E6)
d)
=TOTAL(C2:C6)*(D2:D6)
17.
In figure 23, the #### in Cell E14 is the result of which formatting error?
a)
Height
b)
Justification
c)
Width
d)
Wrap Text
18.
In figure 23, the alignment of "Transaction" in Cell A8 and "Credits" in Cell E8 are the result of which formatting error?
a)
Height
b)
Justification
c)
Width
d)
Wrap text
19.
In figure 23, the alignment of "Running Balance" in Cell F8 is the result of which formatting ?
a)
Height
b)
Shading
c)
Width
d)
Wrap Text
20.
In Figure 23, the automatic completion of the Transaction Numbers in Column A is the result of which operation?
a)
Embed
b)
Fill Series
c)
Freeze panes
d)
Link
21.
In Figure 23, the alignment of the main heading in Row 1 is the result of which formatting?
a)
Autosum
b)
Merge cells
c)
Fill series
d)
Wrap text
22.
In Figure 23, the value of Cell F11 is the result of:
a)
addition
b)
division
c)
multiplication
d)
subtraction
23.
In Figure 23, the number format applied to the values in B10:B17 is:
a)
currency
b)
date
c)
decimal
d)
percent
24.
In Figure 23, what function was used to calculate Total Debts in Cell C4?
a)
Average
b)
Max
c)
Min
d)
Sum
25.
In Figure 23, the amount in Cell F10 is the result of:
a)
addition
b)
division
c)
multiplication
d)
subtraction
Reset
