MS Excel MCQ with Answers

101) You can zoom a worksheet

Answer is:

All of the above

Explanation:

You can zoom a worksheet
* With the mouse pointer in Print Preview
* With the zoom button on the Print Preview toolbar
* With the Zoom command on the view menu

102) You can not link Excel worksheet data to a Word document

Answer is:

With the copy and paste buttons on the standard toolbar

103) This type of software is similar to an accountant′s worksheet

Answer is:

Spreadsheets

104) which function will calculate the number of workdays between 6/9/2004 and 8/12/2004

Answer is:

Networkdays

Explanation:

In Excel, you can use the NETWORKDAYS function to calculate the number of workdays between two dates, excluding weekends and any holidays that fall within the specified range.

Here's an example formula that calculates the number of workdays between 6/9/2004 and 8/12/2004, assuming that the holidays are listed in cells A1:A3:

105) Data marker on a chart are linked to data points in a worksheet, therefore,

Answer is:

101) You can zoom a worksheet

All of the above

102) You can not link Excel worksheet data to a Word document

With the copy and paste buttons on the standard toolbar

103) This type of software is similar to an accountant′s worksheet

Spreadsheets

104) which function will calculate the number of workdays between 6/9/2004 and 8/12/2004

Networkdays

105) Data marker on a chart are linked to data points in a worksheet, therefore,

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