Category Archives: MS Excel MCQs

You can set Page Border in Excel from?

A. From Border tab in Format Cells dialog box
B. From Border tool in Formatting toolbar
C. From Line Style tool in Drawing toolbar
D. None of these

MS Excel will not be able to calculate which of the following formula?

A. SUM(Sales)-A3
B. SUM(A1:A5)*.5
C. SUM(A1:A5)(10+10)
D. SUM(A1:A5)-10

Which of the following Excel feature allows user to evaluate values and return a result?

A. Formulas
B. Formatting
C. Filters
D. Insertions

In MS-Excel undo option will _____ last action?

A. Replace
B. Change
C. Repeat
D. Recoverable

Term chart wizard data in MS Excel refer to?

A. Vertical Axis
B. Horizontal Axis
C. Both A and B
D. None of these

In MS Excel can use the horizontal and vertical scroll bars to?

A. Split a worksheet into two panes
B. View different rows and columns
C. Edit the contents of cell
D. View different worksheets

Cells in MS Excel can be uniquely identified by?

A. Column letters and row numbers
B. Column numbers and row letters
C. Cell coordinates
D. None of these

In Excel, you can sort data in ______?

A. Ascending order
B. descending order
C. Both A & B
D. None of these

Excel would evaluate the formula, = 20*10/5*8, and return this answer?

A. 5
B. 6.25
C. 320
D. 232

A collection of related worksheets is called?

A. Workbook
B. File
C. Group
D. none of these