Заданными величины x, y, z соответственно в ячейках A3, B3 и C3
Topic 3 Software. Operating systems
жүктеу/скачать 0,81 Mb. Pdf көрінісі
|
rqcf0kjgph3tw4sahmt8vao5b0pfspsunjsrscgisehmyz
- Бұл бет үшін навигация:
- Task execution.
| Topic 3 Software. Operating systems.
Task 1 Perform calculations using the following formulas (выполните вычисления по следующим формулам): assuming x, y, z are given in the cells A3, B3 and C3 accordingly (считая заданными величины x, y, z соответственно в ячейках A3, B3 и C3). Task execution. We introduce concrete values of variables into cells A3, B3 and C3 and in cells B5, B6 and B7 the corresponding formulas. For example, to calculate the first value, we can introduce the formula = 4 + 3 * X + 2 * X ^ 2 + X ^ 3. However, it is better to perform calculations according to the Horner scheme, which allows to reduce the number of operations performed. In this case, the formula takes the form = ((X + 2) * X + 3) * X + 4. The proposed formulas use as their operands, created names, which makes them similar to mathematically corresponding formulas. If necessary, you can also use the links to the cells in the worksheet in the formulas. In this case, the desired formula would have the form = (A3 + 2) * A3 + 3) * A3 + 4. Task 2 On the sheet, write down the formula for calculating the product of the sums of two one-dimensional arrays A and B, i.e. where ai and bi are the corresponding elements of the arrays, and n is their dimension. (На листе запишите формулу для вычисления произведения сумм двух одномерных массивов A и B, т.е. где ai и bi соответствующие элементы массивов, а n – их размерность). жүктеу/скачать 0,81 Mb. Достарыңызбен бөлісу:
|