Premium Essay

Haha Blah

In:

Submitted By dcolmen1
Words 461
Pages 2
Specialized Functions

Project Description:
In the following project, you will perform sales analysis, calculate summary data using database functions, and complete an amortization table.

Instructions:
For the purpose of grading the project you are required to perform the following tasks: Step | Instructions | Points Possible | 1 | Download and open the file named exploring_e07_grader_a1.xlsx, and then save the file as e02c1Sales_LastFirst, replacing LastFirst with your name. | 0 | 2 | Click the Sales Data by Agent worksheet and enter a nested function in cell H9 the Bonus column. If the employee is international and sold over $200,000 they receive 5% bonus, all other employees receive 3%. | 10 | 3 | Using the appropriate cell referencing, copy the function down the column. | 7 | 4 | Type Ron in cell B24. | 4 | 5 | Type Q1 in cell B25. | 4 | 6 | Enter a nested function in cell B26 that uses the cells B24 and B25 to return a specific sales record. | 10 | 7 | Click the Individual Awards worksheet and enter conditions in the Criteria Range for international sales reps that made $250,000 or more in sales. | 10 | 8 | Perform an advanced filter based on the criteria range. Set the filter to copy the new data into row 22. | 10 | 9 | Enter a database function to calculate the total number of international sales rep in cell J8. | 12 | 10 | Enter a database function to calculate the highest international sales dollar in cell J9. | 3 | 11 | Click the Acquisition worksheet and then insert a function in cell E2 to calculate the loan amount based on the loan parameters. | 4 | 12 | Enter a formula in cell E3 to calculate the total number of periods. | 2 | 13 | Enter a formula in cell E4 to calculate the periodic monthly rate. | 2 | 14 | Enter a function in cell E5 to calculate the monthly payment. Modify the function to ensure that the result

Similar Documents

Free Essay

Reaction

...naman kasi nakakita ng simpleng lalaki?? Well, I do know a boy which is SIMPLE for me but it is different from the feelings I feel for girls and I don’t exactly know what it is… Hoy!! Don’t be so malisyoso ha?! I’m not boyish nor tomboy!!! Nasabi ko na bang may pagka-man hater ako? Kung hindi pa . . . Pwes! nasabi ko na.. It’s for some reason and you’ll soon find out. Hayyss!! Nose-bleed na itey. I’m being so Ingleshera! Ako nga pala si Princess Mikay L. Ignacio. 14 years old and studying at Wellington High. Wapak! bongga ng school noh? Well, nabiyayaan nga pala ako ng kaalaman sa pagkanta, pagguhit, konting talino(charing) haha!, paggitara and many more. Hindi sa mayabang ako or what, pero Maganda ako, cute at sabihan na nating madaming good personalities. Pero may kaliitan ako at kahit negative to, additional point naman sa pagiging cute ko. Haha! Medyo...

Words: 2406 - Pages: 10

Free Essay

Trnascript Ideas

...*Enters home* Me: MOOOOOMMM I’M HOME! Mum: Really? I would never have guessed(.) So how was school? Me: It was okay(.) Can’t really expect much news from this school. Mum: Well, you’re gonna have to deal with it now// Me: //Acha, acha. Pata hai. Meri ghalti hai ke mein iss school me pas gaye hoon. (Yeah, yeah. I know it’s my fault I’m stuck in this school.) Mum: Firstly don’t talk over me and secondly when I’m talking to you in English then you should reply in English. Me: Okay then(.) Where’s Diya and Ayanna? Mum: It’s a small house(.) Go and find them. Me: Fine. GUYS, WHERE ARE YOU? Diya: Here we are Khushboo di. You okay? Me: Yeah, I’m fine(.) You? Diya: I’m okay(.) Ayanna’s hiding let’s go and find her. Me: Okay. *Finds Ayanna* Ayanna: AAAAAHHHHHHHHHH Mum: Go change your clothes(.) I’m getting your food ready. Me: Okey Dokey Mum: Zara jaldi karlo(.) Khana tyar hai. Hurry up a little(.) Your food’s ready. Me: Acha (Okay) Mum: Khana kane ke baad Diya aur Ayanna ko nahla dena. Zara jaldi. (After eating give your sisters a shower. Hurry up a little.) Me: I don’t want to give them a shower(.) They’re annoying. Mum: Yes, but they’re your sisters so hurry up and do what I said. Me: But// Mum: //No buts(2) Jaldi karo. Me: That’s so not fair. Mum: Life’s not fair so deal with it and hurry the hell up. Me: Fine. Mum: Don’t act like a 2 year old with a tantrum. ...

