MS excel set 8 Detailed Explanation And More Example

Question : 1

You can set Excel in Automatic or Manual calculation mode. If it is in manual mode which key you will press to update the formula values?

a) F9

b) F5

c) F8

d) F11

e) None of these

Question : 2

When you link data maintained in Excel workbook to a Word document

a) The Word document cannot be edited

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

Question : 3

Which of the following is not a term of MS-Excel?

a) Cells

b) Rows

c) Columns

d) Document

e) None of these

Question : 4

In Excel how do you change column width to fit the contents?

a) Single-click the boundary to the left to the column heading

b) Double click the boundary to the right of the column heading

c) Press Alt and single click anywhere in the column

d) All of above

Question : 5

Multiple calculations can be made In a single formula using....

a) Standard Formulas

b) Array Formula

c) Complex Formulas

d) Smart Formula

Question : 6

Microsoft Excel Is a powerful...........

a) Word processing package

b) Spreadsheet package

c) Communication S/W Package

d) DBMS package

e) None of these