Spreadsheet


Spreadsheet

 

 

 

• Is an application software that analysis and storage of data in tabular form.

 

 

 

 

 

• Can be used for creating data models, using functions, adding formulae, sort data, filter data, testing data and creating graph charts…etc


 

 

 

 

 

 

• Cells: a cell is a box in which you can enter a single piece of data, is the intersection between a row and a column on a spreadsheet, identified by a letter and number such as A1

• Rows: rows are "horizontal" collections of items belonging to a certain category, identified by numbers.

• Columns: Columns are the vertical lines of data that stretch from the top of the spreadsheet to the bottom , identified by letters.

• Sheets: a combination of rows and columns together can be divided to one page or more.

• Tabs: used to identify the sheet name, which can be renamed, copied, moved and deleted

• Chart: is a graphical representation of data, in which "the data is represented by symbols, such as bars in a bar chart, lines in a line chart, or slices in a piechart".


the importance of accurate data entry in spreadsheets

 

• When we enter correct data, so correct results will be obtained.

 

• How To Help Minimize Errors in Data Entry: by using Validation, verfication.


 

 

 

 

 

 

• Formula: used to perform calculations, begins with equal sign.

• Function: a function is a preset formula, Functions make it easier to carry out, begins with equal sign

• absolute reference: absolute reference remain constant when a formula is copied to anotherr cell.

• relative reference: Relative references change when a formula is copied to another cell.

• Ranges: an number of cells selected together fof later use. • Named cell: cell can be identified by a name for later use

• named range: number of cells (range) can be identified by a name for later use.

• nested formulae/functions: With nested functions one or more functions are placed inside a main function.


Order of operations

 

 

 

 

 

 

 

 

 

Symbol: ( )

 

 

Symbol: ^

 

 

 

Symbol: * /

 

 

 

Symbol: - +


Testing data

 

 

 

 

 

 

 

• Testing data: means checking that the data model formulas and functions are work correctly.

 

• Test data is the data that is used in tests of a software system. • expected outcome: the supposed results after using a data model.

• actual outcome: the existing and current results after using a data model. • Normal data: acceptable, valid data/data, inside the given range

• Abnormal data: outside the limits of acceptability/validity • Extreme data: at the limits of acceptability/validity


Sample of test plan

 

 

 

 

 

 

 

Cell reference

Formula tested

 

 

 

 

Test data

 

 

Why chosen

 

 

expected outcome

 

 

actual outcome

 

Tested formula works Y/N

Remedial action