Formula and Functions in MS Excel Class 6 MCQ

Formula and Functions in MS Excel Class 6 MCQ: CBSE Board Class 6 Computer MCQ Questions and Answers with elaborate explanation. Students get here all Important MCQ on Formula and Functions in MS Excel Class 6.

Formula and Functions in MS Excel Class 6 MCQ with Answers and Explanations:

Q1) Multiple Choice Questions :-

(1) It is a powerful spreadsheet program.

(a) MS – Excel         b) MS-Word                     c) MS- Powerpoint                     d) MS- Access

Explanation :-MS- Excel is a spread sheet program which is used to organize the data, make complete calculations, to frame decisions and  develop reports.

 

(2) The values that is directly entered into the cell is

(a) Neutral values b) Stable values             c) Constant values              d) None of these

Explanation :- Constant values is one the type data that is entered into worksheet. These type of values are directly entered into the cell. For ex :-  Number, names, data, currency etc are such examples of the constant values.

 

(3) It is a sequence of cell reference, mathematical operators and functions of the existing value to give a new value.

(a) Function b) Constant value               c) Formula                       d) All of the above

Explanation :- Formula is a sequence of cell reference, mathematical operators and functions of the existing value to give a new value. With the help of Formula, One can perform different kinds of calculations in Excel worksheet. For ex : -you can add the contents of a column of monthly sales figures to calculate the total sales.

 

(4) It is much important to give a ………………………… sign at the beginning of the formula.

(a) + plus sign b)  –  minus sign                  c) – Hyphen                 d) = is equal to sign

Explanation :-  In normal Mathematics when you write down the formula, the formula is written in such a way that the is equal = sign comes after the operators and values. For ex :- 2 + 2 = 4 But while writing the formula in Excel, we start to write the formula by making use of is equal to = sign after that values and operators. For ex : – = 2 + 2 . excel has an ability of identifying any data as the formula that starts with the is equal to = sign.

 

(5) Every cell in a worksheet is called

(a) Cell Reference b) Cell location                c) Cell destination                     d) cell venue

Explanation :-For the identification of particular cell, the unique address is given which is known as cell address or cell reference. The cells in the worksheet are identified by row number and column letter by default.  Cell references play an important role in calculating the data present in the cells. Cell references are made used in the formula instead of using the actual data. For ex :- The data in A5 ( column A and row number 5 )cell is 10 and B5 ( Column B and row number 5) cell is 10. Soby making use of the cell references we will find out the total. = A5 (10) + B5 (10) =  ( 20 )result will be displayed in the desired cell.

 

(6) It is a group of related cells in worksheet

(a) Cell reference b) cell range                    c) cell destination                  d)  None of these

Explanation :-  Cell range is a grouping of similar cells in the worksheet those are related with each other. The cell ranges in the worksheet can be easily identified by the anchor points which you see at the upper left corner and lower right corner of the cell range. The range includes the separation of anchor points by the colons. For ex if the cell range is A3: C3 includes the cells as A1, A2, A3, B1, B2, B3, C1, C2, and C3 respectively. In the cell rage name, it starts with a letter of any case i.e is uppercase or lowercase letters. We must makes note of it that the cell range names does not include any space in between.

 

(7) It shows the types of operations

(a) Operators b)  symbols                       c) Operands                 d)  None of these

Explanation :-  In MS-Excel, operators play a significant role in performing mathematical operations. Operators are the symbols that helps the users to identify what type of operations they are. Arithmetic operators and comparison operators are some types of the operators.

 

(8) This type of operators are used for performing mathematical calculations.

(a) Comparison b) Logical                    c) Arithmetic                 d) All of the above

Explanation :-  Arithmetic operators are the operators that are used for performing mathematical tasks. This operators are always used in between the operands. The table below clearly descripts about the arithmetic operators :-

