MS excel set 7 Detailed Explanation And More Example

Question : 1

In Excel this type of software is similar to an accountant’s worksheet

a) Word processing

b) Database

c) Spreadsheets

d) Graphics

Question : 2

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

e) None of these

Question : 3

In Excel 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) (A) and (C)

Question : 4

Where can you change automatic or manual calculation mode in Excel?

a) Double CAL indicator on status bar

b) Go to Tools > > Options > > Calculation and mark the corresponding radio button

c) Both of above

d) Press F7

e) None of these

Question : 5

In Excel 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

Question : 6

In Excel when you see a cell with a red triangle in the top right corner, what does this signify?

a) There is an error in the cell

b) There is a comment associated with the cell

c) The font color for text in the cell is red

d) A formula cannot be entered into the cell