L4_Intro_excel using excel and spreadsheets

about excel

2. Objectives
1.Identify the functions of a spreadsheet
2.Identify how spreadsheets can be used.
3.Explain the difference in columns and rows.
4.Locate specific cell references.
5.List the types of data that can be put into a spreadsheet.
6.Input a formula for adding and averaging data.

3. What is a Spreadsheet?
A program that allows you to use data to
forecast, manage, predict, and present
information.

4. Spreadsheet Uses
School:Student grades, payroll
Sports:individual and team statistics
Personal:checkbook, household expenses
Business:payroll, investments

5. Introduction to Excel
•columns –identified with alphabetic headings
•rows -identified with numeric headings
•and their intersections are called cells
•(Cell references: B4, A20)
Spreadsheets are made up of :

6. A1
B3
E7

7. Introduction to Excel
In each cell there may be the following types of data
•text (labels)
•number data(constants)
•formulas(mathematical equations that do all the work)

8. Data Types

9. Formulas ALWAYS begin with an =sign. This “tells” Excel
that a calculation will need to be performed.
Reference cells, NOT the numbers in them!

10. Built in Functions
Use of colon = “through”

11. To change column width:
Put cursor on line
between two columns
and drag to the right to
the desired width

12. Orientation –the angle at which a text is displayed.
To change the orientation of a text, press CTRL+1

13. Accounting Number Format–a number
format that is used for accounting.
Note:Values of PHP or Philippine Peso sign use the Accounting
Number format. Its default uses the dollar symbol ($). To change
this, click the drop-down arrow at the currency format, then
change the symbol to PHP.

14. Sum-a function used to compute for the summation
for the number of a range

15. Average–a function use to compute for the average
of the number of a range

16. Count–a function used to count the cells with
content in a range

17. SUMIF–a function used to compute for the
summation of a range if a certain condition is met .

18. AVERAGEIF –a function used to compute for the
average of a range if a certain condition is met.

19. COUNTIF –A function used to count the cells
with a specified content within a range
Range–the range of cells where you want to
look for the criteria. Example C2:C15
Criteria –a value or label that determines if a
cell is part of the range to be averaged. You can
use the criteria like these : “10”, A2, ">=10",
"some text".

20. And here is the simplest example of Excel COUNTIF function. What
you see in the image below is the list of the best tennis players for
the last 14 years. The formula=COUNTIF(C2:C15,"Roger
Federer")counts how many times Roger Federer's name is on the
list:
RANGE
CRITERIA

21. Average Range –the actual range of cells
that will be averaged, if omitted, the range will
be used instead.