Excel MCQs Quiz. This MCQs set of Computer Science on Microsoft Excel covers objective type questions important information about excel spreadsheet its history, shortcut keys and all its versions which will be helpful in preparation of public and civil service exams .
1. Latest version of Microsoft Excel is_____?
(A) 2007
(B) 2010
(C) 2015
(D) 2016
2. Lotus 1-2-3 was used as _______?
(A) Word application
(B) Spreadsheet
(C) Powerpoint
(D) None of the above.
3. First spreadsheet which was developed ______?
(A) Microsoft Excel
(B) Visicalc
(C) Lotus-12-3
(D) None of the above.
4. Mircosoft Excel is which type of software ?
(A) Freeware
(B) opensource
(C) trialware
(D) None of these
5. Which is the current version of Microsoft Excel 2016 ?
(A) 12.0
(B) 13.0
(C) 14.0
(D) 16.0
6. Microsoft Excel was first released in which year ?
(A) 1986
(B) 1987
(C) 1988
(D) 1999
7. Which of the following version of Microsoft Excel was not released by Microsoft due to superstitions surrounding?
(A) 8.0
(B) 9.0
(C) 11.0
(D) 13.0
8. When you will save the file of Excel it will be saved with which extension?
(A) .xls
(B) .xlsx
(C) .xlsb
(D) All of the above
9. Excel 2008 (Version 12.0) can handle maximum number of rows ?
(A) 1,040,578
(B) 1,048,576
(C) 1,048,578
(D) None of the above
10. Excel 2008 (Version 12.0) can handle maximum number of columns ?
(A) 16,348
(B) 17,348
(C) 18,348
(D) All of the above
11. Which shortcut keys are used to move between two or more opened Excel files?
(A) CTRL+TAB
(B) Shift+TAB
(C) Both A & B
(D) None of the above
12. Which function Key is used to go to the specific cell?
(A) F4
(B) F5
(C) F6
(D) F7.
13. Which function Key is used to check the spellings in Excel Sheet ?
(A) F7
(B) F8
(C) F9
(D) F10
14. Which shortcut Key is used to insert the current date in the cell ?
(A) Ctrl+:
(B) CTRL+ ;
(C) CTRL+Shift+;
(D) None of these
15. Which shortcut Key is used to create chart from the selected data?
(A) F9
(B) F10
(C) F11
(D) None of the above
See More
Excel MCQs Quiz Computer Science vol 2