Page 14 - Excle-En-V3

Figure 151: The result of the UPPER function........................................................................................................................... 100
Figure 152: Choosing the LOWER function ............................................................................................................................... 101
Figure 153: The result of the LOWER function.......................................................................................................................... 101
Figure 154: Round Function ..................................................................................................................................................... 101
Figure 155: Randbetween Functions........................................................................................................................................ 102
Figure 156: SUMIF & COUNTIF ................................................................................................................................................. 103
Figure 157: TODAY FUNCTION ................................................................................................................................................. 104
Figure 158: NOW FUNCTION .................................................................................................................................................... 104
Figure 159: If Function steps .................................................................................................................................................... 105
Figure 160: If Function result ................................................................................................................................................... 105
Figure 161: nested IF functions ................................................................................................................................................ 105
Figure 162: Error ####.............................................................................................................................................................. 107
Figure 163: Error #NAME?........................................................................................................................................................ 107
Figure 164: Error VALUE! ......................................................................................................................................................... 108
Figure 165: Error DIV/0!........................................................................................................................................................... 108
Figure 166: Error #REF! ............................................................................................................................................................ 108
Figure 167: SUBTOTAL function before sorting Area ................................................................................................................ 110
Figure 168: SUBTOTAL function after sorting Area................................................................................................................... 110
Figure 169: SUBTOTAL number of Areas .................................................................................................................................. 111
Figure 170: SUBTOTAL of the count function ........................................................................................................................... 111
Figure 171: First level of SUBTOTAL ......................................................................................................................................... 112
Figure 172: Second level of SUBTOTAL..................................................................................................................................... 112
Figure 173: Subtotal for total order quantity ........................................................................................................................... 112
Figure 174: SUBTOTAL of the sum function.............................................................................................................................. 113
Figure 175: Replace current subtotals...................................................................................................................................... 113
Figure 176: Subtotal for both count & sum .............................................................................................................................. 114

6 Central Unit for Information Technology Training - Supreme Council of Universities © Intellectual Property Rights 2024