Why Choose Us?
0% AI Guarantee
Human-written only.
24/7 Support
Anytime, anywhere.
Plagiarism Free
100% Original.
Expert Tutors
Masters & PhDs.
100% Confidential
Your privacy matters.
On-Time Delivery
Never miss a deadline.
California State University Los Angeles - BUS 4150 Instructors Manual Problem Set CHAPTER 10: MULTIPLE CHOICE QUESTIONS 1)What is the value of cell B7? a) 1080
California State University Los Angeles - BUS 4150
Instructors Manual Problem Set
CHAPTER 10: MULTIPLE CHOICE QUESTIONS
1)What is the value of cell B7?
a) 1080.50
b) 1050.20
c) 975.34
d) 932.54
e) 837.11
-
a) 1586.8
b) 26.67
c) 13.33
d) 40.00
e) 80.00
-
a) =(B4B6)/(PRICE(B2,B3,B4,B5,B6/B6100,B7,B8)B6)
b) =B4B6/PRICE(B2,B3,B4,B5,B6/B6/100,B7,B8)
c) =B4B6/PRICE(B2,B3,B4,B5,B6/B6100,B7,B8)/100B6
d) =(B4B6)/(PRICE(B2,B3,B4,B5,B6/B6100,B7,B8)/100B6)
e) =B4/PRICE(B2,B3,B4,B5,B6/B6,B7,B8)
- What is the correct formula for B10?
a) =YIELD(B2,B3,B4,B9/10,100,B7,B8)
b) =RATE(YEARFRAC(B2,B3,B8)B7,B4B6/B7,-B9,B6)B7
c) =YIELD(B2,B3,B4,B9/B6100,B6/B6100,B7,B8)
-
- All of the above
- None of the above
- What is the correct formula in cell B10?
a) =YIELD(B1,B2,B4,B9/B5100,B5/B5100,B7,B8)
b) =YIELD(B1,B3,B4,B9/B5100,B6/B5100,B7,B8)
c) =YIELD(B1,B2,B4,B9,B5,B7,B8)
d) =RATE(YEARFRAC(B1,B2,B8)B7,B4B5/B7,-B9,B5)B7
e) =YIELD(B1,B3,B4,B9,B5,B7,B8)
- What is the value of cell B4?
a) 1.28%
b) 1.49%
c) 1.52%
d) 1.64%
e) 1.72%
-
a) 1.28%
b) 1.49%
c) 1.52%
d) 1.64%
a) 1.72%
-
a) =DURATION(B1,B2,B3,B4,B6,B7)
b) =MDURATION(B1,B2,B4,B3,B6,B7)
c) =MDURATION(B1,B2,B3,B4,B6,B7)
-
a) =DISC(B1,B2,B3,B4,0)
b) =DISC(B1,B2,B3,B4,1)
c) =DISC(B1,B2,B3,B4,2)
d) =DISC(B1,B2,B3,B4,3)
e) =DISC(B1,B2,B3,B4,4)
-
b) 1.0
c) 1.5
- 2
- 3
Expert Solution
PFA
Archived Solution
You have full access to this solution. To save a copy with all formatting and attachments, use the button below.
For ready-to-submit work, please order a fresh solution below.