Operators Descriptions
+ Addition (A1 + B1)
Subtraction ( A1  – B1)
* Multiplication ( A1 * B1)
/ Division  ( A1 / B1)
% Percent ( A1 % )
^ Exponentiation ( A1 ^ B1 )

(9) This type of operators are used for making comparison between two values.

(a) Comparison              b) Logical                    c) Arithmetic                  d) All of the above

Explanation :-  Comparison operators are used for comparing two values. The value which we get after making use of Comparison operator, is either True or False. The table below clearly descripts about the comparison operators :-

Operators Descriptions
= Equal to ( A1 = B1 )
Greater than ( A1 > B1)
Lesser than ( A1 < B1)
>= Greater than or equal to ( A1 > =B1)
<= Lesser than or equal to ( A1 < = B1)
<>  Not equal to ( A1 <> B1)

(10) This feature in MS-Excel helps in copying the formula across the rows and columns in a worksheet.

(a) Automatic b) Auto-formula                         c) Auto-fill                 d) None of these

Explanation :-  The Autofill feature in MS- Excel helps the user in copying the formulas across the rows and columns in a worksheet. This feature reduces/ saves time by entering the same formula again and again. You can copy the formula by Autofill as many times as you want.

 

(11) MS-Excel provides the in-built formula that is used for performing calculations.

(a) Formula b) Autofill                         c) Operator                      d) Function

Explanation :-  Functions are the readymade or built in default formulas in Excel, that performs the tasks of calculations or different series of operations on the range of data or values in the worksheet. There are approximately 300 functions that are used for performing calculations on the data those are present in the worksheet.

 

(12) In Excel, the symbol that is made used to specify the individual cell separately in a function .

(a) Semi colon ( : ) ,

b) colon ( ; ) ,

c) Comma ( , )

d) Period or full stop ( . )

Explanation :-In the Excel function, when the comma ( , ) symbol is made use specify the individual cells separately in a function, then each cell is considered for performing the calculations. For ex :- =SUM(A1,A2,A3) is similar as =A1+A2+A3.

 

(13) In Excel, the symbol that is made used to specify group of cells in a function .

(a) colon ( : ) ,

b) semi colon ( ; ) ,

c) Comma ( , )

d) Period or full stop ( . )

Explanation :-In the Excel function, when the colon ( : ) symbol is made use specify the group of cells in a function, then each cell is considered for performing the calculations. For ex :- =SUM(A1:A3) is similar as =A1+A2+A3.

 

(14) In Excel, there are …………….. categories of functions that are grouped together.

(a) 5             b) 10                                       c) 13                                       d) 11

Explanation :- Excel provides 11 categories of the functions that are grouped in together. Each category of function tells the use of it. Following is the table, that descripts the use of the categories of grouped functions :-

Category Description
Cube  If you are making use of this complex OLAP formulas (such as Pivot Tables), cubes functions take the OLAP data and display it in a cell.
Date & Time It includes the function which is only used for calculation in regards to date, time and minutes.
Engineering This function provides the user the formulas that are in relation to the calculation of engineering.
Financial This function includes in related to calculation and tracking loans, principal, interest, yield depreciation, and future values.
Information This function includes the function which is used only for checking the data.
Logical This includes for logical conjectures such as if then-statement.
Lookup & Reference Use these function to locate references or specific values in you worksheets.
Mathematical and Trignometric This function is used for performing calculations that are based on all types.
Statistical It is used for making calculation in-relation with grades, probabilities, rankings etc
Text Text based functions to search and replace data and other text tasks.
Database It is used only for database programs like counting, add and filing the database items

(15) This function in Excel, is used for engineering purpose.

(a) Cube       b)  Information         c) Logical                         d) Engineering

Explanation :-  In Excel, we perform various types of calculations. Engineering is the function in MS- Excel that helps us to perform the calculation work that is related to Engineering. This function acts as a helpful aid for the engineers.

Updated: May 25, 2022 — 5:03 pm

Leave a Reply

Your email address will not be published. Required fields are marked *