Question 1: Which of the following is not an arithmetic operator?
Answer: c. // ✔
Question 2: Which of the following is not a correct example of absolute referencing?
Answer: c. $A$1 ✔
Question 3: Which operator is used to join two strings?
Answer: D. & ✔
Question 4: Which type of referencing changes the cell address when you copy it in another cell?
Answer: C. Relative ✔
Question 5: Which operator is used to find the square of a number?
Answer: b. ^ ✔
[B] Fill in the blanks with suitable words.
Question 1. ...............are the symbols using which you can perform calculations.
Answer: OPERATORS
Question 2: .......... are cells which are associated with each other from edge to edge.
Answer: ADJACENT CELLS
Question 3: ...............symbol is used in absolute referencing.
Answer: Dollar ($)
Question 4: ..... is a block of cells selected together.
Answer: RANGE
Question 5: You can apply the formula on a ...... of cells.
Answer: RANGE
[C] Write whether the following statements are true or false.
Question 1. You cannot perform calculations on strings.
Answer: True ✔ — Strings are text, so normal arithmetic calculations cannot be performed directly on them.
Question 2: Joining of two strings is known as replication.
Answer: False ✘ — Joining two strings is called concatenation, not replication. The & operator is used to join strings in Excel.
Question 3: # symbol is used for absolute referencing.
Answer: False ✘ — # symbol is not used for absolute referencing. The $ (dollar) symbol is used for absolute referencing.
Question 4: The count() function counts the number of cells that contain values.
Answer: True ✔ — The COUNT() function counts the number of cells containing numbers/values in a selected range.
Question 5: Avg() is used to find the average of given range of cells.
Answer: True ✔ — The AVERAGE() function is used to find the average of the values in a given range of cells.
[d] Write the formulas for the following commands.
Question 1. To find the cube of 5
Answer: =5^3
Question 2: To multiply 45 with 4 and then add 78 to the product
Answer: =45*4+78
Question 3: To find the average of 45, 56, 78 and 66
Answer: =AVERAGE(45,56,78,66)
Question 4: To add 458, 789 and 453
Answer: =458+789+453
[B] Answer the following questions.
Question 1. Define an operator.
Answer: An operator is a symbol used to perform a calculation or operation in Excel. For example, +, -, *, / and ^ are operators.
Question 2: What is the use of cell range?
Answer: A cell range is a group of selected cells. It is used to perform calculations or apply functions to several cells at the same time.
Example: A1:A5
Question 3: What are the components of cell reference?
Answer: A cell reference has two components: Column letter
Row number
For example, in B5, B is the column and 5 is the row.
Question 4: What is the significance of using functions?
Answer: Functions make calculations quick, easy and accurate. They can perform common calculations such as finding the sum, average, maximum and minimum of values.
Question 5: Write the difference between function and formula.
Answer: Function -A built-in calculation in Excel. Example: =SUM(A1:A5)
Formula- An expression created by the user to perform a calculation. Example: =A1+A2+A3
Question 6: Explain the different types of referencing in Excel.
Answer: There are three types of cell referencing:
Relative referencing: The cell address changes when the formula is copied. Example: A1
Absolute referencing: The cell address does not change when the formula is copied. Example: $A$1
Mixed referencing: Either the row or column remains fixed. Examples: $A1 or A$1
Question 7: What are the different functions that can be used in Excel?
Answer: Some commonly used Excel functions are:
SUM() – adds numbers
AVERAGE() – finds the average
COUNT() – counts cells containing numbers
MAX() – finds the largest value
MIN() – finds the smallest value
Question 8: What are the different operators that can be used in Excel?
Answer: The main operators are:
Arithmetic: +, -, *, /, ^, %
Comparison: =, >, <, >=, <=, <>
Text: & — joins two strings.
