Casio Spreadsheet Application Manual do Utilizador descarregar pdf (Página 6)

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008

Then EXE

The Retainer-plus-Commission Calculator is complete.

Now use it to complete the investigation which was:

Find three different combinations of Retainer Amount, Sales Made and Percentage Rate of Commission which earn a

salesperson $2850 in a week.

Three possible solutions are shown in Fig22:

Building a Wage Calculator:

Can you do it?

Consider the situation where an employee works a combination of normal time, time-and-a-half, double-time and double-

time-and-a-half.

Your task is to design a spreadsheet whereby both the number of hours and the hourly rate can vary.

Design the Wage Calculator in your own way.

Then follow the instructions below to build the version described by these instructions.

One example of the Wage Calculator:

Create a new spreadsheet and name it suitably (FILE NEW)

Move the cursor to Cell A1 and type HRS by pressing ALPHA EXP SHIFT ALPHA H R S EXE (Fig 23)

Now enter the remaining labels in Fig23 (Hourly Rate, Penalty Levels, Totals and Grand Total) as shown in B1, C1, D1 and

Enter the penalty values 1 1.5 2 2.5 into cells C2 to C5 (Fig23)

To create the active Totals cells D2, D3, D4 and D5:

Press EDIT, F6, FILL.

Then enter the values as shown in Fig24.

Press EXE, EXE.

Fig 22

Fig 23

Fig 24

1 2 3 4 5 6 7 8 9 10 11 ... 21 22

Sem comentários

Casio Spreadsheet Application Manual do Utilizador Página 6