Spreadsheets

Column: A vertical devision of a page
Cell: An intersection between a row and column
Row: A range of cells that go across
Formula: An expression which calculates value
Data: Info that is stored in a spreadsheet
Validation: Allows you to control what is entered

Definitions

File format and management

SUM: Adds all of the numbers in a range of cells
Label: a heading that names something
Sort: The process of arranging things
Cell reference: A reference to a cell or a range of cells
Absolute cell reference: When a cell reference is locked with $ signs
Chart: Visually display data

File Format

Formulas for excel

Average: Returns the average of the numbers provided
Minimum: Returns the smallest value from the numbers provided
Maximum: Returns the largest value of numbers.

How to write a basic formula

Find and click on the cell where you would like to write the formula
Type in the equal sign=
Click on the cells you would like to include the formula
Type in the operator
Click of the other cell you would like to use in the formula
Press enter

Example formulas

=C3D2= It multiples the number in C3 and the number in D2
= SUM(E8:E15) = It finds the sum of the numbers in the cells range of E8 to E15
=A1+B2= It adds the numbers in A1 to B2
= AVERAGE(D1:D6) = It finds the average for the numbers in D1 to D16
=(D2B4)/2= It multiples the numbers in D2 and B4 and then divides by 2

File management

Application based File Management

File management utilities

Applications typically provide way to open files d save them in a specific folder on a storage device

Mainframes

The mainframe computers are expensive, large and multi-user computers. They are able to process a lot of information every second and they can control large amount of devices.

Microprocessors are small integrated circuits embedded into devices which carry out the functions of a CPU. The CPU is stands for Central processing Unit. It's the brain of the computer. They can be programmed or reprogrammed to alter the performance of the devices..

link for CPU/Microprocessors in My Learning :http://wso.ae.gems-fusion.com/index.php?name=FileManager&fid=4L24272829232929

Example of using the formulas

https://gemselearning-my.sharepoint.com/:x:/r/personal/zainab_a2_wso_gemselearning_com/_layouts/15/Doc.aspx?sourcedoc=%7B993655f9-2147-4cd0-a8fe-564c8c274727%7D&action=default&uid=%7B993655F9-2147-4CD0-A8FE-564C8C274727%7D&ListItemId=25&ListId=%7B357490BE-41DC-40C0-A4EE-1941F3935CA7%7D&odsp=1&env=prod

Videos to help for revision

Example spreadsheet with tasks

File management utilities show you the files stored on your disks and help you work with them

File management metaphors