header

Microsoft Excel Questions

Q1. The intersection 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 extension 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 entered 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 command need to execute 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