MS excel set 1 Detailed Explanation And More Example

Question : 1

In Excel when you want to insert a blank imbedded excel object in a word document you can

a) Click the office links button on the standard toolbar

b) Click the object command on the insert menu

c) Click the import excel command on the file menu

d) Click the create worksheet button on the formatting toolbar

Question : 2

In Excel comments can be added to cells using

a) View > Comments

b) File > Comments

c) Insert > Comments

d) Edit > Comments

Question : 3

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 : 4

Which area in an excel window allows entering values and formulas ?

a) Formula bar

b) Title bar

c) Standard toolbar

d) Menu bar

Question : 5

In Excel which functions will calculate the number of workdays between 6/9/2004 and 8/12/2004

a) Networkdays

b) Workday

c) Date

d) All of the above

Question : 6

In Excel you can create only a horizontal page break by first selecting

a) A cell in column A

b) A row below the row where you want the page break to occure

c) A cell in row 1

d) (A) and (B)