(i) What is the purpose of spreadsheets?
(a) Drawing
(b) Data maintenance
(c) Word processing
(d) Gaming
(ii) Who is known as the father of the electronic spreadsheet?
(a) Bill Gates
(b) Dan Bricklin
(c) Steve Jobs
(d) Mark Zuckerberg
(iii) Which program is mentioned as a part of Microsoft Office 2010 package?
(a) MS Word
(b) MS PowerPoint
(c) MS Excel
(d) All of the above
(iv) What is the default extension for a workbook in MS Excel?
(a) .doc
(b) .xls
(c) .ppt
(d) .txt
(v) How is the Quick Access Toolbar useful?
(a) It allows access to commonly used commands.
(b) It changes the color of the worksheet.
(c) It creates new workbooks.
(d) It performs complex calculations.
(i) Spreadsheets are used for doing calculations and arranging data in an ____________ manner.
(ii) Dan Bricklin and Bob Frankston co-invented the software program ____________, the first spreadsheet application for personal computers.
(iii) The MS Excel window includes components like Quick Access Toolbar, Ribbon, and ____________.
(iv) The File tab in MS Excel is used to open new or existing workbooks, save, and ____________ them.
(v) The cell reference A2 indicates the intersection of column ____________ and row ____________.
(i) If a person enters wrong data in a manual worksheet, the totals and averages are automatically corrected.
(ii) MS Excel 2010 is a part of the Microsoft Office 2010 package.
(iii) The active cell in MS Excel always has a red outline.
(iv) The Auto Fill feature in Excel is only used to fill the same data in adjacent cells.
(v) The File tab in MS Excel is used for formatting cells.
You can access the solutions to this worksheet here.
1. What is Microsoft Excel and why is it important for students? | ![]() |
2. How can I create a simple spreadsheet in Excel? | ![]() |
3. What are some basic functions I can use in Excel? | ![]() |
4. How can I format cells in Excel to make my data more readable? | ![]() |
5. What are charts in Excel, and how can they help me? | ![]() |