FINAL QUIZ

Quiz Summary

0 of 25 Questions completed

Questions:

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 25 Questions answered correctly

Your time:

You have reached 0 of 0 point(s), (0)

Nice attempt! Look at the course material and please try again. You need a minimum of 80% to move on to the next lesson.   You are at the finish line, go for it!
Very well done! Feel free to attempt the quiz again or move on to the next lesson. You conquered the course!
You crushed it!! Congratulations you are a real champ!

Current
Review
Answered
Correct
Incorrect

Question 1 of 25

1. Question
1 point(s)
All the following are classified under liquidity ratios except
- Cash ratio
- Current ratio
- Quick ratio
- Debt Service Coverage Ratio
Correct

Incorrect
Question 2 of 25

2. Question
1 point(s)
Accounts payable are calculated by dividing payable turnover days by 365 days multiplied by __________
- Accounts payable are calculated by dividing payable turnover days by 365 days multiplied by
Correct

Incorrect
Question 3 of 25

3. Question
1 point(s)
Which of the following is not true about using shortcut keys in Excel?
- Press Alt + I + R to insert new row in a worksheet
- Press Ctrl + Spacebar to select an entire column
- Press Ctrl + Pagedown/ Pageup to move between worksheets
- Press Alt + enter to highlight between cells
Correct

Incorrect
Question 4 of 25

4. Question
1 point(s)
If a company has a total current asset at 210,000 naira and total current liabilities at 60,000 naira. What is its working capital?
Correct

Incorrect
Question 5 of 25

5. Question
1 point(s)
_________ is a financial ratio used to measure a company’s ability to pay the interest on its debt.
- Current ratio
- Interest coverage ratio
- Cash ratio
- Liquidity ratio
Correct

Incorrect
Question 6 of 25

6. Question
1 point(s)
The main three components of financial statements are _______
- This response will be awarded full points automatically, but it will be reviewed and possibly adjusted after submission.
Grading can be reviewed and adjusted.

Grading can be reviewed and adjusted.
Question 7 of 25

7. Question
1 point(s)
__________ is a tool of financial modeling that helps an analyst to determine how the values of certain dependent valuables react to the changes in the values of certain independent variables.
- Index
- Sensitivity analysis
- Referencing
- Vlookup
Correct

Incorrect
Question 8 of 25

8. Question
1 point(s)
Sales to Total Asset Ratio is
- Basic asset turnover (BAT)
- Current asset turnover (CAT)
- Total asset turnover (TAT)
- Net asset turnover (NAT)
Correct

Incorrect
Question 9 of 25

9. Question
1 point(s)
Which command is used to know the linked cells attached to an input?
- Trace dependents
- Insert
- Create from selection
- Format control
Correct

Incorrect
Question 10 of 25

10. Question
1 point(s)
In building financial model, what question is most fundamental?
- Decisions of competition
- How the values would be derived
- Understanding the model objectives
- How the portfolio can be diversified
Correct

Incorrect
Question 11 of 25

11. Question
1 point(s)
Which schedule provide financial data on depreciation?
- Fixed assets
- Equity capital
- Working capital balance
Correct

Incorrect
Question 12 of 25

12. Question
1 point(s)
All the following are limitations of the Financial Statement Analysis except
- They are bounded by underlying theories
- Differences in accounting policies/procedures
- Differences in reporting standards (GAAP vs IFRS) across borders
- Unusual or transient events (one-off transactions)
Correct

Incorrect
Question 13 of 25

13. Question
1 point(s)
Use the details below to answer the next few questions

        Capital A and B plc Balance sheet as at the year ended 31st Dec 2021.

                        Assets

Current Assets

Receivables                      $7,000

Cash                                  $12,000

Inventories                        $5,500

Non-Current Assets

Plant and Machinery       $20,000

Liabilities

Current Liabilities

Payables                           $4,000

Financial liabilities            $5,000

Non-Current Liabilities

Deferred tax liabilities        $2,000

Lease liabilities                    $3,500

Equity

Share Capital                     $20,000

Retained Earnings              $10,000

The Quick ratio of Capital A and B plc account is _________
- 1. The Quick ratio of Capital A and B plc account is
Correct

Incorrect
Question 14 of 25

14. Question
1 point(s)
The Cash ratio of Capital A and B plc account is ________
- The Cash ratio of Capital A and B plc account is
Correct

Incorrect
Question 15 of 25

15. Question
1 point(s)
The Debt-to-Equity ratio of Capital A and B plc account is ___________
- The Debt-to-Equity ratio of Capital A and B plc account is
Correct

Incorrect
Question 16 of 25

16. Question
1 point(s)
The total debt ratio of Capital A and B plc account is ___________
- The total debt ratio of Capital A and B plc account is
Correct

Incorrect
Question 17 of 25

17. Question
1 point(s)
A company is well positioned when its Receivable days are ___________ and payables days are _________________
- Higher, lower
- Lower, higher
- Higher, higher
- Lower, lower
Correct

Incorrect
Question 18 of 25

18. Question
1 point(s)
A ratio less than One for a company’s Total Asset Turnover depicts that the company is able to turn over its assets faster.
- True
- False
Correct

Incorrect
Question 19 of 25

19. Question
1 point(s)
Interest coverage ratio is calculated as
- Operating profit/ Interest expense
- EBITDA / Interest expense
- Profit before tax/ Interest expense
- Profit after tax/ Interest expense
Correct

Incorrect
Question 20 of 25

20. Question
1 point(s)
The closing balance of a company’s assets is also known as the Net Book Value
- True
- False
Correct

Incorrect
Question 21 of 25

21. Question
1 point(s)
Depreciation and amortization as a line item on the Fixed asset schedule is linked to which of the following account statements_____________________?
- Depreciation and amortization as a line item on the Fixed asset schedule is linked to which of the following account statements and
Correct

Incorrect
Question 22 of 25

22. Question
1 point(s)
Creating a dynamic chart title can be done with which of the following function
- SUMIF
- Index
- Vlookup
- Create from selection
Correct

Incorrect
Question 23 of 25

23. Question
1 point(s)
Which of these charts is most appropriate for representing margins?
- Line chart
- Pie chart
- Bar chart
- Column chart
Correct

Incorrect
Question 24 of 25

24. Question
1 point(s)
The shortcut for formatting cells is ________________
- Ctrl 1
- Ctrl H
- Ctrl 5
- Ctrl 7
Correct

Incorrect
Question 25 of 25

25. Question
1 point(s)
The shortcut for cell styles is ___________________
- Alt + H+ D
- Alt + H + J
- Alt + C + S
- Ctrl + C + S
Correct

Incorrect

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question

8. Question

9. Question

10. Question

11. Question

12. Question

13. Question

14. Question

15. Question

16. Question

17. Question

18. Question

19. Question

20. Question

21. Question

22. Question

23. Question

24. Question

25. Question