CUF Excel Lab Assignment

Assignment E.1

There is a table of purchases of various flowmeters for a technological process.

Fill in appropriate formulas in to the light blue cells, so you will create a purchase budget.

Display appropriate format of numbers in cells by formatting the data type in cells.

Fill in cell E27, where the appropriate discount will be applied according to purchased amount that is cells from D24 to E25.

Create appropriate graphs showing the percentage of single items in the whole purchase project.

Download the Excel File

Assignment E.2

Using MS Excell, calculate values of currents in the electronic cuircuit by solving a set of three linear equations ( http://en.wikipedia.org/wiki/Cramer_rule )

Assure the results will vary with changing values in gray fields.