MS Excel Questions Answers

• 22. Which function in excel counts the numbers of characters in a cell ?

  1. 31%
  2. 33%
  3. 34%
  4. 36%
  5. LENGHT
  6. LGT
  7. LT
  8. LEN

  Answer :

  Option

• 23. 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 :

  Option C

• 24. Formula palette is used to ?

  1. format cells containing numbers
  2. create and edit formulas containing functions
  3. entered assumptions data
  4. copy all cells

  Answer :

  Option B

• 25. A value used in a formula that does not change is called a ?

  1. Constant
  2. Cell address
  3. Varaible
  4. Static

  Answer :

  Option A

• 26. What term refers to a specific set of values saved with the workbook ?

  1. Range
  2. File set
  3. Data set
  4. Scenario

  Answer :

  Option D

• 27. Which of the following methods cannot be used to edit the content of cell ?

  1. Pressing F2
  2. Clicking the formula bar
  3. Pressing the Alt key
  4. Double clicking the cell

  Answer :

  Option C

• 28. 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 :

  Option B