Multiple Choice Question for Microsoft Excel || 18
Read multiple choice questions for computer operator training as well as IT Training. Improve your computer skills.
171 To protect a worksheet, you can
choose Protection and the Protect Sheet from the ?.. menu
A. Edit
B.
Format
C. Tools
D. Data
172 You can open
the Highlight Changes dialog box by choosing Track Changes from the ?. Menu.
A. Edit
B. Insert
C. Format
D. Tools
173
Which of the following is not a worksheet design criterion?
A. Efficiency
B.
Auditability
C. Description
D. Clarity
174
To copy cell contents using drag and drop, press the
A. End key
B. Shift
key
C. Esc key
D. None of above
175 If you
press ?., the cell accepts your typing as its contents.
A. Enter
B. Ctrl +
Enter
C. TAB
D. Insert
176 The autofill
feature
A. Extends a sequential series of data
B. Automatically adds a range
of cell values
C. Applies a boarder around selected cells
D. None of above
177 What is the keyboard shortcut (button or
buttons to be pressed) for creating a chart from the selected cells?
A. F3
B. F5
C. F7
D. F11
178 you can use the
formula palette to
A. format cells containing numbers
B. create and edit
formulas containing functions
C. entered assumptions data
D. copy a range of
cells
179 What Pivot Table toolbar button
updates the data in a Pivot Table or Pivot Chart report if the source data chas
changed
A. Format Report
B. Pivot Table
C. Refresh Data
D. Show Detail
180 What is an expression that tells how the
numbers in a determined set of cells are to be calculated?
A. Formula
B.
Field
C. Data
D. Query Correct Answer: