Worksheet: Introduction to excel | IT Elements Class 5: Book Solutions, Notes & Worksheets PDF Download

Q1: Multiple Choice Questions (MCQs).

(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.

Q2: Fill in the Blanks.

(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 ____________.

Q3: Match the Column.

Q4: True or False.

(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.