Solution

WORKSHEET - 7

Class 10 - Information Technology (402)

1.
(c) Finds related records
Explanation: Finds related records
2.
(b) All of these
Explanation: All of these
3.
(c) (iii)
Explanation: Both double click on one of the existing sheet and right click on existing sheet and then choose rename
4.
(b) Percentage
Explanation: Percentage
5.
(d) ii
Explanation: Click the Currency Style button on the formatting toolbar.
6.
(b) ii
Explanation: provides a quick way to view the result of an arithmetic operation on a range of cells
7.
(d) mixed referencing
Explanation: It represents mixed reference because we are using $ sign before row number 5 only. Hence, as we will drag this,
only B will change but 5 will remain the same.
8.
(d) Edit > Compare Document
Explanation: Edit > Compare Document
9. (a) Charts group
Explanation: Various charts are available in the Charts group of the Insert tab.
10.
(c) All of these
Explanation: All of these
11.
(b) blank spaces
Explanation: Page margins are the blank spaces between the worksheet data and the edges of the printed page.
12.
(d) position the mouse pointer over the cell
Explanation: position the mouse pointer over the cell
13.
(b) Define Range
Explanation: Define Range
14. (a) PMT
Explanation: PMT
15.
(b) i
Explanation: Exponentiation, multiplication and division, positive and negative values

1/5
AY 2023-24
16. (a) Choose Tools > Options > [Link] Base > Databases
Explanation: Choose Tools > Options > [Link] Base > Databases
17.
(b) a horizontal axis
Explanation: a horizontal axis
18.
(c) Solver
Explanation: solver
19. (a) Format cells dialog box alignment tab
Explanation: Format cells dialog box alignment tab
20.
(d) Press Ctrl + Home
Explanation: Press Ctrl + Home
21. (a) Data label
Explanation: Data label provides additional information about a value in the chart, that is coming from a worksheet cell.
22. (a) Download
Explanation: Download
23. (a) a group of cells
Explanation: a group of cells
24.
(b) All of these
Explanation: All of these
25. (a) Home tab
Explanation: AutoSum option is available in the Editing group of Home tab.
26. There are four tabs in the Page Setup dialog box, which are used to make different changes in Page Setup, i.e. Page, Margins,
Header/Footer, and Sheet.
27. Cells A2, A3, A4 and A5 will contain Tuesday, Wednesday, Thursday and Friday respectively.
28. Microsoft Excel should be used because it cannot only be used for storing data but also be used to perform calculations and
analysis of the data.
29. A workbook is a collection of worksheets. By default, there are three worksheets in every workbook.
30. = B1 + A2 will be copied into B3.
31. Formula for adding values of cells A1 to A5 would be = SUM(A1 : A5)
32. A formula is an equation that calculates the value to be displayed. A formula when used in a worksheet, must begin with an equal
to (=) sign.
33. A Page Break is used to determine where the printed page ends and begins the next one, so the content before the page break will
be printed on one page and after the page break on another.
34. With the help of legend, each data series can be uniquely identified by assigning a unique color or pattern.
35. Conditional formatting allows user to format a cell based on the value in it. For example, if you want to highlight all the cells
where the value is less than 30 with a red color, you can do that with conditional formatting.
36. Using electronic spreadsheets, a large volume of data can be stored in worksheets. Worksheets can be managed, edited, viewed,
retrieved, and printed easily in the desired format. Electronic spreadsheets support charts, which represent data pictorially.
37. A Scenario is a set of values that Calc saves for a group of cells. Whenever we run a scenario, Calc automatically substitutes the
saved cell values into a connected formula to give us an output. By having different scenarios for a same group of cells we can get
different results from the formula and compare these results to know which is the most suitable set of values for us.
38. Hyperlinks can be stored within your file as either relative or absolute. An absolute link will stop working only if the target is
moved. A relative link will stop working only if the start and target locations change relative to each other. For instance, if you
have two spreadsheets in the same folder linked to each other and you move the entire folder to a new location, a relative
hyperlink will not break.
39. Lotus 1-2-3, MS-Excel, OpenOffice Calc.
40. Hyperlinks can be stored within your file as either relative or absolute. An absolute link will stop working only if the target is
moved. A relative link will stop working only if the start and target locations change relative to each other. For instance, if you

