Page 7 - IT 402 v2.0 class 10
P. 7
Assessment Resources
ecti e and Su ecti e ue ions Sneak Peek
This section contains questions To Create a New Style in Microsoft Word:
Solved Exercise (Objective Type Questions) to assess the intellectual and 2. The ‘Styles’ task pane will appear. Select the ‘New Style’ button from the bottom of the task
pane.
1. Click on the arrow in the bottom-right corner of the ‘Styles’ group.
Section A
formatting.
1. Which feature of Calc helps to see the changes made in the shared worksheet?
A. Multiple choice questions: ii. Solver comprehensive writing skills. 4. Click on ‘OK’ button.
iv. None of these
3. A dialog box will appear on the screen. Type a name for the style and choose the desired text
i. Record Changes ii. File > Changes > Comments
5. The new style will appear in the 'Styles' group.
2. We can add a comment regarding any changes made in shared worksheet by:
iv. None of these
iii. Subtotal
i. Edit > Changes > Comments
iii. View > Changes > Comments
3. Worksheets can be merged from ............................. menu. ii. File Lab Assignment ‘n Activity
iv. Tools
Complete the following activities and tick on the circle.
i. Edit
ii. Repetitive
4. Which types of tasks can be easily performed using Macros?
to go through the worksheet and update their address and phone number, if required. He also would like to
iii. View iv. All of these Create a new style with mentioned formatting options such as font style "Baskerville Old
5. Raj has created a worksheet where he has added all the information of his employees. He wants every employee Face", font colour "blue", text highlight colour as "red", and font size as "18". Text should be
i. Rare
written in "bold". Save this style as ‘My list’.
iii. Decision making [CBSE Sample Paper, 2022]
know the changes done by his employees. Which feature of spreadsheet he should enable to see the changes Updating Styles from Selections
ii. Link Workbook To update a 'Style':
iv. Track Changes
made by his employees?
i. Macro Lab Assignment 'N Activity Step 2: Select the text.
iii. Change Worksheet 5. iv Step 3: Select Text style formatting
3. i 4. ii
1. ............................. feature is used to track every edited call by highlighting with coloured border.
Step 1: Press ‘F11’ function key from the keyboard. ‘Styles and Formatting’ window appears on the screen.
Ans. 1. i 2. i This section contains
2. ............................. option helps to display the comment permanently.
B. Fill in the blanks. 3. colors 4. comment. an activity to apply the 2
. he comments of different author appear in different ............................. .
4. Calc automatically adds a ............................. to any record changes.
Ans. 1. Record changes 2. Show comment concepts learnt.
Section B
(Subjective Type Questions)
Ans. The Record Changes feature is used to track the editing process of any cell by highlighting it with a coloured
1. What do you mean by ‘Record Changes’? List the steps to start recording changes.
border. On selecting the edited cell the details of the changes made by different authors will appear. he steps to
A. Answer the following questions: 3
Now start making the changes in the document. Changes get highlighted by a border around the cells.
Open the document to be edited.
Click the Edit menu and Select Changes.
start Record Changes are: 231
Select Record option. More About Spreadsheet
Advanced Features of Word Processor
109
9. Mention any two operations that can be performed using Macros in a spreadsheet. [CBSE Sample Paper 2023]
7. Write the complete procedure to use solver in OO Calc. [CBSE Sample Paper 2023] Practical Work Practical Work
. hat do you mean by yperlinks in Spreadsheets ive the two different types of yperlinks that can be used in
. hat is difference between relative and absolute hyperlink
[CBSE Sample Paper 2023]
ii. Goal Seek
Spreadsheets.
iv. Subtotal
Cr itical T h ink ing
Cr itical T h ink ing
Name
i. Scenarios
11. Anshita is preparing spreadsheet notes for her Term Exam. Help her to write short note on the following: This section has sample . onsolidate data of two sheets given below in third sheet of OpenO ce alc. S ub j e ct E nr ich me nt
Amit
1. Enter following data into worksheet and compute strike rate of batsman:
iii. Solver
June Pocket Money
Sumit
B. Application based questions: 103.90 ue ions for practical Kamal 1300 1200
80
Naina
77
1000
Suman
Runs Scored
examination.
1500
Balls Faced
Now find out the strike rate for following data and give them proper names and comments. Amit Name Sheet 1 1400
Strike Rate
The formula for strike rate is: =(cell1 / cell2) * 100
i. When score is 55 and balls faced are 40.
2. Sunita is making a project in spreadsheets. She wants to rename a spreadsheet as it will help her identify the Suman 1300 900
July Pocket Money
ii. When score is 78 and balls faced are 80.
Sumit
Naina
iii. When score is 95 and balls faced are 77.
worksheet data easily. hich option should she use to solved her problem
1100
Kamal
1200
1. A colored border, with ............................., appears around a cell where changes are made in a shared worksheet.
Previous Years’ Questions (b) a dot in the lower left-hand corner [2023] 2. Consider the given table mentioning student's details and perform the following:
1250
Sheet 2
(d) a cross in the upper right-hand corner
Rollno
Class
(a) a dot in the upper left-hand corner
(c) a cross in the upper left-hand corner
Phone_no
Sumit
2. ............................. feature adds data arranged in a group of cells in Calc, with labels for columns and/or rows. [2023] 3 1 2 XII X Amit Name 1234565
(b) Subtotal X Anuj 3564583
Ans. (a) (d) Solver [2023] Pre ious ears ue ions • isplay all the records of table Student. XI Mini 1236589
4
(a) Average
(c) Goal Seek
3. A ............................. refers to a cell or range of cells on a worksheet whose data values can be used in a formula. • Insert one record of your choice. 5869542
his section has ue ions • isplay record of student whose roll number is .
Ans. (b) (b) cell • isplay record of students who are in class .
(d) cell data [2023] • isplay the record of nu
(c) cell reference
(a) sheet with answers that were
(b) Goal Seek
4. ............................. feature of Calc is used to test ‘what-if’ questions. • Save the letter
Ans. (c) (d) Styles
asked in CBSE examinations. • xit OpenO ce riter
3. Write a letter to your father telling him about your Annual Day using Mail Merge.
(a) Solver
(c) Scenario
Ans. (c)
Touchpad Information Technology-X
200 Practical Work 415
Model Test Paper M ax . M arks: 5 0
M ax . T ime: 2 H ours Model Te Pa er Projects
2. T his Q ues tion P aper cons is ts of 21 q uestions in two s ections : Section A & Section B .
4. Out of the giv en ( 5 + 1 6 = ) 21 q uestions, a candidate has to answer ( 5 + 1 0 = ) 1 5 q uestions in the allotted ( max imum) time
3. Section A has Ob jectiv e type q ues tions whereas Section B contains Sub jectiv e type q ues tions .
G eneral Instructions: This section has Hints for Part D
1. P leas e read the ins tructions carefully.
5. All q ues tions of a particular s ection mus t b e attempted in the correct order. CBSE based model PROJECT-1
of 2 hours.
6 . SECT ION A - OB J ECT IVE T Y PE Q U EST ION S ( 24 M A R K S) :
Follo t e gi en instruction to com lete t e ro ect in en ce:
graduation, end of school or Memorial Day party. You can pick any event. Your letter will serve as your form
ii. M ark s allotted are mentioned agains t each q ues tion/ part.
i. T his s ection has 05 q ues tions . te paper. Type a letter inviting friends and/or family to a party you are hosting. For example, you can host a birthday,
iii. T here is no negativ e mark ing.
7 . SECT ION B – SU B J ECT IVE T Y PE Q U EST ION S ( 26 M A R K S) : Format the letter as 'left' aligned (block letter) with '0.5' or '1' margins depending on the length.
iv . Do as per the ins tructions giv en. letter. Save your letter as Mail Merge Letter.
ii. A candidate has to do 10 q ues tions .
i. T his s ection has 16 q ues tions . Projects Make sure your address is listed at the top of the document. Example of address: Address 1 Address 2 City,
letters. reate fields such as title first name last name address address city state and I . ou can
If y ou don’ t solv e Practice Papers before an ex am, y ou might be surprised at
iii. Do as per the ins tructions giv en.
how difficult it is to write q uickly and legibly during the ex am.
iv . M ark s allotted are mentioned agains t each q ues tion/ part. reate a data source with the names and addresses of at least five families in which you wish to mail the
State, ZIP
SECT ION A - OB J ECT IVE T Y PE Q U EST ION S ( 1 x 4 = 4 marks) This is an assessment to make appropriate field names of your choice but make sure you include the address information.
i. A Student completes his work only when his parents remind and driv e him do. T he s tudent is facing lack of … .......… … … … … … … . 1
Q 1 . A nswer any 4 out of the giv en 6 q uestions on Employ ability Skills 1 challenge the udents to Print invitation letter and label for each recipients.
b . Self-Awarenes s
reate a ro ect on onsum tion of air Products in e el i in alc:
a. Self-Dis cipline d. Self-R egulation
ii. … .......… … … … … … … s tres s mak es a pers on worris ome, les s productiv e and may lead to v arious dis orders . PROJECT-2
c. Self-M otiv ation
b . P os itiv e
d. None of thes e 1 apply the concepts learnt. This sheet can be shared with Dairy Companies who are supplying their dairy products in New Delhi.
iii. Neha is receiv ing s ev eral mails from companies who are adv ertis ing a product or trying to attract her to their web s ites .
a. Negativ e
c. B oth of the ab ov e
Such type of mails are called … .......… … … … … … … . b . B ulk mails 1
d. L ab elled mails
a. Adv ertis ing mails b . Infect printer 1
c. Spam mails
iv . W hat can a computer v irus NOT do? d. M ak e the computer s low
a. Infect files
b . P lanning
v . E ntrepreneurs hip has a crucial role in the … .......… … … … … … … of the s ociety. 1
c. Corrupt files
d. None of thes e …
v i. An indiv idual who initiates , creates and manages a new b us ines s can b e called .......… … … … … … … .
a. E v olution
c. F unctioning b . A manager
d. A profes s ional 427
a. A leader Model Test Paper Consider your 3 friends as representatives of Company A, B and C, respectively. Share the worksheet with
c. An entrepreneur your friends to update the selling data of Dairy Products in New Delhi by their company.
Touchpad Information Technology-X
420

