Q1. Fill in the blanks :- (3) a. Cell range formed by 7th column 15th row to 15th column 15th row is --------- b. A -------- indicates the active cell. c. The values passed through a function are known as ---------
Q2. What is relative referencing? Give example. (2)
Q3. Write down the use of the following functions :- (3)
a. =AVERAGE () b. =ABST() c. =MIN()
Q4. Explain about any two types of Chart. (2)
if you don't know the answer so don't reply and send it till 11:00 am meaning 30 minutes
if you don't know the answer so don't need to answer
Answers
Answered by
0
Que 1.
a) E8
b) border gridlines
c) parameter
Que 2.
Relative cell references are basic cell references that adjust and change when copied or when using AutoFill. Example: =SUM(B5:B8), as shown below, changes to =SUM(C5:C8) when copied across to the next cell.
Que 3.
a) Returns the average (arithmetic mean) of the arguments.
b) The ABS function in Excel returns the absolute value of a number.
c) MIN will return the minimum value in a given list of arguments.
Que 4.
There are several different types of charts and graphs. The four most common are probably line graphs, bar graphs and histograms, pie charts, and Cartesian graphs. ... Pie charts to show you how a whole is divided into different parts.
Similar questions