1
Formulas are used to perform Calculations.
Solution not available in the source paper.
Spreadsheet
ICSE Class 8 Computer Studies · Class - 8: ICSE Kips Logix Computer Book Solutions with BlueJ · 23 solved questions
2
The cell address in a formula is also called Cell reference.
Solution not available in the source paper.
3
The cell address in a formula that does not change on copying, is considered as Absolute reference.
Solution not available in the source paper.
4
Arguments are input to functions, which accept values as number or text.
Solution not available in the source paper.
5
The & character is used for concatenation of strings.
Solution not available in the source paper.
1
Formulas must begin with the question mark (?).
False
Solution not available in the source paper.
2
In Absolute Referencing, the relative position of rows and columns changes where you copy a formula.
False
Solution not available in the source paper.
3
In Absolute Referencing, '$' sign is used before the cell co-ordinates.
True
Solution not available in the source paper.
4
A range can be used in a formula.
True
Solution not available in the source paper.
5
The error #VALUE occurs if the number is divided by a zero.
False
Solution not available in the source paper.
1
A Sports teacher has measured the height of the students in a class. Saumya has been given the assignment to find the maximum and minimum height from the collected data. Suggest the function, which she should use to accomplish the task.
Show SolutionHide Solution↓
Saumya can use MAX() function to find the maximum height and MIN() function to find the minimum height.
2
Ms Priya and her friends got a raise of 10% in their salaries. Find the total amount if their present salary is ₹15,000. Calculate the salary by using the formula.
Show SolutionHide Solution↓
Formula is =15000+(15000*10/100)
1
To use the Sheet reference, which address is appropriate out of the following options?
- (a)D4! Sheet1
- (b)Sheet1, D4
- (c)Sheet1! D4 ✓
Show SolutionHide Solution↓
2
Which key combination is used to get the sum of the values of adjacent cells?
- (a)Shift + S
- (b)Ctrl + '
- (c)Alt + = ✓
Show SolutionHide Solution↓
3
Which function finds the largest number in a range?
- (a)AVERAGE ()
- (b)COUNT ()
- (c)MAX () ✓
Show SolutionHide Solution↓
4
Which of the given cell references can be used in a relative reference?
- (a)$D6
- (b)A3 ✓
- (c)A$1
Show SolutionHide Solution↓
5
Which function is used to count the number of numeric values in a range?
- (a)COUNT() ✓
- (b)SUM()
- (c)COUNTNUMBERS()
Show SolutionHide Solution↓
1
What is a Formula? Explain with the help of an example.
Show SolutionHide Solution↓
A Formula is a user defined instruction to perform calculations. It is an expression that can include cell addresses, numbers, arithmetic operators and parenthesis. It begins with equal to (=) symbol, followed by cell references and operators. For example:=A2+B2*5-SUM(E3:E5)
2
What is Cell Reference? Mention its types.
Show SolutionHide Solution↓
The cell address that we use in the formula is known as the cell reference. The address of the cell consists of the column letter followed by the row number. For example, cell address A1 denotes the column name as A and the row number as 1. The different types of cell references are Relative reference, Absolute reference and Mixed reference.
3
What do you know about Absolute Reference? Explain with the help of an example.
Show SolutionHide Solution↓
Absolute reference is used when we do not want to change the address of the cell while copying the formula to another cell. To use absolute reference in a cell, you need to add dollar ($) sign before the column and row number. For example: =$A$1+$A$2
4
Explain circular reference with an example.
Show SolutionHide Solution↓
A circular reference occurs when a formula in a cell refers to its own cell value directly or indirectly. For example, if you enter the formula =A1+A2*3 in cell A2, you are making the formula to refer to its own cell value, which creates a circular reference.
5
What do you mean by a Function? Name some of the Functions.
Show SolutionHide Solution↓
Functions are the pre-designed formulas in Excel to perform both simple and complex calculations. Functions begin with the equal to (=) sign followed by the function name and then the list of arguments separated by comma within the parenthesis. For example, =Function name (argument1, argument2....). Some of the commonly used functions are:
- SUM(range)
- AVERAGE(range)
- MAX(range)
- MIN(range)
- SQRT(number)
6
What are the rules to enter a Function?
Show SolutionHide Solution↓
The rules to enter a Function are:
- All Excel functions must begin with = sign.
- Function name must be a valid Excel name. For example: SUM, AVERAGE.
- Function name must be followed by an opening and closing parenthesis.
- Arguments are enclosed in the parenthesis. For example,
=SUM (A1:A5).
Press ↓ to reveal a solution and move to the next question. Back to Class - 8: ICSE Kips Logix Computer Book Solutions with BlueJ.