Microsoft Excel Set-19

181. “Qtr 1, Qtr 2, Qtr 3” is an example of a
     a. Formula
     b. Function
     c. Series
     d. Syntax
     
182. You can edit existing Excel data by pressing the
     a. F1 key
     b. F2 key
     c. F3 key
     d. F4 key
183. The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ….
     a. G1-G10
     b. B1.G10
     c. B1;G10
     d. B1:G10
184. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
     a. Go to File-Save As – Save As Type – Excel worksheet
     b. Right click on the spreadsheet tab and select DELETE
     c. Right click on the spreadsheet and select Insert – Entire Column
     d. None of above
185. What feature enables you to adjust or back solve the value in
     a cell to reach a desired outcome in a formula?
     a. Goal Seek
     b. Scenario Summary report
     c. Forecasting
     d. Trend line
     

186. what term describes a background that appears as a grainy, non smooth surface
     a. gradient
     b. pattern
     c. solid
     d. texture
187. Excel is a
     a. Graphic program
     b. None of these
     c. Word processor
     d. A spreadsheet
     
188. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called
     a. HTML
     b. Pivot Table Field List
     c. Pivot Table List
     d. Pivot Table Report
189. Which of the following is not a valid Zoom percentage in Excel?
     a. 10
     b. 100
     c. 300
     d. 500
190. The spelling tool is placed on __ toolbar
     a. Standard
     b. Formatting
     c. Drawing
     d. Reviewing

________________________________________________________________________________