Home » Computer » MS Excel MCQ » MS Excel Quiz MCQ Questions and Answers – (Set-2)

MS Excel Quiz MCQ Questions and Answers – (Set-2)

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications etc. Students will find MS Excel MCQ Quiz Questions & Answers.

Study MS Excel MCQ Quiz Sets:

This Sets of MS Word MCQs are helpful for students for learning better about computer.
Practice MS Word MCQ Questions for computer related Exams, Job Interviews and Entrance Tests.

(Q.9) When integrating word and excel, word is usually the

A. Server
B. Destination
C. Client
D. Both (B) and (C)

D. Both (B) and (C)

Discuss Answer


(Q.10) Text formulas:

A. Replace cell references
B. Return ASCII values of characters
C. Concatenate and manipulate text
D. Show formula error value

C. Concatenate and manipulate text

Discuss Answer


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

A. Wrap Text in Format >> Cells
B. Justify in Edit >> Cells
C. Text Wraping in Format >> Cells, Layout tab
D. All of above

A. Wrap Text in Format >> Cells

Discuss Answer


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

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

A. Right click on Sheet Tab of third sheet and choose Delete from the context menu

Discuss Answer


(Q.13) When a label is too long to fit within a worksheet cell, you typically must

A. Shorten the label
B. Increase the column width
C. Decrease the column width
D. Adjust the row height

B. Increase the column width

Discuss Answer


(Q.14) How do you delete a column?

A. Select the column heading you want to delete and select the Delete Row button on the
standard toolbar
B. Select the column heading you want to delete and select Insert Delete from the menu
C. Select the row heading you want to delete and select Edit>Delete from the menu
D. Right click the column heading you want to delete and select delete from the shortcut menu

D. Right click the column heading you want to delete and select delete from the shortcut menu

Discuss Answer


(Q.15) If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

A. From Edit menu choose Clear and then Formats
B. From Edit menu choose Delete
C. Click on Remove Formatting tool on Standard Toolbar
D. Double click the Format Painter and then press Esc key in keyboard

A. From Edit menu choose Clear and then Formats

Discuss Answer


(Q.16) Which is used to perform what if analysis?

A. Solver
B. Goal seek
C. Scenario Manager
D. All of above

D. All of above

Discuss Answer


Parts of MS Excel MCQ Questions & Answer:

Leave a Reply

Your email address will not be published. Required fields are marked *

Solve : *
42 ⁄ 14 =