Trivia Quiz On Microsoft Excel 2007 Formulas And Functions!
Settings
Microsoft Excel often called as MS Excel, is a spreadsheet application which is used for data processing and financial presentation. Do you really know all the functions and formulas of excel? Are you an expert? To become an expert one should learn certain complex formulas and functions. This quiz has been created to test and increase your knowledge about formulas and functions of MS Excel. So, let's try out the quiz. Good Luck!
- 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 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 the 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 the 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 date 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 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? (You learned this in the practice.)
- A.
Add the labels manually.
- B.
Change the chart style.
- C.
Change the chart layout.
- 25.You learned in the 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
Back to top