Microsoft Excel MCQs with Answers – Set 02

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 edit in an embedded excel worksheet object in a word document

(A) Use the excel menu bar and toolbars inside the word application
(B) Edit the hyperlink
(C) Edit the data in a excel source application
(D) Use the word menu bar and toolbars

Answer: (A) Use the excel menu bar and toolbars inside the word application


Q2. What symbol is used before a number to make it a label?

(A) ” (quote)
(B) = (equal)
(C) _ (underscore)
(D) ‘ (apostrophe)

Answer: (D) ‘ (apostrophe)


Q3. You can use the drag and drop method to

(A) Copy cell contents
(B) Move cell contents
(C) Add cell contents
(D) Both ‘a’ and ‘b’

Answer:(D) Both ‘a’ and ‘b’


Q4. Rounding errors can occur

(A) When you use multiplication, division, or exponentiation in a formula
(B) When you use addition and subtraction in a formula
(C) Because excel uses hidden decimal places in computation
(D) When you show the results of formulas with different decimal places that the calculated results

Answer: (A) When you use multiplication, division, or exponentiation in a formula


Q5. Which of the following will not cut information?

(A) Pressing Ctrl + C
(B) Selecting Edit > Cut from the menu
(C) Clicking the Cut button on the standard
(D) Pressing Ctrl+X

Answer: (A) Pressing Ctrl + C


Q6. You can copy data or formulas

(A) With the copy, paste and cut commands on the edit menu
(B) With commands on the shortcut menu
(C) With buttons on the standard toolbars
(D) All of the above

Answer: (D) All of the above


Q7. A typical worksheet has __ Number of columns

(A) 128
(B) 256
(C) 512
(D) 1024

Answer:(B) 256


Q8. Comments can be added to cells using

(A) Edit > Comments
(B) Insert > Comments
(C) File > Comments
(D) View > Comments

Answer: (B) Insert > Comments


Q9. You can use the format painter multiple times before you turn it off by

(A) You can use the format painter button only one time when you click it
(B) Double clicking the format painter button
(C) Pressing the Ctrl key and clicking the format painter button
(D) Pressing the Alt key and clicking the format painter button

Answer: (B) Double clicking the format painter button


Q10. How do you select an entire column?

(A) Select Edit > Select > Column from the menu
(B) Click the column heading letter
(C) Hold down the shift key as you click anywhere in the column
(D) Hold down the Ctrl key as you click anywhere in the column

Answer:(B) Click the column heading letter


Q11. You can convert existing excel worksheet data an charts to an HTML document by using

(A) FTP wizard
(B) Internet assistant wizard
(C) Intranet wizard Intranet wizard
(D) Import wizard

Answer: (B) Internet assistant wizard


Q12. The Chart wizard term data categories refers to;

(A) A chart plot area
(B) A horizontal axis
(C) The organization of individual values with a chart’s data series
(D) The data range that supply chart data

Answer: (B) A horizontal axis


Q13. Which of the following is an absolute cell reference?

(A) !A!1
(B) $A$1
(C) #a#1
(D) A1

Answer:(B) $A$1


Q14. Excel probably considers the cell entry January 1,2000 to be a

(A) Label
(B) Value
(C) Formula
(D) Text string

Answer: (B) Value


Q15. How can you find specific information in a list?

(A) Select Tools > Finder from the menu
(B) Click the Find button on the standard toolbar
(C) Select Insert > Find from the menu
(D) Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button

Answer: (D) Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button


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