Data Analysis Fundamentals using Excel Quiz Questions and Answers

What refers to the horizontal cells which can contain information?

Answer :
  • Rows

In which tab wrap text feature is present in MS Excel 2007?

Answer :
  • Home

Which of these data types is not in MS.excel?

Answer :
  • Label

Which of the following is not a term pertaining to spreadsheets?

Answer :
  • Browser

In MS-Excel without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

Answer :
  • Press Ctrl +Home

A formula in Excel always begins with which of the following?

Answer :
  • Equal sign

What function displays row data in a column or column data in a row?

Answer :
  • Transpose

In MS-Excel, to access the Find feature, you can press which of the following?

Answer :
  • Ctrl + F

In MS-Excel, to access the New feature, you can press which of the following?

Answer :
  • Ctrl + N

In MS Excel, to access the Hyperlink feature, you can press which of the following?

Answer :
  • Ctrl + K