Employees at the Red Bluff Golf Club & Pro Shop have the opportunity to become certified trainers if they log enough hours. Aleeta would like to know which of her employees are certified. On the EmployeeAnalysis worksheet, in cell D5, enter a function that will return the text Certified if the number of training hours completed is 50 or more, otherwise return the text Not Certified. AutoFill the function down through cell D9. Club members get a 10% discount off all items in the Pro Shop. Aleeta wants to keep track of these discounts. On the Transactions worksheet, in cell I10, enter a function that will return 0.07 if the customer is a member, otherwise return a blank value (""). Use the fill handle to copy the formula down through cell I30.

Answers

Answer 1

Answer:

Following are the solution to this question:

Explanation:

Some of the data is missing in the question, which is defined in the attached file. Please find it.

Follows are the formula which is used in the question:

EmployeeAnalysis Worksheet IF(C5>49,"Certified","Not Certified") Transactions Worksheet IF(F10="No","",0.07)

In the first condition, it checks "C5" is greater than 49 if the condition is true, it will give "Certified" otherwise, it will give "Not Certified".

In the second condition, it checks "F10" is equal to "No" if the condition is true, it will give a blank or space otherwise, it will give "0.07".

Employees At The Red Bluff Golf Club & Pro Shop Have The Opportunity To Become Certified Trainers

Related Questions

Dave is a website administrator and manages several websites and a couple of blogs. One of his primary concerns is secure data transfer. Which telecommunication component can help Dave and other users to encrypt data?

Answers

Answer: C:Control Software

Explanation: The test said so

On the Cities worksheet, click cell F13. The lodging is based on a multiplier by City Type. Some cities are more expensive than others. Insert a VLOOKUP function that looks up the City Type (B13), compares it to the City/COL range (A7:B10), and returns the COL percentage. Then multiply the result of the lookup function by the Total Base Lodging (B5) to get the estimated lodging for the first city. Copy the function from cell F13 and use the Paste Formulas option to copy the function to the range F14:F18 without removing the border in cell F18.

Answers

Answer:

I have found and attached a spreadsheet (cities.xlsx) that matches this question.

First we remember the VLOOKUP sintax:

=VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

We need to look up the City Type (B13),

compare it to the City/COL range (A7:B10),

and return the COL percentage (2nd column of City/COL)

so the VLOOKUP function on cell F13 has to be:

=VLOOKUP(B13,$A$7:$B$10,2)

Next, to multiply the result by the Total Base Lodging (B5):

=VLOOKUP(B13,$A$7:$B$10,2) *$B$5

Finally que copy the formula to the F14:F18 cells

Notice the use of $  to make cells static and avoid errors while copying the formulas to different cells.

I have attached the completed spreadsheet as "cities final.xlsx"

guys my (R) key just bwoke and I have to copy and paste it every time I want to use it so now I'm talking in this nasty UwU voice... like the wide is every long and wuff like I can't evennnnn ahAHHAHAAAHAhahaHHAHh help please I don't know what to dooooooo like I can't even spell my own name like who am I now audwee

Answers

Answer:

Copy (Ctrl+c) Paste (Ctrl+v) Cant you click the rubber thing under the key you broke hoped i helped

Explanation:

Answer: then use a new keyboard or suffer with the UwU WHatS tHiS

Explanation:

this device can be used to type documents,send email,browse the internet,handle the spreadsheets,do presentations,play games,and more?​

Answers

Answer:

im pretty a computer

Explanation:

A computer is an electronic device that manipulates information, or data. It has the ability to store, retrieve, and process data. You may already know that you can use a computer to type documents, send email, play games, and browse the Web.

Which stage best represents the developing of documents that provides the basis for acquiring the resources and for developing a requirements document?

Design
Implementation
Planning
Development

Answers

Answer:

The answer to this question is given below in the explanation section.

Explanation:

The correct answer to this question is the planning stage. Because the planning stage represents the development of documents that provide the basis for acquiring the resources and for developing the requirement document. at this stage, you plan about what you are going to develop and how to develop it. At this stage, you come out mainly with two documents i.e. project proposal and requirement document.

Other options are not correct because:

In the project management, after planning, you will start designing the product, and after designing you start developing the product, and at the implementation stage, you implement or deploy the product to the customer or to the client. The requirement document that is developed at the planning stage can be used in the later stages of the project.