Words: 672 - Pages: 3

Free Essay

Safasafsf

...Facebook Home 1 Post Account Settings Qianqi Liew Erica Lee Jing Wei Scofield Wang Charles Kang Operation Management Members Events Photos Files Notifications Create Group Search Write Post Add Photo / Video Ask Question Add File Write something... Operation Management Erica Lee uploaded a file. Charles Kang, for this part, the highlighted part is not completed. Need to ask lecturer one. so, i will confirm with u the finalize version. Qianqi Liew pls update this one also.. if u know how to do annual cycle inventory, tell me about it.. Q2.docx Document DownloadPreviewUpload Revision 23 hours ago Comment Seen by everyone View 3 more comments Erica Lee then how should we do Q2? because they call us give recommendation.. recommendation based on Q1 lor.. so, i just take a bit from Q1 and explain 7 hours ago · Like Qianqi Liew Im not sure... Charles Kang what do u think ? 6 hours ago · Like Charles Kang Write a comment... Charles Kang 1st Question - YES, You need to to explore & explain new plans and please do cost comparisons (calculations) for both EG151 & DB032 2nd Question - After analysis pls do specify your recommendation on which is better system for EG151 & DB032 and explain why? From Dr. Affendy on Thursday Comment Seen by everyone Jing Wei ? Whats your question again? 8 November at 09:25 via mobile · Like Qianqi...

Words: 1380 - Pages: 6

Premium Essay

Only Hope

...who will make you happy”, what if the reason why you prefer to be alone is that someone who you want to be with is always ignoring you when you need his help or let say his affection and belongingness is not unto you. What if every time you go for, is just like you’re a wind and crap to that person? How can you stay and find time to reassure that he will give you more time to talk with your problems or flaws either? How should you see yourself to be trapped and when you fall asleep the only thing you can imagine is your already dead without knowing and feel it? Life is really unfair and so ridiculous, you cannot find your way and purpose to anyone’s life and you always rethink of how’s and what’s your purpose in this world might be. Blah Blah Blah!!! People always have different outlooks and positions. Anyway, it’s more on usual ways of expectations and compliments. Ups and downs always find their way to ruin and minimize your dressed feelings and condition. For instance, life is a gift of weaknesses and sober strengths of which God only revel to you the matter...

Words: 8958 - Pages: 36

Free Essay

Nbsb

...Prologue Ako nga Pala si Natasha Julie Ann Cameron.. haba ng name ko noh? Ashie for short, apelyedo ko po ang Cameron :DD NBSB ako, dahil naniniwala ako na sagabal lang sa pag-aaral ang mga lalaki,. I hate guys except for my kuya, blame my father he left us without a trail, iniwan niya kami nila mommy, what is LOve? -for me epal, darating kung saka di pa ako handa. well, kahit NBSB ako may mga manliligaw parin ako, hihihi. pero no luck na ata ngayon, kasi dati pa yun na mga manliligaw... nag sawa na sa kakahintay. kaya ayon, wala na, pero okay lang.. **/if you want to read it on your mobile fone copy paste niyo na lang ‘toh sa notepad. :D sa ibang phone nababasa ‘toh as it. I mean as MC word talaga pero yung iba ebook so you need to cpy paste this pa sa notepad and then saka niyo isend sa cp niyo.. kung myphone gamit niyo you’re lucky enough. copy paste mo lang ‘toh sa notepad and send mo sa cp mo. okay na! kung nokia naman gamit mo, N70 na o-open siya as note.. I don’t know sa ibang model….AT! hindi ko na rin poi to na edit TT^TT, so sorry sa mga wrong spelling,wrong grammar.etc. hope u understand. thanks! :*** Chapter 1 "Natasha! bumaba kana dito kakain na" - mommy "coming right up mom"- me pag baba ko, hmm, mas safe ng idescribe na si mommy ang nag handa ng food namin kahit hindi, >:) "good morning Kuya" –me lagi ko siya ginegreet, kahit di niya ako ginegreet. close kami pero di niya lang type mang bati pag umaga. :D 1 year agwat namin, kaya close. "Ashie...

Words: 71306 - Pages: 286

Free Essay

Gd-Pi

