WorksheetsUNIT-5
Total questions: 15
Worksheet time: 8mins
To get to the ‘Symbol’ dialog box, click on the ______ menu and choose ‘Symbol’.
Insert
Format
Tools
Table
Cut, Copy and Paste is in ________ Group in the Home tab.
Font
Page Setup
Clipboard
Editing
_ is used to convert from upper case to lower case and vice versa.
Toggle case
Sentence case
Lower case
Upper case
Which of the following is not available on the Ruler of MS Word screen?
Tab stop box
Left Indent
Right Indent
Center Indent
Background color or effects applied on a document is not visible in
Web layout view
Print Layout view
Reading View
Print Preview
Which of the following is the second step in creating a macro?
Start recording
Using your mouse or keyboard, perform the task you want to automate
Assign a keyboard shortcut to the macro
Give the macro a name
When you print preview a worksheet
the entire worksheet is displayed
the selected range is displayed
the active portion of the worksheet is displayed
a, b and c
Which of the following is not a valid Zoom percentage in Excel?
10
100
300
500
Formatting a cell in Number format you can’t set
Decimal Places
Use 1000 separator
Negative numbers
Currency Symbol
Which of the following format you can decide to apply or not in AutoFormat dialog box?
Number format
Border format
Font format
All of above
Which of the following Excel screen components can NOT be turned on or off?
Formula Bar
Status Bar
Tool Bar
None of above
To drag a selected range of data to another worksheet in the same workbook, use the
Tab key
Alt key
Shift key
Ctrl key
The auto calculate feature
Can only add values in a range of cells
Provides a quick way to view the result of an arithmetic operation on a range of cells
Automatically creates formulas and adds them to a worksheet
A and c
Which of the following is an absolute cell reference?
!A!1
$A$1
#a#1
A1
Which of the following is not a valid data type in Excel?
Number
Character
Label
Date/Time