Help ASAP!!Choose all the basic elements of algorithms. A.Selection B.Loops C.Flow Charts D.Sequencing E.Combinations F.Iteration

Answers

Answer:

b c d

Explanation:

Answer:

A, C, E, F

Explanation:

Just took the test

How would you declare a variable x of type double and set it equal to 25.25? In JAVA

Answers

In java, you have to use the double keyword.

double x = 25.25;

You have to end the statement with a semi-colon. I hope this helps!

What is the purpose of a computer toolbar?

A. To alphabetize programs
B. To hold frequently used icons
C. To organize files
D. To view all files in the computer

Answers

Answer:

B

Explanation:

In computer interface design, a toolbar (originally known as ribbon) is a graphical control element on which on-screen buttons, icons, menus, or other input or output elements are placed. Toolbars are seen in many types of software such as office suites, graphics editors and web browsers.

The purpose of a computer toolbar is to hold frequently used icons. The correct option is B.

What is toolbar?

A Toolbar is a group of buttons or icons which are the integral part of the window or any software program's interface. Toolbar of the software program's interface has all commands under the menu bar.

In the computer interface, a toolbar has on-screen buttons, icons, menus. Toolbars are available in office suites, graphics editors and web browsers.

Thus, the purpose of a computer toolbar is to hold frequently used icons. The correct option is B.

Learn more about toolbar.

https://brainly.com/question/11496721

#SPJ2

What file format is used to help prevent other people from editing a final document?
RTF
TXT
PDF
PWP

Answers

Answer:

The answer to this question is given below in the explanation section.

Explanation:

The correct answer to this question is PDF.

Because PDF file format does not allow you to edit something in it. It prevenst others from editing in it. In a PDF file, you cannot add text, pictures, etc as like in a word document.

Why other options are not correct.

In RTF (rich text format) and TXT file format, you can easily edit the content in these file formats. Furthermore, RWP  files are the storage of the contents of these RapidWeaver websites. All the website contents are saved using this format that includes information about images, pages and style sheets, etc, and information in it can be easily editable.

Edhesive 1.7 Data Types and Variables.
How do I do this correctly

Noun= input (“Enter a noun”)
adjective = input(“Enter an adjective:”)
Print (“the” +noun “is” + adjective)

Answers

Here's how I would do it in python 3+

noun = input("Enter a noun: ")

adjective = input("Enter an adjective: ")

print(f"The {noun} is {adjective}")

I hope this helps!

I WILL GIVE BRAINLIEST TO WHO ANSWERS FIRST AND CORRECTLY.
All slides in a presentation must use the same transition.

True
False

Answers

Answer:

true

Explanation:

The answer is true good luck

I WILL GIVE BRAINLIEST TO WHO ANSWERS FIRST AND CORRECTLY.
How do you add text to a blank slide layout?

Select text from the Insert menu.
Click in the Task Pane and insert text.
You can't add text to a blank slide layout.
Draw a text box and enter text.

Answers

\The answer is B; Draw a text box and enter text

By default, we add text to a PowerPoint slide by typing it directly into a placeholder. However, you can use a text box to enter text into a blank slide or outside the placeholders. To add text on a blank slide click on the insert menu and select the Text box option. Click and hold down your mouse button while you drag the mouse. You will then clink inside the text box and starting typing.

Which statement best explains the purpose of using online note-taking tools?

Online note-taking tools guarantee better scores on tests.
Online note-taking tools let students take notes quickly and easily.
Online note-taking tools tell students exactly what they need to study.
Online note-taking tools turn disorganized notes into organized notes.

Answers

Answer:

B

i did the instruction

Explanation:

The statement which best explains the purpose of using online note-taking tools is that Online note-taking tools let students take notes quickly and easily. Thus, the correct option for this question is B.

What is an online note-taking tool?

An online note-taking tool may be characterized as a type of software tool that significantly allows users to capture, store, and manage voice and text notes on different devices.

It makes note-taking convenient and accessible and allows you to write and study flexibly. Unlike other note-taking apps, you can view documents and take notes at the same time on one screen.

The primary purpose of note-taking is to encourage active learning and to prepare study materials for exams. Developing note-taking skills should help you organize information into an understandable format that will assist in your studying process.

Therefore, the correct option for this question is B.

To learn more about Note-taking tools, refer to the link:

https://brainly.com/question/18546670

#SPJ2

