Microsoft Excel Questions

HomeComputer Exam⇒ Excel Basic Questions, Quiz

Q1. The intesection of rows and columns are called
(a) Sheet
(b) Cell
(c) Workbook
(d) None of the above

Q2. What is the maximum number of rows supported in a Excel 2007 worksheet
(a) 65,357
(b) 78,487
(c) 1,028,176
(d) 1,048,576

Q3. What is the maximum number of columns supported in a Excel 2007 worksheet
(a) 12,357
(b) 16,384
(c) 21,783
(d) 26,263

Q4. What is the default extention of Microsoft Excel 2003 saved file
(a) .xls
(b) .xsl
(c) .xlsx
(d) .xlxs

Q5. VBA in MS-Excel was used from which version
(a) Excel 4
(b) Excel 5
(c) Excel 6
(d) Excel 7

Q6. Total number of characters that a cell can contain
(a) 24,221
(b) 27,685
(c) 32,767
(d) 39,802

Q7. Which function key generates a bar graph from the values enterd in excel
(a) F9
(b) F10
(c) F11
(d) F12

Q8. All formulas in MS Excel is start with _______ sign
(a) $
(b) =
(c) ()
(d) !

Q9. If "A1" is displayed in Name Box, then is indicates which one
(a) First column (by A) and first row (by 1)
(b) First column (by 1) and first row (by A)
(c) First sheet
(d) None of the above

Q10. Which commanad need to excute from "run window" to open a new excel file
(a) ms excel
(b) win excel
(c) office excel
(d) excel

Q11. In which year, Microsoft released the first version of Excel for Windows version
(a) 1983
(b) 1985
(c) 1987
(d) 1989

Q12. In excel, which chart is also known as X Y chart
(a) Pie chart
(b) Bar chart
(c) Area chart
(d) Scatter chart

Q13. In excel, which one chart type is not available
(a) Radar
(b) Buble
(c) Doughnut
(d) Sphere

Q14. Which one/are the Chart Tool tab/tabs that adds in the ribbon when you display a chart
(a) Design
(b) Layout
(c) Format
(d) All of the above

Q15. In Excel 2007, Axes option can be found in
(a) Design
(b) Layout
(c) Format
(d) Formulas

1 2 3

Enter Email Address for Newsletter

    Share on facebook    Share on twitter    Share on google +