CLASS - VII | CHAPTER -2 ( Functions and Manipulation in Excel) Worksheet

 

Class - VII

Chapter - 2

Worksheets


Worksheet 1  Multiple Choice Question (MCQs).

  1. Which Functions will you use to perform common mathematical functions?

  1.  Text Functions b.  Logical Functions

  1. Mathematical Functions d.  Statistical Functions

  1. Which Function returns square root of the number?

  1.  Sqroot b.  Sqrt

  2. Sqt d. SQR

  1. Which sign is used to begin a Function?

  1.  = b.  &

C. %           d.  $

  1. Which function returns n characters number of characters including spaces?

  1. Len(text) b.  Concatenate (text1, text2)

C.  Right(text) d. Right(text,n)

5. which Function returns number of characters including space?

a. Sum b.  Mod

C. Lower(text) d. Len(text)



Worksheet 2  Write (T) for True and (F) for False against the statements.

  1.  The logical functions returns the result as True or False.  TRUE

  2. The = average(12,14,16) will given the result 16. FALSE

  3. The = max(num1,num2,….) function returns the maximum value out of the Arguments. TRUE

  4. The sqrt(num1) function returns the Square of the number Num1. TRUE

  5. In the function = SUM(A1:A12), the argument is SUM.    FALSE


Worksheet 3  Select the suitable words and fill in the blanks.


Mod Filter arguments Len Left Goal seek


  1. You can  use the Filter option to display only those records which meet some specific criteria.

  2. The Goal Seek option is useful when you want to manipulate the result which you have obtained by applying some Formula.

  3. The MOD function returns the Remainder, after dividing the num1 by the num2.

  4. The Len Left  function returns n characters starting from the left side.

  5. Functions are the special pre - written formula and instructions that accept the values as arguments and ‘return’ the result values.



Worksheet 4  Answer the following:

  1. What are function. Write the syntax of a function.

Answer: Functions are the special pre-written formulae and instruction that ‘accept’ the values as arguments and ‘return’ the result values in the cell in which they have been typed.

Syntax of function is   =Function name (Arguments).


  1. Write one example for the syntax for joining multiple text strings into one.

Answer: =concatenate(text1, text2)

Joins multiple text strings into one.

=concatenate (“My”,”country”)= My Country


  1. What is the use of the Filter option?

Answer:  You can use the Filter option from the Data tab to display only those records which meet some specific criteria.


  1. Write the syntax used for returning the sum value of the Arguments.

Answer: =sum(num1,num2)

  1. What is the use of  Conditional Formatting?

Answer:   If you want to apply formatting to cells, which contain data that meets certain conditions, you can use the conditional formatting.
Labels: