MS Excel MCQs

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

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

Worksheet in excel by default ___

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

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

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

Multiple calculations can be made in a single formula using

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

Worksheet in excel by default ___

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

What do you mean by a workspace ?

1. Group of Workbooks
2. Group of Rows
3. Group of Worksheets
4. None

To select an entire column in MS Excel, press?

1. Ctrl +r
2. Ctrl +s
3. Ctrl +c
4. none

Microsoft excel is a powerful______

1. Spreadsheet package
2. Word processing package
3. DBMS package
4. None