MS excel set 3 Detailed Explanation And More Example

Question : 1

In Excel which of the following is not a valid data type in excel

a) Number

b) Character

c) Label

d) Date/time

Question : 2

Which of the following is the latest version of Excel

a) Excel 2000

b) Excel 2002

c) Excel ME

d) Excel XP

e) None of these

Question : 3

How do you rearrange the data In ascending or descending order?

a) Data, Sort

b) Data, Form

c) Data, Table

d) Data Subtotals

e) None of these

Question : 4

In Excel it is acceptable to let long text flow into adjacent cells on a worksheet when

a) Data will be entered in the adjacent cells

b) No data will be entered in the adjacent cells

c) There is no suitable abbreviation for the text

d) There is not time to format the text

Question : 5

In Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

a) Unfreeze panes command on the window menu

b) Freeze panes command on the window menu

c) Hold titles command on the edit menu

d) Split command on the window menu

Question : 6

In Excel you can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.

a) Edit

b) Insert

c) Format

d) Tools