Scribd
Upload
15 views2 pages

Basic Excel Functions and Formatting

This document defines Excel and identifies its main parts. It then provides instructions on formatting text and entering functions like SUM, AVERAGE, COUNT, LEFT, and combining text using ampersand. Conditional formatting is also introduced. The document aims to teach basic Excel functions and formatting in 3 sentences or less.

Uploaded by

Danny Belarma
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
15 views2 pages

Basic Excel Functions and Formatting

This document defines Excel and identifies its main parts. It then provides instructions on formatting text and entering functions like SUM, AVERAGE, COUNT, LEFT, and combining text using ampersand. Conditional formatting is also introduced. The document aims to teach basic Excel functions and formatting in 3 sentences or less.

Uploaded by

Danny Belarma
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

BASIC EXCEL

Define EXCEL?

Identify Excel Parts

Title Bar
Menu Bar
Tool Bars
Column Headings
Row Headings
Formula Bar
Navigation Button and Sheet Tabs
Formatting in Excel

Type the Following

Lastname Firstname Middle Arts PE Music Health MAPEH


Name
Abad John Bautista 88 89 90 92
Carlos Matthew Sy 89 86 92 90
Molino Kylene Ferrer 87 91 93 91
Tolosa Trish Magno 86 90 89 93

Font: Tahoma
Title Font Style: Bold, Center
Text Content : Not Bold, Tahoma Font, Aligned Left
Number Content : Tahoma, Aligned Center

SUM Function Type =SUM, bring cursor to the range, ENTER


AVERAGE Function Get the Average of MAPEH Grade
COUNT / COUNTA/ COUNTIF/ COUNTIFS function
LEFT Function Type on the cell: =LEFT(cell,1) & "."
COMBINE Text from multiple cells & the use of ampersand (&)
- Insert a column after Middle name
Lastname Firstname Middle Name Arts PE Music Health MAPEH

Abad John Bautista 88 89 90 92


Carlos Matthew Sy 89 86 92 90
Molino Kylene Ferrer 87 91 93 91
Tolosa Trish Magno 86 90 89 93

Conditional Formatting

You might also like