MS Excel Worksheet for Practice Class 4.pdf

MS Excel Worksheet is for Class 4 Computers, comprising the topic of MS Excel It will help students develop a better understanding of MS Excel

1. www.takshilalearning.com call 8800999284
MS Excel Worksheet for Practice Class 4
This worksheet is for Class 4 Computers, comprising the topic of MS Excel. It will help students
develop a better understanding of MS Excel.
The completion of this worksheet will make students comprehend the following:
1. What is MS Excel?
2. Discuss some features of MS Excel.
3. Discuss some benefits of using MS Excel.

1. What is MS Excel?
MS Excel Class
4 computers[/caption]
Microsoft Excel or MS Excel is a spreadsheet tool that comes as a part of the Microsoft Office
applications. The focus of this tool is to record data in periodic tables, which simplifies the
process of data analysis. MS Excel comes with many attractive features helpful in organizing all
kinds of data.
The image below depicts the appearance of an Excel spreadsheet:

2. Discuss some features of MS Excel.
The composition of features in MS Excel is shown in the image below:

2. www.takshilalearning.com call 8800999284
Features of MS Excel.[/caption]
Each tab has features of its own. Let’s go through some of the features -
 Home : Font size, alignment, font styles, font color, background color, formatting choices
and styles, cell insertion and deletion, and editing options are all included.
 Insert : Table format and style, inserting photos and figures, adding graphs, charts, and
sparklines, header and footer settings, and equation, and symbol options are all
included.
 Page Layout: There are options for themes, orientation, and page setup in the page
layout option.
 Formulas: Because MS Excel can build tables with a big quantity of data, you may use
this function to add formulae to your table and receive faster results.
 Data: This category includes features such as adding external data (from the web),
filtering choices, and data tools.
 Review: In the review category, proofreading (like spell check) may be done for an excel
sheet, and a reader can submit comments in this section.
 View : This is where we may change the views in which the spreadsheet is shown.
Zooming in and out, as well as pane layout, are all available in this category.

3. Discuss some benefits of using MS Excel.
The following are some of the most inherent benefits of using MS Excel:
 More Secure: In comparison to data entered in registers or on a piece of paper, these
spreadsheets may be password protected on a laptop or personal computer, and the risk
of losing them is much lower.
 Data at One Place: A systematic tool helps organize data in one place. If there is a
student database to be created, it can be made in 1 MS Excel workbook leveraging the
worksheet feature for adding data of different classes. Such features make data more
comprehensive and structured.

3. www.takshilalearning.com call 8800999284
 Neater and Clearer Visibility of Information: Analyzing data gets easier when it is
recorded in the form of a table. This allows the data to get presented in a more readable
and understandable spreadsheet.
 Easy To Store Data: MS Excel is extensively used to record and analyze data since
there is no limit to the quantity of data that can be saved in a spreadsheet. Filtering data
in Excel is simple and straightforward.
 Easy To Recover Data: Finding information written on a piece of paper might take
longer, but this is not the case with excel spreadsheets. It's simple to locate and retrieve
data.
 Application of Mathematical Formulas: With the formulae feature in MS Excel, doing
calculations has become easier and less time-consuming.

1. Answer the following:
1. The horizontal arrangement of cells. ____________
2. The vertical arrangement of cells. ____________
3. Basic unit of worksheet formed by the interaction of a row and column where we enter
data. _________
4. Black boundary around the selected cell that specifies which cell is active at that
moment. ___________
5. An MS Excel file which consist of one or more worksheets. ____________
6. Horizontal rows and vertical columns form a grid of cells. ___________
7. It displays the name of workbook, which is currently in use. ___________
8. It displays the address of the current cell. ____________
9. The cell on which we are working currently. ____________
10. The contents of the active cell are shown in this region. __________

2. State True/False:
1. A worksheet is also known as a spreadsheet.
2. For creating a new excel sheet, the “Alt + F4” key is the key.
3. Cell Address refers to the cell with a dark boundary.
4. In MS-Excel, a formula always begins with a "#" symbol.
5. Workpad is the name of a Microsoft Excel document.