2/5
AY 2023-24
 have two spreadsheets in the same folder linked to each other and you move the entire folder to a new location, a relative,
hyperlink will not break but an absolute link will break.
41. In order to avoid writing the data again and again for calculating purpose, cell reference is used. When you write any formula, for
specific function, you need to direct Excel the specific location of that data. This location is referred as, cell reference. So, every
time a new value added to the cell, the cell will calculate according to the reference cell formula.
42. Differences between workbook and worksheet are as follows:
Workbook Worksheet

A workbook is an Excel file with one or more worksheets. A worksheet is a single spreadsheet of data.

A workbook would be the entire binder, with everything in it. A worksheet would be like one section in that binder.
43. In spreadsheets, Hyperlinks can be used in Cale to jump to a different location from within a spreadsheet and can leads the other
parts of the current file, to different files.
Hyperlinks can be absolute and relative.
An absolute URL. contains all the information necessary to locate a resource.
A relative URL locates a resource using an absolute URL as a starting point.
44. Subtotal is a function listed under the Mathematical category when you use the Function wizard.
45. i. Scenario
ii. Goal seek
iii. Solver
46. The chart elements are as follows:
i. X-axis is a horizontal axis known as category axis.
ii. Y-axis is a vertical axis known as value axis.
iii. Data Series is the set of values you want to plot in the chart.
iv. Chart Area is the total area of the chart.
v. Chart Title is the descriptive text aimed at helping user to identify the chart.
vi. Gridlines are horizontal and vertical lines which are inserted in the chart.
vii. Data Label provides additional information about a data marker.
47. i. The Scenario is a tool to test "What-if" questions. Each scenario is named and can be edited and formatted separately. When
you print the spreadsheet, only the contents of the currently active scenario are printed.
ii. An absolute link contains all the information necessary to locate a resource and will stop working only if the target is moved.
iii. A relative link locates a resource using an absolute URL as starting point will stop working only if the start and target
locations change relative to each other.
iv. A macro is a saved sequence of commands or keystrokes that are stored for later use or to be used repeatedly.
48. Excel supports three types of cell referencing which are as follows:
i. Relative: Every relative cell reference in the formula automatically changes when the formula is copied down a column or
across a row. As the example illustrated here shows when the formula is entered (= B4 — C4) is cell D4 then this formula is
copied in D5 then it will change into (= B5 — C5) related to the cell.
ii. Absolute: An absolute cell reference is fixed. Absolute references do not change if you copy a formula from one cell to
another. Absolute references have a dollar sign ()likeS9.W henthef ormula = C 4∗ D
9iscopiedintoanothercell, theabsolutecellref erenceremainsasD $9.

