Microsoft Excel 2007 Quiz: Formulas And Functions!

28 Questions | By Zmolls | Last updated: Mar 21, 2022 | Total Attempts: 1521

Questions

Settings

Create your own Quiz

Microsoft Excel 2007 Quiz: Formulas And Functions! - 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.

Questions and Answers

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