Page 15 - Excle-En-V3

Figure 177: Remove all subtotals ............................................................................................................................................. 114
Figure 178: Consolidate tool .................................................................................................................................................... 115
Figure 179: Selecting data from the worksheet........................................................................................................................ 116
Figure 180: Adding or deleting worksheets.............................................................................................................................. 116
Figure 181: All the worksheets that have been added ............................................................................................................. 117
Figure 182: The result of applying the Consolidate tool to more than three worksheets ......................................................... 117
Figure 183: Tracking shares...................................................................................................................................................... 118

Figure 184: Precedent cells& Dependent cells ....................................................................................................................... 118

Figure 185 Formula Auditing Commands ................................................................................................................................. 118
Figure 186: Accessing Add-ins option....................................................................................................................................... 121
Figure 187: Manage option ...................................................................................................................................................... 121
Figure 188: Solver Add-in and analysis Tool Pak ...................................................................................................................... 121
Figure 189: Data analysis tools ................................................................................................................................................ 121
Figure 190: the two teams results............................................................................................................................................ 122
Figure 191: T-test..................................................................................................................................................................... 122
Figure 192: Tests options ......................................................................................................................................................... 123
Figure 193: How to set the test range ...................................................................................................................................... 123
Figure 194: Selecting the location for extracting test results.................................................................................................... 124
Figure 195: Selecting the option Labels.................................................................................................................................... 124
Figure 196: T test result ........................................................................................................................................................... 125
Figure 197 : Product data......................................................................................................................................................... 125
Figure 198: Solver tool application .......................................................................................................................................... 126
Figure 199: Solver transaction ................................................................................................................................................. 126
Figure 200: the result after applying Solver tool ...................................................................................................................... 127
Figure 201: Custom margins .................................................................................................................................................... 127
Figure 202: Centering the printed table ................................................................................................................................... 128

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