Computer Quiz : Microsoft Excel Set – 8

Dear Aspirants,
Welcome to Online Computer Quiz in Affairscloud.com. Here we are providing sample questions in Microsoft Excel. It will be useful for all SBI/IBPS/LIC exams and other competitive exams. We have also included some important questions that are repeatedly asked in previous exams.

1. __________ is used to prevent unwanted changes to the data in a sheet by specifying what information can be changed.
   A. Share Workbook
   B. Protect Sheet
   C. Protect Workbook
   D. None of the above
   
   Answer

   B. Protect Sheet
   
   
2. A(n) ____ takes a value or values, performs an operation, and returns a result to the cell
   A. operation
   B. cell
   C. function
   D. argument
   
   Answer

   C. function
   
   
3. A pie chart with one or more slices offset from the main portion is called a(n) _____ pie chart.
   A. exploded
   B. detached
   C. separated
   D. highlighted
   
   Answer

   A. exploded
   
   
4. You can emphasize a slice of a pie chart by________it from the rest of the slices so it stands out.
   A. offsetting
   B. impacting
   C. embedding
   D. charting
   
   Answer

   A. offsetting
   
   
5. The accounting style shows negative numbers in______
   A. Bold
   B. Brackets
   C. Parenthesis
   D. Quotes
   
   Answer

   C. Parenthesis
   
   
6. To specify an absolute reference in a formula, enter a(n) ________before a column letter or a row number.
   A. percent sign
   B. apostrophe
   C. dollar sign
   D. title
   
   Answer

   C. dollar sign
   
   
7. A cell reference with only one dollar sign before either the column or the row is called a(n)_______.
   A. mixed cell reference
   B. relative cell reference
   C. absolute cell reference
   D. incomplete cell reference
   
   Answer

   A. mixed cell reference
   
   
8. __________ displays the location of different page breaks within the Worksheet.
   A. Freeze Panes
   B. Normal View
   C. Page break Preview
   D. None of the above
   
   Answer

   C. Page break Preview
   
   
9. To centre worksheet titles across a range of cell, you must _______
   A. Use merge and center button to center the text across multiple cells
   B. widen the columns
   C. checks whether text is the same in one cell as in the next
   D. All of the above
   
   Answer

   A. Use merge and center button to center the text across multiple cells
   
   
10. A quick way to return to a specific area of a worksheet is to type in the__________
    A. Name box
    B. Formula bar
    C. Zoom box
    D. None of the above
    
    Answer

    A. Name box