Microsoft Excel 2010 MCQs

Get Started with “Microsoft Excel 2010“ MCQs:

1. Question

Suppose obtained marks of each paper are in B2 to B7 cells. Maximum Marks are 100 for each paper. What is the correct formula to calculate percentage in MS-Excel 2010?

= SUM(B2:B7) /600 *100
=600*100/SUM(B2:B7)
=OBTAIN(B2:B7)/600*100
All of the above

Answer

2. Question

What is the use of Paste with Live Preview in MS-Excel 2010?

It avoid repetitive hit and trails and you can effortlessly reuse content previewing.
It will repair all the files and folder.
It works to compute an unknown values.
There is no such preview available in MS-Excel 2010.

Answer

3. Question

What is the use of Shift + F3 shortcut key in MS- Excel 2010?

To insert an image
To open a new sheet
To save the existing sheet
To insert a function

Answer

4. Question

In MS-Excel charts, actual value of the data point is called _________________?

Legend
Gridlines
Data Labels
Data Series

Answer

5. Question

Tiny charts embedded in a cell that give a visual trend summary alongside your data are-

Embedded charts
Sparklines
Chart styles
Borderline

Answer

Pages: 1 2 3 4 5 6 7 8 9 10 11