Introduction To Micro-Technology
Computer Science Assignment/Project
Course Title: Micro-Soft Excel
AD
BG
LE
Sal
Ady
175
30
59
88
117
146
175
204
233
262
291
320
ID
001
002
003
004
005
006
007
008
009
010
Namc
Sanita Cully
Saah Kpakar
Rudolph Gayflor
Francis Yoryor
Adolphus Naigar
Moses Gay gay
Philip Kuoper
Simon Momno
David Brown
John Yankar
CJ
Hr.
Work
178
180
145
160
185
150
182
186
190
120
DM
IIr.
Rate
8
6
S
4
7
9
10
12
14
15
EP
Reg.
Pay
300
350
325
250
275
340
345
FS GV
Over Gross
Time Pay
115 450
100 500
75 475
50 485
40 425
30 430
35 435
20 375
25 490
80 585
HY JC
Inc. SS
Tax Tax
10.20 20.04
11.75 21.00
12.30 21.06
15.05 22.00
22.08
10.00 23.00
15.75 23.10
17.22 24.00
20.05 24.12
20.00 26.00
17.05
181
141
161
186
151
183
187
191
121
200
TI
380
400
1. Direction: List the Relative, Absolute and Mixed Cell References of the following figures
in the above table:
i. 180
ii. 25
ili 175
iv. 183
V 6
2. State the meanings of the three types of cell references.
3. Assume that you were asked to find Average, Total Number of Students, Maximum,
Minimum and Product. What are the terms used in finding the above within the database?
4. Looking at the cell reference of Status will respect to commission; build a cell reference
stating that if sales which is B7, Less than 800, the rate is 2% below is 1% and state if it
is true or false.
5. Slate the steps of Deleting and Inserting Row.​