Embedded Files
Overview Using a spreadsheet to perform mathematical operations is essential to companies to set budgets, calculate profit margins, keep inventories, and so on. Personally, you can use a spreadsheet to keep track of your own expenses, calculate interest on purchases, or create a timesheet for work. Google Sheets has the ability to make these calculations easily and will update your calculated values as you change your data.
In this section, you will
create and edit simple formulas
review the order of operations (BEDMAS)
create formulas by pointing and clicking
create formulas by selecting ranges
copy and move formulas
To successfully complete this section, read and watch instructional videos of topics covered (above). In particular, in EdPuzzle, watch: Google spreadsheets - sum, average, if, and other functions
Instructions /12
Complete the following steps in order:
Step 1: Open Simple Formulas. Save your copy as Simple Formulas - Firstname Lastname in your Practice folder.
/2 Step 2: Read the problem at the top of the worksheet. Before you begin solving the problem, estimate the amount you think Jean will make after 28 days. Enter your estimate in cell C6. Make sure this cell is formatted for currency.
/1 Step 3: Starting in cell A13, drag the the fill handle (tiny blue square in bottom right corner of cell) down to enter the remaining days of February in column A - do NOT enter them manually.
/1 Step 4: In cell B10, enter a formula that calculates the product of cell B9 multiplied by 2. Note: You can use the =sum( ) formula for all calculation formulas. Use + for addition, - for subtraction, * for multiplication, and / for division.
/1 Step 5: Starting in cell B10, use the fill handle to copy the formula down the column to February 28. Resize the column widths if needed.
/2 Step 6: In cell F6, use a formula to calculate the total amount Jean will earn in February - do NOT just type in the answer. This is an addition formula and will involve you selecting a range of cells. This is the first function demonstrated in the EdPuzzle video, so review that as needed. Again, make sure that this cell is formatted for currency.
/3 Step 7: Answer the three questions on the worksheet. Place your answers in the yellow cells provided. Use formulas that use cell references to complete calculations. Wherever possible, you want to use cell references rather than numbers when creating formulas, because you want the calculation to be correct if you change a number in any of the cells. You can use cell references easily in a formula by selecting them when typing in your formula, and they will show up in a different colour. This way, calculations will automatically update.
/2 Step 8: Create a header with your name and the date. Here is a refresher on how to add headers and footers. Note: Google Sheets does not have a customizable header function like Excel does; you will have to create one in the first row, similar to the example here (scroll down for video, though it may not work while at BCS). Notice that the header can be done with an image OR text.
Insert a new first row
Adjust the text wrapping
Then, under “View” select “Freeze” after the first row so that your header will always be visible
Step 9: Check to see that your Simple Formulas looks similar to this. Submit your Simple Formulas on Google Classroom for assessment.
Page updated
Report abuse