Class 10 IT SpreedSheet (Intermediate) Kips Solution
Class 10 IT Spreadsheet
(Intermediate) Kips Solution
Unit -4 Spreadsheet
(Intermediate)
Session 1: Using
AutoSum in Cells
Assessment
Time
A. Multiple Choice Questions:
1. Autosum
2. Dashed Border
B. State True or False
1.
False
2.
True
3.
False
4. True
5. True
C. Answer the
following questions:
1. The
steps to find out total range of cell using Autosum are as follows:
i. Type the figures to be calculated in
spreadsheet.
ii. Click on Autosum function in the editing
group of Home Tab.
iii. The cell with dashed border will depict
the formula along with auto selected range.
iv. Press enter to display the final result.
2.
Under
the function library group of formula tab Auto sum option is present.
3.
Some
of the functions that can be performed using Autosum are Sum, Average, Count,
Max., Min.
Session: 2- Conditional formatting
Assessment Time
A.
Multiple Choice Questions
1. Font Color
2. Criteria option
3. $H$2
B.
State True or False:
1. True
2. True
3. False
C. Answer the following Questions:
1. Conditional formatting
options are available in Style Group of Home Tab.
2. By using
conditional formatting feature one can apply formatting to one or more cells
and create rules for when and how these cells are to be formatted. This feature
is useful to analyze the patterns and trends by analyzing raw form of data.
3. The various formatting
effects that can be applied using conditional formatting are:
I. Number , format , Text and dates
II. Font, Font style and font color.
III. Border color and border style
IV. Fill Color and Fill Pattern
Session: 3- Hide/Unhide/Freeze Rows And
Columns
Assessment Time
A. Multiple Choice Questions
1. View
2. Hide
3. Rows and Columns
B. State True Or False
1.
False
2. False
3. True
C. Answer the following question:
1. Hide/unhide feature of
Excel makes Rows and Columns Invisible.
2.
Steps to hide Column C in Excel Worksheet:
i. Select the columnC.
ii. Click on Homeà Cellsà format option
iii. A drop down will
appear.
iv. Click on
Hide/Unhideà Hide
Columns.
3.
Sometimes while working in Excel, header needs to remain constant, so that
while entering the data one should not commit errors. This can be done through
the facility of freeze panes, in which header row/column remains fixes and the
user can view contents from different parts of the worksheet at the same time.
Session: 4- Set Page Breaks
Assessment Time
A. Multiple Choice Questions
1. Enable fill handle and
cell
2. Pattern
3. Remove page break
B. State True or False
1.
True
2.
False
3.
False
4.
True
C.
Answer the following questions:
1. A
page break divides the Excel Worksheet into Individual pages for printing.
2.
Automatic and manual page breaks can be differentiated on the basis of line
pattern i.e. Automatic page breaks are depicted by dashed pattern and manual
page breaks are depicted by solid pattern.
3.
To add horizontal page break in Excel Worksheet, select the row below where the
marking line will appear. Right click on it and select Insert page break option
from the shortcut menu. The horizontal page break will be Inserted.
4.
Sheet can be opened in Page break preview by clicking on Page Break Preview
icon in the Workbook Views group on the View Tab or click on the Page Break
Preview button on the excel status bar.
5.
Page break can be moved either by
enabling fill handling and cell drag and drop feature or by moving the page
manually.
6.
To delete the vertical page break:
i.
Select the column on the right where you want to delete the Inserted page
break.
ii.
Now click on break button present in the page setup group on the Page Layout
Tab.
iii.
Select the Remove Page Break option from the drop down menu.
Session: 5- Set Layout
Assessment Time
A.
Multiple Choice Questions
1.
Normal
2.
Sheet Option
3.
Three
B.
State True Or False
1.
True
2.
True
3.
True
4.
False
5.
True
C. Answer the following questions:
1.
The page layout feature of Excel offers to :
i.
Set margins
ii.
Set page Header and footer
iii.
Set Size of the page
iv.
Specify the background
v.
Set orientation
vi.
Hide/Display Gridlines
vii.
Define the Print area
2.
Custom margins in MSExcel can be set by clicking on Margin command on the page
layout tab.
3.
The default orientation of Excel Worksheet is Portrait. The two orientation
option offered by MS Excel are:
i.
Portrait
ii.
Landscape
4.
To delete page background , click the Delete background option which appears on
page setup group on the page layout tab.
5.
Header and Footer for the worksheet can be set as follows:
i.
Switch to page layout view under the View tab
ii.
A place holder appears with the option click here to add header/ click here to
add footer at the top and bottom of the
worksheet respectively.
Session: 6- Manage Workbook Views
Assessment Time
A.
Multiple Choice Questions
1.
Normal
2.
Page layout view
3.
Workbook View
B.
State True Or False
1.
False
2.
False
3.
True
C.
Answer the following questions:
1.
The name of the different view that Excel offers are:
i.
Normal View
ii.
Page layout View
iii.
Page break preview view
iv.
Full screen view
v.
Custom View
2.
The two ways by which one can switch to Normal view is:
i.
By clicking on Normal option present in the Workbook View group.
ii.
By clicking on Normal button present on the Status Bar.
3.
The full screen view eliminates the Ribbon and the status bar and allows the
user to view the spreadsheet in full screen mode.
4.
Page layout view gives the exact image of the worksheet as it would appear on
printing. Headers and Footers are also accessible in this view . Whereas Page
Break Preview gives you the control in determining the page break positions as
the user can adjust the page break as per their requirement..
Session: 7- Apply Cell And Range Name
Assessment Time
A.
Multiple Choice Questions
1.
Formulas
2.
Scope
3.
Edit
B.
State True Or False
1.
True
2.
True
3.
True
C.
Answer the following questions:
1.
Defining Name range is useful in the case when working with large spreadsheets
as useful name can be assigned to group of cells , to refer them with their
name quickly. This helps in easy location of data in large spreadsheets.
2.
Named Range can be used in formula as follows:
i.
Click on any cell and define the formula.
ii.
Specify the range name as a argument to formula.
iii.
Press enter to get the result.
E.g.
= Sum(Units_Sold) Here it is important to note that once you define a name to a
range , the formula becomes static and cannot be copied.
Session: 8- Apply Create Modify And
Format Chart
Assessment Time
A.
Multiple Choice Questions:
1. Format Axis
2.
Chart sheet
3.
Pie Chart
4.
Format Plot area
5.
Layout
B.
State True Or False:
1.
False
2.
True
3.
True
C.
Answer the following questions:
1.
Chart is pictorial representation of any data . It helps the user to quickly
analyze the data.
2.
Charts can be Inserted through Chart group of Insert Tab.
3.
Design. Layout and Format are the three new tabs that are Inserted when user
Inserts a Chart in Worksheet.
4.
Chart area Includes all the area and the objects in the chart whereas plot area is the window within the chart area.
It contains the actual chart Itself and includes Plotted data, Data series.
category and Value axis.
5.
To change the scaling of the chart perform the following option:
i.
In a chart, click the value axis that you want to change, or do the following
to select the axis from a list of chart elements:
ii.
On the Format tab, in the Current Selection group, click Format Selection.
iii.
In the Format Axis dialog box, click Axis Options, and then select one or more option
in the dialog box.
iv.
The scaling of the chart will be done.
Session: 9- Sort And Filter Data
Assessment Time
A.
Multiple Choice Questions:
1.
Arranging
2.
Data
3.
Criteria
4.
Header Row
B.
State True Or False:
1.
True
2.
False
3.
False
C.
Answer the following questions:
1. Sorting means arranging the given data
according to specific field either in
ascending or descending order. Data is sorted so that it can be displayed in
logical order and moreover locating the data becomes very easy if the data is
sorted.
2.
Autofilter command helps in filtering the data list in the same position that meets specific criteria on the basis of
single field., which makes the analysis of data very easy.
3.
The advance filter option is used to filter the data in multiple fields by
using specified criteria or to find unique records. It is also used to copy a
filtered record to a different location.
Session: 10- Calculate Data Across
Worksheets
Assessment Time
A. Multiple Choice Questions:
1.
Average(‘Sheet2’!B3:B6)
2.
Sales_2016
B.
State True Or False:
1.
False
2.
True
C.
Answer The following questions:
1.
Steps to add data from one worksheet(W1) to another worksheet(W2) i. Open W1
worksheet
ii.
Select cell B3 and type the formula:=SUM(B2,’Sheet 1’!B2)
iii. Press enter. The result will be displayed
adding the contents of both the sheets.
2.
=Sum(‘sheet1’!B3.’Sheet 1’!B3:B6)
Session: 11- Using Multiple Workbook
And Linking Cells
Assessment Time
A. Multiple Choice Questions:
1.
Results
2.
Edit Link
B.
State True or False:
1.
True
2.
False
C.
Answer the following questions:
1.
Linking workbooks is useful in the sense that user can summarize data from
several sources. The formula can be created that span different source
workbooks and make calculations by using combination of current and linked
information. This feature helps in keeping the Information upto-date without
editing multiple locations every time the data changes.
2.
When the destination Workbook is closed . once the Automatic updates or links
have been enabled .every time you open the destination workbook .you are asked
if you wish to update the links. When you click update the linked cells get
updated.
3.
Steps to break the Workbook links are as follows:
i.
Open a Workbook that contains a link to a cell in another Workbook.
ii.
Click on Edit link button in the connections group on the data tab.
iii.
In the Edit link dialog box . select the link you want to remove.
iv.
Click on the break line button.
v.
When prompted , click on the break links button to confirm that you want to
break the link.
Session: 12- Sharing Worksheet Data
Assessment Time
A. Multiple Choice Questions:
1.
[Shared]
2.
Review
3.
Editing
B.
State True or False:
1.
True
2.
False
C.
Answer the following Questions:
1.
Steps to share an Excel Workbook are as follows:
i.
Open a Workbook
ii.
Click on share workbook option in Review Tab in the Changes Group. iii. In the
editing tab of share workbook dialog box click on the checkbox: Allow changes
by more than one user at the same time.
iv.
This allows workbook merging.
v. Click on file à save
vi.
Excel saves the Workbook and the word [Shared] appears at the top of Excel
window, next to file name.
2.
Sharing workbook feature gives other user access to the same document and allow
them to edit the workbook simultaneously, which saves the trouble of keeping
track of multiple versions.
3.
Steps to cancel Workbook sharing:
i.
Open the workbook.
ii.
On the Review Tab in the changes group , click share Workbook.
iii.
The share workbook dialog box appears.
iv.
On the Editing Tab , uncheck the checkbox Allow changes by more than one user
at the same time. This also allows workbook merging.
v.
Click ok
vi.
A dialog box appears prompting with a warning message. Click on yes.
vii.
The sharing of the workbook will be cancelled.
Stay with us
ReplyDelete