Page 76 - 2422_C5_Flipbook
P. 76

V. Answer the following questions:
                     1.  What is the use of Redo command?

                        ___________________________________________________________________________
                        ___________________________________________________________________________

                     2.  What is a range? How can you select a range of cells using the mouse?
                        ___________________________________________________________________________
                        ___________________________________________________________________________

                     3.  Write a short note on Formula bar.
                        ___________________________________________________________________________

                        ___________________________________________________________________________
                     4.  What is the purpose Auto Fill feature? Explain in detail.

                        ___________________________________________________________________________
                        ___________________________________________________________________________
                     5.  Differentiate between rows and columns.

                        ___________________________________________________________________________
                        ___________________________________________________________________________

                  VI. Competency-based/Application-based questions.

                     1.   Raj has a list of his favourite books in Excel 2016. He wants to move the list
                        from one worksheet to another and copy the names of the authors to a
                        new column in the same worksheet. How can Raj move the list of books to
                        a different worksheet, and what steps should he follow to copy the authors'
                        names to a new column?

                     2.   Emma wants to quickly fill a column with the names of the months of the year in Excel
                        2016. She has already typed "Jan" into the first cell. How can Emma use the Auto Fill
                        feature to complete the column with the names of the remaining months, and what
                        should she do after entering "Jan" in the first cell?
                     3.  Rohan entered some incorrect data in an Excel cell. What are two ways he can edit it?

                     4.   Simran wants to fill a list of dates sequentially without entering them manually. Which
                        feature should she use?
                     5.   Vikram needs to copy and move data from one cell to another. What are the steps to
                        do this?

                  VII. Assertion and Reasoning questions.

                      Direction: The  following question  consist  of two statements  –  Assertion  (A) and
                      Reasoning (R). Answer these questions by selecting the appropriate option given below:

                      a. Both A and R are correct and R is the correct explanation of A.
                      b. Both A and R are correct but R is NOT the correct explanation of A.


                  74    Premium Edition-V
   71   72   73   74   75   76   77   78   79   80   81