MS excel set 1 Detailed Explanation And More Example

Question : 1

In Excel comments can be added to cells using

a) View > Comments

b) File > Comments

c) Insert > Comments

d) Edit > Comments

Question : 2

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

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

a) Data

b) Tools

c) Format

d) View

Question : 4

In Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ….. ……menu

a) Tools

b) Edit

c) Data

d) Format

Question : 5

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

a) Formula bar

b) Title bar

c) Standard toolbar

d) Menu bar

Question : 6

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