1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
RSB [31]
3 years ago
7

Display the Approval Form worksheet and create an IF statement in cell B13 to determine if the applicant is eligible for a perso

nal loan. Use the criteria below as part of your logic statement:
Computers and Technology
1 answer:
zhuklara [117]3 years ago
4 0

Excel formulas are expressions used to perform computation.

The Excel formula to enter in cell B13 is =IF(B9 < 600, "Denied","Approved)

From the question, we have:

  • Cell B13 represents the applicant's eligibility status
  • Cell B9 represents the credit score

The eligibility criteria are given as:

  • Credit Score < 600 = “Denied”
  • Credit Score >= 600 = “Approved”

To write the formula, we make use of an IF function

An IF function in Microsoft Office Excel has the following syntax

=IF([condition],[value if true],[value if false]).

So, the required formula to enter in cell B13 is:

=IF(B9 < 600, "Denied","Approved)

Read more about Excel formulas at:

brainly.com/question/25683602

You might be interested in
Naomi wants to search for online courses on web development she types this term in the address bar which browser allows her to u
natka813 [3]
Google Chrome browser
4 0
4 years ago
Consider the scenario below. Will the solution attempted by the technician fix the problem or make it worse? Defend your answer.
vampirchik [111]

1. At Work--and at Play

At the 2005 E3 trade show, the big news was the extreme capabilities of the next Xbox and PlayStation consoles--these machines will more closely resemble home media computers rather than game devices. And with flat-screen monitors that double as TVs and cell phones that double as PDAs and MP3 players, the convergence of tech for work and play may reach a crescendo in the next few years.

What does this mean for your business? Maybe you'll return to the heady dotcom days and offer your employees a game console for break times. After all, you can also use it to play back video and digital photos in meetings. And a cell phone that plays music could be handy in traffic, but one that plays MP3s of the latest business audio book can also keep you informed on the go. So don't pooh-pooh the latest consumer devices as having no potential for business use--with a little imagination, you can mix business and fun.

2. Prepare to Get Mini

The mini computer packs a full-fledged PC into a package the size of a laptop battery, and can be used at your desk or as a portable computer--they're smaller than the slimmest laptops, and they don't have the limited capability of a PDA. And they come equipped with all processing power, memory and ports you'd expect in a regular computer, minus the bulk and weight. Some have docking cradles and can be used as tablets, while others feature slide out screens, but they're all small enough to be able to slip into a purse or pocket. Unfortunately, they're still cost prohibitive: A mini PC can cost as much as $4,000, whereas a regular computer with the same processing power can be purchased for less than $500. At this point, mini PCs are really a fashion statement for the ultimate early adopter, but keep your eyes peeled because once prices drop, they could change the way that everyone does business out of the office.

3. Next Gen Cell Phones

3G, or third-generation, cell phone networks are popping up all across the country. And they're not just for making phone calls. Current releases offer a variety of capabilities, including on-demand video services that let you watch streaming video clips on your phone, built-in camcorders that record video, still cameras to snap pix, MP3 players to play your favorite music, and mini SD cards, Memory Sticks or Multimedia Memory Cards to save and transfer it all between devices. 3G Smartphones sport mini keyboards to save your thumb from cramping up during marathon text message sessions, feature Windows Mobile OS and can be Bluetooth or Wi-Fi-enabled. GPS-equipped cell phones also just made their debut. Use them to get driving directions while on the road or to keep track of employees.

4. Inventory Gets Smart

Radio Frequency Identification (RFID) embeds tiny data-packed radio transceiver chips into all kinds of goods and containers. Like a talking bar code, an RFID chip can talk to a scanner several feet away and tell it far more than a printed label, even from inside an unopened carton. The technology has been around for decades, but has only recently come into use. The Department of Defense and Wal-Mart are already taking advantage of RFID. Once pricing gets friendlier and some standards are worked out, the technology will trickle down to smaller retailers and businesses.

"When transportation companies begin reading carton and pallet tags as shipments are loaded, transferred and delivered, this could provide smaller retailers with the same level of tracking that UPS and FedEx provide," says Bert Moore, director of IDAT Consulting and Education, a Pittsburgh technology consulting firm. "Better tracking will allow managers to better schedule work flow and inventory."

3 0
3 years ago
Search engines use indexes created by web _________ to provide fast searches.
Nastasia [14]
Search engines use indexes created by web crawlers to provide fast searches.
3 0
3 years ago
Should spreadsheets be used to maintain a checkbook?<br> YES<br><br> NO
algol [13]

Yes, because it keeps all your data organized and allows you to see the trend and growth of your data by automatically creating different types of charts and graphs to help you visualize your data.

Hope that helps!

7 0
2 years ago
DRU is a small brokerage house that enables its clients to buy and sell
Rudik [331]

The complete question rather reads;

DRU is a small brokerage house that enables its clients to buy and sell

stocks over the Internet, as well as place traditional orders by phone or Fax. DRU has just decided to install a new e-mail package. One vendor offering an SMTP-based two-tier client-server architecture. The second vendor is offering a Web-based e-mail architecture. DRU doesn't understand either one but thanks the Web-based one should be better because, in their words, "the Web is the future".

<u>(a) Briefly explain to DRU management, in layperson's terms, the difference between the two.</u>

<u>(b) Outline the pros and cons of the two alternatives and </u>

<u>(c) Recommend to DRU about which is better</u>

<u>Explanation:</u>

a) SMTP stands for Simple Mail Transfer Protocol. Thus, put simply an SMTP-based two-tier client-server architecture is a package that involves using a client-server provider like Outlook. This implies that Outlook provides the client with his own unique PO Box (server) so to speak.

While the Web-based e-mail architecture enables the DRU access to online mail platforms like G-mail with little server customisation features.

b. The Web-based e-mail architecture is good for personal email activities because of its ease of operation, however, it does not provide top security and customisation features. While an SMTP-based two-tier client-server architecture allows for unique server customisation with added security features as well be suitable for larger organisational work. Although a disadvantage is that it may cost more and quite a complex process to learn.

c) Since DRU is a growing firm the SMTP-based two-tier client-server architecture would be recommended as this would provide it will efficient customer service delivery.

6 0
3 years ago
Other questions:
  • When a chart is inserted into a Word document, it displays
    15·2 answers
  • A blank is a link on a web page that leads to another web page.
    14·1 answer
  • What is the purpose for adding images and graphics to a web page?
    5·1 answer
  • The local emergency manager has the responsibility for coordinating emergency management programs and activities. A local emerge
    7·1 answer
  • Which of the following modes of replication requires a very low latency network connection and ensures data remains in synch wit
    13·1 answer
  • What is the most likely result of a correctly installed processor, but an incorrectly installed cooler?
    6·1 answer
  • To specify AutoCorrect rules and exceptions to the rules, click File to open the Backstage view, click ____ , and then click Pro
    6·1 answer
  • "Jan23" can be stored using which data type? O an alphanumeric string O a boolean operator o characters floating point numbers​
    13·2 answers
  • Does anybody know how to fix my Minecraft??? My character isn’t loading and realms aren’t working?? Look at the picture!
    5·1 answer
  • 1. What are the process involved in data processing cycle?​
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!