Compose an email message
and type your full name. Then, on one line of the message after the other, indicate
which would be the correct answer for each of the following nine questions,
(e.g. ‘12 b’, if ‘b’ was the correct answer for
question 12). Send your email to Jing Li (JLi5@gc.cuny.edu)
and yourself.
Question 1)
The advantage for using a
spreadsheet is:
a)
calculations
can be done automatically
b)
changing data automatically updates calculations (as long
as Excel is not set to calculate manually).
c)
more
flexibility
d)
all of the
above
Question 3)
When you are typing an equation
into a cell the first thing that must be entered is
a)
the first cell
referenced
b)
parenthesis
c)
quotation
marks
d)
an equal sign
Question 4)
Labels are used in a
spreadsheet to:
a)
tell the
computer what we are doing
b)
help us
identify the information
c)
do the
calculations
d)
set up the
equations
Question 5)
The cell labeled F5 refers
to
a)
row F column 5
b)
column F row 5
c)
functions
available in cells
d)
Function key
F4
Question 6)
There are three types of
data found in a spreadsheet
a)
data, words,
numbers
b)
equations,
data, numbers
c)
words,
numbers, labels
d)
numbers,
formulas, labels
Question 7)
The formula =B2+A3
is located in cell b3. If this was copied and pasted into cell D4
the resulting formula would be:
|
|
A |
B |
C |
D |
|
1 |
2 |
4 |
5 |
5 |
|
2 |
3 |
3 |
4 |
6 |
|
3 |
5 |
=B2+A3 |
3 |
8 |
|
4 |
4 |
3 |
4 |
???????? |
a)
=C2+C3
b)
=D3+C3
c)
=D3+C4
d)
none of the
above
Question 8)
The formula =$C$3*D3
is located in cell B1. If this was copied and pasted into cell C1, what
would the resulting formula be:
|
|
A |
B |
C |
D |
|
1 |
|
=$C$3*D3 |
????????? |
|
|
2 |
3 |
3 |
4 |
6 |
|
3 |
5 |
4 |
3 |
8 |
|
4 |
4 |
3 |
4 |
9 |
a)
=$c$3*e3
b)
=c3*e3
c)
=$c$3*d3
d)
24
Question 9)
A constant is another name
for this type of data
a)
Number
b)
Equation
c)
Formula
d)
description