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?

2. Question

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

3. Question

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

4. Question

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

5. Question

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