Important QnA Formulas in Excel 2016 for Class 7

In this article, we are going to discuss exercises for formulas in excel 2016 for class 7. 

Exercises Formulas in Excel 2016 for Class 7

Let’s start the article with objective type questions for Formulas in Excel 2016. 

Objective Type Questions

  1. Equal
  2. $ Dollar
  3. & (Ampersand)
  4. SUM
  5. formula
  6. B:D
  7. before

True/False

  1. True
  2. False
  3. True
  4. False
  5. True
  6. True
  7. True
  8. True

MCQs

  1. ii. 3
  2. i. Editing group
  3. iii. =
  4. iii. mixed
  5. iii. &
  6. iii.AutoSum
  7. i. insert function
  8. i. #REF!

In the next section of the Formulas in Excel 2016 article, we are going to discuss short answer questions. 

Short answer questions (2/3 Marks)

The first part of Formulas in Excel 2016 – short answer questions is based on the basics of formuls and cell referencing.

Q – 1. What is a cell reference in MS Excel?
Ans.: Cell reference refers to a write a cell address or cell name in the formula for calculation. In a formula, the cell address is used to accept the entered value from the referenced cell.
 
Q – 2 What is a cell range?
Ans.: A cell range is a cell address or a rectangular area selected by the user in a worksheet. It can be written as cell1:cell2. For example, A1:B5.
 
Q – 3 Define a formula.
Ans.: A formula is a built-in function of MS excel that performs a specific task and display the desired result. For example, SUM.
 
Q – 4 How to write a formula in MS Excel?
Ans.: To write a formula in MS Excel, you need to follow the syntax of a formula. = symbol is used at the beginning of the formula. Then cell references are provided into the formula.
 
Q- 5 What is cell referencing?
Ans.: Cell referencing is one type of method in excel to write a formula and copying the cell address with respect to the value.
 
Q – 6 What are the ways of performing calculations in MS Excel? 
Ans.: There are two ways to perform calculations in MS Excel.
    1. Using a formula
    2. Using an operator
The next part of Formulas in Excel 2016 – short answer questions will cover the calculation part. 
 
Q – 7 Enlist the operators used in MS Excel with example.
Ans.: 

 

Operator in MS Excel
    • Consider above values for following:
    • + : For addition, Ex. = A1 + B1 , output will be 12 + 45 = 57
    • –  : For substratcion, Ex. = B2 – A2, output will be 52 – 33 = 19
    • * : For multiplication, Ex. = B3 * A3, output will be 45 * 20 = 900
    • /  : For division, Ex. = B3 / 3, output will be 45 / 3 = 15
    • : For power or exponent, Ex. = A1 ^ 3, output will 12 x 12 x 12 =  1728
    • & : For joining the words, Ex. = A1 & B1, output will be 12 & 45 = 1245
Q – 8 Enlist few commonly used math formulas in MS Excel.
Ans.: Few commonly used math formulas are sum(), power(), product(), sqrt(), round() etc.
 
The next part of Formulas in Excel 2016
Q – 9 What is the Autosum feature in excel?
Ans.: Autosum allows to use a formula quickly by just clicking on the autosum icon on the home tab of MS excel. Select your range of cells and click on autosum to compute the result.

 

AutoSum Feature in Excel
 
Q – 10 What is the functions library in excel? How to activate it?
Ans.:  The functions library in excel is the collection of functions stored in different categories. To activate the functions library click on the formula tab.
 

In the next section of Formulas in Excel 2016, we are going to talk about long answer questions.

Long answer questions (5 Marks)

 
Q -1 Explain cell referencing methods used in MS Excel with example.
Ans.: There are three types of cell referencing methods:
  1. Absolute Cell referencing
  2. Relative Cell referencing
  3. Mixed Cell referencing

1. Absolute cell referencing:

This method is used to accept fixed value in ms excel formula calculation. When the user is using the formula and copy the same formula in another cell excel adjusts the value according to the cells used in a formula. So sometimes the user does not want to change the value of the referenced cell but user wants to use fix the value form the cell. In this scenario, absolute cell referencing is used. To use absolute referencing write $ in front of column name and row number.

Example, = $A$1 * $B$1

2. Relative cell referencing:

It changes or adjusts the cell value when a formula is copied from one cell to another. It is by default referencing method in MS Excel. User can use $ sign in front of column name only.

Example, = $A1 * $B1

3. Mixed cell referencing: It is a combination of both absolute and relative cell referencing.
Example, = $A1 * $B$1

 
Q – 2 What are popular errors are associated with excel? 
Ans.: There are a few basic errors associated with excel as follows:
    1. ######:  This error is coming when the value of a cell is expanded beyond the column width. To solve this error increase the column width of a cell. 
    2. #Div/0!: This error is coming when you divide any number with 0. Change the divisor as any other number than 0 for the solution. 
    3. #Name?: This error is coming when a wrong formula is typed which is not available in excel.  To solve this error find the mistake and write an appropriate formula.
    4. #Value!: This error is generally found in excel when the cell contains a different type of value such as actual numbers required in a formula but cell contains a text value. To solve this find the source and type the correct required type data. 
    5. #REF!: This error is an error of wrong cell reference error. Enter the correct cell to solve this error. 
    6. #NUM!: This is displayed when the formula contains an invalid number. Correct the value will solve the error.

Q -3 Explain some mathematical formulas used in excel with example.

Ans.: Consider the following data for calculations:
Important QnA Formulas in Excel 2016 for Class 7
 

S.No

Formula

Returns

Example

Answer

1.

abs()

Absolute Value

= abs(A1)

19

2.

Sum()

Sum

= SUM(A1:D1)

99

3.

Mod()

Remainder

= mod(c1,d1)

18

4.

Power()

Exponential or Power

= power(d2,2)

1296

5.

Round()

Rounding upto specified digits

= round(B2,2)

45.00

 
Read the following article for other chapters:
 
 

Charts in MS Excel

Watch this video explanation for more undestanding:

Leave a Reply