Page 7 - TP_Pluse_V2.2_Class3
P. 7
Assessment Resources
Sheet Tab TesT Your skills
1. Tick ( ) the correct answer
a. An active cell has a ____________ border around it.
It is present at the bottom left side of the Excel window just above the Status bar. Sheets
(i) Green Test Your Skills contains
tabs show the number of worksheets in a workbook and the Active Sheet (currently open
plus sign on the right of the sheet tab. (ii) Blue (iii) Black
worksheet). The name of default worksheet is Sheet 1. To add a new worksheet, click on the
b. Which of these is not a range?
(i) A:3:F9 (ii) C20:E28
(iii) B6:D16 variety of exercises to
Row and Columns c. What is the shortcut key to edit a cell?
(i) Esc key (ii) Enter key
d. The keyboard shortcut to copy and paste cell contents is: (iii) F2 key
Columns are the vertical sections of the worksheet whereas Rows are the horizontal sections
(i) Ctrl + Z & Ctrl + V reinforce the concepts.
of the worksheet. An Excel worksheet has 1,048,576 rows and 16,384 columns.
Cells (ii) Ctrl + C & Shift + V (iii) Ctrl + C & Ctrl + V
e. Which of these cannot be filled using Auto Fill feature in Excel?
(i) Numbers
(iii) Colours
hold numbers, text or formula. (ii) Days
Cells are the intersection of rows and columns. It is the smallest unit in a worksheet and can
2. Fill in the blanks using the words given below:
Worksheet
Editing, Cells, Delete, Column, Number
a. To edit any content, you have to select the ____________.
The worksheet is divided into Rows and Columns. The rows are numbered as 1, 2, 3, 4…. as
indicated by the Row Headers on the left side of the workspace. The columns are labelled
of the workspace. b. To select a column, place the mouse pointer on the ____________ header.
alphabetically as A, B, C, D…Z, AA….AZ,…..XFD as indicated by the Column Headers at the top
Active Cell c. Time and date can be entered in a cell from ____________ group under Home tab.
d. To delete the contents of cells, select the cells and press the ____________ key.
e. The Fill button is in the ____________ group under Home tab.
As the name suggests, it is the cell that is currently active or selected. It can be recognised by
3. Write 'T' for true and 'F' for false.
its thick green border. You can type data into an active cell only.
Formula Bar a. You cannot enter a series of number using Auto Fill feature.
b. You cannot select a range using a mouse.
formula bar.
c. The date and time formats are given in the category box.
It displays the contents of the active cell. You can also type or edit data and formulas in the
Let’s CatCh Up d. You can change the contents of the cell by clicking in the formula bar.
e. Moving the cells data means deleting it from original position.
Match the following.
1. Row Header
a. Address of the active cell 4. Answer the following questions:
2. Column Header
b. Displays content of active cell a. What is the use of Redo command?
3. Sheet Tab
c. Row numbers
4. Name Box ___________________________________________________________________________
d. Column labels
5. Formula Bar ___________________________________________________________________________ Tech Practice is a lab
e. Displays number of sheets in worksheet
Editing Cell Contents in Excel 2016 71
activity to develop
52 Plus (Ver. 2.2)-V
practical skills.
Let's Catch Up Tech Zone contains (Subject Enrichment)
recalls a part of sections such as
21 st Century Skills #Creativity
lesson quickly. Let's Explore, Let's Draw a poster of 'Save the Environment' using Paint application in your computer.
Tech PracTice
Get Better & Let's Make use of the following symbols to create the poster.
Solve.
Tech Zone
LeT's soLve
Guess who am I? 21 st
Century #Critical Thinking
Skills
a. I change the layout of the presentation.
____________
b. I provide the themes for presentation.
____________
c. I add pattern in the background.
____________
d. I provide option to change the font color and size.
____________
LeT's exPLore
21 st
Century #Creativity
Skills
themes in a slide.
1 Follow the steps of applying a theme in presentation and try to apply three different
SDG Activity shows
SDG Activity
how students use digital For The Teacher
You see some trash on the ground in a park where animals live. What can
Demonstrate an example other than one in the book to explain the concept of secret message to students.
you do to help in keeping the animals safe and the park clean? Present
Explain the concept of information processing to students.
your thoughts in the form of an essay in a Word document.
literacy to understand
Tech PracTice
21 st
Century #Creativity
1. Prepare a presentation on the following topics:
Skills
a. Life cycle of butterfly the SDGs. Data Processing 95
b. Environment
2. Add different headings using various WordArt.
3. Add pictures related to topic.
T est Sheet 1 (Based on chapters 1 to 5)
Formatting a Presentation
47
Section A Project Work is an
A. Tick ( ) the correct option.
1. Which of these was used by the early man for counting? (iii) Bones
(i) Calculator (ii) Abacus assessment to develop
Four Periodic 2. Mark-I was built in ____________. (ii) 1948 (iii) 1940
(i) 1944
(ii) Ignore All
Assessments for evaluation. 3. Which of these is not an option in the suggestion box? (iii) Add all practical proficiency.
(i) Change
4. Which of these is not a page orientation in Word?
(ii) Scenery (iii) Portrait
(i) Landscape
5. Which of these is a default paper size in Word? (iii) Letter https://www
(ii) A3
(i) A4
6. Which of these is not available in the Variants group?
PROJECT
(iii) Effects PROJECT WORK
(i) Colors (ii) Designs
Periodic Assessment
1 7. Which of these is not an option in background fill effect? https://www
(Based on chapters 1 & 2) (i) Liquid (ii) Solid (iii) Gradient A. Create the following document in Word and share Century Skills 21 st #Leadership & Responsibility
it with your friends using the Mail Merge feature:
8. Where is the Animation pane option located? https://www
(ii) Design tab (iii) Animation tab
A. Write the names of the following:
(i) Insert tab
9. Which key combination will move the active cell one row up? (iii) Shift + Ctrl https://www
(i) Shift + Enter (ii) Shift + Tab
1. _____________ 10. Which of these is not a range? https://www
2. _____________ (iii) B6:D16
3. _____________ (ii) C20:E28
4. _____________ (i) A:3:F9
11. What is the shortcut key to edit a cell? (iii) F2 key
B. Name the machines associated with the following scientists in the field of computers. (i) Esc key (ii) Enter key
1. Charles Babbage
2. John Mauchly _____________________________ B. Fill in the blanks.
3. Blaise Pascal _____________________________ 1. Transistors and magnetic tapes were used in ____________ generation. B. Create the following in Excel. Century 21 st #Creativity
4. Herman Hollerith _____________________________ 2. The invention of integrated circuits occurred in ____________ generation. Skills
5. Gottfried Wilhelm Leibniz _____________________________ 3. Paper size is the actual length and width of the paper in ____________.
Test Sheet 1
Test Sheet 1 75 75
_____________________________
C. Write 'T' for true and 'F' for false.
1. Paragraph spacing cannot be changed in a document.
2. Line spacing can be changed in a document.
3. The header is placed at the bottom of a page.
Two Test Sheets C. Create similar PowerPoint presentation on Global
4. Abacus is used to calculate numbers at low speed.
Warming.
Century 21 st #Leadership & Responsibility
Skills
5. Herman Hollerith developed the Tabulating Machine in 1890.
have questions to https://www https://www
D. Competency-based/Application-based question.
Rahul wrote an essay on ‘MY COUNTRY—INDIA’ and saved it. Now he wants to break the
assess students.
essay in three paragraphs. Which tab and group will help in doing so?
________ _ _______________________________________________________________________
________ _ _______________________________________________________________________
120 Plus (Ver. 2.2)-V
https://www
34
Plus (Ver. 2.2)-V

