A basketball player made 12 out of 15 free throws she attempted. She wants to know how many consecutive free throws she would have to make to raise the percent of successful free throws to 85%. Write an equation to represent this situation. Solve the equation. How many consecutive free throws would she have to make to raise her percent to 85%? Answer:

Problem 1

The price for one super skateboard is £75.00 which is found in cell C8. When it comes to excel spreadsheets, we always read across the top first before reading the left hand side. So the format is columnRow which may seem strange if you're used to reading the row first.

Right next to cell C8 is D8 and that's the number of super skateboards sold (26 of them). Multiply the unit price by the number of units sold to get the revenue for this particular type of item.

75*26 = 1950

Now the question is: what if the company sells more than 26 skateboards? Let's say there was an error and 30 boards were sold. To quickly recompute the correct answer, we can rely on references rather than hardcoded values.

Typing out [tex]=C8*D8[/tex] will compute the multiplication of items C8 and D8. The equal sign out front is very important. It tells the spreadsheet program that you want to do this type of operation (rather than just write out plain text). If you were to simply type in C8*D8 without the equal sign, then the result is exactly C8*D8 without filling in the variables.

Don't forget about the equal sign out front

===========================================================

Problem 2

Like before, we'll have an equal sign as the first thing we type in. Then we'll type in Sum(E5:E14) to sum of the values from E5 to E14. You could type in Sum(E5,E6,E7,E8,E9,E10,E11,E12,E13,E14) or you could type in E5+E6+E7+E8+E9+E10+E11+E12+E13+E14; however, that would be a tedious approach prone to error. The spreadsheet program interprets the colon as a way to fill in the gap from start to end. We start at E5 and end at E14, and add up everything in between.

Note that all the cells referenced are the various revenues for each type of item. Each of these cells is computed by multiplying the C and D column items.

Don't forget about the equal sign out front

===========================================================

Problem 3

There are a few other alternatives, but your teacher might be talking about adding each item one at a time. Refer to problem 2 for more info.

Or

Don't forget about the equal sign out front

===========================================================

Problem 4

Explanation: Simply pick out the smallest item. The excel command is "min" and you provide it a list of values to pick from. In this case, that list being E5:E14 to represent E5,E6,...,E13,E14. So you'll type in =Min(E5:E14) similar to what you did for the "sum" command.

===========================================================

Problem 5

Explanation: As you can probably guess, the "max" function is used here. It picks out the largest value of a list. The command is =Max(E5:E14)

===========================================================

Below I've attached two images. Figure 1 shows the commands to type in, while figure 2 shows the result of each command. In other words, it's the before and after. I used LibreOffice spreadsheet, but this applies to any spreadsheet program as they all tend to follow the same idea.