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
D. Both (B) and (C)
(Q.10) Text formulas:
A. Replace cell references
B. Return ASCII values of characters
C. Concatenate and manipulate text
D. Show formula error value
(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
(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
(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
(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
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
(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
(Q.16) Which is used to perform what if analysis?
B. Goal seek
C. Scenario Manager
D. All of above