Classical

MS-Excel - Advanced MS-Excel

1:  

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

A.

Workday

B.

Date

C.

Networkday

D.

Weekday

 
 

Option: D

Explanation :


2:  

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

A.

You can automatically apply formatting to a data series

B.

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

C.

You can change a data point value and automatically that is drawn in  the chart

D.

Both (b) & (c)

 
 

Option: D

Explanation :


3:  

MS-Excel uses the . . . . Function when creating a data table

A.

Average

B.

Count

C.

Both (a) & (b)

D.

Table

 
 

Option: D

Explanation :


4:  

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

A.

Workday

B.

Date

C.

Networkday

D.

Weekday

 
 

Option: D

Explanation :


5:  

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

A.

Edit

B.

Format

C.

Tools

D.

All of the above

 
 

Option: C

Explanation :




Suggest an improvement

 


Syllabus Covered in this section is –

  • Basics of Spreadsheet
  • Manipulation of cells
  • Formulas and Functions
  • Editing of Spread Sheet
  • Printing of Spread Sheet

This section contains Microsoft Excel Multiple Choice Questions answers.

Who can benefit - 

  • Any candidate who has to appear for DOEACC CCC level Exam or DOEACC BCC level can also use MS Excel Questions Answers to gain credits in their exams.
  • MS Excel Objective type Questions Answers can also be used by any candidate who wants to appear for Bank Exams.
  • This section also contains MS Excel question papers which can be used for interview preparation.
  • Any student who is pursuing PG Diploma in Computers can also use this MS Excel mcq section. 
  • Microsoft Excel Multiple Choice Questions Answers can also be used by any student who is pursuing any undergraduate or postgraduate certificate in Computer Application.
  • You can also give MS Excel Free Practice Test.
  • This section is divided into three parts- MS Excel MCQ, Advanced MS Excel Questions and MS Excel Shortcut Keys Questions.
  • Microsoft Excel MCQ section can be used as a practice test for beginners.
  • This section can help you in learning excel.
  • You can also get MS Excel mcq pdf from site.
  • You can get MS Excel MCQ eBook from this site.
  • This MS Excel Quiz can be used by any candidate to increase his general knowledge in Computers.

    Various Search Terms used for this section are

MS Excel mcq questions answers pdf

MS Excel mcq pdf

MCQ question for Microsoft  Excel

Microsoft Excel quiz questions and answers

MS Excel question paper

MS Excel question bank

MS Excel questions and answers pdf