MS Excel MCQ Questions and Answers pdf – Set 06

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. Data can be arranged in a worksheet in a easy to understand manner using

(A) Auto formatting
(B) Applying styles
(C) Changing fonts
(D) All of above

Answer: (D) All of above


Q2. The chart wizard term data series refers to

(A) A chart legend
(B) A collection of chart data markers
(C) A set of values you plot in a chart
(D) A data label

Answer: (B) A collection of chart data markers


Q3. Which of the following is not a basic step in creating a worksheet?

(A) Save workbook
(B) Modify the worksheet
(C) Enter text and data
(D) Copy the worksheet

Answer:(D) Copy the worksheet


Q4. An excel workbook is a collection of

(A) Workbooks
(B) Worksheets
(C) Charts
(D) Worksheets and charts

Answer: (D) Worksheets and charts


Q5. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

(A) Press Ctrl +Home
(B) Press Home
(C) Press Shift + Home
(D) Press Alt + Home

Answer: (A) Press Ctrl +Home


Q6. Which of the following is not a way to complete a cell entry?

(A) Pressing enter
(B) Pressing any arrow key on the keyboard
(C) Clicking the Enter button on the Formula bar
(D) Pressing spacebar

Answer: (D) Pressing spacebar


Q7. A numeric value can be treated as a label value if it proceeds with

(A) Apostrophe (&lsquo
(B) Exclamation (!)
(C) Hash (#)
(D) Ampersand (&

Answer:(A) Apostrophe (&lsquo


Q8. To activate the previous cell in a pre-selected range, press

(A) The Alt key
(B) The Tab key
(C) The Enter key
(D) None of the above

Answer: (D) None of the above


Q9. Which elements of worksheet can be protected from accidental modification?

(A) Contents
(B) Objects
(C) Scenarios
(D) All of above

Answer: (D) All of above


Q10. Files created with Lotus 1-2-3 have an extension

(A) DOC
(B) XLS
(C) 123
(D) WK1

Answer: (C) 123


Q11. To create a formula, you first:

(A) Select the cell you want to place the formula into
(B) Type the equals sign (=) to tell Excel that you’re about to enter a formula
(C) Enter the formula using any input values and the appropriate mathematical operators that make up your formula
(D) Choose the new command from the file menu

Answer: (A) Select the cell you want to place the formula into


Q12. You can activate a cell by

(A) Pressing the Tab key
(B) Clicking the cell
(C) Pressing an arrow key
(D) All of the above

Answer: (D) All of the above


Q13. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

(A) Unfreeze panes command on the window menu
(B) Freeze panes command on the window menu
(C) Hold titles command on the edit menu
(D) Split command on the window menu

Answer: (B) Freeze panes command on the window menu


Q14. Which of the following formulas is not entered correctly?

(A) =10+50
(B) =B7*B1
(C) =B7+14
(D) 10+50

Answer: (D) 10+50


Q15. Which of the following is not a worksheet design criterion?

(A) Efficiency
(B) Aditibility
(C) Description
(D) Clarity

Answer:(C) Description


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