Microsoft Excel (Spread Sheet)

Introduction

Excel is a spreadsheet application developed and published by Microsoft. It is part of the Microsoft Office suite of productivity software. It allows you to store, organize, and analyzeinformation. Excel organizes data in columns and rows. Rows and columns intersect at a space called a cell. Each cell can contain a single piece of data, such as text, a numerical value, or a formula. Microsoft Excel was not the first spreadsheet program, Lotus 1-2-3 and VisiCalc were popular spreadhseet programs released before Excel.

Microsoft Excel 2010/2013/2016/2019

Excel 2019 is the latest version yet in the Microsoft Office 2019 package. All the version of Excel of Excel may be some slight differences, but for the most part these versions are similar. In the Excel 2010/2013/2016/2019 version, the operational and functional commands are situated in tabs which that let the user to perform tasks on the Spreadsheet. It is displayed in Gridlines means its working area is the collection of Rows & Columns and that is formally known as Sheet. Microsoft Excel 2010/2013/2016/2019 contains tabs of different kinds like Home, Insert, Page Layout, Formulas, Data, review and view.

In Ms excel, column value is identified by the column header which is label as A,B,C,………,AA,………,XFD. But the row value is identified by the row header which is labeled as 1,2,3,…10,48,576.

Opening the MS Excel 2013 Package

To open MS Excel on your computer, follow the steps given below:

Elements of a Spread Sheet

1.Ribbon:The Ribbon contains multiple tabs, each with several groups of commands. You will use these tabs to perform the most common tasks in Excel. Each tab will have one or more groups.

2.Worksheet: A Worksheet is the place where the user works and performs arithmetical and functional calculations. By default, it is named as Sheet1, Sheet2, Sheet3 etc., a sheet can be renamed too.

3.Workbook: A Workbook is a collection of worksheets where the user works.

4.Cell: A Cell is the intersection of a Row and a Column. For example, Cell A1 is the intersection of column A and Row 1. A cell in which the mouse pointer is available; this cell is known as an active cell; cells may contain text, numbers, and formulas.

5.Cell Range:It contains One or more adjacent cells. A range is identified by its first and last cell addresses, separated by a colon.

6.Formula Bar: This bar appears on the right side of the Name box. it displays formula as well as the value entered into the active cell. It is also used to edit formulas and content in it.

7.Name Box: This box appears on the left of the formula bar and displays the address of the active cell.

8.Sheet Tab: This tab appears at the bottom of the Excel workbook. by using Sheet tab we can open any worksheet. Each worksheet is identified by a label given as Sheet1, Sheet2, Sheet3…etc. You can rename the sheet name according to uour requirements. You move from one worksheet to another worksheet by using navigation button.

Mouse Pointer Styles

The Excel mouse pointer takes on many different appearances as you move around the spreadsheet. The following table summarizes the most common mouse pointer appearances:

Creating of Spreadsheet

Excel files are called workbooks. Whenever you start the Excel application. You’ll need to create a new workbook. You can choose to create a new workbook – either with a blank workbook or predesigned Template-or open any existing workbook.

By using a blank workbook

Select the File tab. Backstage view will appear.
Select New, then click Blank workbook.
A new blank workbook will appear.
you may go ahead and start typing your Sheet.

By using predesigned Template

In Excel 2013, there are many templates that can save you a lot of time. A template is a predesigned spreadsheet file you can use to create new spreadsheets with the same formatting and predefined formulas. It is saved with a different file extension. It is saved with a different file extension (.xlsx) and serves as a basis for new files. A template file contains a variety of content and settings that are applied to the new files created from the template.

Select the File tab. backstage view will appear.
Select New, then Several Templates will appear below the Blank Workbook option.
Select a template to review it. A preview of the template will appear with the selectedtemplate.

Opening an Existing Workbook

Select the File tab. Backstage view will appear.
Select Open, then Select Computer, then click browse. You can also choose OneDrive to open files stored on your OneDrive.
The Open dialog box will appear. Locate and select your workbook, then click Open,

Note:If you ‘ve opened the desired workbook recently, you can browse to your recent Workbooks rather than searching for the file.

Saving a Workbook

Excel offers two ways to save a file: Save and Save As. Both options work in similar ways, with a few important differences:

Steps to Save a Workbook

Click on the Save button on the Quick Access Toolbar. or Go to File tab–>Select Save.
If you are saving the file for the first time,theSave As Pane will appear in Backstage view.
You’ll then need to choose where to save(Computer,OneDrive) the file and give it a file name. If you want to save the workbook on your computer, select Computer, then click Browse. You can also click OneDrive to save the file to uour OneDrive.
The Save As dialog box will appear. Select the location where you want to save the workbook.Entera filename for the workbook, then Click on the save button. In save As Dialog box, you can also change the Save As type.

Page Setup

Before printing if you want to know how a printed how a printed page will appear then you can use the Page setup feature. This page setup feature will appear in the page layout tab. In page setup, you can set the margins, orientation, paper size, header and footer etc.

To change page orientation

Go to Page Layout tab.Click the Orientation command in the Page Setup group.

Post Views: 22

Microsoft Excel (Spread Sheet)