Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 55 - CodePilot V5.0 C7
P. 55

    D.  Answer the following questions:
                        1.  Write the purpose of Conditional Formatting.

                        2.  Differentiate between the SUM() and AVERAGE() function.

                        3.  Explain any two components of a chart.

                        4.  What is a line chart? What type of data can be represented using a line chart?

                        5.  List different ways to enter formulas.

                     COMPETENCY-BASED QUESTIONS                                                    Century   #Critical Thinking
                                                                                                    21 st
                                                                                                   Skills  #Technology Literacy
                     1.   Fatima has a dataset that shows the sales figures for different regions over the past year. She wants
                        to display this data to highlight the relationship between sales in different regions. Which chart type
                        should she use?

                     2.   Meera is creating a contact list in Excel and wants to combine the first and last names into
                        one cell. Which function can she use?

                                  LAB LEARNING                                             21 st
                                                                                          Century   #Technology Literacy
                                                                                           Skills
                            You are organising a school competition for students in grades 5 to 8. Create an Excel sheet
                            with the following details: Roll No., Student’s Name, Class, Address and Phone Number.
                            Apply data validation to:

                            (a)  The Class column to allow only values from 5 to 8. If someone enters a class outside this
                                 range, then an error message: “Class entered is outside the range.” will be displayed.
                            (b)  The Phone Number column should allow only 10-digit numbers. If an invalid phone number
                                 is entered, then an error message: “Enter a valid 10-digit phone number.” will be displayed.

                                                                                                                      53
                                                                                                         Excel in Excel

| 50 51 52 53 54 55 56 57 58 59 60 |