Заданными величины x, y, z соответственно в ячейках A3, B3 и C3
жүктеу/скачать 0,81 Mb. Pdf көрінісі
|
rqcf0kjgph3tw4sahmt8vao5b0pfspsunjsrscgisehmyz
| Task execution.
We enter arbitrary data, for example, in cells A2: D6 of the worksheet, respectively. To calculate the sum of positive numbers, enter the formula in cell F4: = SUMMER (A2: D6; "> 0"; A2: D6), and to calculate the number of negative cells in cell F5, the formula: = COUNTRIES (A2: D6; "<0" ). Task 4 A Payroll consists of Basic Pay, Allowances, Gross Salary, Deductions and Net Salary. The Allowances are 23% of the Basic Pay while the Deductions are 12% of the Gross Salary. In the given worksheet, indicate in each cell what will be inserted, that is – a value or a formula. In the case of a formula, write down the formula in the cell. A B C D E F 1 Stationery Supplies Ltd 2 3 Name Basic Pay Allowances Gross Salary Deductions Net Salary 4 Lewis 5 Francis 6 Edwin . . . . . . 13 Totals Task 5 Create the worksheet below from scratch. (Создайте рабочий лист с нуля) A B C D E F 1 TOWN / DAY Mon Tue Wed Thur Fri 2 Mombasa 30 29.5 31 28.5 32 3 Kisumu 31 33 30 30 32 4 Nakuru 5 Nairobi 24 23.5 22 23 24.5 6 7 8 TOWN / DAY Mon Tue Wed Thur Fri 9 Mombasa 10 Kisumu 11 Nakuru 12 Nairobi |