Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 6 - 2632_CodeMind
P. 6

    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

| 1 2 3 4 5 6 7 8 9 10 11 |