Page 152 - Excle-En-V3
P. 152

Activity 2:
             You have 10 sales representatives and they have achieved a sales percentage.

        Use the (IFS) function to indicate the highest sales percentage, so that if the sales
        are 90% or higher, they are excellent, and if they are between 80% and 90%, they
        are good, and any sales that are less than 80% are Weak
        Activity 3:

             Create a budget model for home needs during a month, for example, using the
        format cells and columns, merge cells, align and center cells, add boarder, and use
        different functions such as SUM, as follows:

             Budget Model
        Activity 4:

                    Format Page Fit to print all workbook sheets in 3 sheets horizontally and 3
              sheets vertically

144 Central Unit for Information Technology Training - Supreme Council of Universities © Intellectual Property Rights 2024
   147   148   149   150   151   152   153   154   155   156   157