Scribd
Upload
132 views1 page

Excel Formulas CheatSheet

The document is a cheat sheet for teachers outlining key Excel formulas to practice, including SUM, AVERAGE, MAX, MIN, IF, COUNT, COUNTA, COUNTIF, ROUND, TEXT, CONCAT, and TODAY/NOW. Each formula is accompanied by a brief description and an example of its usage. This resource serves as a quick reference for educators to enhance their data management skills in Excel.

Uploaded by

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

Excel Formulas CheatSheet

The document is a cheat sheet for teachers outlining key Excel formulas to practice, including SUM, AVERAGE, MAX, MIN, IF, COUNT, COUNTA, COUNTIF, ROUND, TEXT, CONCAT, and TODAY/NOW. Each formula is accompanied by a brief description and an example of its usage. This resource serves as a quick reference for educators to enhance their data management skills in Excel.

Uploaded by

eascseblr
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Excel Formulas Cheat Sheet for Teachers

Key Formulas to Practice:


● SUM: Adds up a range of numbers. Example: =SUM(B2:D2)
● AVERAGE: Calculates the average of selected cells. Example: =AVERAGE(B2:D2)
● MAX: Returns the highest number in a range. Example: =MAX(B2:D2)
● MIN: Returns the smallest number in a range. Example: =MIN(B2:D2)
● IF: Performs a logical test. Example: =IF(E2>=75, "Pass", "Fail")
● COUNT: Counts how many numbers are in the list. Example: =COUNT(B2:B6)
● COUNTA: Counts non-empty cells. Example: =COUNTA(A2:A6)
● COUNTIF: Counts cells that meet a condition. Example: =COUNTIF(E2:E6,">=75")
● ROUND: Rounds a number. Example: =ROUND(AVERAGE(B2:D2),0)
● TEXT: Formats numbers and dates. Example: =TEXT(TODAY(),"dd-mm-yyyy")
● CONCAT / TEXTJOIN: Combines text from multiple cells. Example: =CONCAT(A2, " - ", B2)
● TODAY / NOW: Returns current date/time. Example: =TODAY() or =NOW()

You might also like