Computers and Technology, 18.07.2020 14:01 proutyhaylee

Activity In this activity, you will create a table to demonstrate the different types of cell references.
A grocer keeps track of the fruits he purchases each month. He has a standard order in boxes. For example, if he orders apples in January, then
for the full month of January he will get a daily shipment of 10 boxes of apples. A monthly transport cost is necessary on each box, and this cost is
the same for all fruits. He enters his orders in a spreadsheet such as the following:
E
G
1
3
K
F
January
February
H
March
April
May
А
B
1 Fruit
Boxes
2 Apples
3 Oranges
4 Strawberries
5 Grapefruit
6 Peaches
7 Plums
8 Grapes
9 Apricots
10
11
12 Transport cost
13
035
14
15
с
D
Cost per box Total cost
10
22.05
15
27.15
40
1225
9
42.12
151 19.73
20
18 36
25
25 55
19
34 02
He uses the second table to calculate the cost for each type of fruit per month using the following calculation:
(number of boxes x number of days in the month x cost per box) + (number of boxes x transport cost).
If he orders strawberries throughout January, write a formula to calculate the cost, and then copy the formula to the worksheet for the following
entries:
January: strawberries, peaches, plums, grapes
February: peaches, oranges, apples, grapes
March: peaches, apples, plums
April: peaches, strawberries, grapes
May: oranges, grapefruit, plums, apricots
B

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 10:00

What is a society that has moved to the internet rather than relying on physical media called

Answers: 2

Answer

Computers and Technology, 23.06.2019 18:00

Ramona enjoys her job because she is able to kids in an after school program. the work value ramona feels strongest about is a. leadership b. risk c. independence d. work with people select the best answer from the choices provided a b c d

Answers: 1

Answer

Computers and Technology, 24.06.2019 08:30

Formatting rows and columns is similar to cell formatting. in an openoffice calc spreadsheet, you can format data entered into rows and columns with the of the rows and columns options. you can insert rows and columns into, or delete rows and columns from, a spreadsheet. use the insert or delete rows and columns option on the insert tab. alternatively, select the row or column where you want new rows or columns to appear, right-click, and select insert only row or only column options. you can hide or show rows and columns in a spreadsheet. use the hide or show option on the format tab. for example, to hide a row, first select the row, then choose the insert tab, then select the row option, and then select hide. alternatively, you can select the row or columns, right-click, and select the hide or show option. you can adjust the height of rows and width of columns. select row and then select the height option on the format tab. similarly, select column, then select the width option on the format tab. alternatively, you can hold the mouse on the row and column divider, and drag the double arrow to the position. you can also use the autofit option on the table tab to resize rows and columns.

Answers: 1

Answer

Computers and Technology, 24.06.2019 22:30

When can you access the bios setup utility?

Answers: 1

Answer

You know the right answer?

Activity In this activity, you will create a table to demonstrate the different types of cell refer...

Questions