MS excel set 13 Detailed Explanation And More Example

Question : 1

The view that puts a blue a blue line around each page that would be printed is the......

a) Print Preview

b) Normal View

c) Page Break Preview

d) Split View

e) None of these

Question : 2

How do you insert a row?

a) Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu

b) Select the row heading where you want to insert the new row and select Edit > Row from the menu

c) Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar

d) All of the above

e) None of these

Question : 3

You are editing an worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which Command should you use?

a) New

b) Save As

c) Edit

d) Save

e) None of these

Question : 4

When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply t

a) Use -if function to format the required numbers red

b) Apply Conditional Formatting command on Format menu

c) Select the cells that contain number between 0 and 100 then click Red color on Text Color tool

d) All of above

e) None of these

Question : 5

To select a column the easiest method is to........

a) Double click any cell in the column

b) Drag from the top cell in the column to the last cell in the column

c) click the column heading

d) click the column label

e) None of these

Question : 6

Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?

a) Use Ctrl to select all three cells, then click the paste button on the standard toolbar

b) Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify

c) Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to

d) All of above

e) None of these