MS excel set 10 Detailed Explanation And More Example

Question : 1

Which elements of a worksheet can be protected from accidental modification?

a) Contents

b) Objects

c) Scenarios

d) All of the above

e) None of these

Question : 2

In Excel to center worksheet titles across a range of cell, you must

a) Select the cells containing the title text and use the fill handle to center the text across a range of cells

b) Widen the columns

c) Select the cells containing the title text and use the fill handle to center the text across a range of cells

d) Widen the column

Question : 3

Comments can be added to cells using.....

a) Edit-> Comments

b) Insert •> Comment

c) Fl I e-> Comments

d) View-> Comments

e) None of these

Question : 4

In Excel the following is not an underline option in the format cells dialog box

a) Double

b) Single Engineering

c) Single Accounting

d) Double Accounting

Question : 5

What's a quick way to extend these numbers to a longer sequence, for instance 1 through 20?

a) Select both cells, and then drag the fill handle over the range you- want, for instance 18 more rows

b) Select the range you want, include both cells, point to fill on the Edit menu, and then click down.

c) Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special

d) All of above

e) None of these

Question : 6

You can set Page Border in Excel from

a) From Border tab in Format Cells dialog box

b) From Border tool in Formatting toolbar

c) From Line Style tool in Drawing toolbar

d) You can not set page border in Excel

e) None of these