excel Exam 2009

A cell reference/address is made up of a ___________ ___________and a ____________ ______________.

• Row and a column

• Column and a row

• Row number and a column letter

• Column letter and row number

Which of the following is NOT a correct Excel formula?

• =K11/M30

• =C20*9A

• =E12+B40

• =Sum (C20:G56)

Which if the following can be used to create a graphical representation of data in a spreadsheet?

• All of the above

• Bar charts

• Column bars

• Pie charts

• Line graphs

When the error message ######## is displayed this indicates that:

• There is an invalid use of an operator or argument

• Excel does not recognize the name used in the formula

• The formula is referencing itself

• The number value calculated or entered is too large for the cell width

Which of the following icon is not found on the standard toolbar?

• Undo, icon

• Columns, icon

• Font size, icon

• Tables and borders icon

Which of the following icon is not found on the formatting toolbar?

• Font size icon

• Color icon

• Center icon

• Copy icon

From which menu option would you be able to choose the cut option?

• File

• Edit

• View

• Insert

When performing mail merge you create

• One document

• Two documents

• Three documents

• Four documents

When performing mail merge you click on the:

• File Menu

• View Menu

• Tools menu

The first step in inserting a table is to click on the

• Table menu

• Insert menu

• Format menu

• View menu