# Microsoft Excel 2007 Quiz: Formulas And Functions!

28 Questions | Total Attempts: 1521  Settings Create your own Quiz Microsoft Excel, often called MS Excel, is a spreadsheet application for data processing and financial presentation. Do you know all the functions and formulas of excel? Are you an expert? To become an expert, one should learn specific complex formulas and functions. This quiz will test and increase your knowledge about the formulas and functions of MS Excel. Let's try it out.

• 1.
Which of these is an absolute reference?
• A.

B4:B12

• B.

\$A\$1

• 2.
The Name Box shows you the contents of the active cell.
• A.

True

• B.

False

• 3.
In a new worksheet, you must start by typing in cell A1.
• A.

True

• B.

False

• 4.
There are three worksheets with every new workbook. You can change that automatic number if you want to.
• A.

True

• B.

False

• 5.
Pressing ENTER moves the selection of one cell to the right.
• A.

True

• B.

False

• 6.
To enter a fraction such as 1/4, the first thing you enter is _____.
• A.

One

• B.

Zero

• C.

Minus Sign

• 7.
You learned in the practice that ###### means:
• A.

You've entered a number wrong.

• B.

You've misspelled something.

• C.

The cell is not wide enough.

• 8.
To enter the months of the year without typing each month yourself you'd use:
• A.

AutoComplete.

• B.

AutoFill.

• C.

CTRL+ENTER.

• D.

None

• 9.
To delete the formatting from a cell, you would:
• A.

Delete the cell contents.

• B.

Click the Font group on the Home tab.

• C.

Click the Editing group on the Home tab.

• 10.
You learned in practice how to undo a deletion. Press:
• A.

CTRL+Z

• B.

F4

• C.

ESC

• 11.
To add a column, click a cell in the column to the right of where you want the new column.
• A.

True

• B.

False

• 12.
What is a function?
• A.

A prewritten formula.

• B.

A math operator.

• C.

A Utility Tool

• D.

None

• 13.
A formula result is in cell C6. You wonder how you got the result. To see the formula, you:
• A.

Click in cell C6, and then press CTRL+SHIFT.

• B.

Click in cell C6, and then press F5.

• C.

Click in cell C6.

• 14.
Which cell reference refers to a range of cells in column B, rows 3 through 6?
• A.

(B3:B6)

• B.

(B3,B6)

• 15.
In practice, you learned that if you misspell SUM in this formula =SUME(B4: B7), you'll get an error value of #NAME? To fix the formula, you must delete it and start over again.
• A.

True

• B.

False

• 16.
Which of these dates will Excel store as plain text rather than as a serial number?
• A.

June 23, 2012

• B.

23-June-12

• C.

June 23 2012

• 17.
In practice, you learned how to apply data formats to serial numbers. After selecting a cell, go to the Home tab, and select the Number group. Click the arrow in the Number format box. Then click:
• A.

Short date

• B.

Long date

• C.

More number formats

• D.

Any of the above

• 18.
8/22/2011 and 22-August-2011 are stored as different serial numbers.
• A.

True

• B.

False

• 19.
Which function would you use to find the date that falls after a number of workdays?
• A.

NETWORKDAYS

• B.

WORKDAY

• C.

TODAY

• 20.
What do you type to start the formula in Excel?
• A.

A function

• B.

Mathematical operators

• C.

An equal sign (=)

• 21.
How many arguments does the date function have?
• A.

One

• B.

Two

• C.

Three

• 22.
You've created a chart. Now you need to compare data another way. To do this, you must create a second chart.
• A.

True

• B.

False

• 23.
You can't change the chart type after you create a chart.
• A.

True

• B.

False

• 24.
You want to add data labels above each column to show a value for each column. How can you do this?
• A.

Add the labels manually.

• B.

Change the chart style.

• C.

Change the chart layout.

• 25.
You learned in practice how to create a pie chart. There's no difference between a column and a pie chart, other than the pie shape.
• A.

True

• B.

False

Related Topics Back to top
×

Wait!
Here's an interesting quiz for you.