Short Answer Type Questions: Advance Features of Excel | Computer Science for Grade 9 PDF Download

Q.1. What is absolute cell referencing?

An absolute cell reference is a cell reference in a spreadsheet application that remains constant even if the shape or size of the spreadsheet is changed, or the reference is copied or moved to another cell or sheet.

Q.2. Give a cell reference as an example for:
(a) Relative referencing 
(b) Mixed referencing

(a) A1
(b) $A$1

Q.3. What is a ‘Data Point’ in a chart? 

It represents one value of the data series.

Q.4. What are the different mathematical operators and their use in Excel?

The different mathematical operators in Calc are:
^ for exponential (to the power of) e.g. 5^2 = 25 as 52=25
+ for addition
- for subtraction
* for multiplication
/ for division

Q.5. What are the rules for using a function?

Rules for using a function: 

• All functions begin with the = sign.
• After the = sign define the function name (e.g., SUM, AVERAGE). 
• One or more arguments-numbers, text or cell references-enclosed by parentheses. If there is more than one argument, separate each by a comma.

Q.6. What is the difference between Line chart and pie chart?

A line chart shows trends and variations in data over time using a line. It displays a series of points that are connected over time. A pie chart displays the contribution of each value to the total. It is very useful to display information when you want to represent different parts of the whole, or the percentages of a total.

Q.7. Which operator is used to start with a formula or function?

=

Q.8. Give the general syntax of the IF function in Excel.

The general syntax of the function is:
= IF(Test , Then_value , Otherwise_value)

Q.9. What are the three types of cell referencing?

Relative, Absolute and Mixed Referencing.

Q.10. Explain the following with respect to charts:
(a) Chart Area 
(b) Data Series 
(c) Data Label

(a) The Chart area is the entire area that is reserved for accommodating a chart and other components like titles, legends, etc.
(b) Data Series is a collection of related values that are plotted on a chart.  
(c) It is some piece of text that is written near the Data Point to highlight some aspect of it.