MS Excel Questions Answers

• 15. Which among following is associated with excel ?

  1. Graphic program
  2. Word Processor
  3. Presentation
  4. Spreadsheet

  Answer And Explanation

  Answer: Option D

  • Comment on this question

• 16. The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is ?

  1. C1:10H
  2. C1:H10
  3. C1:H-10
  4. C1:H:10

  Answer And Explanation

  Answer: Option B

  • Comment on this question

• 17. You can convert existing Excel worksheet data and charts to HTML document by using the ?

  1. Internet Assistant Wizard
  2. Intranet Wizard
  3. Import Wizard
  4. Export Wizard

  Answer And Explanation

  Answer: Option A

  • Comment on this question

• 18. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called ?

  1. HTML
  2. Pivot Table Field List
  3. Pivot Table Report
  4. Pivot Table List

  Answer And Explanation

  Answer: Option C

  • Comment on this question

• 19. What function displays row data in a column or column data in a row ?

  1. Transpose
  2. Index
  3. Rows
  4. Hyperlinks

  Answer And Explanation

  Answer: Option A

  • Comment on this question

• 20. Except which of the following function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result ?

  1. NOT
  2. OR
  3. IF
  4. AND

  Answer And Explanation

  Answer: Option C

  • Comment on this question

• 21. Macros can be executed from the which of the following menu ?

  1. Format
  2. Home
  3. Insert
  4. Tools

  Answer And Explanation

  Answer: Option D

  • Comment on this question