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

