MS Excel MCQs

The name box on to the left of formula bar

1. Shows the name of worksheet currently working on
2. Shows the name of cell or range currently working on
3. Shows the name of workbook currently working on
4. none

Can you merge the main document with data source in excel. In mail merge operation, the word usually

1. Server
2. Client
3. Source
4. none

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

1. Double CAL indicator on status bar
2. Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button
3. both
4. none

MS Excel provides the default value for step in fill series dialogue box

1. 1
2. 2
3. 3
4. 5

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

1. Justify in Edit > Cells
2. Wrap Text in Format > Cells
3. None
4. All

The command Edit >Fill Across worksheet is active only when

1. One sheet is selected
2. One sheet is not selected
3. When many sheets are selected
4. None

To remove the content of selected cells you must issue ___ commands

1. Clear All
2. Clear Delete
3. Clear Contents
4. All

Edit> Delete Command

1. Deletes selected cells
2. Deletes Formats of cell
3. Deletes the comment of cell
4. All

What is the shortcut key to replace data with another in sheet ?

1. Ctrl + Shift + R
2. Ctrl + H
3. Ctrl + R
4. All

Multiple calculations can be made in a single formula using

1. Complex Formulas
2. Standard Formulas
3. Array Formula
4. All