B01: Introduction to Excel Spreadsheets/ Google Sheets

Formula

Allow you to manipulate data in Excel

=

use to indicate formula/starting

Formula Bar

displays the formula in the active cell

Active cell

displays the formulas resulting values

Relative, Fixed or Absolute, and Mixed Cell Reference

types of cell references

Relative Cell Reference

- refer to a cell or a range of cells in excel

Fixed or Absolute Cell Reference

- cell reference that don’t change even if you extend the formula horizontally or vertically, this is indicated by preceding the row or column reference with a dollar sign “$”.

Mixed Cell Reference

- part of the reference is fixed, either the row or the column, and the other part is relative.

Relative

=G2*H2 is an example of what cell reference?

Mixed

=SUMIFS($C$2:$C$1) is an example of what cell reference?

Absolute

=$A$1 is an example of what cell reference?

horizontally, vertically, bottom right

Formulas can be extended ___ and ___by dragging the ___ corner of the cell

similarly

cells that are copied and pasted behave ___.

Addition (+)

Adds value in cells A1 and A2

Subtraction (-)

Subtracts the value in cell A2 from the value in cell A1

Multiplication (*)

Multiplies the value in cell A1 and A2

Division (/)

Divides the value in cell A1 by the value of cell A2

Exponentiation (^)

Raises the value in cell A1 to the 3rd power

Equal to (=)

compares one value to other value

Greater than (>)

Tests whether the value is greater than certain value or not

Less than (<)

Tests whether the value is less than certain value or not

Greater than or equal to (>=)

Tests whether the value is greater than or equal to certain value or not

Less than or equal to (<=)

Tests whether the value is less than or equal to certain value or not

Not equal to (<>)

Tests whether the particular value is not equal to certain value

data sorting, filtering, and analysis

Formatted headers support ___

Paste Link

this option in Excel is a feature within the Paste Special menu that allows you to create a dynamic link between cells. This link ensures that the content of one cell automatically updates if the original data changes.

Paste Link

It’s particularly useful for summarizing data, creating reports, or consolidating information from multiple sheets or workbooks

Transpose

this option in Excel’s Paste Special feature allows you to change the orientation of your data. Specifically, it converts rows to columns and columns to rows.

Transpose

This is useful when you need to reorganize your data without manually copying and pasting each individual cell.

=SEQUENCE(number_of_rows, 1, start_value, step)

sequence formula

Go To Special

is a feature in Excel that allows users to quickly select cells based on specific criteria, such as blank cells, cells with formulas, or cells with conditional formatting.

Go To Special

One powerful application of this feature is finding row differences, which helps identify discrepancies in data across rows.