Embedded Files
Basic Formulas and Graphing
Basic Formulas and Graphing
Writing Formulas
Writing Formulas
A formula is an equation that performs a calculation. Like a calculator, spreadsheets can execute formulas that add, subtract, multiply, and divide.
A formula is an equation that performs a calculation. Like a calculator, spreadsheets can execute formulas that add, subtract, multiply, and divide.
Spreadsheets use standard operators for equations.
Spreadsheets use standard operators for equations.
Plus sign for addition (+)
Plus sign for addition (+)
Minus sign for subtraction (-)
Minus sign for subtraction (-)
Asterisk for multiplication (*)
Asterisk for multiplication (*)
Forward slash for division (/)
Forward slash for division (/)
Caret for exponents (^)
Caret for exponents (^)
When writing formulas for spreadsheets, remember that all formulas must begin with an equal sign (=). This is because the cell contains, or is equal to, the formula and its value.
When writing formulas for spreadsheets, remember that all formulas must begin with an equal sign (=). This is because the cell contains, or is equal to, the formula and its value.
Types of Charts
Types of Charts
A chart is a tool you can use in Excel to communicate data graphically. Charts allow your audience to see the meaning behind the numbers. Spreadsheets have a variety of chart types, each with its own advantages.
A chart is a tool you can use in Excel to communicate data graphically. Charts allow your audience to see the meaning behind the numbers. Spreadsheets have a variety of chart types, each with its own advantages.
Sorting Data
Sorting Data
Sorting is a common task that allows you to change or customize the order of your spreadsheet data. For example, you could organize a list by last name, color, or payment date, making it easier to find what you are looking for.
Sorting is a common task that allows you to change or customize the order of your spreadsheet data. For example, you could organize a list by last name, color, or payment date, making it easier to find what you are looking for.
Your Assignment
Your Assignment
This assignment is located in your Google Classroom which is to be completed in Google Sheets. Please follow these instructions carefully.
This assignment is located in your Google Classroom which is to be completed in Google Sheets. Please follow these instructions carefully.
The file contains six sheets to complete. Formulas, Graph 1, Graph 2, Graph 3, Sort Data & Challange. Use the instructional videos below or in Google classroom under Tutorials.
The file contains six sheets to complete. Formulas, Graph 1, Graph 2, Graph 3, Sort Data & Challange. Use the instructional videos below or in Google classroom under Tutorials.
4-1 Data Sort
4-1 Data Sort
Page updated
Report abuse