Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 70 - logicode 2609 C5
P. 70

    2.  Fill in the blanks using the words from the help box.

                                                   Redo, Undo, Delete, Range, Autofill

                          a.  The _______________ command reverses any action performed by us.
                          b.  The _______________ option reverses back the action performed using the Undo option.

                          c.  When we select more than one cell at a time, these contiguous  cells form a _______________.
                          d.  To delete the contents of cells, select the cells and press the _______________ key.
                          e.  The feature of entering sequential data in the cells of a worksheet is called _______________.

                      3.  Answer in one words.
                          a.  Name the key you press to edit a cell's contents directly.                    ____________

                          b.    Where on the interface must we click to select an entire worksheet?         ____________
                          c.   The Paste option is present under which tab?                                 ____________

                          d.    Which toolbar contains the Undo and Redo buttons?                           ____________

                          e.    Name the icon at the bottom-right of a selected cell for AutoFill.          ____________
                      4.  Think and answer.

                          a.   Which action is used to select an entire row in Excel?

                             ______________________________________________________________________________
                             ______________________________________________________________________________

                          b.   What is the use of the Autofill feature in Excel?
                             ______________________________________________________________________________

                             ______________________________________________________________________________
                          c.  Write the steps to insert a new row in an Excel worksheet.

                             ______________________________________________________________________________

                             ______________________________________________________________________________

                                                                                                   21 st
                      5.  Competency-based/Application-based questions.                          Century   #Technology Literacy
                                                                                                  Skills
                            a.   You accidentally deleted a sentence in your school report and want to get it back. Which
                             command should you use to reverse the last action?
                          b.   Kazim is arranging students details by roll numbers from 1 to 50. How can he fill this number
                             sequence without manual entry?

                          c.   Mansi entered data in a worksheet but wants to correct only a few letters in a cell without
                             removing the entire content. Which method should she use to edit the cell contents?
                          d.   Priya prepared a marks sheet in Excel but later realized that she needs to add two new
                             subjects  between existing columns. Which Excel feature  should she use to  insert the
                             required columns without deleting the existing data?

                          e.   While working in Excel, Mayank used the Undo command by mistake and wants to bring
                             back the last action he reversed. Which Excel command should he use?

                       68   Premium Edition-V

| 65 66 67 68 69 70 71 72 73 74 75 |