Answers
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.
Answer is =C8*D8Don'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.
Answer is =Sum(E5:E14)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.
Answer is =Sum(E5,E6,E7,E8,E9,E10,E11,E12,E13,E14)Or
Answer is =E5+E6+E7+E8+E9+E10+E11+E12+E13+E14Don't forget about the equal sign out front
===========================================================
Problem 4
Answer: 96 poundsExplanation: 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
Answer: 1950 poundsExplanation: 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.
Related Questions
What is 6 3/4 percent of 800
Answers
Answer:
54
Step-by-step explanation:
6 3/4 = 6*4 + 3 / 4
= 27/4
=> 27/4 /100 * 800
=> 27/400 * 800
=> 27 * 2
=> 54
If 20% of a number is 28 and 25% of the same number is 35, find 45% of that number.
Answers
explanation: 20% + 25% = 45% and 20%= 28
25%= 35
thus, 28 + 35 = 45% = 63
How do you evaluate (-12)3
Answers
Step-by-step explanation:
-1728 y'all i do by using calculator and it is correct
Answer:
its -1728
Step-by-step explanation:
i worked it out right.
Solve for q.
7q+17q–14q–8q=14
q=
Answers
24q - 22q = 14
2q = 14
q = 7
[tex](7 + 17 - 14 - 8)q = 14[/tex]
[tex](24 - 22)q = 14[/tex]
[tex]2q = 14[/tex]
Divide both sides by 2
[tex] \frac{2q}{2} = \frac{14}{2} \\ [/tex]
[tex]q = 7[/tex]
There u go...
Have a great day ❤
Only answer this if you know the answer.
Find out the gradient of both blue lines
Answers
Answer
first line=4.1,10
second=6,10
Step-by-step explanation:
what is the last number
lol
Answers
Answer:
Infinity probally. But there is a number called the god's number reported by Galileo in which he states a number in which the enitre universe fits.
Please help please help please help please help
Answers
Answer:
2 , 3
Step-by-step explanation:
Look at attached photo. Will give brainiest to correct answer. Trigonometry.
Answers
Answer:
Step-by-step explanation:
Which statement is true?
Answers
Hope this helped!!
What would you do if you found out that you wrote a cheque of $78 but it was recorded as $98 in check register?
Answers
Answer:
I will cryy because I only want to write 78 why it recorded as 98
Jill had some candy to give to her five
children. She first took seven pieces for
herself and then evenly divided the rest
among her children. Each child received
five pieces. With how many pieces did
she start?
Answers
Explanation: If she had 5 children and each child received 5 pieces, you can determine that she gave her children a total of 25 pieces because 5 x 5 = 25. If she took 7 pieces for herself before giving the rest away, you can determine that she had 32 pieces of candy to start with because 25 + 7 = 32.
Help !!!!!!!!!!!!!!!!!!!!
Answers
Answer:
Step-by-step explanation:
One must rearrange the function to decreasing value of exponents
f(x) = -7x⁴ + 8x³ - 3x² - 9x + 11
to see that it is a 4th degree polynomial with leading coefficient of -7
Help me answer 5d, thank you!
Answers
Answer:
5. is III. Since there is a vertical asymptote at x= -3 and hole at x=0
I need help with number 9 please
Answers
Answer:
29.85
Step-by-step explanation:
1 month = 9.95
2 months = 19.9
3 months= 29.85
It shows the progression through three months and how much it was starting off from one month.
Answer: $29.85
per day it charges $9.95
she has the subscription for three months
we will then multiply the amount charged per month
$9.95 x 3 = $29.85
I hope this helps! :)
find the length of fencing required to go all the way around the rectangular field that is 136000mm wide and 425m long
Answers
show how to find slope of a line that passes through the points in the table
Answers
Answer:
Step-by-step explanation:
here you go m = (y2-y1)/(x2-x1)
= (11-(-9))/(3-(-1))
= 20/4
= 5
Due Tomorrow: answer question 1 with steps
Answers
Answer:
the 1 st qn that is no2 c is just down right corner am I right
Step-by-step explanation:
plzzz make me ans as the brainliest ans
Simplify -3(xy + 2y) + 5y - x.
Answers
Answer:
Step-by-step explanation:
-3 (xy+2y)+5y-x
-3xy-6y+5y-x
-3xy-y-x
evaluate -x^3 - 3x^2 + 4 when x = -2
Answers
-(-2)^3 = 8
-3(-2^2)= -12
Then add 4
-12 + 4 + 8 = 0
Answer:
32
Step-by-step explanation:
x = -2
-x^3 - 3x^2 + 4
-(-2)^3+6^2+4
8+36+4=48
Hope this helps :)
What percent of 80 is 84?
Answers
Answer: 105
Step-by-step explanation: if you are using a calculator, simply enter 84÷80×100 which will give you 105 as the answer.
Write an equation of a line with an x-coefficient of - 3 and a y-intercept of 7
Answers
Answer:
y = -3x + 7
Step-by-step explanation:
For an equation in the format y = ax + b, a is the coefficient of x, and b is the y intercept.
Cassidy places 40 stamps on each of 8 albums pages how many stamps dose she place
Answers
Answer:
Cassidy places 5 steps on each album page.
Cassidy places 320 stamps in total.
Step-by-step explanation:
40÷8=5 stamps on each album page
40×8=320 stamps in total
PLEASE HELP ME WILL MARK BRAINLIEST AND PLZ EXPLAIN
Answers
Y= a (x-h)^2 + k
Now we have to identify the vertex which is (-4,-3). Now substitute the vertex for (h,k). So now we have.
Y= a( x-(-4)^2 + (-3)
This gives us
Y = a(x+4)^2 -3
Now we have to pick a point from the graph to substitute for the x and y values. This can be any point expect for the vertex. I have chosen (-3,-1). Now let’s substitute:
-1= a(-3+4)^2-3
Now we have to solve for a:
-1=a(1)^2 -3
-1= a-3
-1+3=a
a= 2
Now that we know the value of a we can write the equation down:
Y= 2(x+4)^2 + 3
Can someone tell me what’s going on here
Answers
Answer:
c = 105 degres
Step-by-step explanation:
When two lines cross like that and form an x, the opposite sides are equal (so the angle below the 75 degree one is also 75 degees). Using this, you can figure out the rest.
If both the top an bottom are equal, you know that 150 degres are taken (75+75) and you know that there can only be 360 degres in total here, so you subtract 150 from 360 and get 210. Now you know that the last two sides together are 210, and since they are equal, you divide it by two to get 105 degrees.
b) Complete the table to show the total amount of calories Mary will burn for
cycling and running for 0, 10, 15, and 30 minutes. Show and explain your work.
Minutes (m)
Total Calories Burned (C)
0
10
Answers
For 0 minutes she can burn 0 calories
For 10 minutes she can burn 20-40 calories
For 15 mins she can burn 40-60 calories
For 30 minutes she can burn 140-295 calories
I hoped this helped!
Have a great day/night! :)
A credit union pays interest of 2% per annum on a certain
savings plan. If $1000 is deposited in such a plan and the
interest is left to accumulate, how much is in the account after 1
year?
Answers
Answer:
$1020
Step-by-step explanation:
1000 ÷ 100 = 10
10 × 2 = 20
$20 is gained per annum.
Robert has 4 times as many pennies as he does nickels. If Robert has $1.44 worth of pennies and nickels, how many nickels does he have?
Answers
Which fractions are equivalent to 1012?
Select each correct answer.
23
56
1224
3036
5060
6084
Answers
Answer:
5/6, 30/36, 50/60
Step-by-step explanation:
10/12 divided by 2= 5/6
10/12•3= 30/36
10/12•5= 50/60
p l s… h e l p… m e…
Match the unknown entries in the two matrices with their correct values
Answers
Answers:
v = 54y = 0u = 6w = -48x = -1===================================================
Explanation:
The left hand side is
[tex]-6\begin{bmatrix}3 & -1 & 3\\8 & x & -9\\4 & -1 & y\end{bmatrix}[/tex]
That -6 outside the matrix is multiplied with each item inside the matrix. This is known as scalar matrix multiplication. Effectively, it's very similar to the idea of the distributive property.
So for the first row, we have the three columns of: -6*3 = -18 and -6*(-1) = 6 and -6*3 = -18
The other two rows are handled the same way. This is what should result:
[tex]-6\begin{bmatrix}3 & -1 & 3\\8 & x & -9\\4 & -1 & y\end{bmatrix}= \begin{bmatrix}-18 & 6 & -18\\-48 & -6x & 54\\-24 & 6 & -6y\end{bmatrix}[/tex]
From here, you'll then match up the terms in the given right hand side matrix. The top row has the variable 'u' in the middle, which matches with the '6' in the middle of the top row shown. Therefore, u = 6.
-----------------------------
Now to the second row.
The -48 in the first spot pairs up with the w in the other matrix. So we can see that w = -48. Similarly, we have v = 54.
Also, we have -6x in the middle which matches with the 6 in the same corresponding spot. Solving -6x = 6 leads to x = -1.
-----------------------------
Finally, the third row.
There's only one variable here and that's the variable y in the bottom right corner. It pairs up with 0 in the same corresponding spot for the right hand side matrix. Therefore, y = 0.
Robert has 4 times as many pennies as he does nickels. If Robert has $1.44 worth of pennies and nickels, how many nickels does he have?
Answers
9514 1404 393
Answer:
16 nickels
Step-by-step explanation:
Robert can group his coins into groups consisting of 1 nickel and 4 pennies. The value of each group is 9¢, so the number of groups Robert can make is ...
$1.44/$0.09 = 16 . . . groups
Since there is 1 nickel in each group, Robert has 16 nickels.
Answer:
16
Step-by-step explanation: