1. Which of the following is an
absolute cell reference?
a. !A!1 b. $A$1
c. #a#1 d. A1
2. What symbol is used before a
number to make it a label?
a. “ (quote) b. = (equal)
c. _ (underscore) d. ‘
(apostrophe)
3. Which symbol must all
formula begin with?
a. = b. +
c. ( d.
@
4. Which of the following
formulas is not entered correctly?
a. =10+50 b.
=B7*B1
c. =B7+14 d.
10+50
5. Which of the following
formulas will Excel Not be able to calculate?
a. =SUM(Sales)-A3 b. =SUM(A1:A5)*.5
c. =SUM(A1:A5)/(10-10) d. =SUM(A1:A5)-10
6. A typical worksheet has ….
Number of columns
a. 128 b.
256
c. 512 d.
1024
7. How many characters can be
typed in a single cell in Excel?
a. 256 b.
1024
c. 32,000 d.
65,535
8. A worksheet can have a
maximum of …. Number of rows
a. 256 b.
1024
c. 32,000 d.
65,535
9. Which of the following is
not an example of a value?
a. 350 b.
May 10, 2001
c. 57% d.
Serial Number 50771
10. The chart wizard term data
series refers to
a. A chart legend
b. A collection of chart data
markers
c. A set of values you plot in
a chart
d. A data label
No comments:
Post a Comment