Chapter AE, Problem AE3.1

Explanation of Solution

a)

Make the first two rows of the spreadsheet similar to that in figure AE-1. Choose the background color and the type...

Explanation of Solution

b)

Place the current date which is centered in cells C3, D3 and E3 and merge all the specified cells...

Explanation of Solution

c)

Make the outline for the cells as shown in Figure AE-1.

Explanation of Solution

d)

Enter random data in the spreadsheet.

Use the formula as shown in figure AE-1...

Explanation of Solution

e)

Formatting the cells in the column.

Explanation of Solution

f)

Three management decision that can be inferred from the data,

The three management decisions that can be inferred from the table are,

• The bike models which occupies more inventory.
• The models occupying more inventories and the revenue generated by each models...

Explanation of Solution

g)

Other calculation which might helpful for the bike rental management:

• The additional calculation can be made to generate...