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. The name box
(A) Shows the location of the previously active cell
(B) Appears to the left of the formula bar
(C) Appears below the status bar
(D) Appears below the menu bar
Answer: (B) Appears to the left of the formula bar
Q2. It is acceptable to let long text flow into adjacent cells on a worksheet when
(A) Data will be entered in the adjacent cells
(B) No data will be entered in the adjacent cells
(C) There is no suitable abbreviation of the text
(D) There is not time to format the next
Answer: (B) No data will be entered in the adjacent cells
Q3. Which of the following is a correct order of precedence in formula calculation?
(A) Multiplication and division exponentiation positive and negative values
(B) Multiplication and division, positive and negative values, addition and subtraction
(C) Addition and subtraction, positive and negative values, exponentiation
(D) All of above
Answer: (D) All of above
Q4. Comments put in cells are called
(A) Smart tip
(B) Cell tip
(C) Web tip
(D) Soft tip
Answer: (B) Cell tip
Q5. How many characters can be typed in a single cell in Excel?
(A) 256
(B) 1024
(C) 32000
(D) 65535
Answer: (D) 65535
Q6. Hyperlinks can be
(A) Text
(B) Drawing objects
(C) Pictures
(D) All of above
Answer: (D) All of above
Q7. Documentation should include
(A) Destination and users of the output data
(B) Source of input data
(C) Information on the purpose of the workbook
(D) All of the above
Answer: (D) All of the above
Q8. Which of the following options is not located in the Page Setup dialog box?
(A) Page Break Preview
(B) Page Orientation
(C) Margins
(D) Headers and Footers
Answer: (A) Page Break Preview
Q9. To center worksheet titles across a range of cells, you must
(A) Select the cells containing the title text plus the range over which the title text is to be centered
(B) Widen the columns
(C) Select the cells containing the title text plus the range over which the title text is to be enfettered
(D) Format the cells with the comma style
Answer:(A) Select the cells containing the title text plus the range over which the title text is to be centered
Q10. Tab scrolling button
(A) Allow you to view a different worksheet
(B) Allow you to view additional worksheet rows down
(C) Allow you to view additional worksheet columns to the right
(D) Allow you to view additional sheets tabs
Answer: (D) Allow you to view additional sheets tabs
Q11. To copy formatting from one area in a worksheet and apply it to another area you would use:
(A) The Edit > Copy Format and Edit > Paste Format commands form the menu
(B) The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu
(C) There is no way to copy and apply formatting in Excel – You have to do it manually
(D) The Format Painter button on the standard toolbar
Answer: (D) The Format Painter button on the standard toolbar
Q12. When you copy a formula
(A) Excel erases the original copy of the formula
(B) Excel edits cell references in the newly copied formula
(C) Excel adjusts absolute cell references
(D) Excel doesn’t adjust relative cell references
Answer: (B) Excel edits cell references in the newly copied formula
Q13. When you want to insert a blank imbedded excel object in a word document you can
(A) Click the object command on the insert menu
(B) Click the office links button on the standard toolbar
(C) Click the create worksheet button on the formatting toolbar
(D) Click the import excel command on the file menu
Answer:(A) Click the object command on the insert menu
Q14. Text formulas:
(A) Replace cell references
(B) Return ASCII values of characters
(C) Concatenate and manipulate text
(D) Show formula error value
Answer: (C) Concatenate and manipulate text
Q15. The auto calculate feature
(A) Can only add values in a range of cells
(B) Provides a quick way to view the result of an arithmetic operation on a range of cells
(C) Automatically creates formulas and adds them to a worksheet
(D) Both A and C
Answer: (B) Provides a quick way to view the result of an arithmetic operation on a range of cells
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.