Question Detail

Formula palette is used to ?

  • format cells containing numbers
  • create and edit formulas containing functions
  • entered assumptions data
  • copy all cells
Similar Questions :

1. What is shortcut to enter current date in cell in excel ?

  • Ctrl + ;
  • Alt + ;
  • Shift + &
  • Ctrl + $

2. VLOOKUP function used to ?

  • Finds related records
  • Looks up text that contain "v"
  • Check if two cells are identical
  • None of above

3. Which among following wildcard characters are recognized by excel ?

  • + and -
  • ! and ^
  • * and ?
  • < and >

4. To insert three columns between columns A and B you would

  • Select column A
  • Select A and B
  • Select B
  • All of above

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

  • True
  • False
Read more from - MS Excel Questions Answers