Question: Which of these will not select all the cells in a document?

  • AUsing the Edit
  • BPressing Ctrl + A on the keyboard
  • CClicking three times with the right mouse button in the spreadsheet
  • DNone of above

Question: A value used in a formula that does not change is called a?

  • AConstant
  • BCell address
  • CVaraible
  • DStatic

Question: A Spreadsheet contains?

  • Acolumns
  • Brows
  • Crows and columns
  • DNone of above

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

  • ATrue
  • BFalse

Question: Which among following wildcard characters are recognized by excel ?

  • A+ and -
  • B! and ^
  • C* and ?
  • D< and >

Question: Which function will you use to enter current time in a woksheet cell?

  • A=time()
  • B=nowtime()
  • C=now()
  • D=currentTime()

Question: Merge cells option can be applied from?

  • AFormatting toolbar
  • BFormat Cells dialog box Alignment Tab
  • CBoth of above
  • DNone of above

Question: The name box appears at the?

  • Aleft of the formula bar
  • Bright of the formula bar
  • Cbelow the status bar
  • Dbelow the menu bar

Question: The intersection of row and column is called a ?

  • Adataset
  • Bcell
  • Cdata
  • Dset

Question: To join some cells and place the content in the middle of the joined cell, which tool you will use?

  • AFrom Format Cells dialog box choose Merge and Center check box
  • BClick on Merge and Center tool on formatting toolbar
  • CFrom Format Cells dialog box select the Centered alignment
  • DFrom Format Cells dialog box click on Merge Cells check box