excel quiz

In spreadsheet, a vertical arrangement of cells is called a:

• row

• range

• column

• label

What name is given to a group of cells in Microsoft Excel?

• a range

• a cell cluster

• the cell contents

• a column

Which of the following BEST describes the type of help given when using a spreadsheet program like Microsoft Excel?

• Context Sensitive

• Information Sensitive

• Data Sensitive

• Content Sensitive

Which of the following items may NOT be hidden on the display screen?

• Individual cells

• Graphs, charts and data in them

• Tool Bar

• Start Bar

A grid of labels, values and numbers computed through the use of a formula is a:

• table

• spreadsheet

• template

• graph

To add the contents of cells A1 and A2 on a spreadsheet, one should type:

• = A1 + A2

• A1 and A2

• A1A2

• A1 + A2

In Microsoft Excel, which of the following mode must be used to add a word or number in an existing cell?

• Type over mode

• Over write mode

• Insert mode

• Normal mode

If a cell in Microsoft Excel contains the formula = SUM (A4:A8), what will be the result if the enter key is pressed?

• Returns the average of all number in the range of cells

• Totals all the numbers in the range

• Computes the numbers in the first four and last eight rows of Column A

• Adds up the numbers in cells A4 and A8

When 7.78E+06 appear in your cell, in Microsoft Excel, what does this mean?

• That your number is short of one digit

• That you need to put an apostrophe in front of the cell entry

• The cell is not wide enough to display the full length of the entry

• The keyboard is stuck on '#' and needs to be rebooted

By default, when text is entered in Microsoft Excel, it is:

• right aligned

• left aligned

• not aligned

• centered