A short Quiz over Excel
Please type in your name?:
Please type in your complete e-mail address?: (I will not give away or sell this to anyone.)
The following is a short Quiz over Excel.
Question 1)
The advantage of 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 2)
The intersection of a row and a column is called:
a) data.
b) a field.
c) a cell.
d) an equation.
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
Question 10)
I found this to be:
a) too easy.
b) not too bad.
c) good.
d) very good.
15280
Choose:
TRIO home
I
tutorials
I by
Brad James
I
[email protected]