100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Omis 259 - Chuck Downing with Questions 100% Solved |Latest Update| Verified Answers $12.99   Add to cart

Exam (elaborations)

Omis 259 - Chuck Downing with Questions 100% Solved |Latest Update| Verified Answers

 0 view  0 purchase
  • Course
  • OMIS 259
  • Institution
  • OMIS 259

Omis 259 - Chuck Downing with Questions 100% Solved |Latest Update| Verified Answers

Preview 2 out of 13  pages

  • October 13, 2024
  • 13
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • OMIS 259
  • OMIS 259
avatar-seller
KenAli
Omis 259 - Chuck Downing with
Questions 100% Solved |Latest Update|
Verified Answers

If you don't know how a function in Excel works or which function to use, the best thing(s) to
do is: - ✔ANS Review that function in MyITLab and the ebook Choose "Formulas" / "Insert
Function" and review how the function works and what it needs to work.



What formula needs to be entered into cell D2? - ✔ANS #REF!



What should you do if you are using a Mac and MyITLab is not working well for you, or having
trouble with your laptop in general? - ✔ANS Ask the TA to make your Mac or laptop work
Borrow a PC laptop from BH 205 by giving them your ID Use a Barsema Hall lab PC to complete
your MyITLab work Use a friend or roommate's PC laptop that works to do your MyITLab work



What should be entered in Cell E2? - ✔ANS An =VLOOKUP function



How should the =VLOOKUP function in cell E2 be entered? - ✔ANS #REF!



What's wrong with this VLOOKUP statement for cell T4? =VLOOKUP(S4,V13:W17,2) -
✔ANS There are no absolute references for V13:W17.



What's the formula in cell C9? - ✔ANS #VALUE!



If I could refinance my house at 4%, what would I have to change in the spreadsheet to see
the new numbers. - ✔ANS Only cell A2.

, If it cost (closing costs, etc.) me $3000 to refinance for 4%, is that economically smart over
the long term? - ✔ANS Yes, because I'll save more than $48,000



Given this data, if we want Total Investment, we'll need to - ✔ANS Add a column calculating
and showing total investment



To get revenue, we need to know - ✔ANS How much we make for each plastic
bottle produced



To get profit per month, we need to calculate - ✔ANS Revenue minus total costs



Break-even is... - ✔ANS total investment / profit



You'll never break even if you have... - ✔ANS negative profit per period



I believe my manager will spend almost as much time reviewing the spreadsheets I submit
to him/her as I spent on making them. - ✔ANS Yes No



How do you get (easiest way) the menu to change chart type, format data labels, change
tab colors, etc.? - ✔ANS Right-click with your mouse in the correct area.



How did Dr. Downing just insert the block arrow? - ✔ANS With chart selected, chose
Format tab, Insert Shapes group. With chart selected, chose Design tab, Shapes. Chose Insert
tab, Shapes. Chose Home tab, Insert, Shapes.



To make the numbers larger in the pie chart, Dr. Downing just went to the ______ tab. - ✔ANS
Home.

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller KenAli. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $12.99. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

85169 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$12.99
  • (0)
  Add to cart