Kristine Baluyan
$3/hr
Customer Service Representative and Data Entry (Entry Level)
- Reply rate:
- -
- Availability:
- Full-time (40 hrs/wk)
- Age:
- 39 years old
- Location:
- Sablayan, Occidental Mindoro Region 4, Philippines
- Experience:
- 0 years
Google Sheet Work
I. SUM Formula
ITEMS
AMOUNT
-
Item 1
500
-
Item 2
320
-
Item 3
150
-
Item 4
600
-
Item 5
700
TOTAL
2270
-
II. COUNTIF Formula
ITEMS
Jam
Jam
Jam
8
Bryan
Bryan
Bryan
4
Jam
Jam
George
6
George
George
Mary
2
George
George
Bryan
Bryan
Jam
Jam
Mary
Mary
George
George
Jam
Jam
III. MULTIPLICATION Formula
ITEMS
QTY
UNIT
TOTAL
Item 1
2
$275.00
$550.00
Item 2
3
$788.00
$2,364.00
Item 3
5
$1,478.00
$7,390.00
Item 4
4
$99.00
$396.00
Item 5
7
$178.00
$1,246.00
TOTAL
$11,946.00
IV. Data Validation & Conditional Formatting
CLIENT NAME
EMAIL
NUMBER
STATUS
Client 1-6.39179E+11
NEW
Client 2-6.39179E+11
ACTIVE
Client 3-6.39179E+11
FOLLOW UP
Client 4-6.39179E+11
FOLLOW UP
Client 5-6.39179E+11
NEW
Client 6-6.39179E+11
NEW
Client 7-6.39179E+11
NEW
Client 8-6.39179E+11
ACTIVE
Client 9-6.39179E+11
ACTIVE
Client 10-6.39179E+11
INACTIVE
V. Time Tracking Sheet with Basic Formulas
DATE
PROJECT
START TIME
END TIME
HOURS SPENT
4/12
Project 1
8:00
9:25
1:25
4/13
Project 2
1:00
3:56
2:56
4/14
Project 3
12:00
13:30
1:30
4/15
Project 4
7:00
8:32
1:32
4/16
Project 5
5:00
12:00
7:00
VI. IF Formula
EXPENSES
BUDGETED
ACTUAL
DIFFERENCE
STATUS
Rent
₱12,000.00
₱12,000.00
₱0.00
ON BUDGET
Internet
₱1,999.00
₱800.00
-₱1,199.00
UNDER BUDGET
Insurance
₱3,500.00
₱4,000.00
₱500.00
OVER BUDGET
Grocery
₱5,000.00
₱8,000.00
₱3,000.00
OVER BUDGET
Transportation
₱8,000.00
₱12,000.00
₱4,000.00
OVER BUDGET
VII. AVERAGE Formula
AGENT
MONTH
SALES
Agent 1
April
₱12,000.00
Agent 2
₱3,254.00
Agent 3
₱4,000.00
Agent 4
₱8,000.00
Agent 5
₱12,000.00
Agent 6
₱47,889.00
Agent 7
₱1,999.00
Agent 8
₱3,500.00
Agent 9
₱65,874.00
Agent 10
₱8,000.00
AVERAGE
₱16,651.60
VIII. MIN & MAX Formulas
ITEMS
IN STOCK
REORDER LVL
Item 1
88
50
Item 2
25
30
Item-
Item 4
81
80
MIN
MAX
Item 5
63
60
22
750
Item-
Item-
Item-
Item-
Item-
IX. TODAY & TEXT Formulas
DATE TODAY
01/09/2025
FORMAT: dddd, mmmm dd, yyyy
Monday,September 01,2025
EVENT
DATE
TIME
DAYS LEFT
Event 1
10/10/25
19:00
39
Event 2
11/23/25
19:00
83
Event 3
12/3/25
19:00
93
Event 4
1/12/26
19:00
133
Event 5
2/14/26
19:00
166
