WorksheetsMS Excel - Day 03
Total questions: 10
Worksheet time: 5mins
Keyboard shortcut to create a table in Excel is
Ctrl + T
Alt + T
Ctrl + L
None of the mentioned
_______ is a way to refer to a table when working with formulas or elsewhere in a sheet.
Absolute reference
Relative reference
Structured reference
Mixed reference
Tabs which appear only during particular context are called _______.
Table tab
Contextual tab
Design tab
None of the mentioned
Insert slicer option is available from which version of Excel?
2003
2010
2013
2016
The custom list creation can be done by using
File - Options - Quick Access Toolbar
File - Options - Add-ins
File - Options - Customize Ribbon
File - Options - Advanced
In custom number formatting, 0 after decimal represents
Atleast the digit equal to the number of zeros
Atmost the digit equal to the number of zeros
None of the mentioned
Both the mentioned
In custom number formatting, 0 before decimal represents
Atleast the digit equal to the number of zeros
Atmost the digit equal to the number of zeros
None of the mentioned
Both the mentioned
What will the following function print?
=AND(TRUE,FALSE)
TRUE
FALSE
ERROR
None of the mentioned
What will the following function print?
=OR(TRUE,FALSE)
TRUE
FALSE
ERROR
None of the mentioned
What will the following function print?
=NOT(0)
TRUE
FALSE
ERROR
None of the mentioned
