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!
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
Click the Data tab.
Click the Insert tab.
Copy the chart.
True
False
True
False