Class 5 Exam  >  Class 5 Notes  >  IT Elements Class 5: Book Solutions, Notes & Worksheets  >  Worksheet: Introduction to excel

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.

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

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.

You can access the solutions to this worksheet here.

The document Worksheet: Introduction to excel | IT Elements Class 5: Book Solutions, Notes & Worksheets is a part of the Class 5 Course IT Elements Class 5: Book Solutions, Notes & Worksheets.
All you need of Class 5 at this link: Class 5
35 docs

FAQs on Worksheet: Introduction to excel - IT Elements Class 5: Book Solutions, Notes & Worksheets

1. What is Microsoft Excel and why is it important for students?
Ans.Microsoft Excel is a spreadsheet application that allows users to organize, format, and calculate data using formulas. It is important for students as it helps them learn essential skills like data analysis, problem-solving, and basic mathematics, which are useful in academics and future careers.
2. How can I create a simple spreadsheet in Excel?
Ans.To create a simple spreadsheet in Excel, open the program, click on a blank workbook, and start entering data into the cells. You can use rows and columns to organize your information. Remember to save your work frequently!
3. What are some basic functions I can use in Excel?
Ans.Some basic functions in Excel include SUM (to add numbers), AVERAGE (to find the average), MIN (to find the smallest number), and MAX (to find the largest number). These functions can help you analyze your data effectively.
4. How can I format cells in Excel to make my data more readable?
Ans.To format cells in Excel, select the cells you want to format, right-click, and choose "Format Cells." Here, you can change the font, size, color, and number format, which makes your data easier to read and understand.
5. What are charts in Excel, and how can they help me?
Ans.Charts in Excel are graphical representations of your data, such as bar graphs, pie charts, or line graphs. They help you visualize trends and comparisons in your data, making it easier to understand and present information effectively.
Related Searches

past year papers

,

video lectures

,

Free

,

study material

,

Notes & Worksheets

,

mock tests for examination

,

Objective type Questions

,

Viva Questions

,

Worksheet: Introduction to excel | IT Elements Class 5: Book Solutions

,

Worksheet: Introduction to excel | IT Elements Class 5: Book Solutions

,

Notes & Worksheets

,

Semester Notes

,

Extra Questions

,

ppt

,

Notes & Worksheets

,

MCQs

,

Worksheet: Introduction to excel | IT Elements Class 5: Book Solutions

,

practice quizzes

,

pdf

,

Sample Paper

,

shortcuts and tricks

,

Exam

,

Important questions

,

Previous Year Questions with Solutions

,

Summary

;