Exam (elaborations)
BITM 215 Questions &Exam (elaborations) answers 100% satisfaction guarantee
- Course
- Institution
BITM 215 Questions &Exam (elaborations) answers 100% satisfaction guarantee
[Show more]
Content preview
BITM 215Insert a function in cell B2 to display the current date from your system. - ✔✔Formulas - Date and
Time - TODAY - Press Ok
With cell B2 selected, set the width of column B to AutoFit. - ✔✔Home - Format - Auto Fit Column
%
Width
Insert a VLOOKUP function in cell C5 to display the ring cost for the first student. The cost of the ring
type should be an exact match. Use appropriate relative and absolute cell references. - ✔✔Formula -
Lookup & References - VLOOKUP
Lookup_Value - Click first student ring type
0
Table_Array - A16:B19 then click and choose F4 for the addition of a $
Col_index_num - 2
Range_Lookup - FALSE
Apply Accounting number format to the range C5:C11 - ✔✔Click the %
0
Insert an IF function in cell E5 to calculate the total due. If the student has chosen to personalize the
ring, there is an additional charge of 5% located in cell B21 that must be added to the cost of the ring;
if not, the student only pays the base price. Use appropriate relative and absolute cell references. -
1
✔✔Formula - Logical - IF
Logical_test - Specific Cell(D5) = "Yes"
Value_if_true - C5 + (C5*B21) (click specific cells) Highlight B21 and click F4
Value_if_false - C5
Insert a function in cell G5 to calculate the first student's monthly payment, using appropriate relative
and absolute cell references. Ensure the result is a positive number. - ✔✔Formula - Financial - PMT
Rate - Click B22 then F4 divide by 12 (cause of monthly payment)
Nper - F5*12
Pv - Insert a neg sign [ - ] then click E5
Then pick Ok
Calculate totals in cells C12, E12, and G12. - ✔✔Click the three columns then AutoSum (E looking
symbol)
Set 0.3" left and right margins and ensure the page prints on only one page. - ✔✔Page Layout -
Margin - Custom Margin
The benefits of buying summaries with Stuvia:
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
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
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 EXAMQA. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
83662 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now