Question

please answer my questions
please answer OR question also it's very urgent​

Answer 1

Answer:

1. i) in cell F2,

=SUM(C2:D2)

using autofill copy this formula till cell F6

ii) sort feature.

select the data

under editing group

select sort option

choose ascending option from dropdown list

iii) conditional formatting. home tab styles group.

iv) in C7, =AVERAGE(C2:C6)

    IN  D7, =MAX(D2:D6)

v) in page layout tab

   page setup group

   orientation option

   portrait option from drop down list.

2. i) select the data

       under insert tab

       charts group

       charts option

       select required chart from the list

  ii) Design, Layout and Format

  iii) 7 elements -

       chart area

       plot area

       legend

       data labels

       horizontal and vertical axis

       chart and axis titles

       data points