WorksheetsBIM 1 Excel 9 Weeks Review
Total questions: 16
Worksheet time: 7mins
Name
Class
Date
1.
What kind of software is Excel?
a)
Word processing software
b)
Spreadsheet Software
c)
Data Base Software
2.
In Excel rows are labeled by
a)
letters
b)
numbers
c)
rows and numbers
3.
In excel, columns are labeled by
a)
Letters
b)
Numbers
c)
Letters and numbers
4.
What button will add up a group of numbers
a)
Equals button
b)
Plus symbol button
c)
Auto-sum button
5.
Excel refers to files as
a)
Documents
b)
Workbooks
c)
data bases
6.
Where rows and columns meet are referred to as
a)
Blocks
b)
Cells
c)
Boxes
7.
When inserting a formula, always start with
a)
equals symbol
b)
plus symbol
c)
minus symbol
8.
If you see a series of "######" in a cell, that means the following:
a)
You keyed in an incorrect number
b)
The row height is too high
c)
The text is incorrectly spelled
d)
The column width is not wide enough
9.
You can only work in one cell at a time. The actual cell that you are working in is called what?
a)
Column
b)
Name Box
c)
Active Cell
d)
Row
10.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
11.
What formula inserts the current date and time into the active cell?
a)
DATE
b)
TIME
c)
NOW
d)
LONG DATE
12.
Which of the following cells contains an absolute cell reference?
a)
A1
b)
=A1
c)
=$A$1
d)
="A1"
13.
Which formula do we use when we want to perform an action based on the outcome of a logical test?
a)
NOW
b)
IF
c)
AND
d)
OR
14.
Which comparison operator means "not equal to"?
a)
<
b)
>
c)
=
d)
<>
15.
Which of the following happens when you enter the formula =G15 into a cell?
a)
Excel recalculates all formulas in the worksheet
b)
Excel assigns the sum of the values in the previous 15 cells to the active cell
c)
Excel assigns the value in cell G15 to the active cell
d)
Nothing; =G15 is an invalid formula
16.
A ____ is a prewritten formula that is built into Excel
a)
function
b)
feature
c)
task
d)
calculation
100 %
