Page 7 - TP_Pluse_V2.2_Class_5
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
   2   3   4   5   6   7   8   9   10   11   12