MS Excel - Day 03

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