...Hundreds(of(real(personal(accounts(of Group'Discussions'&'Personal'Interviews during(MBA(admissions(to(India’s(best(B9schools Written'by Compiled'by Loads'of'MBA'Aspirants The'PaGaLGuY'MadCapz'Group PaGaLGuY.com Antholo gy Hundreds of real personal accounts of Group Discussions and Personal Interviews during MBA admissions to India’s best business schools. In this edition: The IIMs at Ahmedabad, Bangalore, Calcutta, Lucknow, Indore & Kozhikode. Written by Loads of MBA aspirants Compiled by The PaGaLGuY MadCapz Team PaGaLGuY GD-PI Anthology Copyright © 2011, PaGaLGuY.com All text and content in this document is solely owned by PaGaLGuY.com. Reproduction without permission in any form or means is illegal. Special copy prepared exclusively for mustafa rokerya Get your own Free personalized copy (with your name on it) of this book from http://www.pagalguy.com/books/ What this book is about What is a real IIM interview like? What kind of questions do they ask and what judgments do applicants have to make while answering them? Since 2003, those with real Group Discussion and Personal Interview calls from India’s top bschools have been posting entire and detailed transcripts of their admission interviews immediately after they happen, so that others slotted for later interviews can learn what GDPI is going to be like this year. This book is a collection of dozens of handpicked GDPI experiences from the country’s top bschools during the admission...

Words: 178933 - Pages: 716

Free Essay

Sddfcvhbkml

...Unlucky Cupid ➶ Prologue ★★★ She is smart, HE's intelligent. She's gorgeous, HE's sizzling hot. She's popular, HE has huge resemblance to a world-wide known teen-age superstar. She's snob but somehow nice, while HE is the gentleman every girl will die for. Will rivalry cross their fate? Or Love will play their lives? He was always mistaken for the popular singer, whom She really hates. Will Her high school life end up just like those typical one's? Or will He make the best or even worst out of it? ➶ Chapter 1: Interference /KATHERINE'S PERSPECTIVE First day of school, sigh. Simula na naman ito ng hectic schedule, little time, less fun, and whatsoever bothersome school works. Pero first day of school sometimes is not that bad, kasi usually pupunta ka lang sa unahan at magpapakilala. Orientations, introductions, chit-chats - yeah, that's pretty much it. Kaya on second thought, I'm going to enjoy this first day lalo na dahil makikita ko na ang aking mga hmm, how should I describe my friends? Loud speaker-like? Loquacious? Nah, pero siguro ganyan nga sila - love ko naman. Ew, korni ko.I guess back na kami sa routine namin. Si Lindsay, medyo brat, madaldal (as I've said), okay naman pag dating sa academics, mabait, at sabihin na nating medyo war-freak. Di sya close sa parents nya gawa ng wala lagi sa bahay nila. So ayun, siguro yun ang dahilan kung bakit parang naging "Play Girl" itong si Lindsay, in other way. Hindi naman talaga. Pero all in all she's one of a kind...

Words: 84202 - Pages: 337

Free Essay

Nothing Important to Read : )

...another person. I’ll help him.       I’ll be his tutee. He’ll be my tutor.   Right. We’ll have a tutorial.    A tutorial that will change OUR life.                 And it’s funny how he entitled it with…                       Our Love Tutorial.     Lesson 1   “Ate! Dad! Bilisan niyo! Malalate na ako!”   Ang bagal-bagal nila kumilos. Jusmiyo!   “Eto na!”-Daddy “Bakit ka ba kasi nagmamadali? Eh 8 pa class mo ah? 7 pa lang oh!”   Nagreklamo pa si ate. -_____- Bakit ba? Masama bang pumasok ng maaga? Di naman di ba?   Sumakay na kami sa kotse at si daddy ang nad-drive since nag-leave si Kuya Ronald, yung driver namin.     ^____________________^     Halata bang maganda ang gising ko ngayon? Haha! Ang lapad kaya ng ngiti ko! Excited na kasi akong pumasok eh! After 15 minutes eh nasa tapat na kami ng school....

Words: 18742 - Pages: 75

Free Essay

Powerful Sleep

...Powerful Sleep – Secrets of the Inner Sleep Clock by Kacper M. Postawski, PowerfulSleep.com Copyright © 2004 PowerfulSleep.com All 1 Rights Reserved Powerful Sleep – Secrets of the Inner Sleep Clock by Kacper M. Postawski, PowerfulSleep.com Table of Contents Disclaimer: ________________________________________________________________5 Introduction _______________________________________________________________6 The Popular Myth about Sleeping ________________________________________________ 6 Recent “Eye Opening” Discoveries ________________________________________________ 7 How Much Sleep Do You Really Need? ____________________________________________ 7 The Mystery of Quality Sleep ____________________________________________________ 7 Chapter 1: Sleep Mechanics __________________________________________________9 What is Sleep, and Why Do We Sleep? __________________________________________9 Your Crash Course on Brain Waves ______________________________________________ 9 The 5 Stages of Sleep ___________________________________________________________ 9 Sleep Cycles __________________________________________________________________ 11 How Important is Deep Sleep? __________________________________________________ 13 How Important is REM Sleep? __________________________________________________ 13 So what is Quality Sleep?_______________________________________________________ 14 Chapter 2: The Inner Sleep Clock_____________________________________________15 ...

Words: 26531 - Pages: 107

Premium Essay

When the Moon Howls

...Dad has a new job, which means a new area, a new house and worst of all, a new school. Sadly I finished unpacking yesterday so I'm going to school today, why can't I stay home again? "Scarlet! Come down or you'll miss breakfast!" My mum calls from downstairs; I take one more look at my choice of outfit before going to the kitchen and eating my breakfast. "Where's dad?" I look up at my mum to see her over happy face, how can she be so happy about this? "He's gone to work; a different job means a different schedule." I don't question anymore as I finish my food, kiss my mum and little sister and run out the door. I get to school and head to the principal’s office, the woman at the desk lets me in and the principal stares me down. "Welcome Scarlet, here is you new class schedule, I have also assigned a buddy to help you get around the school." Before I know what's happening I'm out the office and facing a boy a little taller than me. "Hey." Man I'm awkward around new people, he doesn't look up as he whispers a small hello and walks off. I run after him and silently follow into a class room, he sits down and I get the feeling he doesn't like me. Too bad, the only open seat is next to him, I walk over and the teacher starts talking about random stuff. As the teachers going on and on I decide its best to at least have my 'buddy' half like me, so I write a note and slide it over to him, luckily he has a look and writes back. Me: what's your name? Him: Ben, yours? Me: Scarlet...

Words: 64377 - Pages: 258

Free Essay

Hundred in One

...Hundred in one Brief intro: Sabi nga nung mga kaibigan ko dati, masarap daw ang pakiramdam ng sikat. Yung tipong, ikaw yung hinahangaan. Naisip ko naman, lahat naman ng positive side, may kaequal sa negative side. Hindi naman puro maganda ang kinalalabasan. I'm just the girl next door. Well, hindi naman yung literal na meaning. Typical girl kumbaga. Yung mamemeet mo sa pangarawaraw. In short, average lang. Pero may nagsasabi sa akin na hindi raw ako average. Sometimes above or below. Kainis na mga yun!!! Ang lakas ng loob na sabihing above average ako? 4th year high school na nga pala ako. Bagong school. Sa katunayan, hindi naman na talaga bago sa akin ang 'Edison High School.' Nakatira naman na kasi kami dito sa lugar na ito, dati pa. Kaya lang nadestino yung Papa ko sa ibang lugar kaya napilitan kaming lumipat. Pero ngayon, stayput na siya. Hindi na yata namin kailangang lumipat uli. Kaya bumalik na naman ako sa pinanggalingan ko. Makikita ko na naman yung mga naging kaibigan ko dati. I have two brothers. Yung isa mas matanda sa akin, yung isa mas bata. Nagkataon namang yung mas bata sa akin eh ang mortal kong kaaway sa bahay namin! Si Kuya naman, hindi nakatira sa amin dahil college na siya. Bakasyon pa naman. Inienjoy ko pa naman dahil kapag nagpasukan na, magsisimula na ang nightmare. Hindi pa maayos yung bahay namin mula sa pagkakalipat, marami pa kasing hindi nabubuksang kahon. Pero syempre, inuna kong ayusin yung kwarto ko. Aba, yun ang pinakamahalaga...

Words: 82674 - Pages: 331

Free Essay

Mine

...WORKING WHILE IN CLASS MAEVELYN Q. CALAPARDO Submitted to the COLLEGE OF MASS COMMUNICATION University of the Philippines Diliman In partial fulfillment of the requirements For the degree of Bachelor of Arts in Film and Audio-Visual Communication October 2011 WORKING WHILE IN CLASS by MAEVELYN DE QUIROZ CALAPARDO has been accepted for the degree of BA Film and Audio-Visual Communication by Professor Olivia L. Cantor and approved for the University of the Philippines College of Mass Communication by Professor Roland B. Tolentino Dean, College of Mass Communication BIOGRAPHICAL DATA Name Maevelyn de Quiroz Calapardo 4 Toclong 1st - C Imus, Cavite Permanent Address Mobile Number Email Address 0927 412 1288 maevelyn018@yahoo.com Date and Place of Birth July 18, 1988 Mandaluyong City EDUCATION Secondary Level St. Emilene Academe Imus, Cavite Primary Level St. Emilene Academe Imus, Cavite WORK EXPERIENCE Associate Producer / Assistant Camera Person Sa Ilalim ng Tulay, Cinemaone Originals October 2011 Video Editor Talk, Understand, Care: Discipline Without Violence October 2011 Intern, Roadrunner Inc., May-June 2009 PASASALAMAT Ipinararating ang taos pusong pasasalamat sa lahat ng taong sumuporta at gumabay upang maisakatuparan ang proyektong ito. Pasasalamat sa aking mga magulang na sina Mobil at Leny Calapardo para sa pagmamahal at walang sawang pagtitiwala sa aking kakayahan. Sa aking mga kapatid...

Words: 30375 - Pages: 122

Free Essay

Can You Keep a Secret

...Can You Keep A Secret? Sophie Kinsella Contents Acknowledgements One Two Three Four Five Six Seven Eight Nine Ten Eleven Twelve Thirteen Fourteen Fifteen Sixteen Seventeen Eighteen Nineteen Twenty Twenty-one Twenty-two Twenty-three Twenty-four Ttwenty-five Twenty-six Twenty-seven Acknowledgements A big thank you to Mark Hedley, Jenny Bond, Rosie Andrews and Olivia Heywood for all their generous advice. And hugest gratitude as always to Linda Evans, Patrick Plonkington-Smythe, Araminta Whitley and Celia Hayley, my boys and the board. ONE Of course I have secrets. Of course I do. Everyone has a secret. It's completely normal. I'm sure I don't have any more than anybody else. I'm not talking about big, earth-shattering secrets. Not the-president- is-planning-to-bomb-Japan-and-only-Will-Smith-can-save-the-world type secrets. Just normal, everyday little secrets. Like for example, here are a few random secrets of mine, off the top of my head: 1. My Kate Spade bag is a fake. 2. I love sweet sherry, the least cool drink in the universe. 3. I have no idea what NATO stands for. Or even what it is. 4. I weigh 9 stone 3. Not 8 stone 3, like my boyfriend Connor thinks. (Although in my defence, I was planning to go on a diet when I told him that. And to be fair, it is only one number different.) 5. I've always thought Connor looks a bit like Ken. As in Barbie and Ken. 6. Sometimes, when we're right in the middle of passionate sex, I suddenly want to...

Words: 96037 - Pages: 385

Free Essay

Me Before You

...Jojo Moyes a fter you Contents CHAPTER ONE CHAPTER TWO CHAPTER THREE CHAPTER FOUR CHAPTER FIVE CHAPTER SIX CHAPTER SEVEN CHAPTER EIGHT CHAPTER NINE CHAPTER TEN CHAPTER ELEVEN CHAPTER TWELVE CHAPTER THIRTEEN CHAPTER FOURTEEN CHAPTER FIFTEEN CHAPTER SIXTEEN CHAPTER SEVENTEEN CHAPTER EIGHTEEN CHAPTER NINETEEN CHAPTER TWENTY CHAPTER TWENTY-ONE CHAPTER TWENTY-TWO CHAPTER TWENTY-THREE CHAPTER TWENTY-FOUR CHAPTER TWENTY-FIVE CHAPTER TWENTY-SIX CHAPTER TWENTY-SEVEN CHAPTER TWENTY-EIGHT CHAPTER TWENTY-NINE CHAPTER THIRTY ACKNOWLEDGEMENTS FOLLOW PENGUIN For my grandmother, Betty McKee chapter one The big man at the end of the bar is sweating. He holds his head low over his double Scotch, but every few minutes he glances up and out, behind him, towards the door. A fine sheen of perspiration glistens under the strip-lights. He lets out a long, shaky breath, disguised as a sigh, and turns back to his drink. ‘Hey. Excuse me?’ I look up from polishing glasses. ‘Can I get another one here?’ I want to tell him it’s really not a good idea, it won’t help, it might even put him over the limit. But he’s a big guy and it’s fifteen minutes till closing time and, according to company guidelines, I have no reason to tell him no, so I walk over, take his glass and hold it up to the optic. He nods at the bottle. ‘Double,’ he says, and slides a fat hand down his damp face. ‘That’ll be seven pounds twenty, please.’ It’s a quarter to eleven on a Tuesday night and the Shamrock and Clover, East City...

Words: 120665 - Pages: 483