MS excel set 6 Detailed Explanation And More Example

Question : 1

Which of the following is not What IF analysis tool in Excel?

a) Goal Seek

b) Scenarios

c) Macros

d) All of above

e) None of these

Question : 2

Which key do you press to check spelling?

a) F3

b) F5

c) F7

d) F9

e) None of these

Question : 3

How can you delete a record?

a) Delete the column from the worksheet

b) Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button

c) Select Data > Delete Record from the menu

d) Click the Delete button on the Standard toolbar

e) None of these

Question : 4

In Excel to cancel the marquee, press

a) Ctrl + End

b) End

c) Esc

d) Shift + Esc

Question : 5

You can check the conditions against ___ when applying conditional formatting

a) Cell value

b) Formula

c) Both of above

d) writing

e) None of these

Question : 6

How should you print a selected area of a worksheet, if you'll want to print a different area next time?

a) On the file menu, point to print area, and then click set print are

b) On the file menu, click print, j and then click selection under print what

c) On the view menu, click custom views, then click add

d) All of above

e) None of these