Page 176 - IT 402 v2.0 class 10
P. 176
Lab Assignment ‘n Activity Cr itical T h ink ing
Complete the following activities and tick on the circle.
onsider the worksheet as shown below.
Ob ective is to get Maximum rofit by optimising the uantity using Solver .
onstraints: ere are a couple of constraints that must be considered while trying to
maximise the profit.
uantity of roduct should be made at least .
uantity of roduct should be made at least .
uantity of roduct should be made at least .
otal uantity of roducts should be made 5 .
LINK DATA AND SPREADSHEETS
Spreadsheet allows linking among data associated within cells from various worksheets to summarise data
from several sources.
Setting Up Multiple Worksheets
very workbook contains at least one worksheet by default. hile working with a large amount of data
multiple worksheets can be created to organise the workbook and make it easier to find data. orksheet
can also be grouped to uickly add information to multiple worksheets at the same time. y default every
workbook contains a sheet named Sheet which is managed using tabs at the bottom of the spreadsheet
as shown below:
Sheet Tab
174 Touchpad Information Technology-X

