MS excel set 1 Detailed Explanation And More Example

Question : 1

In Excel if you begin typing an entry into a cell and then realize that you don’t want your entry

a) Press Esc

b) Press the Erase key

c) Press the Edit Formula button

d) Press the Enter button

Question : 2

All formula in Excel start with

a) -

b) +

c) =

d) &percent;

Question : 3

Which of the following is not a valid data type in Excel?

a) Number

b) Character

c) Label

d) Date/Time

e) None of these

Question : 4

In Excel you can open the Sort dialog box by choosing Sort from the ….. menu

a) Data

b) Tools

c) Format

d) View

Question : 5

In Excel data marker on a chart are linked to data points in a worksheet, therefore,

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

b) You can automatically apply formatting to a data series

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

d) (A) and (B)

Question : 6

In Excel comments can be added to cells using

a) View > Comments

b) File > Comments

c) Insert > Comments

d) Edit > Comments