Class 8 Spreadsheet - Formulas and Functions

-

A Fill in the blanks with the correct words:
1. The formula in Excel starts by typing = sign.
2. The $ symbol is used for absolute referencing.
3. On selection, the formula entered into a cell is displayed in the Formula bar.
4. The : symbol is used in specifying a range of cells.
5. SUM is the name of a Function in Excel 2013.

B Write T for the true statement and F for the false one. Correct the false statement(s).
1. The default cell referencing is absolute type. F (The default cell referencing is relative type)
2. The AVG function is used to find the average value of list of values. F (The AVERAGE function is used to find the average value of list of values)
3. The range A2:F5 covers 14 cells. F (The range A2:F5 covers 24 cells)
4. A function can be used inside another function. T
5. $A5 is not a valid cell reference in Excel 2013. F ($A5 is a valid cell reference in Excel 2013)

C Choose the correct option.
1. Which one is not a type of cell referencing in Excel 2013?
a. Relative
b. Absolute
c. Hybrid
d. Mixed
2. Which one is not a mathematical operator in Excel 2013?
a. +
b. =
c. *
d. ^
3. What will be the value returned by the function =POWER(1, 100)?
a. 1
b. 100
c. 10
d. .01
4. How many cells are there in the range A3:C8?
a. 12
b. 14
c. 16
d. 18
5. Which symbol is used in referencing a worksheet in a cell?
a. &
b. @
c. !
d. $

D Answer the following:
1. How will you write the formula = A2 + B2 using pointing?
We can enter the cell addresses A2 and B2 by pointing and clicking on those cells while typing the formula.
2. What are the three types of cell referencing? Explain with an example.
The three types of cell referencing are:
a) Relative cell reference: The formula adjusts itself when it is copied to another cell. Both column and row value can change. Example: A5
b) Absolute cell reference: The formula doesn't adjust itself when it is copied to another cell. Both row and column remain constant. Example: $A$5
c) Mixed cell reference: The formula can either adjust the column or the row (but not both) while it is copied to another cell. Example: A$5 or $A5
3. How will you name a cell range A1:D5?
From FORMULAS tab, Defined Names group, Define Name option.
4. How will you rename the worksheet to PicnicDetails?
By right-clicking the worksheet, choosing the Rename option, and entering the new name.
5. Explain the meaning of circular referencing with an example.
When a cell reference is used in a formula entered in the same cell directly or indirectly, it is called a circular cell reference. Example: Entering formula = A1 + 1 in the cell A1 itself.

Location: Asansol, West Bengal, India

Comments

Post a Comment

Popular posts from this blog

Encrypt Program ISC Specimen 2023 Theory

-
A class Encrypt has been defined to replace only the vowels in a word by the next corresponding vowel and forms a new word, i.e. A → E, E  → I, I  → O, O  → U and U  → A. Example : Input: COMPUTER Output: CUMPATIR Some of the members of the class are given below: Class name : Encrypt Data members/instance variables : wrd: to store a word len: integer to store the length of the word newWrd: to store the encrypted word Methods/Member functions : Encrypt(): default constructor to initialize data members with legal initial values void acceptWord(): to accept a word in uppercase void freqVowCon(): finds the frequency of the vowels void nextVowel(): replaces only the vowels from the word stored in 'wrd' by the next corresponding vowel and assigns it to 'newWrd', with the remaining alphabets unchanged void disp(): displays the original word along with the encrypted word Specify the class Encrypt giving details of the constructor, void acceptWord(), void freqVowCon(), void nex
Read more

No Repeat Program ISC Computer Science 2022 Semester 2 Theory

-
Design a class NoRepeat which checks whether a word has no repeated alphabets in it. Example : COMPUTER has no repeated alphabets but SCIENCE has repeated alphabets. The details of the class are given below: Class name : NoRepeat Data members/instance variables : word: to store the word len: to store the length of the word Methods/Member functions : NoRepeat(String wd): parameterized constructor to initialize word = wd boolean check(): checks whether a word has no repeated alphabets and returns true else returns false void prn(): displays the word along with an appropriate message Specify the class NoRepeat, giving details of the constructor, boolean check() and void prn(). Define the main() function to create an object and call the functions accordingly to enable the task. import java.util.Scanner; class NoRepeat{     String word;     int len;     public NoRepeat(String wd){         word = wd;         len = word.length();     }     public boolean check(){         for(int i = 0; i &l
Read more

Bank Inheritance Program ISC Specimen 2023 Theory

-
A super class Bank has been defined to store the details of the customer in a bank. Define a subclass Interest to calculate the compound interest. The details of the members of both the classes are given below: Class name : Bank Data members/instance variables : name: to store the name of the customer accNo: integer to store the account number principal: to store the principal amount in decimals Methods/member functions : Bank(...): parameterized constructor to assign values to the data members void display(): to display the customer details Class name : Interest Data members/instance variables : rate: to store the interest rate in decimals time: to store the time period in decimals Methods/member functions : Interest(...): parameterized constructor to assign values to the data members of both the classes double calculate(): to calculate and return the compound interest using the formula: CI = P(1 + R / 100) N - P, where P is the principal, R is the rate and N is the time void displ
Read more