MS Excel Questions Answers Online Quiz Test

• 1. Protection and the Protect Sheet options can be selected from ?

  1. Data
  2. Tools
  3. Edit
  4. Format

• 2. Which of the following is not a valid Zoom percentage in Excel ?

  1. 10
  2. 100
  3. 300
  4. 500

• 3. You can check the conditions against ____ when applying conditional formatting ?

  1. Cell Value
  2. Formula
  3. Both of above
  4. None of above

• 4. How can we set Page Border in Excel ?

  1. From Edit menu
  2. From Home
  3. You can not set page border in Excel
  4. From Tools menu

• 5. Which function calculates your monthly mortage payment ?

  1. PV
  2. NPER
  3. PMT
  4. All of above

• 6. Which types of charts can excel produce ?
  

  1. Line graphs and pie charts only
  2. Bar charts, line graphs and pie charts
  3. Bar charts and line graphs only
  4. Only line graphs

• 7. How is data organized in a spreadsheet ?

  1. Rows and columns
  2. Layers and planes
  3. Lines and spaces
  4. Height and width

• 8. VLOOKUP function used to ?

  1. Finds related records
  2. Looks up text that contain "v"
  3. Check if two cells are identical
  4. None of above

• 9. Gridlines may be turned off for display but turned on for printing.

  1. True
  2. False

• 10. How do you change column width to fit the contents ?

  1. Single-click the boundary to the left to the column heading
  2. Double click the boundary to the right of the column heading
  3. Press Alt and single click anywhere in the column
  4. All of above

• 11. To insert three columns between columns A and B you would

  1. Select column A
  2. Select A and B
  3. Select B
  4. All of above

• 12. To drag a selected range of data to another worksheet in the same workbook, use the ?

  1. Ctrl key
  2. Shift key
  3. Alt key
  4. Tab key

• 13. You can activate a cell by ?
  

  1. Pressing the Tab key
  2. Clicking the cell
  3. Pressing an arrow key
  4. All of above

• 14. A function inside another function is known as ?

  1. Round function
  2. Sandwich function
  3. Switch function
  4. Nested function

• 15. What excel feature can you use if you want to work with one record at a time ?

  1. Auto Complete
  2. Data Form
  3. Set Form
  4. Auto Text

• 16. Which function is used for creating a data table ?

  1. Sum
  2. Table
  3. Add
  4. Count

• 17. The accounting style shows negative numbers in ?

  1. Bold
  2. Italics
  3. Parentheses
  4. Quotes

• 18. 3-D reference in a formula ?

  1. Spans worksheets
  2. Can not be modified
  3. Only appears on summary worksheets
  4. Limits the formatting options

• 19. Auto calculate feature provides a quick way to view the results of an arithmetic operation on a range of cells.

  1. True
  2. False

• 20. Which among following wildcard characters are recognized by excel ?

  1. + and -
  2. ! and ^
  3. * and ?
  4. < and >