Microsoft Excel 2010 MCQs


36. Question

We are having marks of English, Maths and Science in B2, B3 and B4 cells respectively. The maximum marks of each subject are 100. Then the correct formula for calculating percentage in MS-Excel 2010 is/are:




Answer
37. Question

What is he correct formula to perform the addition of data present in A1 to A5 cells?




Answer
38. Question

In MS-Excel, ____________ is an intersection of rows and cloumns.




Answer
39. Question
Which function you can use for getting specified number of characters starting from left of a string in Windows Excel 2010?




Answer
40. Question
To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the-




Answer