microsoft excel q/a Practice Questions Answers Test with Solutions & More Shortcuts

Question : 11

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 : 12

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 : 13

Data marker on a chart are linked to data points in a . worksheet therefore,

a) You can automatically apply formatting to a data series

b) You can change the position of a data marker and automatically change the data point value in the worksheet

c) You can change a data print value and automatically are draw the chart

d) a and b

e) None of these

Question : 14

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 : 15

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