101. What function displays row data in a column or column data in
a row?
a. Hyperlink b. Index
c. Transpose d. Rows
102. When you insert an Excel
file into a Word document, the data are
a. Hyperlinked b. Placed in a
word table
c. Linked d. Embedded
103. Except for the …… function, a
formula with a logical function shows the word “TRUE” or “FALSE” as a result
a. IF b. AND
c. OR d. NOT
104. Macros are “run” or executed from
the ….. menu.
a. Insert b. Frmat
c. Tools d. Data
105. You can open the consolidate
dialog box byt choosing Consolidate from the ….. menu.
a. Insert b. Format
c. Tools d. Data
106. Each excel file is
called a workbook because
a. It can contain
text and data
b. It can be modified
c. It can contain many sheets including worksheets and
chart sheets
d. You have to work
hard to create it
107. Which types of charts can excel
produce?
a. Line graphs and
pie charts only
b. Only line graphs
c. Bar charts, line graphs and pie charts
d. Bar charts and
line graphs only
108. How are data organized in a
spreadsheet?
a. Lines and spaces b. Layers and planes
c. Rows and columns d. Height and width
109. What does the VLOOKUP function
do?
a. Looks up text that
contain ‘v’
b. Checks whether
text is the same in one cell as in the next
c. Finds related records
d. All of above
110. Gridlines
a. May be turned off
for display but turned on for printing
b. May be turned on
or off for printing
c. The be turned off
for display and printing
d. a, b and c
No comments:
Post a Comment