NEW
Font size
WorksheetsQuizizz Study Guide for Excel Final
Total questions: 40
Worksheet time: 14mins
What does the colon mean? D5 : F5
Through
And
Continue
Then
Shipping: Without given cost
=(A1*8%)
=(A1*$0.00)
=(A1*.06)
=(A1+B1)
How do you start a formula?
=(
;(
:(
=)
Can you have multiple sheets in one Workbook?
Yes
Sheets?
No
Possibly
What is letter "B"?
Chart Area
Plot Area
Legend/Key
X-Axis
The numbers going down the left hand side of the worksheet are known as?
Row
Numbers
Column
Cells
What is letter "E"?
y-axis
Legend/Key
x-axis
Chart Area
What is letter "C"?
Plot Area
Legend/Key
x-axis
Chart Area
What is letter "D"?
y-axis
Legend/Key
x-axis
Chart Area
What is letter "A"?
y-axis
Legend/Key
x-axis
Chart Area
Shipping: With given cost
=(A1*8%)
=(A1+$0.00)
=(A1*.06)
=(A1+B1)
Sales Tax
=(A1*8%)
=(A1*$0.00)
=(A1*.06)
=(A1+B1)
Total
=(A1*8%)
=(A1+B1)
=(A1*.06)
=(A1*B1)
Grand Total
=(A1*8%)
=(A1+B1+C1)
=(A1*.06)
=(A1*B1*C1)
Average/Mean
=(A1*8%)/3
=(A1+B1+C1)/3
=(A1*.06)/3
=(A1*B1*C1)/3
What is the correct formula to find the Total for an item priced at $9.99?
A1: Cost is $9.99
B1: Quantity is 2
C1: Total is _
D1: Tax is _
E1: Shipping is _
F1: Grand Total _
=(A1*B1)
=(A1+C1)
=(F1*E1)
=(D1+B1)
What is the correct formula to find the Grand Total for an item priced at $9.99?
A1: Cost is $9.99
B1: Quantity is 2
C1: Total is _
D1: Tax is _
E1: Shipping is _
F1: Grand Total _
=(C1+D1+E1)
=(A1+D1+B1)
=(F1+A1+E1)
=(C1+F1+E1)
The letters going across the top of the worksheet are known as, _.
Row
Column
Cells
Ruler
The numbers going down the left hand side of the worksheet are known as, _.
Column
Ruler
Cells
Row
In your worksheet you have invisible margins that look like several rectangles, these are known as?
Rectangles
Columns
Cells
Boxes
When selecting multiple cells to merge or colorfil this is known as _.
Drag N' Drop
Color Fill
Fill in the blank
Highlighting
What is the correct formula to find the Shipping for an item priced at $9.99, when shipping cost is $5.99?
A1: Cost is $9.99
B1: Quantity is 2
C1: Total is _
D1: Tax is _
E1: Shipping is _
F1: Grand Total _
=(C1*$5.99)
=(C1+$5.99)
=(C1+8%)
=(C1*.08)
What is the correct formula to find the Shipping for an item priced at $9.99, when not given a shipping cost?
A1: Cost is $9.99
B1: Quantity is 2
C1: Total is _
D1: Tax is _
E1: Shipping is _
F1: Grand Total _
=(C1*8)
=(C1+8%)
=(C1+.08)
=(C1*.08)
What is the correct formula to find the Tax for an item priced at $9.99?
A1: Cost is $9.99
B1: Quantity is 2
C1: Total is _
D1: Tax is _
E1: Shipping is _
F1: Grand Total _
=(C1+.06)
=(C1*6)
=(C1*6%)
=(C1*.60)
Previously I had you type January in a random cell. In order for Excel to auto fill the rest of the months you needed to place your cursor on the bottom right corner of the selected cell and do what?
Drag N' Drop
Select
Highlight
Paint fill
What is your cursor telling you?
Drag N' Drop
Highlight
Move selected item
Normal cursor
What is your cursor telling you?
Drag N' Drop
Highlight
Move selected item
Cell
What is your cursor telling you?
Drag N' Drop
Highlight
Move selected item
Cell
Letter "A" is the cursor to change the ______ height
Column
Row
Contextual Tab
Drag N' Drop
Letter "B" is the cursor to change the ______ width
Column
Row
Contextual Tab
Drag N' Drop
"A" is called what?
Y-Axis
X-Axis
Z-Axis
E-Axis
"B" is called what?
Y-Axis
X-Axis
Z-Axis
E-Axis
"A" is called what?
Icons
Contextual Tabs
Margins
Groups
"B" is called what?
Icons
Dialogue Box
Margins
Groups
"C" is called what?
Icons
Dialogue Box
Margins
Groups
"D" is called what?
Contextual Tabs
Dialogue Box
Tabs
Groups
"E" is called what?
Document Title
Presentation Title
Workbook Title
Title
"F" is called what?
Dialogue Box
Icons
Groups
Ribbon
This picture shows words stacked on top of each other in one cell, this is called what?
Merging
Wrap Text
Wrap the Words
Stacking
The arrow is pointing to tabs that appear when you select a chart, what are those tabs called?
Tabs
Ribbon
Wrap Text
Contextual Tab
