NEW
Font size
S
M
L
XL
WorksheetsLet's check your Excel Knowledge_Sanwar
Total questions: 10
Worksheet time: 3mins
Name
Class
Date
1.
What is default alignment of Date in cell in MS Excel?
a)
Right
b)
Left
c)
Center
d)
It can be anywhere
2.
What all data types require double quotes (") in the case of manual input?
a)
Text, Date & Time
b)
Text, Numbers
c)
Numbers & Logicals
d)
Text & Logicals
3.
How can we get the quick access to any of the option in Excel?
a)
Via Status Bar
b)
Via Quick Access Toolbar
c)
Via Formula Bar
d)
All of the Above
4.
Which function is used in Excel to find the 4th Largest Number?
a)
Max
b)
Large
c)
Len
d)
Average
5.
What is the shortcut Key of Format Cells?
a)
Alt +1
b)
Control +1
c)
Window +1
d)
Control+T
6.
Which input way is used in this formula? =Count(C1:C20)
a)
Manual Input
b)
Reference Input
c)
Formula Input
d)
Text Input
7.
What is the shortcut key to change a table in "Table Design"?
a)
CTRL+L
b)
CTRL+SHIFT+L
c)
CTRL+K
d)
CTRL+E
8.
How can we apply the multiple criteria filters in one Go?
a)
Filter
b)
Advance Filter
c)
Multiple Sorting
d)
Validation
9.
Which of the following functions can control the error?
a)
ISERROR
b)
ERRORTYPE
c)
IFERROR
d)
ERRORVALUE
10.
Which function key is used to “Save As” an Excel file?
a)
F1
b)
F4
c)
F5
d)
F12
Reset
