Excel Formulas

Question 1

Every formula in Excel begins with an ______. This signals to Excel that what follows is a formula rather than plain text or a number

Answer 1

equal sign

Question 2

These are fixed values (numbers or text) directly entered into the formula, such as =2*3.

Answer 2

Constants

Question 3

Instead of hardcoding numbers, you can reference cells (e.g., =A1+B1), allowing the formula to update automatically when the referenced cell values change

Answer 3

Cell References

Question 4

+ for addition
/ for division
- for subtraction
^ for exponent
* for multiplication

Answer 4

Operators

Question 5

Excel provides built-in ____that simplify complex calculations. For example, the SUM() _____can add up a range of cells, such as =SUM(A1:A5)

Answer 5

Functions

Question 6

most commonly used functions:

Answer 6

SUM
AVERAGE
COUNT
IF
COUNTIF
SUMIF.

Question 7

adds together a range of numbers. It can handle individual numbers, cell references, and ranges.

Answer 7

SUM function

number1: The first number or range to sum (required).
number2: Additional numbers or ranges (optional, up to 255).

Example: =SUM(A1:A5) adds all values from cells A1 to A5. This function automatically ignores empty cells and text value

Question 8

calculates the mean of a set of numbers

Answer 8

AVERAGE function

=AVERAGE(number1, [number2], …)

Similar to SUM, it accepts multiple arguments.

Example: =AVERAGE(B1:B10) computes the average of values in cells B1 through B10. This function also ignores empty cells

Question 9

counts the number of cells that contain numeric values within a specified range

Answer 9

COUNT function

value1: The first value or range to count (required).
Additional values can be included (optional).

Example: =COUNT(C1:C10) counts how many cells in the range C1 to C10 contain numbers

Question 10

performs a logical test and returns one value for a TRUE result and another for a FALSE result

Answer 10

IF Function

The syntax is:
=IF(logical_test, value_if_true, value_if_false)

logical_test: The condition to evaluate.
value_if_true: The value returned if the condition is TRUE.
value_if_false: The value returned if the condition is FALSE.

Example: =IF(D1>100, “Pass”, “Fail”) checks if the value in D1 is greater than 100 and returns “Pass” or “Fail” accordingly

Question 11

function counts the number of cells that meet a specific criterion within a range

Answer 11

COUNTIF Function

The syntax is:
=COUNTIF(range, criteria)

range: The group of cells to evaluate.
criteria: The condition that must be met.

Example: =COUNTIF(E1:E10, “>50”) counts how many cells in E1 to E10 have values greater than 5

Question 12

sums the values in a range that meet specific criteria.

Answer 12

SUMIF Function

The syntax is:
=SUMIF(range, criteria, [sum_range])

range: The range of cells to evaluate against the criteria.
criteria: The condition that must be met.
sum_range: The actual cells to sum (optional).

Example: =SUMIF(F1:F10, “Yes”, G1:G10) sums the values in G1 to G10 where corresponding cells in F1 to F10 equal “Yes”