V.
Write the MS Excel function for the given data.
151
A
1 NAME
B
C с
D
ARNOLD RUHAAN UTKARSHAKSHIT
78
80
92
82
HARDIK
80
2 ENGLISH
3 MATHS
4 SCIENCE
64
61
78
70
85
95
92
85
85
87
5 COMPUTERS
90
84
89
88
92
6 HINDI
85
80
78
72
81
1. Write the function to find total of RUHAAN.
2. Write the function to find average of HARDIK.
3. Write the function to find maximum marks in COMPUTERS.
4. Write the function to find minimifm marks in MARKS.
5. Write the function to find the total marks of AKSHIT. tell the functions only
Answers
Answer:
A range of cells is a group of cells that have been selected and which form a shape of a rectangular box.
True
Question 2
A spreadsheet can only contain numeric data.
False
Question 3
You can insert a chart but not clipart in a worksheet.
False
Question 4
The cell in which the cell pointer is located in a worksheet is the active cell.
True
Question 5
You can select a range of data as per your choice in a spreadsheet.
True
Fill in the blanks
Question 1
Charts are the pictorial representation of data values stored in the worksheet.
Question 2
When the corresponding cell address changes with reference to a new cell address, it is known as relative reference.
Question 3
By default, MS Excel provides three worksheets in a workbook.
Question 4
The built-in formulae for specific numeric/non-numeric processing are called functions.
Question 5
A range of cells is a rectangular block consisting of a few cells, an entire row, an entire column or the whole worksheet.
Write the format of the functions used in MS Excel to perform the following tasks
Question 1
To calculate the average of 82, 67, 80, 74 and 95.
Answer
=AVERAGE(82,67,80,74,95)
Question 2
To find the highest value of the cell references from D3 to K3.
Answer
=MAX(D3:K3)
Question 3
To calculate the sum of the first five multiples of 7.
Answer
=SUM(7,14,21,28,35)
Question 4
To determine the lowest value of the cell references from A4 to A12.
Answer
=MIN(A4:A12)
Question 5
To find the sum of all the prime numbers from 1 to 10.
Answer
=SUM(2,3,5,7)
Question 6
To find the arithmetical mean of the cell references from E4 to K4.
Answer
=AVERAGE(E4:K4)
Explain the meaning of the following functions
Question 1
=SUM (C5:H5)
Answer
This function calculates the sum of the cell references from C5 to H5.