NEW
Font size
S
M
L
XL
WorksheetsEXCEL QUIZ (ROUND 2)
Total questions: 10
Worksheet time: 3mins
Name
Class
Date
1.
What is the name of the Last column in Excel?
a)
XFC
b)
XFD
c)
XFE
d)
XFG
2.
What is the correct syntax of IF() function?
a)
=IF (logical_test, TRUE([value_if_true]), FALSE([value_if_false]))
b)
=IF (logical_test, {[value_if_true]}, {[value_if_false]})
c)
=IF (logical_test: #REF!, #REF!)
d)
=IF (logical_test, #REF!, #REF!)
3.
Which function is used to get days, months, or years between two dates?
a)
DATE()
b)
CURDATE()
c)
DATEVALUE()
d)
DATEDIF()
4.
Which option allows you to display all numbers which are less than 0 (negative numbers) in red color in MS Excel?
a)
Styling
b)
Conditional Formatting
c)
Special Formatting
d)
Compare Formatting
5.
Which of the following is not the correct method of editing the cell content
a)
Press the Alt key
b)
Press the F2 key
c)
Double click the cell
d)
Click the formula bar
6.
The number of rows in an Excel 2007 worksheet is:
a)
1048579
b)
1048578
c)
1048576
d)
1048577
7.
In Excel, what does the acronym "CTP" stand for in relation to add-ins?
a)
Create Task Pane
b)
Custom Tool Part
c)
Customize Tab Panel
d)
Custom Task Pane
8.
Which of the following is a volatile function in Excel (i.e., it recalculates every time Excel recalculates)?
a)
VLOOKUP
b)
SUM
c)
CONCATENATE
d)
NOW
9.
Which function can you use to retrieve the last non-blank cell in a column?
a)
=LOOKUP(2,1/(A:A<>""),A:A)
b)
=MAX(A:A)
c)
=HLOOKUP("*",A:A,1,FALSE)
d)
=VLOOKUP(1E+30,A:A,1)
10.
_____ can be used as a keyboard shortcut key to check spelling in MS Excel
a)
F4
b)
F5
c)
F6
d)
F7
Reset
