1. To copy cell
contents using drag and drop press the
a. End key
b. Shift key
c. Ctrl key
d. Esc key
2. Which of the
following is the latest version of Excel
a. Excel 2000
b. Excel 2002
c. Excel ME
d. Excel XP
3. When you copy a
formula
a. Excel erases the
original copy of the formula
b. Excel edits cell
references in the newly copied formula
c. Excel adjusts
absolute cell references
d. Excel doesn’t
adjust relative cell references
4. The Autosum feature
a. extends a
sequential series of data
b. automatically adds
range of cell values
c. applies a boarder
around the selected cells
d. none of the above
5. Which menu option
can be sued to split windows into two
a. Format > window
b. View > window
> split
c. Window > split
d. View > split
6. Which of the
following is an absolute cell reference?
a. !A!1
b. $A$1
c. #a#1
d. A1
7. What symbol is used
before a number to make it a label?
a. ” (quote)
b. = (equal)
c. _ (underscore)
d. ‘ (apostrophe)
8. Which symbol must
all formula begin with?
a. =
b. +
c. (
d. @
9. Which of the
following formulas is not entered correctly?
a. =10+50
b. =B7*B1
c. =B7+14
d. 10+50
10. 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
11. A typical worksheet
has …. Number of columns
a. 128
b. 256
c. 512
d. 1024
12. How many characters
can be typed in a single cell in Excel?
a. 256
b. 1024
c. 32000
d. 65535
13. A worksheet can have
a maximum of …. Number of rows
a. 256
b. 1024
c. 32000
d. 65535
14. Which of the
following is not an example of a value?
a. 350
b. May 10, 2001
c. 0.57
d. Serial Number 50771
15. 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
16. The Chart wizard
term data categories refers to;
a. A chart plot area
b. A horizontal axis
c. The organization of
individual values with a chart’s data series
d. The data range that
supply chart data
17. A worksheet range is
a
a. A command used for
data modeling
b. A range of values
such as from 23 to 234
c. A group of cells
d. A group of
worksheets
18. Getting data from a
cell located in a different sheet is called …
a. Accessing
b. Referencing
c. Updating
d. Functioning
19. Tab scrolling button
a. Allow you to view a
different worksheet
b. Allow you to view
additional worksheet rows down
c. Allow you to view
additional worksheet columns to the right
d. Allow you to view
additional sheets tabs
20. A numeric value can
be treated as a label value if it precedes with
a. Apostrophe (&lsquo
b. Exclamation (!)
c. Hash (#)
d. Ampersand (&
21. Concatenation of
text can be done using
a. Apostrophe
(&lsquo
b. Exclamation (!)
c. Hash (#)
d. Ampersand (&
22. Data can be arranged
in a worksheet in a easy to understand manner using
a. auto formatting
b. applying styles
c. changing fonts
d. all of above
23. You can use
drag-and-drop to embed excel worksheet data in a word document
a. By dragging a range of
excel data to the word button on the taskbar while pressing the Ctrl key
b. By dragging a range
of excel data to the word button on the taskbar while pressing Shift key
c. By dragging a range
of excel data to the word button on the taskbar while pressing Alt key
d. None of above
24. The auto calculate
feature
a. Can only add values
in a range of cells
b. Provides a quick way to
view the result of an arithmetic operation on a range of cells
c. Automatically
creates formulas and adds them to a worksheet
d. A and c
25. Excel uniquely
identifies cells within a worksheet with a cell name
a. Cell names
b. Column numbers and
row letters
c. Column letters and row
numbers
d. Cell locator
coordinates
