Navigate

Question Detail

Which function is used for creating a data table ?

  • Sum
  • Table
  • Add
  • Count

Answer: Option B

Similar Questions :

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

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

Answer: Option A

2. VLOOKUP function used to ?

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

Answer: Option A

3. Which among following is associated with excel ?

  • Graphic program
  • Word Processor
  • Presentation
  • Spreadsheet

Answer: Option D

4. When creating a vertical page break ?

  • The active cell must be in row 1
  • The active cell must be A1
  • The active cell must be in row 10
  • The active cell must be in column A

Answer: Option A

5. To convert a column of data into row, which command will you choose

  • Edit -> Paste Special -> Transpose
  • Cut and Paste
  • Both of above
  • None of above

Answer: Option A

Read more from - MS Excel Questions Answers