2 Formulas and Functions Free Online FlashCards

What character begins a spreadsheet formula?

A formula begins with `=` and can combine cell references, values, operators, and functions.

How do parentheses affect calculation order in a formula?

Parentheses clarify or change calculation order. In `=(B2+C2)*D2`, the values in B2 and C2 are added before the result is multiplied by D2.

What happens to a relative reference when its formula is copied?

A relative reference adjusts to the formula’s new position when copied; for example, `B2` changes as the formula is filled elsewhere.

What does an absolute reference do when copied?

An absolute reference stays fixed when copied. Dollar signs fix both the column and row, as in `$B$2`.

How do mixed references fix only part of a cell reference?

A mixed reference fixes either the column or the row: `$B2` fixes the column, while `B$2` fixes the row.

How are the arguments ordered in `SUMIFS`?

`SUMIFS` adds values that meet multiple criteria. Its sum range comes first, followed by pairs of criteria ranges and criteria; each criteria range should align in size with the sum range.

What does `COUNTIFS` calculate?

`COUNTIFS` counts rows that meet multiple conditions, such as rows where the region is West and the product is Tea.

What does an `IF` formula do?

`IF` returns one result when a condition is true and another when it is false.

How do `AND` and `OR` differ when combining conditions?

`AND` is true only when all conditions are true; `OR` is true when at least one condition is true.

What does `TRIM` do to text?

`TRIM(A2)` removes extra spaces around words in the text in A2.

What should you remember when using `TEXT` on a number?

`TEXT` displays a value in a specified text format, but converts the value to text. Use the original numeric value for later arithmetic when possible.

What does `DATE(year,month,day)` do?

`DATE(year,month,day)` constructs a date from its year, month, and day parts.