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