Computer Science Microsoft Excel Questions with Answers – Set 04

Are you guys looking for Computer science Engineering MCQ Questions with Answers PDF Free Download as per Computer science Engineering new exam pattern? You came to the right page. This may assist you to understand and check your knowledge about the Subjects. Students also can take a free test of the Multiple Choice Questions of Computer science Engineering. Each question has four options followed by the right answer. These Computer science Engineering MCQ Questions are selected supported by the newest exam pattern.


Q1. To save a workbook, you:

(A) Click the save button on the standard toolbar from the menu
(B) Press Ctrl + F5
(C) Click Save on the Windows Start button
(D) Select Edit>Save

Answer:(A) Click the save button on the standard toolbar from the menu


Q2. When you insert an excel file into a word document. The data are

(A) Hyperlinked placed in a word table
(B) Linked
(C) Embedded
(D) Use the word menu bar and toolbars

Answer: (B) Linked


Q3. All worksheet formula

(A) Manipulate values
(B) Manipulate labels
(C) Return a formula result
(D) Use the addition operator

Answer:(C) Return a formula result


Q4. The autofill feature

(A) Extends a sequential series of data
(B) Automatically adds range of cell values
(C) Applies a boarder around the selected cells
(D) None of the above

Answer: (D) None of the above


Q5. Excel files have a default extension of

(A) Xls
(B) Xlw
(C) Wk1
(D) 123

Answer: (A) Xls


Q6. Which of the following is not information you can specify using the solver?

(A) Input cells
(B) Constraints
(C) Target cell
(D) Changing cells

Answer:(A) Input cells


Q7. To create a formula, you can use:

(A) Values but not cell references
(B) Cell references but not values
(C) Values or cell references although not both at the same time
(D) Value and cell references

Answer:(D) Value and cell references


(A) With the right drag method
(B) With a hyperlink
(C) With the copy and paste special commands
(D) With the copy and paste buttons on the standard toolbar

Answer: (D) With the copy and paste buttons on the standard toolbar


Q9. You can enter which types of data into worksheet cells?

(A) Labels, values and formulas
(B) Labels and values but not formulas
(C) Values and formulas but not labels
(D) Formulas only

Answer: (A) Labels, values and formulas


Q10. 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

Answer: (B) Increase the column width


Q11. Excel worksheet cells work very similarly to what common element of the windows graphical user interface

(A) Option buttons
(B) List boxes
(C) Text boxes
(D) Combo boxes

Answer: (C) Text boxes


Q12. You can use the formula palette to

(A) Format cells containing numbers
(B) Create and edit formulas containing functions
(C) Enter assumptions data
(D) Copy a range of cells

Answer: (B) Create and edit formulas containing functions


Q13. Which of following is Not one of Excel’s what-if function?

(A) Goal seek
(B) Solver
(C) Scenario manager
(D) Auto Outline

Answer: (D) Auto Outline


Q14. Which of the following is the latest version of Excel?

(A) Excel 2000
(B) Excel 2002
(C) Excel ME
(D) Excel XP

Answer: (D) Excel XP


Q15. You can use the horizontal and vertical scroll bars to

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

Answer: (B) View different rows and columns edit the contents of a cell


Microsoft Excel MCQ – All Set

We hope the given computer science Engineering on Microsoft Excel MCQ Questions with Answers will definitely yield fruitful results. Hope you got enough ideas on the MCQs on Microsoft Excel. If you have any queries related to computer science Engineering on Microsoft Excel MCQs Multiple Choice Questions with Answers, drop your questions below and will get back to you as soon as possible.

Leave a Comment

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

Scroll to Top