Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN: 9781337508841
Author: Carey
Publisher: Cengage
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
A startup Internet company has generated the following cash balance for the first six years of its IS projects: -$250,000, -$180,000, $225,000, $340,000, $410,000, and $425,000. Using the NPV function in Excel, calculate the net present value of this project at an 8.5 percent interest rate. What is the IRR of this project? If a bank is willing to give the company a loan at 15 percent to implement these projects, should the company accept the loan (assuming there are no other conditions)? Why or why not?
The CTO of the company mentioned in Project 1 has decided to acquire a CASE tool to help expedite and better document the Web site that is being designed for his company’s e-commerce operations. The CTO has narrowed these choices to CA ERwin Process Modeler and Oracle Designer. Based on the information provided in this module and other sources, which tool would you recommend? What are the three major factors behind your recommendation?
The CTO of the company mentioned in Project 1 also…
In G2:G11, the values should evaluate to the surname and the first character of the first name, with some punctuation. For example G2 should evaluate to Johnson R. What function should be used to achieve this?
Choices:
A. CONCATENATE
B. MIN,MAX
C. SEARCH
D. RANK
E. No choice given
TID
items_bought
100
{M, O, N, K, E, Y}
200
{D, O, N, K, E, Y}
300
{M, A, K, E}
400
{M, U, C, K, Y}
500
{C, O, K, I, E}
Which of the following are maximal itemset in the table above, when minsup is 40%?
a. {K, C}
b. {M, K}
c. {O, N, K, Y}
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- The monthly cost of this option can be represented by function c, defined by: C(x)=30×+5, where x is the gigabytes of data used over the monthly allowance.arrow_forwardQ2. Consider the following options for characters in setting a password: Digits = { 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 } Letters = { a, b, c, d, e, f, g, h, i, j, k, l, m, n, o, p, q, r, s, t, u, v, w, x, y, z } Special characters = { *, &, $, # } Compute the number of passwords possible that satisfy these conditions: Password must be of length 8. Characters can be special characters, digits, or letters. The first character must be a letter. Characters may be repeated.arrow_forwardYou have two columns, say Age group in column A and purchase in column B. If either Age group is kid or senior citizen and purchase is more that INR 15000 the purchaser gets 10% discount otherwise only 2% discount shall be given. Which of the following formula is correct? a. if(AND((A1="Kid" OR A1="Senior Citizen"),B1>15000), "12%", "2%") b. if((A1="Kid" AND A1="Senior Citizen") OR B1>15000, 12%, 2%) c. if(AND(OR(A1="Kid",A1="Senior Citizen"),B1>15000), "12%", "2%") d. None of thesearrow_forward
- What is the Big O function for the following growth rate function? F(n) = 1000*n10 + 10*2n Question 11 options: O(2n) O(n10) O(n2) O(n10 + 2n)arrow_forwardClyde Clerk is reviewing his firm’s expense reimbursement policies with the new salesperson, Trav Farr. “Our reimbursement policies depend on the situation. You see, first we determine if it is a local trip. If it is, we only pay mileage of 45 cents a mile. If the trip was a one-day trip, we pay mileage and then check the times of departure and return. To be reimbursed for breakfast, you must leave by 7:00 A.M., lunch by 11:00 A.M., and have dinner by 5:00 P.M. To receive reimbursement for breakfast, you must return later than 10:00 A.M., lunch later than 2:00 P.M., and have dinner by 7:00 P.M. On a trip lasting more than one day, we allow hotel, taxi, and airfare, as well as meal allowances. The same times apply for meal expenses.” Draw a decision tree depicting the reimbursement policy in this Problem using LucidChart or Word documentarrow_forwardA hockey season ticket holder pays $77.52 for her tickets plus $6.00 for a program each game. A second person pays $18.92 for a ticket to every game, but doesn't buy programs. In how many games will they have paid the same amountarrow_forward
- I need help with an Excel Function Formula. Here's the question. In cell F6 enter a formula that will multiply the number of children by the Income Per (Column E). If the number of children is zero (the income isn’t based on a per-child cost), then the formula should return the figure in the Income Per column. D6=Children, E6=Income Per As per the question, I'm assuming that if D6=0 then the answer would be the content in E6 so if D6=0 and E6=110 then the answer would be 110. In the other hand, if D6=9 and E6=220 then the answer is 1980. Am I right? If so, I came up with this formula =IF(D6="0", E6, D6*E6) This works good if the content in D6 is greater than 0 but for some reason if the content is 0 my answer keeps coming up as 0 instead of giving me the content from E6. Help. What am I doing wrong?arrow_forwardLael is always on the lookout for students who might be interested in running for office in student groups.In cell M2, enter a formula using a nested IF function and structured references as follows to determine first if a student has already been elected to office in a student group, and if not, whether that student meets the qualifications to run in the future:a. If the value in the Elected column is equal to the text "Yes", the formula should display Elected as the text.arrow_forward1. Dean wants a quick way to look up staff members by their Staff ID. In cell Q3, nest the existing VLOOKUP function in an IFERROR function. If the VLOOKUP function returns an error result, the text “Invalid Staff ID” should be displayed by the formula. (Hint: You can test that this formula is working by changing the value in cell Q2 to 0, but remember to set the value of cell Q2 back to 1036 when the testing is complete.) Current cell function is =VLOOKUP(Q2,CBFStaff[[Staff ID]:[Name]],2,FALSE) 2. In cell Q4, enter a formula using the VLOOKUP function to display a staff member’s years of service. Look up the staff ID listed in cell Q2. Use a structured reference to retrieve the value in the 4th column of the CBFStaff table. Since the formula is looking for a specific staff member’s data, find an exact match.arrow_forward
- Gotham City National Bank is open Monday through Friday from 9 a.m. to 5 p.m. From past experience, the bank knows that it needs the numbers of tellers listed in the file P04_104.xlsx. Gotham City Bank hires two types of tellers. Full-time tellers work 9 a.m. to 5 p.m. five days per week, with one hour off each day for lunch. The bank determines when a full-time employee takes his or her lunch hour, but each teller must go between 12 p.m. and 1 p.m. or between 1 p.m. and 2 p.m. Full-time employees are paid (including fringe benefits) $15 per hour, which includes payment for lunch hour. The bank can also hire part-time tellers. Each part-time teller must work exactly four consecutive hours each day. A part-time teller is paid $9 per hour and receives no fringe benefits. To maintain adequate quality of service, the bank has decided that, at most, six part-time tellers can be hired. Determine how to meet the bank’s teller requirements at minimum cost.arrow_forwardSuppose we have a nice young couple who borrow $700000 from the bank, at an annual interest rate of3.124%. The mortgage is a 30 year loan, so they need to pay it off within 360 months total. Our happycouple decide to set their monthly mortgage payment at $2000 per month. Will they pay off the loan intime or not?Note that the monthly balance will be calculated asbalance = (im × previous balance) - monthly paymentwhere the convert annual interest to a monthly multiplier im is calculated as im = (1 +i)1/12 and i = annualinterest rate.Write a loop for track the total payment in 360 months so that we can evaluate if the couple can pay off theloan. Write in R Please and thank you.arrow_forwardsuppose that a company offers quantity discounts. if up to 1,000 units are purchased, the unit price is $10, if more than 1,000 and up to 5,000 units are purchased, the unite price is $9, and if more than 5,000 units are purchased, the unit price is $7.50. Develop an excel templete using the VLOOKUP function to find the unite price associated with any order quantity and compute the total cost of the orderarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:CengageProgramming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:Cengage
- Operations Research : Applications and AlgorithmsComputer ScienceISBN:9780534380588Author:Wayne L. WinstonPublisher:Brooks Cole
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Operations Research : Applications and Algorithms
Computer Science
ISBN:9780534380588
Author:Wayne L. Winston
Publisher:Brooks Cole