Info Tech Excel Quiz

In Excel, which of the following is NOT a function?

• Sum

• Average

• Add

• Maximum

What are rows and columns?

• Rows run from left to right and are designated by a number while columns run from top to bottom and are designated by a letter.

• Rows run from left to right and are designated by a letter while columns run from top to bottom and are designated by a number.

• Rows run from top to bottom and are designated by a number while columns run from left to right and are designated by a letter.

• Rows run from top to bottom and are designated by a letter while columns run from left to right and are designated by a number.

Data on which you can perform calculations on is called? Select the BEST possible answer.

• Labels

• Cells

• Values

• Formulae

The cell reference for the sixth row and fourth column is: Select the BEST possible answer.

• F4

• D6

• F6

• D4

What are values and labels?

• A value is any data that can be used in calculation while a label is a text entry and is used as an identifier.

• A label is any data that can be used in calculation while a value is a text entry and is used as an identifier.

• A value and a label can be used in calculation and can also be used as an identifier.

• A value and a label can be used in calculation but cannot be used as an identifier.

Which of the following is NOT a type of chart in Microsoft Excel?

• Grouping Chart

• Bar Chart

• Line Chart

• Pie Chart

Select True or False. A Formula is an instruction that tells the computer to work out the answer for the values entered. When writing a formula putting the equal sign at the beginning is not necessary.

• False

• True

Which of the following is NOT a form of cell referencing?

• Direct referencing

• Relative referencing

• Absolute referencing

• Mixed referencing

What are the viewing options in Microsoft Excel?

• Page Layout view

• Normal view

• Print view

• Page Break view

Select True or False. Spreadsheet software is used to perform calculations and keep track of tabular data.

• True

• False