Microsoft Excel Set-18

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:

_________________________________________________________________________________________