Microsoft Excel 2016

Microsoft Excel 2016

by Charanjeet Kaur

​Class - 5

​What??

​Microsoft excel is a popular spreadsheet component of Microsoft Office Suite that allows you to store, organize, calculate, and manipulate the available data. It is widely used to perform mathematical calculations. The data is spread in a tabular form, consisting of rows and columns. It provides inbuilt features and tools, such as formulae, functions, and data analysis tools that make it easier to work with large amount of data.

Multiple Choice

MS Excel is used for.....................

• Calculation

• Drawing

• Typing letters

• Listen Music

​Features of Excel

• ​Formulae are mainly used for performing simple and complex mathematical calculations. Functions are the built-in formulae used for calculating percentage, interest, average, etc.

• ​Formatting features improve the appearance of data.

  The data is automatically recalculated in the entire worksheet if any change is made in a single cell.

  The data can be searched quickly and if required replaced instantly.

  Quick data entry can be done in a large series of cells by using the Auto Fill option.

  The data can be viewed in a graphical form, such as charts, which help to understand, analyse, and compare data in an effective manner.

Multiple Choice

Which of the following is not the feature of MS Excel?

• Calculation

• Formatting

• Charts & Graphs

• Adding Sound & Audio

​Worksheet & Workbook

​Workbook - An Excel file  is  called  a  Workbook.  Workbook is like a notebook, which consists of number of pages called worksheet. Default  title for a workbook is  Book1 .

​

​Worksheet - is a grid-like area, made up of rows and columns, where you can enter and work with data. By default, an Excel workbook displays a single worksheet with the name Sheet 1.

​A worksheet consists of 1,048, 576 rows and 16,384 columns. Columns are represented by alphabets on the top and rows by numbers on the left side of the worksheet.

​The Spreadsheet Window

​Components of a worksheet

​Cell - A cell is an intersection of a column and row in a worksheet. Each cell is identified by its column letter and row number, which is known as Cell Address. e.g, A5. A Cell is used to store data, such as text, numbers, formulae, functions, etc. A cell can contain upto 32,767 characters.

​

​Active Cell - When you click on a cell, a thick black border appears around it, which differentiates it from the rest of the cells. This highlighted box is called Cell pointer. It indicates that the current cell is active. Data can be entered only in the active cell.

​Range - A range is a group of contiguous cells, which formt he shape of a rectangle. It can be as small as a single cell or as big as an entire worksheet. You can specify a range by writing the starting cell address followed by the ending cell address, both separated by a colon (:). For example, C1:C10 indicates a range starting from C1 cell address and ending in C10 cell address.

​

​Name Box - Name box is located just above the Column heading on the left side of the window. This area displays the location of the cell pointer.

​

​Formula Bar - The Formula Bar is located to the right of the Name Box. This bar shows the characters and formulae that you enter in an active cell.

​Column Heading - Alphabets across the top border of each worksheet are called column headings. These headings identify columns with letters A to Z, AA.....AZ, BA....BZ,....XAA...XFD. Every worksheet in Excel contains 16,384 columns.

​

​Row Headings - Row headings are the numbers marked from 1 to 1,048,576 along the left border of the worksheet to represent each row of it.

​

​Status Bar - The Status bar is located at the bottom of hte Excel window. It gives us information aout he current selection. It includes the name of the currently selected command or current activity. It also displays warning messages.

​Moving around the Spreadsheet

​Entering Data

​Let us see how to enter data...

​Types of Data

​Three types of data can be entered in a Microsoft Excel worksheet. They are as follows: -

• ​Numbers

• ​Text

• ​Formulae