30 Questions | Total Attempts: 48  Settings  • 1.
Ed arranged his spreadsheet so that he could view the cell range A1:A10 and Row 2 while he worked in cells on Row 179. This is an example of which operation?
• A.

Embed

• B.

Fill Series

• C.

Freeze

• D.

• 2.
Mrs. Jay uses a spreadsheet to keep track of student test scores and daily grades. Which function should she use to calculate a final grade for each student?
• A.

Average

• B.

Count

• C.

If

• D.

Sum

• 3.
Mr. Evans sorted the students athletes in order by GPA, last name, first name, and homeroom. GPA is an example of which part of the sort operation?
• A.

Ascending

• B.

Desending

• C.

Primary

• D.

Secondary

• 4.
What Operation will Eve use to keep rows and columns visible so that they don't scroll off the screen as she moves around the worksheet?
• A.

Embed

• B.

Freeze

• C.

• D.

Fill series

• 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.
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

• 7.
In the formula =f10*\$J\$4, F10 is an example of a/an?
• A.

Absolute reference

• B.

Mixed reference

• C.

Range

• D.

Relative reference

• 8.
In the formula =f10*\$j\$4,\$j\$4 is an example of a/an?
• A.

Absolute reference

• B.

Mixed reference

• C.

Reange

• D.

Relative reference

• 9.
In the formula =\$A1+B1, \$A1 is an example of  a/an:
• A.

Absolute reference

• B.

Mixed reference

• C.

Range

• D.

Relative reference

• 10.
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:E5

• 11.
A B  C  D E 1 Name Instrument  Per Month Fee   Number of Months Total Cost 2 Tom saxphone  \$   45.00 10  \$    450.00 3 Joan clarinet  \$   35.00 10  \$    350.00 4 Heather trumpet  \$   60.00 5  \$    300.00 5 Stan drums  \$   55.00    \$           -   6 Jose flute  \$   42.00    \$           -   7 Total Rental Fee  \$ 1,100.00 In the MiddleSchool Band spreadsheet, what formula will calculate the total cost per year for the saxophone?
• A.

=B2*C2/10

• B.

=B2/10*C2

• C.

=C2/D2

• D.

=C2*D2

• 12.
A B  C  D E 1 Name Instrument  Per Month Fee   Number of Months Total Cost 2 Tom saxphone  \$   45.00 10  \$    450.00 3 Joan clarinet  \$   35.00 10  \$    350.00 4 Heather trumpet  \$   60.00 5  \$    300.00 5 Stan drums  \$   55.00    \$           -   6 Jose flute  \$   42.00    \$           -   7 Total Rental Fee  \$ 1,100.00 What format has been applied to Cells C1 and D1?
• A.

Border

• B.

Merge

• C.

Wrap

• D.

• 13.
A B  C  D E 1 Name Instrument  Per Month Fee   Number of Months Total Cost 2 Tom saxphone  \$   45.00 10  \$    450.00 3 Joan clarinet  \$   35.00 10  \$    350.00 4 Heather trumpet  \$   60.00 5  \$    300.00 5 Stan drums  \$   55.00    \$           -   6 Jose flute  \$   42.00    \$           -   7 Total Rental Fee  \$ 1,100.00 What formula is used to calculate the Toal Rental Fee?
• A.

=sum(E2:E6)

• B.

=sum(C2:E6)

• C.

=Total(c2:C6)*(D2:D6)

• D.

=Sum(D2:D6)

• 14.
C4 is known as the_________ in spreadsheet
• 15.
A file that contains one or more speadsheets
• 16.
Text or numbers that will not be used in calculations is known as?
• 17.
Data that has potential to be used in calculation.
• 18.
Name the 4 functions that can be used?
• 19.
What is the default setting of a label?
• 20.
What is the default setting of a value?
• 21.
What does ###### mean?
• 22.
Used to combine two or more cells;
• 23.
Used to alighn multi-lined text within a cell
• 24.
A               B C 1 Budget 2 Income   3 Paycheck 2,000.00 4 Birthday Money 150.00 5 Babysitting 50.00 6 Total Income 2200.00 7 Expenses   8 Rent  575.00 9 Power 95.00 10 Car Payment 375.00 11 Cable 75.00 12 Gas 100.00 13 Food 200.00 14 Entertainment 200.00 15 Total Expenses 1620.00 16 Net Income/Loss  \$ 580.00 The placement of the individual income items in Cells A3:A6 and expense items in Cells A8:A15 is the result of which formatting?
• A.

Border

• B.

Indent

• C.

Merge

• D.

Wrap

• 25.
A               B C 1 Budget 2 Income   3 Paycheck 2,000.00 4 Birthday Money 150.00 5 Babysitting 50.00 6 Total Income 2200.00 7 Expenses   8 Rent  575.00 9 Power 95.00 10 Car Payment 375.00 11 Cable 75.00 12 Gas 100.00 13 Food 200.00 14 Entertainment 200.00 15 Total Expenses 1620.00 16 Net Income/Loss  \$ 580.00 The Net Income/Loss value in Cell C16 is the result of which operation?
• A.

• B.

Division

• C.

Multiplication

• D.

Subtraction

Related Topics Back to top