Question

How to answer this question?

Answer 1

a. Type formula = SUM( D2:E2) in cell F2

b. Type in formula in cell D7 = MIN(‘D2:D6’)

c. Use charts option. To represent information in the form of a chart , select it and click on the insert tab and in the illustrations group , click on chart option.

Select the desired chart.

d. Click on page layout tab, in the page setup group , click on orientation option and click portrait.

e. Sort feature.

Click on data tab, sort and filter group, select sort feature. Change the criteria from highest to lowest.