01 Excel Functions
01 Excel Functions
01 Excel Functions
1754500
ZQ
11-08 05:41:45)
all sales.
AHN3l0Zc
(2020-11-08 05:41:45)
rson's average review score for the entire year is
0, then, indicate here as "Yes." Else, "No."
Sales Tracker
only one between ======
both sales and rendered sales and rendered ID#AAAAHN3l0Zg
hours needs to be hours needs to be donnie (2020-11-08 05:41:45)
Hours Rendered for the considered considered If the total sales is above 10000
Salesperson Total Sales Month Qualified for Bonus? Qualified for Bonus? hours rendered is less than 100
Jenkins, Scott 75698 160 No No indicate here "Yes." Else, "No."
Ashley, Michael 88749 155 No No
Tanner, Timothy 126262 101 No Yes
Phillips, Liesl 89303 84 No Yes
Jensen, Kristina 119610 137 No Yes
Leblanc, Jenny 162028 142 No Yes
Taylor, Hector 76635 160 No No
Reynolds, Barbara 124010 94 Yes Yes
Burgess, Cherie 25344 146 No No
Rich, Brent 181546 90 Yes Yes
Watkins, Gary 118651 99 Yes Yes
Stafford, Rhonda 149975 92 Yes Yes
Winters, Shaun 139555 138 No Yes
=
AAHN3l0Zg
e (2020-11-08 05:41:45)
total sales is above 100000, and the
rendered is less than 100, then
te here "Yes." Else, "No."
Region Rep Item Units Unit Cost Total Sales
Luzon Juan Package A 95 ₱ 1.99 ₱ 189.05
Visayas Karlo Package B 50 ₱ 19.99 ₱ 999.50 Mindanao
Visayas Jardine Package A 36 ₱ 4.99 ₱ 179.64 Mindanao
Luzon Gill Package C 27 ₱ 19.99 ₱ 539.73 Mindanao
Luzon Sorvino Package A 100 ₱ 19.99 ₱ 1,999.00
Mindanao Juan Package B 60 ₱ 4.99 ₱ 299.40
Visayas Andrea Package A 12 ₱ 1.99 ₱ 23.88
Visayas Jardine Package A 90 ₱ 4.99 ₱ 449.10 Visayas
Luzon Tomas Package A 32 ₱ 1.99 ₱ 63.68 Luzon
Luzon Juan Package B 60 ₱ 8.99 ₱ 539.40 Luzon
Mindanao Howard Package B 29 ₱ 1.00 ₱ 29.00
Luzon Juan Package A 35 ₱ 4.99 ₱ 174.65
Mindanao Juan Package C 16 ₱ 1.29 ₱ 20.64
Mindanao Juan Package C 64 ₱ 8.99 ₱ 575.36
Visayas Karlo Package C 96 ₱ 4.99 ₱ 479.04
Mindanao Juan Package C 74 ₱ 1.29 ₱ 95.46
Visayas Gill Package B 46 ₱ 8.99 ₱ 413.54
Visayas Smith Package B 87 ₱ 15.00 ₱ 1,305.00
Mindanao Juan Package B 4 ₱ 4.99 ₱ 19.96
Luzon Sorvino Package B 7 ₱ 19.99 ₱ 139.93
Visayas Jardine Package C 50 ₱ 4.99 ₱ 249.50
Visayas Andrea Package A 66 ₱ 1.99 ₱ 131.34
Mindanao Howard Package C 96 ₱ 4.99 ₱ 479.04
Visayas Gill Package A 53 ₱ 1.29 ₱ 68.37
Visayas Gill Package B 80 ₱ 8.99 ₱ 719.20
Visayas Karlo Package D 19 ₱ 50.00 ₱ 950.00
Luzon Juan Package C 62 ₱ 4.99 ₱ 309.38
Visayas Morgan Package C 55 ₱ 1.99 ₱ 109.45
Visayas Karlo Package C 42 ₱ 5.00 ₱ 210.00
Luzon Sorvino Package D 57 ₱ 19.99 ₱ 1,139.43
Visayas Gill Package A 7 ₱ 1.29 ₱ 9.03
Luzon Sorvino Package C 76 ₱ 1.99 ₱ 151.24
Luzon Tomas Package B 57 ₱ 19.99 ₱ 1,139.43
Visayas Andrea Package A 14 ₱ 1.29 ₱ 18.06
Visayas Jardine Package B 11 ₱ 4.99 ₱ 54.89
Visayas Jardine Package B 94 ₱ 19.99 ₱ 1,879.06
Visayas Andrea Package B 28 ₱ 4.99 ₱ 139.72
======
D#AAAAHN3l0ZU
Author (2020-11-08 05:41:45)
Find the director as seen on the right.
Last Name First Name Academic Program
Abe Osami Arts & Sciences Undergrad
Alanis Jasper Cruz University Div Pre-Busine
Alfaro Bernabé Cotto Business Undergraduate
Aranda Amilcar Lozano Business Acctg Grad Progr
Arce Romelio Alva Health, PE & Rec Undergra
Arce Aurea Muñoz University Div Pre-Educat
Armijo Valderrama Cazares Arts & Sciences Undergrad
Arteaga Zuleica Hernández Arts & Sciences Undergrad
Asai Kiyotaka Law Professional
Avilés Nasha Cordova University Div Pre-CollAr
Barela Dunstano Hurtado Arts & Sciences Undergrad
Barraza Lorujama Anguiano Arts & Sciences Undergrad
Benavidez Jovianne Cervántez University Div Pre-Busine
Black Billy Music Graduate
Briones Barlaan Zavala Education -GrSch
Cabán Iguazel Journalism Undergraduate
Campos Alem Montez Optometry Professional
Cano Natan Portillo University Div Pre-Busine
Castellanos Vittorio Matías University Div Undergradu
Ceballos Teseo Caldera Education Undergraduate
Cedillo Bela Amador Arts & Sciences Undergrad
Chang Jacob Arts & Sciences Undergrad
Collado Sigfrido Roldán University Div Pre-Educat
Colón Umberto Urrútia University Div Pre-HPER
Connors April Arts & Sciences Undergrad
Cordle Martha University Div Pre-CollAr
Dean Juan Journalism Undergraduate
Echevarría Raffi Agosto Education Undergraduate
Fernandez Arthur Music Undergraduate
Ferro Susan Arts & Sciences Undergrad
Foreman James Arts & Sciences Undergrad
Fuller Jason Informatics Undergraduate
Godfrey Shannon Arts & Sciences Undergrad
Goolsby Ora Arts & Sciences Undergrad
Gracia Quimey Bueno Arts & Sciences Undergrad
Hardin Lucien Education Undergraduate
Academic Plan Fees
Geology $36.00
Business $86.00 ======
Business $86.00 ID#AAAAHN3l0Zk
Author (2020-11-08 05:41:45)
Business $86.00 Determine the fees to be paid per student
Health, Phys Ed, & R $58.00 (found in Fees sheet).
Education $74.00
Anthropology $23.00
Communication & Cult $21.00
Law $68.00
Theatre & Drama $64.00
Theatre & Drama $64.00
Biology $27.00
Business $86.00
Music $46.00
Education $74.00
Journalism $81.00
Optometry $75.00
Business $86.00
University Division $34.00
Education $74.00
Apparel Merch/Int De $25.00
East Asian Lang & Cu $58.00
Education $74.00
Health, Phys Ed, & R $58.00
Fine Arts $49.00
Biology $27.00
Journalism $81.00
Education $74.00
Music $46.00
Criminal Justice-Coa $60.00
Biology $27.00
Informatics $85.00
Psychology $24.00
Psychology $24.00
Fine Arts $49.00
Education $74.00
Campus Program Director Fee
Laguna Business Abbott, James $ 86.00
BGC Theatre & Drama Abbott, James $ 64.00
BGC Informatics Adkins, Michael $ 85.00
Quezon City Music Anthony, Robert $ 46.00
Quezon City Apparel Merch/Int De Baker, Barney $ 25.00
Laguna Communication & Cult Ball, Kirk $ 21.00
Laguna University Division Ball, Kirk $ 34.00
Quezon City Dentistry Ballard, Martin $ 72.00
Laguna Near Eastern Lang & Ballard, Martin $ 37.00
Laguna Mathematics Banks, Ryan $ 42.00
BGC Journalism Barton, Barry $ 81.00
Laguna East Asian Lang & Cu Bean, Deborah $ 58.00
Laguna Optometry Bean, Deborah $ 75.00
BGC Geology Bennett, Chris $ 36.00
BGC School Of Continuing Bennett, Chris $ 59.00
BGC Law Booker, Judith $ 68.00
Quezon City Biology Bowen, Kes $ 27.00
Laguna Education Bradley, David $ 74.00
Laguna Political Science Bradley, David $ 20.00
Laguna Fine Arts Brady, Traci $ 49.00
Laguna Public And Envir Aff Brady, Traci $ 35.00
Quezon City English Buchanan, Dennis $ 26.00
BGC Psychology Buchanan, Dennis $ 24.00
Quezon City Criminal Justice-Coa Carr, Susan $ 60.00
Laguna Anthropology Chase, Troy $ 23.00
Laguna Health, Phys Ed, & R Diaz, David $ 58.00
Quezon City Telecommunications Diaz, David $ 41.00