Practice MS Excel Multiple Choice Questions Quiz-2 - MCQGeeks.com

Q.1

By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?

Right click on Sheet Tab of third sheet and choose Delete from the context menu
Click on Sheet 3 and from Edit menu choose Delete
Both of above
None of above

Q.2

Which of the following action removes a sheet from workbook?

Select the sheet, then choose Edit > Delete Sheet
Select the sheet then choose Format > Sheet > Hide
Both of above
None of above

Q.3

To remove the content of selected cells you must issue ______ command

Delete
Clear Contents
Clear All
Clear Delete

Q.4

MS Excel provides the default value for step in Fill Series dialog box

0
1
5
10

Q.5

When a row of data is to be converted into columns

Copy the cells in row, select the same number of cells in row and paste
Copy the cells in column then choose Paste Special, then click Transpose and OK
Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK
Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK

Q.6

Ctrl + D shortcut key in Excel will

Open the font dialog box
Apply double underline for the active cell
Fill down in the selection
None of above

Q.7

Which of the cell pointer indicate that you can move the content to other cell?

Doctor’s symbol (Big Plus)
Small thin plus icon
Mouse Pointer with anchor at the tip
None of above

Q.8

The shortcut key Ctrl + R is used in Excel to

Right align the content of cell
Remove the cell contents of selected cells
Fill the selection with active cells to the right
None of above

Q.9

The command Edit > Fill Across Worksheet is active only when

One sheet is selected
When many sheets are selected
When no sheet is selected
None of above

Q.10

Long text can be broken down into many lines within a cell. You can do this through

Wrap Text in Format > Cells
Justify in Edit > Cells
Text Wrapping in Format > Cells
All of above

Q.11

Which of the following Excel screen components can NOT be turned on or off?

Formula Bar
Status Bar
Tool Bar
None of above

Q.12

What happens when you press Ctrl + X after selecting some cells in Excel?

The cell content of selected cells disappear from cell and stored in clipboard
The cells selected are marked for cutting
The selected cells are deleted and the cells are shifted left
The selected cells are deleted and cells are shifted up

Q.13

It is acceptable to let long text flow into adjacent cells on a worksheet when

Data will be entered in the adjacent cells
No data will be entered in the adjacent cells
There is no suitable abbreviation for the text
There is not time to format the text

Q.14

You can merge the main document with data source in Excel. In mail merge operation, Word is usually

Server
Source
Client
None of the above

Q.15

How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?

F8
F9
F10
F11

Q.16

You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?

Custom List
Auto Fill Options
Fill Across Worksheet
Fill Series

Q.17

Where can you change automatic or manual calculation mode in Excel?

Double CAL indicator on status bar
Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button
Both of above
None of above

Q.18

How can you show or hide the gridlines in Excel Worksheet?

Go to Tools > Options > View tab and mark or remove the check box named Gridline
Click Gridline tool on Forms toolbar
Both of above
None of above

Q.19

Which tool you will use to join some cells and place the content at the middle of joined cell?

From Format Cells dialog box click on Merge Cells check box
From Format Cells dialog box select the Centered alignment
From Format Cells dialog box choose Merge and Center check box
Click on Merge and Center tool on formatting toolbar

Q.20

Tab scroll buttons are place on Excel screen

Towards the bottom right corner
Towards the bottom left corner
Towards the top right corner
Towards the top left corner

Q.21

The Name box on to the left of formula bar

Shows the name of workbook currently working on
Shows the name of worksheet currently working on
Shows the name of cell or range currently working on
None of above

Q.22

Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

Work sheet
Chart sheet
Macro sheet
Data sheet

Q.23

Which of the following is not the correct method of editing the cell content?

Press the Alt key
Press the F2 key
Click the formula bar
Double click the cell

Q.24

You can check the conditions against __________ when applying conditional formatting

Cell value
Formula
Both of above
None of above

Q.25

Which of the following is not true regarding Conditional Formatting?

You can add more than one condition to check
You can set condition to look for Bold and apply Italics on them
You can apply Font, border and pattern formats that meets the specified conditions
You can delete any condition from Conditional Formatting dialog box if it is not requried

Q.26

Which of the following is invalid statement?

Sheet tabs can be colored
Some picture can be applied as a background of a sheet
You can set the column width automatically fit the amount of text
The width of a row and be specified manually or fit automatically

Q.27

You can use the formula palette to

Format cells containing numbers
Create and edit formula containing functions
Enter assumptions data
Copy a range of cells

Q.28

When a range is selected, how can you activate the previous cell?

Press the Alt key
Press Tab
Press Enter
None of above

Q.29

How can you remove borders applied in cells?

Choose None on Border tab of Format cells
Open the list on Border tool in Format Cell toolbar then choose first tool (none)
Both of above
None of above

Q.30

Where can you set the shading color for a range of cells in Excel?

Choose required color form Patterns tab of Format Cells dialog box
Choose required color on Fill Color tool in Formatting toolbar
Choose required color on Fill Color tool in Drawing toolbar
All of above

0 h : 0 m : 1 s