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

What are the two common wildcard characters that MS-Excel recognizes in In MS-Excel?

Answer :
  • * and ?

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

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

What are Graphics objects on a chart used for in MS Excel?

Answer :
  • All the above

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

Answer :
  • Ctrl + F