Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 154 - logicode 2609 C6
P. 154

    Perform the following tasks:

                               Center align all the data.

                               Use Auto Fill to extend Registration No. up to 110.

                                Insert a new column named Parent Contact after Registration Number and enter the
                               contact number for each student.
                                Increase the Row Height of the first row and apply Bold + Fill Colour to all column
                               headings.

                               Adjust Column Width of Student Name and Event for better display.

                               Insert a new student record between row 3 and row 4.

                               Delete the last row of the sheet.

                               Save the workbook with the name School Event Registration.

                       14.  Create the given worksheet in Excel:

                            Perform the following tasks:
                               Insert a new row above the heading and type the month (Example: January Budget).

                               Calculate the Difference using the formula in D2: =B2 – C2.

                               Use Auto Fill to calculate Difference for all remaining categories.

                               If Difference becomes negative, format it as Red + Bold.

                               Center align all the data.

                                Insert a new row below the table and calculate the total Budgeted and Actual expenses
                               using: =SUM(B2:B6) and =SUM(C2:C6).

                               Adjust row height to improve visibility and neatness.

                               Save the workbook with the name Monthly Household Budget Planner.

                      152   Premium Edition-VI

| 149 150 151 152 153 154 155 156 157 158 |