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. Each excel file is called a workbook because
(A) It can contain text and data
(B) It can be modified
(C) It can contain many sheets including worksheets and chart sheets
(D) You have to work hard to create it
Answer: (C) It can contain many sheets including worksheets and chart sheets
Q2. Concatenation of text can be done using
(A) Apostrophe (&lsquo
(B) Exclamation (!)
(C) Hash (#)
(D) Ampersand (&
Answer: (D) Ampersand (&
Q3. A worksheet can have a maximum of _ Number of rows
(A) 256
(B) 1024
(C) 32000
(D) 65535
Answer: (D) 65535
Q4. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
(A) Pie chart
(B) Row chart
(C) Line chart
(D) Column chart
Answer: (C) Line chart
Q5. Multiple calculations can be made in a single formula using
(A) Standard formulas
(B) Array formula
(C) Complex formulas
(D) Smart formula
Answer: (B) Array formula
Q6. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
(A) Select Format > Money from the menu
(B) Click the Currency Style button on the formatting toolbar
(C) You have to retype everything and manually add the dollar signs, commas, and decimals
(D) None of these
Answer: (B) Click the Currency Style button on the formatting toolbar
Q7. Which of the following methods cannot be used to enter data in a cell?
(A) Pressing an arrow key
(B) Pressing the Tab key
(C) Pressing the Esc key
(D) Clicking on the formula bar
Answer: (C) Pressing the Esc key
Q8. Getting data from a cell located in a different sheet is called _
(A) Accessing
(B) Referencing
(C) Updating
(D) Functioning
Answer: (B) Referencing
Q9. You can edit a cell by
(A) Clicking the formula button
(B) Double clicking the cell to edit it in-place
(C) Selecting Edit > Edit Cell from the menu
(D) None of above
Answer: (B) Double clicking the cell to edit it in-place
Q10. When you link data maintained in an excel workbook to a word document
(A) The word document cannot be edit
(B) The word document contains a reference to the original source application
(C) The word document must contain a hyperlink
(D) The word document contains a copy of the actual data
Answer: (B) The word document contains a reference to the original source application
Q11. Which of the following methods cannot be used to edit the contents of a cell?
(A) Press the Alt key
(B) Clicking the formula bar
(C) Pressing the F2 key
(D) Double clicking the cell
Answer: (A) Press the Alt key
Q12. How do you insert a row?
(A) Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
(B) Select the row heading where you want to insert the new row and select Edit >Row from the menu
(C) Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
(D) All of the above
Answer:(A) Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
Q13. Excel uniquely identifies cells within a worksheet with a cell name
(A) Cell names
(B) Column numbers and row letters
(C) Column letters and row numbers
(D) Cell locator coordinates
Answer: (C) Column letters and row numbers
Q14. Right clicking something in Excel:
(A) Deletes the object
(B) Nothing the right mouse button is there for left handed people
(C) Opens a shortcut menu listing everything you can do to the object
(D) Selects the object
Answer: (C) Opens a shortcut menu listing everything you can do to the object
Q15. Which of the following is the oldest spreadsheet package?
(A) VisiCalc
(B) Lotus 1-2-3
(C) Excel
(D) StarCalc
Answer: (A) VisiCalc
Microsoft Excel MCQ – All Set
- Microsoft Excel Multiple Choice Questions – Set 01
- Microsoft Excel MCQs with Answers – Set 02
- Microsoft Excel MCQ Questions and Answers – Set 03
- Computer Science Microsoft Excel Questions with Answers – Set 04
- MCQ for Microsoft Excel – Set 05
- MS Excel MCQ Questions and Answers pdf – Set 06
- Microsoft Excel Exam Questions MCQs with Answers pdf – Set 07
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.