MS excel set 9 Detailed Explanation And More Example

Question : 1

In Excel the auto calculate feature

a) Can only add values in a range of cells

b) Provides a quick way to view the results of an arithmetic operation on a range of cells

c) Automatically creates formulas and adds them to a worksheet

d) None of the above

Question : 2

Excel worksheet cells work very similarly to what common element of the windows graphical user interface

a) Option buttons

b) List boxes

c) Text boxes

d) Combo boxes

e) None of these

Question : 3

In Excel Comments put in cells are called

a) Smart tip

b) Cell tip

c) Web tip

d) Soft tip

Question : 4

When you work with large worksheets, you may need to

a) size the worksheet to fit on the specific number of pages

b) add and remove page breaks

c) specify only certain print areas

d) all of above

e) None of these

Question : 5

In Excel the following is not a basic step in creating a worksheet

a) Save workbook

b) Modifiy the worksheet

c) Enter text and data

d) Copy the worksheet

Question : 6

In Excel cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is

a) B1-G10

b) B1.G10

c) B1;G10

d) B1:G10*