Create and check a multi-sheet spreadsheet solution to meet specified user needs that uses a selection of appropriate functions and both simple and complex formulae

Unit 10-M1 Huriya Nazari

M1:

A spreadsheet is also known as a worksheet, as it is made up of tables; it is organized into columns and rows, this makes individual cells. The columns have labels which have letters of the alphabet, whereas the rows are numbered, both of these features enables the cells to have and address, which is the column letter and the row number.

Spreadsheet are used for different types of things, but are most frequently used for storing, manipulating and analysing numeric data. For example:

Storing values: number of sales made in each year.
Manipulating large sets of data: sorting and filtering makes it easier for a certain criteria to be identified.

Spreadsheet are used for different types of things, but are most frequently used for storing, manipulating and analysing numeric data. For example:

Storing values: number of sales made in each year.
Manipulating large sets of data: sorting and filtering makes it easier for a certain criteria to be identified.

Income

Function:

Week 2: I calculated the income by entering this formulae in the function bar “=SUM(D5*C5)”,

Week 3: I calculated the income by entering this formulae in the function bar “=SUM(D5*C5)”,

Week 4: I calculated the income by entering this formulae in the function bar “=SUM(D5*C5)”,

For all three weeks I pressed the fill handle on column “income” so that I could get the results of the rest of the income.