Microsoft Excel u Introduction of Microsoft Excel u

What is Microsoft Excel • The basic environment in Microsoft Excel is a Workbook

Uses – Mathematical tool which is formatted in columns and rows to display numerical

File Conventions • Files in Microsoft Excel are saved as Excel Workbooks • These

Introduction of Excel screen u Title bar u Menu bar u Standard Toolbar u

Introduction of Excel screen Title Bar Menu bar Standard Toolbar Formula bar Formatting Toolbar

The Excel Cell • Everything in Excel starts from the cell. – A cell

Exercises 1 • Open Microsoft Excel Application • Save and Rename Microsoft Excel Book

Exercises 2 • Column headers – Cell A 1 enter Result Of BS(IT)-1 –

Exercise 3 • • • Merge cells A 1 thru E 1 into one

Exercise 4 • Formatting – Center data in columns – Formatting Numbers – Borders

Mark sheet u To calculate total, Average & Grade u First To make a

Slides: 32

Download presentation

Microsoft Excel u Introduction of Microsoft Excel u. Uses of Microsoft Excel u How to start Microsoft Excel u Introduction of Microsoft Excel Screen u Practical of Mark sheet

What is Microsoft Excel • The basic environment in Microsoft Excel is a Workbook file that can contain one or more worksheets. • Electronic grid made up of rows and columns where you can perform numeric calculations and formulas • It consists of 65, 536 rows and 256 columns.

Uses – Mathematical tool which is formatted in columns and rows to display numerical data • Accounting • Data Analysis • Scientific Formulas – Can display • Calculations • Charts • Reports

File Conventions • Files in Microsoft Excel are saved as Excel Workbooks • These files carry the. XLSX extension

Introduction of Excel screen u Title bar u Menu bar u Standard Toolbar u Formatting Toolbar u Formula bar u Status bar

Introduction of Excel screen Title Bar Menu bar Standard Toolbar Formula bar Formatting Toolbar Status bar

The Excel Cell • Everything in Excel starts from the cell. – A cell is a placeholder of data, numbers, formulas – Most entry is done in an active cell, the one with a bold black frame around it. – A cell is shown below:

Exercises 1 • Open Microsoft Excel Application • Save and Rename Microsoft Excel Book 1 – mid term result

Make a New Work Sheet

Make a Rename of work sheet

Save a Work sheet

Exercises 2 • Column headers – Cell A 1 enter Result Of BS(IT)-1 – Cell A 2 enter Sr. no – Cell B 2 enter Name – Cell C 2 enter Total marks – Cell D 2 enter Obtained Marks – Cell E 2 enter Percentage

Exercise 2 - completed

Exercise 3 • • • Merge cells A 1 thru E 1 into one cell Change font color to Blue and BOLD Center Header Enter the following data: Total marks=12 Obtained marks=

Exercise 3 - completed

Exercise 4 • Formatting – Center data in columns – Formatting Numbers – Borders • Simple Functions (formulas) – Percentage

Exercise 4 - completed

Mark sheet u To calculate total, Average & Grade u First To make a New Work Sheet

To make a Mark sheet

Sum

Total

Average

Grade

Result