Excel

Mansoura University
Faculty of Computers and Information

Department of Information Technology
First Semester- 2023-2024
Computer Basics
Information Technology
Grade: 1
HADEEL ELSISI
INTRODUCTION
 Microsoft Excel is one of the most used software applications of all time.
 Hundreds of millions of people around the world use Microsoft Excel.
 You can use Excel to enter all sorts of data and perform financial, mathematical or statistical calculations.
 Excel includes many common functions that can be used to quickly find the sum, average, count, maximum
value, and minimum value for a range of cells.
 In order to use functions correctly, you'll need to understand the different parts of a function and how to
create arguments to calculate values and cell references.
2
3
There are 5 important areas in the screen.
1. Quick Access Toolbar: This is a place where all the important tools can be placed. When you start Excel
for the very first time, it has only 3 icons (Save, Undo, Redo).
2. Ribbon: It depicts all the features of Excel in easy to understand form. Since Excel has 1000s of features,
they are grouped in to several ribbons.
The most important ribbons are – Home, Insert, Formulas, Page Layout & Data.
3. Formula Bar: This is where any calculations or formulas you write will appear.
4. Spreadsheet Grid: This is where all your numbers, data, charts & drawings will go.
Each Excel file can contain several sheets. But the spreadsheet grid shows few rows & columns of active
spreadsheet.
5. Status bar: The status bar also shows quick summaries of selected cells (count, sum, average, minimum
or maximum values).
4
Basics of a Spreadsheet
• Spreadsheets are made up of
– columns
– rows
– and their intersections are called cells
• In each cell there may be the following types of data
– text
– number data (constants)
– formulas (mathematical equations)
5
6
THE PARTS OF A FUNCTION
 The basic syntax for a function is the equals sign (=), the function name (SUM, for example), and one or
more arguments.
 Arguments contain the information you want to calculate. The function in the example below would add the values of
the cell range A1:A20.
7
WORKING WITH ARGUMENTS
 Arguments can refer to both individual cells and cell ranges and must be enclosed within parentheses.
For example, the function =AVERAGE(B1:B9) would calculate the average of the values in the cell range B1:B9.
This function contains only one argument.
8
BASIC MATH
 Spreadsheets have many Math functions built into them. The most basic operations are the standard multiply,
divide, add and subtract.
 These operations follow the order of operations (just like algebra).
9
CREATING A FUNCTION
There are a variety of functions available in Excel.

Here are some of the most common functions you'll use:
• SUM: This function adds all of the values of the cells in the argument.
• AVERAGE: This function determines the average of the values included in the argument. It calculates the sum of
the cells and then divides that value by the number of cells in the argument.
• COUNT: This function counts the number of cells with numerical data in the argument. This function is useful for
quickly counting items in a cell range.
• MAX: This function determines the highest cell value included in the argument.
• MIN: This function determines the lowest cell value included in the argument.
10
TO CREATE A FUNCTION USING THE AUTOSUM COMMAND:
 The AutoSum command allows you to automatically insert the most common functions into your formula,
including SUM, AVERAGE, COUNT, MIN, and MAX.
 In the example below, we'll use the SUM function to calculate the total cost for a list of recently ordered items.
1. Select the cell that will contain the function. In our example, we'll select cell D13.
11
2. In the Editing group on the Home tab, click the arrow next to the AutoSum command.
Next, choose the desired function from the drop-down menu.
In our example, we'll select Sum.
12
3. Excel will place the function in the cell and automatically select a cell range for the argument.
In our example, cells D3:D12 were selected automatically; their values will be added to calculate the total cost
13
TO ENTER A FUNCTION MANUALLY:
 If you already know the function name, you can easily type it yourself.
 In the example below (a tally of cookie sales), we'll use the AVERAGE function to calculate the average number
of units sold by each troop.
14
15
16
17
THE ‘IF’ FUNCTION
 check the logical condition of a statement and return one value if true and a different value if false.
 The syntax is
 =IF (condition; value-if-true; value-if-false)
– value returned may be either a number or text
– if value returned is text, it must be in quotes “ “
18

Excel

Uploaded by

Copyright:

Available Formats

Excel

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Excel

Uploaded by

Copyright:

Available Formats

Mansoura University

Faculty of Computers and Information

• Spreadsheets are made up of

• In each cell there may be the following types of data

There are a variety of functions available in Excel.

You might also like