NEW
Font size
S
M
L
XL
WorksheetsGoogle Sheets Review
Total questions: 20
Worksheet time: 16mins
Name
Class
Date
1.
What is a vertical section of a spreadsheet
a)
row
b)
addition
c)
column
d)
format
2.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
3.
The correct formula to add cell B1 and B2 is
a)
AddB1+C1
b)
=sum(B1+C1)
c)
=B1+B2
4.
B1 is a?
a)
row
b)
column
c)
cell
d)
sheet
5.
What number is in D1?
a)
1
b)
2
c)
blank
d)
4
6.
=A1*B1
a)
2
b)
3
c)
4
d)
Error
7.
All formulas in Microsoft Excel begin with the following symbol:
a)
+
b)
-
c)
=
d)
%
8.
=B1+C1
a)
2
b)
3
c)
4
d)
Error
9.
Opening a new file in this app is called a
a)
row
b)
column
c)
cell
d)
sheet
10.
D1-C1
a)
2
b)
3
c)
4
d)
Error
11.
What number should be in E1 (based on the formula)?
a)
1
b)
2
c)
5
d)
9
12.
Which is the correct formula to add cells A1 to A5?
a)
=SUM(A2+A5)
b)
=SUM(A1:A5)
c)
=A1+A2+A3
d)
=SUM(A1:A4)
13.
Which letter on the image is a Column?
a)
A
b)
B
c)
C
d)
D
14.
Which letter on the image is a Row?
a)
A
b)
B
c)
C
d)
D
15.
If I want to make a cell a particular color, which button would I click on?
a)
orange arrow
b)
red arrow
c)
blue arrow
d)
green arrow
16.
Which of the following is NOT Cash Flow OUT
a)
Tips
b)
Wages
c)
Rent
d)
Electricity
17.
Shows where the money Goes
a)
Breakeven
b)
Cash flow
18.
Available Cash is calculated by
a)
Adding Beginning Cash & Money Out
b)
Adding Beginning Cash & Money In
c)
Subtracting Money Out from Beginning Cash
d)
Subtracting Money In from Beginning Cash
19.
Fixed Cost/Selling Price
a)
Cash Flow
b)
Break Even
c)
None of the Above
20.
Fixed Cost/(Selling Price-Variable Cost)
a)
Cash Flow
b)
Break Even
c)
None of the Above
Reset
