NEW
Font size
S
M
L
XL
WorksheetsEXCEL REVIEW 1
Total questions: 30
Worksheet time: 14mins
Name
Class
Date
1.
What do you call the blank boxes on a spreadsheet?
a)
cells
b)
info
c)
squares
d)
spots
2.
What would be a correct formula for sum in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
3.
_____ are vertical.
a)
Rows
b)
Columns
4.
________ are horizontal
a)
Rows
b)
Columns
5.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
a)
Cell address
b)
Worksheet
c)
Formula
6.
Microsoft Excel is what type of software?
a)
Word Processing
b)
Spreadsheet
c)
Presentation
d)
Drawing
7.
Excel allows you to
a)
read stories
b)
work with data
c)
invent ideas
8.
Which symbol must you use to begin a formula?
a)
+
b)
=
c)
/
d)
*
9.
How do you make a cell the active cell?
a)
Click the ACTIVE button
b)
Click INSERT CELL
c)
Click on the cell
d)
Cells are always active
10.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
11.
_________ allows you to perform calculations on data entered into a spreadsheet?
a)
Formulas
b)
Data
c)
Cell
d)
Cell reference
12.
True or False: Spreadsheets can be used in everyday life by analyzing sports stats, grades, and creating a budget for expenses?
a)
True
b)
False
13.
What is the Formula sign for multiply?
a)
*
b)
-
c)
/
d)
+
14.
In a spreadsheet, where can cells be found?
a)
At the top, where each column is defined
b)
At the bottom, where all the numbers are added up
c)
On the right-hand side, where each row is defined
d)
At the intersection of every row and every column
15.
In Excel, what currency format is this in?
a)
Accounting
b)
Currency
c)
General
d)
It’s not in a currency format
16.
Which of the following formulas is correctly written for Excel?
a)
=5B*4
b)
5+8=
c)
D3/4=
d)
=b1-d23
17.
What is the formula to calculate the MAXIMUM of a range of cells?
a)
=(MAX)B3:B8
b)
= MAX(B3:B8)
c)
MAX(B3:B8)=
d)
= MAXIMUM(B3:B8)
18.
What is the formula to calculate the MINIMUM of a range of cells?
a)
= MIN(B3:B8)
b)
= MIN:B3:B8
c)
=MINIMUM(B3:B8)
d)
MIN(B3:B8)=
19.
“Top”, “middle”, “bottom”, “center” and “left” are all types of this:
a)
Fonts
b)
Alignment options
c)
Styles
d)
Charts
20.
Absolute cells are identified by the _____________ symbol.
a)
Hash tag
b)
Asterisk
c)
Dollar sign
d)
Ampersand
21.
What would the result be if you copied this formula: =A1+B1 DOWN to the next cell:
a)
=A2+B2
b)
=B1+C1
c)
=B2+C2
d)
=A1+B1
22.
What would the result be if you copied this formula: =A1+B1 to the cell on the RIGHT:
a)
=A1+B1
b)
=B2+C2
c)
=B1+B2
d)
=B1+C1
23.
What would the result be if you copied this formula: =$A$1+B1 to the cell on the RIGHT:
a)
=A1+C1
b)
=$A$1+B1
c)
=$A$1+C1
d)
=$A$1+B2
24.
What is this?
a)
A square
b)
A cell
c)
Fill handle used to copy contents to another cell
d)
An arrow pointing to a square
25.
An electronic document in which data is arranged in the rows and columns of a grid and can be manipulated and used in calculations.
a)
Spreadsheet
b)
Database
c)
Report
d)
Table
26.
Luisa is creating a worksheet tracking her company’s spending on a project. However, when viewing her document, she has noticed that some of the cells contain pound signs like in the example below.
Which of the following suggestions would help Luisa?
Which of the following suggestions would help Luisa?
a)
Make the cell wider
b)
Change the number formatting in the cell
c)
Change the font format in the cell
d)
Delete the data and re-type it
27.
Jun is the director of a summer camp. This spreadsheet contains campers’ names, information, and their counselors.
Which two features will help him sort the list by counselor, and then print out a list containing only the campers’ and counselors’ names?
a)
Track Changes
b)
Hide Columns
c)
Formatting
d)
Custom Sorting and Hide Columns
28.
Alex needs to add three cells and then divide the sum by 4. Which of the following is an example of the correct formula to do this?
a)
=(A1+A2+A3)/4
b)
A1+A2+A3/4
c)
=A1+A2+A3^4
d)
(A1+A2) + A3/4
29.
Minh wanted to find the average of all of her grades, but can not get her function work. Her spreadsheet is below. What error is Min making?
a)
She has the incorrect arguments
b)
She has the wrong function name
c)
She is missing an equal sign at the beginning of her formula
d)
The colon should be replaced with a dash (-)
30.
Gerilynn wanted to find the total amount of vanilla cakes ordered. Which of the following formulas should she use?
a)
=(C3+C5+C9)/3
b)
=SUM(C2:C10)
c)
=AVERAGE(C2:C10)
d)
=(C3+C5+C9)
Reset
