Microsoft Excel 2010 MCQs
11. Question
Which of the following chart contains only one chart data series and all the values should be positive for this type of chart in MS-Excel 2010?
Answer
12. Question
Suppose you are working on Worksheet named “sheet1” and you want sum the values of A1 to A10 cells present in worksheet named “sheet3” then the correct formula in MS-Excel 2010 is
Answer
13. Question
In MS-Excel, _________ is an intersection of rows and column.
Answer
14. Question
Which function you can use for joining two or more text strings of selected cell range in Windows Excel 2010?
Answer
15. Question
__________ function used to removes duplicate spaces and spaces at the start and end of the string in MS-Excel 2010.
Answer