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.
B4:B12
$A$1
True
False
True
False
True
False
True
False
One
Zero
Minus Sign
You've entered a number wrong.
You've misspelled something.
The cell is not wide enough.
AutoComplete.
AutoFill.
CTRL+ENTER.
None
Delete the cell contents.
Click the Font group on the Home tab.
Click the Editing group on the Home tab.
CTRL+Z
F4
ESC
True
False
A prewritten formula.
A math operator.
A Utility Tool
None
Click in cell C6, and then press CTRL+SHIFT.
Click in cell C6, and then press F5.
Click in cell C6.
(B3:B6)
(B3,B6)
True
False
June 23, 2012
23-June-12
June 23 2012
Short date
Long date
More number formats
Any of the above
True
False
NETWORKDAYS
WORKDAY
TODAY
A function
Mathematical operators
An equal sign (=)
One
Two
Three
True
False
True
False
Add the labels manually.
Change the chart style.
Change the chart layout.
True
False