URGENT PLEASE HELP!!!!!
Which rule of composition gives an illusion of movement or context?
A. the rule of odds
B. the rule of three
C. the rule of space
D. simplification

Answers

Answer:

Answer:

C. the rule of space

Answer:

The answer is NOT D. simplification. I took the test and got this wrong, my next guess of what it could be would be C. the rule of space.

I hope that this was helpful to you! :)

Why do filmmakers release trailers?

A. To arouse interest in viewers

B. To compete with other filmmakers

C. To dramatically announce the film’s release date

D. To see how the movie looks on the big screen

Answers

I believe the answer is to arouse interest in viewers (A) so more people can get the idea of the film and want to watch it

Which symbol is at the beginning and end of a multiline comment block? &&& """ %%% ###

Answers

Answer:

#

Explanation:

I have notes on it we learned it in 8th

###

the other guy was correct.

What are the key ideas in dealing with a superior?


respect and ethics

respect and understanding

respect and timeliness

respect and communication

Answers

Respect is a key requirement for a healthy work environment. It promotes teamwork and increases productivity and efficiencies in the workplace. It lets employees know they are valued for their abilities, qualities and achievements, and that their role is important to their company's success.

Answer:

respect and ethics

Explanation:

brainliest Will be given​

Answers

A (I am pretty sure)

Which is the faster cpu and why?

Answers

Answer:

Core i7 unlocked

Explanation:

This is known to not only be faster but also more stable.

Answer:

Intel Core i7 Unlocked has more GHz (gigahertz) along with an Octa core.

Explanation:

More gigahertz means your CPU would run all applications at a faster speed and be more efficient. Not only that, an octa core is much more efficient than a quad core. (Octa meaning 8 while Quad being 4).  

Lisa intends to use the Hide command on a column in her spreadsheet. How are the cells in this column affected by this command?
A) The data in all of the cells is deleted.
B) The data in only some of the cells is deleted.
C) The cells can no longer be referenced in functions or formulas.
D) The cells can still be referenced in functions or formulas.

Answers

Answer:

D

Explanation:

Answer:

D Because it's all about the functions

A publication created by a business or individual that is distributed on a regular basis - Weekly, monthly, or quarterly. Used to
provide informational updates to a specific club, group, organization, agency, or business

Answers

Newsletter

Hope this helps!

I WILL GIVE BRAINLIEST TO WHO ANSWERS FIRST AND CORRECTLY.
select all that apply
What guidelines should you follow when adding graphics to your presentations?

They should be used to make a bad presentation better.
Graphics should appear on each slide.
Graphics should only be used when they improve the communication.
Their size should be appropriate for viewing by your audience.
They should be relevant and appropriate to the content.

Answers

Answer:

the third and the last one

What is the term used to describe the basic unit of data passed from one computer to another?

message

packet

package

transmission

Answers

Answer:

transmission

Explanation:

The most common cause of foodborne illness is

Answers

Answer:

Food posioning

Explanation:

According to the Food and Drugs Administration (FDA), the most common cause of foodborne illness is food poisoning.

What is a foodborne illness?

A foodborne illness can be defined as a type of disease that is generally caused due to the consumption of a contaminated food or any food material that has been poisoned.

According to the Food and Drugs Administration (FDA), the most common cause of foodborne illness around the world is food poisoning such as when bacteria and other pathogens grow on a food.

Read more on food poisoning here: https://brainly.com/question/27128518

#SPJ2

the hardware device that allows the user to see the results after processing is the monitor,scanner,webcam,Camara​

Answers

Answer:hey

Explanation:

A device is one that is an external device and includes Printer, monitor, keyboard, and scanner. The input device includes the mouse and other point devices.

The camera is also an input device, a web-cam is a external device. The external device that lets the user see the output or the result on the screen is monitor.

Hence the option A is correct.

Learn more about the device that allows the user to see the results.

brainly.com/question/25756373.

I really need help to answer all these questions if you could like answer thee on a docs then upload it on the site
plz do so xoxoxox

Answers

Answer:

Gossip

Explanation:

Hugs and kisses

Search engines are used to find a specific entry in a database.

True or false?

Answers

True true true true I think

Answer:

True

Explanation:

My answer is true no explanation but i think its trueeeeeee

What is the special set of characters that indicates the start and end of an HTML element and that element's type?

Answers

the answer is HTML Tag

The HTML tag ..........

Select the five factors measured in the big five personality test.

A-extraversion

B-passivity

C-neuroticism

D-Openness

E-passion

F-energy

G-agreeableness

H-Conscientiousness​

Answers

the answers are:

- a. extraversion

- c. neuroticism

- d. openness

- g. agreeableness

- h. conscientiousness

The five factors measured in the big five personality test are extraversion, neuroticism, openness, agreeableness, and conscientiousness. The correct options are a, c, d, g, and h.

What is personality test?

A person's motives, preferences, interests, emotional makeup, and manner of interacting with others and situations are all subjected to a series of questions on personality tests.

A wide range of personality tests are now used, and many of them are based on particular theories or systems of personality.

Personality tests are frequently used in business to evaluate potential hires and assist in forming cohesive teams, as well as in psychology to help clarify diagnoses.

They can also assist people in realizing their talents and limitations so they can develop into their best selves.

The Big Five Personality Test measures extraversion, neuroticism, openness, agreeableness, and conscientiousness as its five main personality traits.

Thus, the correct options are a, c, d, g, and h.

For more details regarding personality test, visit:

https://brainly.com/question/8789865

#SPJ2

so can u please follow my new ig acc i just started it yesterday its called stunnerspamz

Answers

Answer:

why are you advertising in brainly?????

Ohhhhhhhh okay uh sure
Other Questions
PLEASE HELP PLEASE!!Complete the following statement to estimate the root of 75 to the nearest tenth. Use numbers that are closest to the root of 75 Three times two less than a number is greater than or equal to five times the number. Find all of the numbers that satisfy the given conditions.Let n = a number. Choose the inequality that represents the given relationship. I need help filling in the blanks! What happened to John Smith on his way to Jamestown? 4(8-6)+2(4+8)Solve? Over the past few years, there has been a strong positive correlation between the annual consumption of diet soda drinks and the number of traffic accidents.(a) Do you think increasing consumption of diet soda drinks causes traffic accidents? Explain your answer.No. A strong correlation implies causation.No. A strong correlation does not imply causation. Yes. A strong correlation does not imply causation.Yes. A strong correlation implies causation.(b) What lurking variables might be causing the increase in one or both of the variables? Explain your answer. can tone and mood word be the same? why or why not? Which of the following is most likely course the liquid in tube A to rise 9Select the correct answer.Which of the following is a medicine that stimulates the body's immune response to make disease-fighting molecules to attack a specific pathogen?A. analgesicB. antibioticC. antitoxinReset NextPost Test: Substance Abuse 2020 Edmentum. All rights reserved. When two countries must rely on each other to obtain the products they need, they are best described as economically __________. A. intermodal B. Westernized C. interdependent D. developed Please select the best answer from the choices provided A B C D Which would increase the speed of a sound wave?O A wave passes from a solid to a liquid while remaining the same temperature.The medium increases in temperature while remaining in the same phase.The medium decreases in temperature while remaining in the same phase.O A wave passes from a liquid to a gas while remaining the same temperature. Rewriting linear equation in standard form (Ax+By=C) Three people are traveling and need to exchange the currency of their native countryfor the currency of the country they are visiting. Drag each exchange to the categorythat shows the ratio of currencies in that exchange.CLEARU.S. Currency Foreign(in dollars) Currency25.0015.75U.S. Currency(in dollars)73.00ForeignCurrency81.03U.S. Currency(in fllars)20.00ForeignCurrency22.20U.S. Currency Foreign(in dollars) Currency30.00 21.90U.S. Currencyin dollars)50.00ForeignCurrency36.501 U.S. dollar per 1.1172 dollarAustralian dollartban Between which pair of numbers is the of exact product 379 and 8 Pls pls Pls pls Pls Pls help me pls pls pls pls pls pls ASAP pls pls pls Pls pls Pls pls Pls Pls help me pls pls pls pls pls pls ASAP pls pls pls I WILLLL GIVVVE BRAINLIEST!!!!! If m(x) = 4(x - 2), find m(-5) music lessons cost $20 per week how much do 6weeks of lessons cost A taco stand sells tacos for $3.50 each. The stand's expenses for the day are$180. How many tacos do they need to sell in a day in order to make a profit?Write and solve an equation. What branch of government has been instrumental in determining Oklahoma's borders?JudicialExecutiveLegislativeAll branches have had a role. HELP ASAP!!!!How often should you get routine checkups at the doctor? Once annually Twice a year Three times a year Four times a year