BASICS OF MS-EXCEL - Introduction - Objectives - Excel Features - Starting Excel - Excel Worksheet

Sep 17, 2026

Upload by Connor

BASICS OF MS-EXCEL presents an introductory lesson on using MS Excel to enter, edit, analyze, and store numerical and textual data. It covers arithmetic operations, sorting options, and common formula uses, along with learning objectives such as worksheet modification, data entry, and keyboard shortcuts. The material explains core Excel features including AutoFormat, AutoSum, AutoFill, AutoShapes, chart types, PivotTables, shortcut menus, and drag-and-drop. It also guides readers through starting Excel and understanding worksheets, cells, and standard toolbar commands for creating, opening, saving, printing, and editing workbooks.

LanguageEnglish

CategoryTechnology

FormatPDF

Pages20

Reading Time50 min

AccessFree to download

12.1 Introduction

12.2 Objectives

12.3 Excel Features

12.4 Starting Excel

12.5 Excel Worksheet

12.5.1 Selecting, Adding and Renaming Worksheets

12.5.2 Standard Toolbar

12 BASICS OF MS-EXCEL 12.1 INTRODUCTION MS-Excel 2000 is a Windows based application package. It is quite useful in entering, editing, analysis and storing of data. Arithmetic operations with numerical data such as addition, subtraction, multiplication and division can also be done with Excel. You can sort the numbers/characters according to some given criteria (like ascending, descending etc.)and solve simple financial, mathematical and statistical formulas. 12.2 OBJECTIVES After going through this lesson you would be in a position to 􀁬 explain the basic features of MS Excel 􀁬 set pages and their printing 􀁬 modify a worksheet 􀁬 enter and edit data in a worksheet 􀁬 work on keyboard shortcuts 12.3 EXCEL FEATURES There are a number of features that are available in Excel to make your task easier. Some of the main features are: AutoFormat - lets you to choose many preset table formatting options. 1 AutoSum - helps you to add the contents of a cluster of adjacent cells. 2 List AutoFill-automatically extends cell formatting when anew item is added to the end of a list. 3 AutoFill-feature allows you to quickly fill cells with repetitive or sequential data such as chronological dates or numbers, and repeated text. AutoFill can also be used to copy functions. You can also alter text and numbers with this feature. 4 AutoShapes toolbar will allow you to draw a number of geometrical shapes, arrows, flowchart elements, stars and more. With these shapes you can draw your own graphs. 5 Wizard - guides you to work effectively while you work by displaying various helpful tips and techniques based on what you are doing. Drag and Drop-feature will help you to reposition the data and text by simply dragging the data with the help of mouse. 6 Charts - features will help you in presenting a graphical representation of your data in the form of Pie, Bar, Line charts and more. 7 PivotTable-flips and sums data in seconds and allows you to perform data analysis and generating reports like periodic financial statements, statistical reports, etc. You can also analyse complex data relationships graphically. 8 Shortcut Menus - commands that are appropriate to the task that you are doing appear by clicking the right mouse button. 12.4 STARTING EXCEL 1. Click on (with the help of mouse) the Start button on the Windows 98 Taskbar at the bottom of the Screen 2. Highlight the Programs item. The program menu will open. 3. Select Microsoft Excel from the list of programs. (these steps are shown Figure 12.1) 4. Click on Microsoft Excel Symbolically these actions are shown below. Select Start→Programs→Microsoft Excel commands from your menu bar. Microsoft Excel MSOB Fig. 12.1 Throughout the text of your lessons on MS Excel we will be showing the symbol → to indicate the direction (steps) you have to follow. You can also use the Microsoft Office Shortcut Bar (MSOB) as shown in figure 12.1 to start your work on Excel. 12.5 EXCEL WORKSHEET Excel allows you to create worksheets much like paper ledgers that can perform automatic calculations. Each Excel file is a workbook that can hold many worksheets. The worksheet is a grid of columns (designated by letters) and rows (designated by numbers) . The letters and numbers of the columns and rows (called labels) are displayed in gray buttons across the top and left side of the worksheet. The intersection of a column and a row is called a cell. Each cell on the spreadsheet has a cell address that is the column letter and the row number. Cells can contain either text, numbers, or mathematical formulas. Cell Number Box Standard Tool Bar Active Cell Menu Bar Formatting Tool Bar Row Headings Worksheet Tab Scroll Buttons Sheet Tab Status Bar Formula Bar Column Headings Horizontal ScrollBar Vertical ScrollBar Fig. 12.2 12.5.1 Selecting, Adding and Renaming Worksheets The worksheets in a workbook are accessible by clicking the

FAQs

What can MS Excel 2000 do for data handling?

MS Excel 2000 supports entering, editing, analysis, and storing of data, including arithmetic operations and simple financial, mathematical, and statistical formulas.

Which Excel features help make worksheet tasks easier?

Key features include AutoFormat, AutoSum, AutoFill, AutoShapes, the Wizard, drag-and-drop, charts, PivotTables, and shortcut menus.

How do you start Excel and manage worksheets using the toolbar?

Start Excel from the Windows Programs list, then use worksheet tabs for selecting and inserting sheets. The standard toolbar commands cover creating new workbooks, opening existing files, saving, printing, and other editing actions.

Sep 17, 2026

Upload by Connor