iii. Mixed: A mixed cell reference has either an absolute column and a relative row, or an absolute row and a relative column, e.g.
$A1 is an absolute reference to column A and a relative reference to row 1. As a mixed reference is copied from one cell to
another, the absolute reference stays the same but the relative reference changes.
49. A Scenario is a set of values that Calc saves for a group of cells. Whenever we run a scenario Calc automatically substitutes the
saved cell values into a connected formula to give us an output. By having different scenarios for a same group of cells we can get
different results from the formula and compare these results to know which is the most suitable set of values for us. For example,
if you wanted to calculate the effect of different interest rates on a car loan, you could add a scenario for each interest rate, and
quickly view the results. This will help you to easily find out the most desirable rate of interest for availing the loan. Clearly a
Scenario is a tool to test "What-if" questions (What happens if I replace THIS value by questions (What happens if I replace THIS
value ∙ ∙ .). Each scenario has a name, and can be edited and formatted separately. You can easily switch between different
scenarios for a group of cells by using the scenario drop down list or scenario navigator.

3/5
AY 2023-24
50. i. Scenarios: Scenarios are a tool to test "What-if" questions. Each scenario is named and can be edited and formatted
separately. It is essentially a saved set of values for calculations. We can easily switch between these sets using the Navigator
or a Drop-down list which can be shown beside the changing cells.
ii. Goal Seek: It is used to calculate a result based upon existing values. Using Goal Seek option under Tools menu, we can
discover what values will produce the result that we want.
iii. Solver: It is an elaborated form of Goal seek. The difference is that the solver deals with equations with multiple unknown
variables. It is specifically designed to minimize or maximize the result according to a set of rules defined by us.
iv. Subtotal: lt is a function listed under the Mathematical category when we use the Function Wizard (Insert > Function).
Because of its utility, the function has a graphical interface.
SUBTOTAL, gets the total/adds the data arranged in array-that is, a group of cells with labels for columns and /or rows. For
increasing the efficiency, we can choose up to three groups of arrays to which the function can be applied.
51.
(c) A is true but R is false.
Explanation: A is true but R is false.
52.
(c) A is true but R is false.
Explanation: A is true but R is false.
53.
(b) Both A and R are true but R is not the correct explanation of A.
Explanation: Both A and R are true but R is not the correct explanation of A.
54.
(c) A is true but R is false.
Explanation: A is true but R is false.
55.
(b) Tools
Explanation: Tools
56.
(d) Cell reference
Explanation: Cell reference
57.
(d) Insert
Explanation: Insert
58. (a) Heavy
Explanation: Heavy
59.
(b) Standard
Explanation: Standard
60.
(b) 4
Explanation: 4
61. (a) Red
Explanation: Red
62.
(b) 3
Explanation: 3
63. (a) Ctrl
Explanation: Ctrl
64. (a) Shared
Explanation: Shared

4/5
AY 2023-24
65.
(b) Subtotal
Explanation: subtotal
66. (a) Sorting
Explanation: Sorting allows you to easily reorder your data.
67.
(b) What-if analysis
Explanation: What-if analysis
68. State True or False:
(i) (a) True
Explanation: Page Break Preview displays the page breaks as blue line when we print the document.
(ii) (b) False
Explanation: The bar located at the top of the application window is called the title bar.
(iii) (a) True
Explanation: True
69. Read the text carefully and answer the questions:
The Subtotal function in Excel is like Auto Sum on steroids. Instead of spending your much-deserved Tea break inserting
formulas and rows into a worksheet, use the Subtotal function to quickly do all the hard work for you. The Subtotal function can
be used to determine the sum, product, count, average, max, min, and other calculations, of sections. To use the Subtotal function:
i. Open the worksheet containing the data you wish to summarize using Subtotal.
ii. Ensure the data is sorted according to the criteria you wish to subtotal it.
iii. Select the celt range, including headings, you wish to organize using the Subtotal function.
iv. Click on the Data tab on the Ribbon. In the Outline group, click on the Subtotal button. This will launch the Subtotal dialog
box.
v. In the first box, under the At Each Change in heading, select the heading that represents the group of numbers you wish to
apply the Subtotal to.
vi. Select the function you wish to use in the Subtotal, for example, Sum.
vii. Select which column to add the Subtotal to.
viii. Tick the option boxes for replacing current subtotals, inserting a page break, or inserting a summary below the data. This will
depend on how you wish the Subtotals and groupings to display and it is worth experimenting with different options.
ix. Press OK to apply the subtotals.
(i) (b) iii
Explanation: Select the data. Launch the Subtotal dialog box and tick the box for Page Break between Groups.
Although you could use printer settings or set manual page breaks, for a worksheet containing 300 sections, this will
not be the most efficient method. The Page Break between Groups option in the Subtotal dialog box permits you to
set this automatically.
(ii) (d) iv
Explanation: Under the Data tab on the Ribbon in the Outlining group.
(iii) (b) iii
Explanation: Click on the Subtotal button and in the Subtotal dialog box select Remove All.
(iv) (b) i
Explanation: In the Subtotal dialog box she needs to change the option below the label, Use Function, to Average.
(v) (b) iv
Explanation: No. These options are based on the column headings in the worksheet which are included in the cell
range selection. If you change the column headings, these options will change to match the new column heading.

5/5
AY 2023-24