Qstnid -C-3- Count Function This Function Counts The Number Of Cells That Contain Numbers And Numbers Within The List Of Arguments. Argument Type Any Type Return Type Number Syntax = Count(valuel, Value2, ) E.g. If The Values Contained In Cells Al, A2, A3 And A4 Are 5, 7, True And 10 Respectively, Then - Count(al:a4) Will Return 3. <Ul> <Li>arguments That Are Numbers, Dates Or Text Representation Of Numbers (E.g. A Number Enclosed In Quotation Marks, Such As &Lsquo;1’) Are Counted. <Li>arguments That Are Error Values Or Text That Cannot Be Translated Into Numbers Are Not Counted. <Li>if An Argument Is An Array Or Reference, Only Numbers In That Array Or Reference Are Counted. Empty Cells, Logical Values, Text Or Error Values In The Array Or Reference Are Not Counted. </Ul> -4. Counta Function This Function Is Similar To The Count( ) Funtion. The Only Difference Is That The Counta() Function Also Calculates The Text Entries Even When The Entries Contain An Empty String Of Length 0(zero), I.e. &Ldquo; &Rsquo; &Rdquo;, But Empty Cells Are Ignored. The Counta() Function Counts The Total Number Of Values In The List Of Arguments. Argument Type Any Type Return Type Number Syntax = Counta (Number 1, Number 2, ...) E.g. If The Value Contained In Cells Al, A2, A3 And A4 Are 5, 7, True And 10 Respectively Then = Counta (Al : A4) Will Return 4. 5. Max Function This Function Is Used To Return Maximum Value From A List Of Arguments. Argument Type All Numbers Return Type Number Syntax = Max(numberl, Number2, ....) E.g. If The Values Contained In Cells Al, A2, A3 And A4 Are 5, 7, 2 And 10 Respectively Then = Max(a1:a4) Will Return 10. <Ul> <Li>max Will Consider Only Numeric And Logical Values To Compute Maximum. Ifij <Li>if An Argument Is An Array Or Reference, Only Numbers In That Array Or Reference Are Used. Empty Cells Or Text In The Array Or Reference Are Ignored. <Li>if The Arguments Contain No Numbers, Max Returns 0 (Zero). <Li>arguments That Are Error Values Or Text That Cannot Be Translated Into Numbers Cause Errors. </Ul> Question 3: Write Down The Name And Purpose Of Various Components Of A Chart. - 11: Ms-excel 2007 - Cbse-ix-foundation Percent 20of%20information%20technology%20.

Home Learn Fast select Course

Show Unit/Chapter Change Unit Change Subject Last Menu

CBSE-IX-Foundation percent 20of%20Information%20Technology%20.

11: MS-Excel 2007

digibest Free NCERT Solutions with no signup needed page 3

Qstn# C-3 Prvs-Qstn Next-Qstn

#3
COUNT Function
This function counts the number of cells that contain numbers and numbers within the list of arguments. Argument Type Any Type Return Type Number
Syntax = COUNT(valuel, value2, )
e.g. if the values contained in cells Al, A2, A3 and A4 are 5, 7, TRUE and 10 respectively, then - COUNT(Al:A4) will return 3.

Arguments that are numbers, dates or text representation of numbers (e.g. a number enclosed in quotation marks, such as ‘1’) are counted.

Arguments that are error values or text that cannot be translated into numbers are not counted.

If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text or error values in the array or reference are not counted.

-4. COUNTA Function
This function is similar to the COUNT( ) funtion. The only difference is that the COUNTA() function also calculates the text entries even when the entries contain an empty string of length 0(zero), i.e. “ ’ ”, but empty cells are ignored. The COUNTA() function counts the total number of values in the list of arguments.
Argument Type Any Type Return Type Number
Syntax = COUNTA (number 1, number 2, ...)
e.g. if the value contained in cells Al, A2, A3 and A4 are 5, 7, TRUE and 10 respectively then = COUNTA (Al : A4) will return 4.
5. MAX Function
This function is used to return maximum value from a list of arguments.
Argument Type All Numbers Return Type Number
Syntax = MAX(numberl, number2, ....)
e.g. if the values contained in cells Al, A2, A3 and A4 are 5, 7, 2 and 10 respectively then = MAX(A1:A4) will return 10.

MAX will consider only numeric and logical values to compute maximum.
ifij

If an argument is an array or reference, only numbers in that array or reference are used. Empty cells or text in the array or reference are ignored.

If the arguments contain no numbers, MAX returns 0 (zero).

Arguments that are error values or text that cannot be translated into numbers cause errors.

Question 3:
Write down the name and purpose of various components of a chart.
Ans :
Various components or parts of chart are as follows:

X-axis Refers to a horizontal axis, which is also known as category axis.

Y-axis Refers to a vertical axis also known as value axis.

X-axis title Conveys the full details of the X-axis values.

Y-axis title Conveys the full details of the Y-axis values.

Data series Refers to a set of data that you want to display in a chart.

Chart area Refers to the total space that is enclosed by a chart.

Plot area Refers to the main region of the chart in which your data is plotted.

Chart title Denotes the type of data plotted in a chart.

Legend In a chart showing different data series, a unique color or pattern is assigned to each data series. This unique color of pattern is known as a legend.

Gridlines These are the horizontal and vertical lines within the plot area in a chart.

Data label Provides additional information about a value in the chart, that is coming from a worksheet cell.