Advance Features in MS Excel Class 7 MCQ: CBSE Board Class 7 Computer MCQ Questions and Answers with elaborate explanation. Students get here all Important MCQ on Advance Features in MS Excel Class 7.
Advance Features in MS Excel Class 7 MCQ with Answers and Explanations:
(1) The another name for Microsoft Excel is
(a) Spreadsheet b) Spacesheet c) Task sheet d) None of these
Explanation :-The other name of spreadsheet program is MS Excel which is a part of the MS Office Suite. Microsoft Excel is an electronic spreadsheet and a part of Microsoft Office Suite. This program was designed for performing different mathematical operations on a spreadsheet (the data is entered in tabular form (rows and columns) on a sheet. Microsoft Excel is also known as spreadsheet.
(2) In Excel, the file in which the data is entered or stored.
(a) Workbook b) Document c) Page d) Slide
Explanation :-Workbook is the file in Excel, in which data is entered or stored. Workbook is a collection worksheets. It is the single page in excel where you can work on it. Worksheet is made up rows and columns. There are 16384 columns and 10,48,576 rows total in a single worksheet. The columns are labelled alphabetically from A to XFD and rows from 1 to 10,48,576. There are 3 worksheets named as Sheet1, Sheet2, Sheet3 by default in Excel. You can rename and change the colour of the worksheet name.
(3) It is a sequence of cell reference, mathematical functions or operators of existing values to give a new value.
(a) Function b) Formula c) Data d) Operator
Explanation :-Formula is a mathematical calculation of cell reference, in which the operators or mathematical functions to the current value to gain/finding the new value. We can work on all kinds of data by calculating in Excel data. Ex :- You can add the contents of a column of monthly sales figures to calculate the total sales.
(4) It is the built in formula which helps you to perform the calculations on the data in the worksheet.
(a) Data b) Formula c) Operator d) Function
Explanation :- In MS-Excel Function is a built-in formula that is used in performing the calculations work within the data present into the worksheet. This formulas works on the specified range of values. Approximately there are nearly 300 built-in functions in MS-Excel by which the user can perform/accomplish different types of tasks/work.
(5) There are nearly ……………… built in functions in Excel that helps to perform the tasks of every kind.
(a) 100 b) 200 c) 300 d) 1000
Explanation :-In worksheet you can work with mathematical calculations by making use of 300 functions which is provided by Excel. Some of the commonly used functions are SUM, AVERAGE, COUNT, MAX, MIN etc. In Excel, every function has a name such as to sum the data is called SUM, for averaging values AVERAGE function is used where as for finding minimum or maximum values from the series of data we make use of MIN and MAX functions. There are 11 categories of functions that are grouped in Excel which are Cube, Date and Time, Engineering, Financial, Information, Logical, Lookup & Reference, Mathematical & Trigonometric, Statistical, Text, Database.
(6) Every formula in Excel, consists of ………………………… sign
(a) Plus sign ( + )
b) equal to ( = )
c) minus sign ( – )
d) underscore ( _ )
Explanation :-While making use of any function (formula), it is necessary to add/type is equal to (=) sign at the beginning, the arguments/ operators such as division, multiplication, addition and subtraction in the parentheses () after the function name. If you forget to apply/type is equal to (=) sign at the beginning, then the function will not work properly. It will not show us proper results.
(7) It is used to find out the highest value within the selected range of cells.
SUM b) MAX c) MIN d) AVERAGE
Explanation :- The MAX function in Excel, is used to show the highest/more value from the selected range of cells. The user can manually type the MAX formula in the formula bar by making use of keyboard otherwise you can directly enter MAX function by making a click on the Insert Function option that is available on the Formulas Tab under the function libraries group.
(8) It is used to find out the lowest value within the selected range of cells.
(a) SUM b) MAX c) MIN d) AVERAGE
Explanation :- The MIN function in Excel, is used to show the lowest value from the selected range of cells. The user can manually type the MIN formula in the formula bar by making use of keyboard otherwise you can directly enter MIN function by making a click on the Insert Function option that is available on the Formulas Tab under the function libraries group.
(9) The function that helps to multiply two or more numbers by using SQRT function.
(a) SUM b) MAX c) MIN d) PRODUCT
Explanation :- In Excel, the PRODUCT function is used to multiply two or more numbers by making use of the SQRT function, i.e means it is much helpful in finding out the square roots of the numbers.
(10) The formula that is been formed by making a combination of SUM and IF functions together
(a) SUMIF b) AUTOSUM c) SUM d) None of these
Explanation :- This SUMIF function is been used to adding the numbers of the cells that fulfills the defined set of criteria. This workings of SUMIF function is based on three arguments i.e are range of numbers, the condition being applied to the numbers, and range to which the condition applies. Values that meets the conditions are been added together.
(11) In Excel, there is a tool which will tell/help us to find a way for reaching to the goal
a) Objective b) Target gain c) Goal Seek d) Achievement
Explanation :-In Excel, there is a tool which will tell/help us to find a way for reaching to the goal. For ex:- If you want to take a new loan from the bank for constructing a new house, but our goal is to pay specific monthly amount as EMI. With the use of goal seek feature one can reach towards the goal by making an adjustment with the loan terms such as its interest or loan amount.
(12) The function in Excel that is used to calculate loan amount.
(a) Loan b) Liabilities c) PMT d) None of these
Explanation :-In Excel there is a function named as PMT. To make of this function we have to click on Financial —– PMT —— where you can calculate the loan amount, rate of interest, loan tenure etc.
(13) It is a collection of related information.
(a) Data b) Database c) Fields d) Records
Explanation :-You might have heard a system called ‘ Sampoorna ‘ that contains all the information about the students in our public schools. The data regarding lakhs of students have be compiled systematically. Such collection of data in a systematic manner is called databases. In databases, the data is recorded in one or many tables. Database helps to store data securely, add new data, removes unwanted data, uses data as per need, makes suitable changes etc. For ex:- Telephone and address books are examples of paper databases.
(14) This form is used to enter the records in the database in a faster manner.
(a) Database form b) Records c) Fields d) Tables
Explanation :-Form allows you to add and update data in a table, one record at a time. With the making use of data form, it helps the user to enter the database list very fastly. There is availability of all table fields in your data form. By filling/completing the fillation of fields in the form, it is easier for one to enter a record.
(15) It is the list of information of the entire database
(a) Fields b) Tables c) Forms d) Record
Explanation :-Table is a collection of data organized into rows and columns which contains an entire list of information . You can create as many tables as you can in Excel. For ex:- One table might contain list of customers and addresses and another might list product items and prices.
Leave a Reply