CLASS – VII
Chapter – 4
A. Picture Quiz
1. Identify the chart used to show comparisons among individual items.
2. Identify the chart used to show pair of values in scatter format.
B. Multiple Choice Questions.
1. Charts present data and information in a ____ manner.
Ans: (c) compact
2. A/An ____ chart shows the trend of values over time or categories.
Ans: (b) Area
3. Shortcut key to print a chart is ____ .
Ans: (b) Ctrl + P
C. Fill in the blanks.
1. A picture showing numeric data is called Chart.
2. Charts are easier to understand and compare.
3. Legend identifies each data series in a unique colour or pattern.
4. Chart style group is present in Design tab of the ribbon.
Section – B
A. Answer the questions.
1. What is a chart ?
Ans: A picture showing numeric data is called a chart or graph.
2. Name the subtypes of a pie chart.
Ans: (a) 2D pie and (b) 3D pie.
3. How do you create a chart in Excel ?
Ans: Step 1 – Select the cells within the table.
Step 2 – Click the Insert tab in the ribbon.
Step 3 – Select the type of chart you want from the Chart group.
Step 4 – Now, select the chart subtype from the drop down list.
4. How do you delete data from a chart ?
Ans: To delete data from a Excel chart, we have to delete data from the related worksheet.
5. How do you resize a chart ?
Ans: To resize a chart proportionally, drag the corner handle on the chart diagonally.
6. Explain the following charts.
(a) Column Chart (b) Line Chart (c) Pie Chart
Ans: (a) Column Chart – A column chart shows the data changes over a period of time or illustrates comparisons among items
(b) Line Chart – A Line Chart shows the different trends in data at equal intervals. It shows data in different styles of lines varying at equal intervals.
(c) Pie Chart – A Pie Chart shows one data series in the form of the comparative size of things that make up the data series to the sum of the items.
7. Write the steps to insert a Sparkline Chart.
Ans: Step 1 – Select the cells of a single row or multiple rows.
Step 2 – Click the insert tab in the ribbon.
Step 3 – Select the type of Sparkline chart that we want from Sparkline group.
8. Write the steps to print a chart.
Ans: Step 1 – Select the chart and click the File tab.
Step 2 – Select Print option from the File tab.
Step 3 – Click Print button.
CLASS – VII
Chapter – 3
A. Picture Quiz
1. Identify the icon used to sort the data based on several criteria.
2. Identify the icon used to filter the data.
B. Multiple Choice Questions
1. ____ function counts the number of cells that contains numeric value.
Ans: (b) COUNT
2. ____ function counts the number of characters in the text.
Ans: (b) LEN
3. SUM, AVERAGE, MAX and MIN are ____ functions.
Ans: (b) Logical
4. To see all the rows again after applying filter, click ____ command.
Ans: (b) Clear
5. ____ is used to filter data on specific conditions.
Ans: (b) Custom Filter
C. Fill in the blanks
1. Every cell has a name called its address.
2. An absolute referencing is specified by using $ (dollar) sign.
3. The predefined commands that perform some particular operations are called Function.
4. Filtering is a quick way to find the set of data in a range.
5. You can apply filters to only single range on a worksheet at a time.
D. Answer the following.
1. What is cell referencing ?
Ans: Cell referencing means how a cell address behaves in the formulae when it is copied from one cell to other.
2. What is meant by sorting ?
Ans: Sorting means to arrange data either in ascending or descending order.
3. Who is known as the father of spread sheet ?
Ans: Don Bricklin is known as father of the electronic spread sheet.
4. Explain any two statistical functions with example.
Ans: (a) Average – It calculate the average of the numbers in a given range of cells.
Example – = AVERAGE (A1:A12) gives the calculated average of the numbers in said range of cells.
(b) Len – It counts the number of characters in the text.
Example – = LEN(“Chandrayaan”) gives the output 11.
5. State the use of IF function. Explain with an example.
Ans: IF is the type of conditional function. It gives output as the condition is either TRUE or FALSE depending on certain conditions.
6. Explain the deferent ways to shot the data.
Ans: (a) We can sort the data by ascending or descending order as A to Z or Z to A form.
(b) Other way to sort data is Based on several criteria at once.
7. Define the following with an appropriate example of each.
(a) Relative reference (b) Absolute referencing (c) Mixed referencing
Ans: (a) Relative referencing – In it both column part and row part are not fixed.
Example : When a formula copied vertically down the cell addresses in
formula has to automatically change.
(b) Absolute referencing – in it both column part and row part are fixed.
Example : When a formula copied to the lower rows, there is no changes in the cell
(c) Mixed referencing – in it either column part or row part is fixed.
Example : When a formula in mixed cell reference with absolute column and
8. What do the following function do ? Explain with the help of an example.
(a) LCM (b) PRODUCT (c) SQRT (d) TODAY
Ans: (a) LCM – It returns the least common multiple of the numbers in a given range of cells.
Example: = LCM (A1 : A5) gives the LCM of the numbers in said cells as output.
(b) PRODUCT – It multiple the numbers in a given range of cells.
Example : = PRODUCT (A1 : A10) gives the multiplied result of the numbers in the said cells.
(c) SQRT – It returns the square root of the numbers.
Example : = SQRT (81) gives the output 9.
(d) TODAY – It displays the current date.
Example : = TODAY () gives the output as the present date of the operation.
9. Write the steps to apply Custom filter on a range of cells.
Ans: Question No. 9 is for practical classes.
10. Explain the Goal Seek feature with the help of an example.
Ans: Goal Seek is used to use a desired result of a formula to find the possible input value necessary to achieve that result. Suppose a shopkeeper sells 100 products at the rate of Rs.400 each unit for a monthly profit of Rs.10000. And if he decides to make monthly profit Rs. 15000, then Goal Seek feature can find how much he needs to raise the price of each unit to meet the target.