Question

5M
Q1. Consider the worksheet given below and solve the following questions (Any 5): -
Teme what you want to do
Page Layout
To
A A
Wap Test
Merge & Center
Conditional Fom
Formatting - Tal
Nube
A1
Marksheet
D
Average
2 S No.
Maths
79
4
36
Н
Marksheet
Science So Science Computer Sanskrit Total
65
67
78
60
56
54
53
56
40
32
33
47
49
SO
56
69
76
65
70
79
78
69
74
73
79
56
32
29
34
Name English Hindi
1 Anushka
77
2 Arin
56
Bharya
35
Chirag
45
Jatin
63
karan
75
69
Samruddhi 46
70
Vinay
28
5
39
20
69
78
77
34
7
8
10
12
13
15
16
18
20
21
Sheet1
1) Write steps to use AUTO FILL option to enter S No. into the cells AS:A10.
2) Create formula to find Total marks obtained by Anushka, in cell 33.
3) Create a function to find Average marks obtained by Chirag in cell K6.
4) Name the Excel function to find highest marks obtained by student in MATHS.
5) Write steps to rename worksheet named as "SHEET 1" to "Mark-list"
6) Write down the cell address that contains the marks obtained by Karan in computer​

Answer 1

Answer:

It looks like there aren't many great matches for your search