Navigate

Question Detail

Which function is used for creating a data table ?

  • Sum
  • Table
  • Add
  • Count

Answer: Option B

Similar Questions :

1. 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

2. 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

3. To drag a selected range of data to another worksheet in the same workbook, use the ?

  • Ctrl key
  • Shift key
  • Alt key
  • Tab key

Answer: Option A

4. To open an existing workbook, click the Open button on the ___ toolbar ?

  • Form
  • Standard
  • Drawing
  • Formatting

Answer: Option B

5. Merge cells option can be applied from ?

  • Formatting toolbar
  • Format Cells dialog box Alignment Tab
  • Both of above
  • None of above

Answer: Option B

Read more from - MS Excel Questions Answers