Page 25 - Computer - 8
P. 25
6. Click the OK button.
The Scenario Values dialog box opens.
7. Type the formulas in each box as shown in the image.
8. Click the Add button. 7
9. Repeat Steps 4 to 7 to add another scenario with an
increment value of 10%.
8
10
10. Once all scenarios are added, click the OK button.
A dialog box appears.
11. Click the OK button.
The Scenario Manager dialog box appears.
12. Select a scenario from the Scenarios list and click the Show button.
The worksheet is displayed with values as per the selected scenario.
12 13
13. Click the Close button to close the Scenario Manager dialog box.
PIVOT TABLE
A Pivot Table is a powerful tool to calculate, summarise, and analyse data that lets you see comparisons,
patterns, and trends in your data. It allows us to transform columns into rows and rows into columns.
It allows grouping by any field (column) and performing advanced calculations on them. The ‘pivot’
part of a pivot table arises from the fact that you
can rotate (or pivot) the data in the table to view it
from a different perspective.
Pivot tables are especially useful with large
amounts of data that would be time-consuming to
calculate by hand. A few data processing functions
a pivot table can perform include identifying
sums, averages, ranges or outliers. The table then
arranges this information in a simple, meaningful
layout that draws attention to key values.
23
