Formulas & Functions Reference Guide: Long Description

Formulas & Functions Reference Guide

Long Description

• The image is an instructional guide on the topic "Formulas & Functions" in Excel. The guide is divided into three sections. Each section includes bullet-pointed information, icons, and screenshots for visual assistance. 

• The top section is titled "Formulas" and features a plus icon. The instructions include starting every formula with an equal sign, using cell references, employing basic mathematical operators, and pressing Enter to complete formulas. It includes a screenshot of a spreadsheet with cells G2 and H2 highlighted and a formula in column L: "=G2*H2."

• The middle section is titled "Functions" and features a sigma icon. It describes aggregate functions that combine multiple values, mentioning the SUM, AVERAGE, and COUNT functions, and emphasizes typing the function name with parentheses. It includes a screenshot of a spreadsheet showing a "quantity" column, highlighted and calculated with a sum formula.

• The bottom section is "Combine Formulas & Functions" and features a "greater than or equal to" icon. It discusses using IF functions for basic conditions, AND for multiple true conditions, OR when any condition can be true, and combining functions for complex logic.  It includes a screenshot of a spreadsheet showing “total amount” column and a formula in L2, = if I 2 is greater than 500 then “High” otherwise “Standard."

• A footer banner reads, "Strengthen your Excel Essentials at sites.google.com/asu.edu/excelessentials."

Transcribed Text

Formulas & Functions

Formulas

1. Start every formula with an equal sign (=)

2. Use cell references (such as A1 or B5) instead of typing numbers directly

3. Use basic operators: + (add), - (subtract), * (multiply), / (divide)

4. Press Enter to complete the formula

Functions

1. Aggregate functions combine multiple values into a single result. 

   • Use SUM() to add up values in a range 

   • Use AVERAGE() to find the mean of values 

   • Use COUNT() to count cells with numbers

2. Type the function name followed by the range in parentheses

Combine Formulas & Functions

• Use IF(condition, value_if_true, value_if_false) for basic conditions

• Use AND() when all conditions must be true

• Use OR() when any condition can be true

• Combine functions for complex logic

Strengthen your Excel Essentials at sites.google.com/asu.edu/excelessentials