1. FIN3704-26-S2
2. Assessment 1
QUIZ
Assessment 1
Started on July 2026, 4:43 PM
State Finished
Completed on July 2026, 5:28 PM
Time taken mins 31 secs
Marks 15.00/15.00
Grade 100.00 out of 100.00
Question 1
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Income statement reports
a.
Assets
b.
Liabilities
c.
Profit or loss
d.
Equity only
Feedback
Your answer is correct.
The correct answer is:
Profit or loss
Question 2
Correct
Mark 1.00 out of 1.00
Flag question
Question text
The cash flow statement tracks
a.
Profits
b.
Cash movements
c.
Assets
d.
Equity
,Feedback
Your answer is correct.
The correct answer is:
Cash movements
Question 3
Correct
Mark 1.00 out of 1.00
Flag question
Question text
DEMONSTRATE THE ABILITY TO DESIGN APPROPRIATE PROCEDURES FOR INFORMATION
GATHERING TO ANALYSE FINANCIAL STATEMENTS IN EXCEL.
a.
=Revenue – Expenses
b.
=Expenses – Revenue
c.
=SUM(Revenue)
d.
=AVERAGE(Revenue, Expenses)
Feedback
The correct answer is: =Revenue – Expenses
Question 4
Correct
Mark 1.00 out of 1.00
Flag question
Question text
How can Excel's goal seek feature be used to analyse financial statements?
a.
by creating new financial accounts
b.
by finding the value of a variable that helps in attaining a given financial objective
c.
by presenting financial information
d.
by avoiding errors in calculation
Feedback
The correct answer is: by finding the value of a variable that helps in attaining a given financial
objective
Question 5
Correct
Mark 1.00 out of 1.00
Flag question
Question text
How do you add a new worksheet to an Excel workbook?
a.
Press Ctrl + W
b.
Click the "+" button next to the sheet tabs
c.
Use the Insert function
d.
Press Shift + F3
Feedback
,The correct answer is: Click the "+" button next to the sheet tabs
Question 6
Correct
Mark 1.00 out of 1.00
Flag question
Question text
How do you change the name of a worksheet in Excel?
a.
Double-click on the sheet tab and enter a new name
b.
Right-click on the sheet tab and choose "delete.
c.
Use sort & filter
d.
Use the format painter
Feedback
The correct answer is: Double-click on the sheet tab and enter a new name
Question 7
Correct
Mark 1.00 out of 1.00
Flag question
Question text
How do you quickly go to cell A1 in an Excel worksheet?
a.
Press Ctrl + A
b.
Press Ctrl + Home
c.
Press Ctrl + End
d.
Click on the sheet anywhere
Feedback
The correct answer is: Press Ctrl + Home
Question 8
Correct
Mark 1.00 out of 1.00
Flag question
Question text
How do you select an entire row in Excel?
a.
Click on the row number on the left
b.
Click on any cell in the row and press Ctrl + C
c.
Use the merge & Centre option
d.
Press Shift + Enter
Feedback
The correct answer is: Click on the row number on the left
Question 9
Correct
Mark 1.00 out of 1.00
, Flag question
Question text
How do you select an entire row in Excel?
a.
Click on the row number on the left.
b.
Click on any cell in the row and press Ctrl + C
c.
Use the merge & centre option
d.
Press Shift + Enter
Feedback
The correct answer is: Click on the row number on the left.
Question 10
Correct
Mark 1.00 out of 1.00
Flag question
Question text
How is sensitivity valuable analysis used in capital budgeting?
a.
It determines the exact project cost
b.
It studies the impact of changes in significant assumptions on project results
c.
It forecasts market demand
d.
It eliminates the use of NPV computations
Feedback
The correct answer is: It studies the impact of changes in significant assumptions on project results
Question 11
Correct
Mark 1.00 out of 1.00
Flag question
Question text
If two projects are mutually exclusive, what does it indicate?
a.
Both projects can be chosen
b.
Selecting one project renders it impossible to choose the other
c.
The projects have equal NPV
d.
Both projects must be rejected
Feedback
The correct answer is: Selecting one project renders it impossible to choose the other
Question 12
Correct
Mark 1.00 out of 1.00
Flag question
Question text
In later versions, what is the default file extension for an Excel workbook?
a.
2. Assessment 1
QUIZ
Assessment 1
Started on July 2026, 4:43 PM
State Finished
Completed on July 2026, 5:28 PM
Time taken mins 31 secs
Marks 15.00/15.00
Grade 100.00 out of 100.00
Question 1
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Income statement reports
a.
Assets
b.
Liabilities
c.
Profit or loss
d.
Equity only
Feedback
Your answer is correct.
The correct answer is:
Profit or loss
Question 2
Correct
Mark 1.00 out of 1.00
Flag question
Question text
The cash flow statement tracks
a.
Profits
b.
Cash movements
c.
Assets
d.
Equity
,Feedback
Your answer is correct.
The correct answer is:
Cash movements
Question 3
Correct
Mark 1.00 out of 1.00
Flag question
Question text
DEMONSTRATE THE ABILITY TO DESIGN APPROPRIATE PROCEDURES FOR INFORMATION
GATHERING TO ANALYSE FINANCIAL STATEMENTS IN EXCEL.
a.
=Revenue – Expenses
b.
=Expenses – Revenue
c.
=SUM(Revenue)
d.
=AVERAGE(Revenue, Expenses)
Feedback
The correct answer is: =Revenue – Expenses
Question 4
Correct
Mark 1.00 out of 1.00
Flag question
Question text
How can Excel's goal seek feature be used to analyse financial statements?
a.
by creating new financial accounts
b.
by finding the value of a variable that helps in attaining a given financial objective
c.
by presenting financial information
d.
by avoiding errors in calculation
Feedback
The correct answer is: by finding the value of a variable that helps in attaining a given financial
objective
Question 5
Correct
Mark 1.00 out of 1.00
Flag question
Question text
How do you add a new worksheet to an Excel workbook?
a.
Press Ctrl + W
b.
Click the "+" button next to the sheet tabs
c.
Use the Insert function
d.
Press Shift + F3
Feedback
,The correct answer is: Click the "+" button next to the sheet tabs
Question 6
Correct
Mark 1.00 out of 1.00
Flag question
Question text
How do you change the name of a worksheet in Excel?
a.
Double-click on the sheet tab and enter a new name
b.
Right-click on the sheet tab and choose "delete.
c.
Use sort & filter
d.
Use the format painter
Feedback
The correct answer is: Double-click on the sheet tab and enter a new name
Question 7
Correct
Mark 1.00 out of 1.00
Flag question
Question text
How do you quickly go to cell A1 in an Excel worksheet?
a.
Press Ctrl + A
b.
Press Ctrl + Home
c.
Press Ctrl + End
d.
Click on the sheet anywhere
Feedback
The correct answer is: Press Ctrl + Home
Question 8
Correct
Mark 1.00 out of 1.00
Flag question
Question text
How do you select an entire row in Excel?
a.
Click on the row number on the left
b.
Click on any cell in the row and press Ctrl + C
c.
Use the merge & Centre option
d.
Press Shift + Enter
Feedback
The correct answer is: Click on the row number on the left
Question 9
Correct
Mark 1.00 out of 1.00
, Flag question
Question text
How do you select an entire row in Excel?
a.
Click on the row number on the left.
b.
Click on any cell in the row and press Ctrl + C
c.
Use the merge & centre option
d.
Press Shift + Enter
Feedback
The correct answer is: Click on the row number on the left.
Question 10
Correct
Mark 1.00 out of 1.00
Flag question
Question text
How is sensitivity valuable analysis used in capital budgeting?
a.
It determines the exact project cost
b.
It studies the impact of changes in significant assumptions on project results
c.
It forecasts market demand
d.
It eliminates the use of NPV computations
Feedback
The correct answer is: It studies the impact of changes in significant assumptions on project results
Question 11
Correct
Mark 1.00 out of 1.00
Flag question
Question text
If two projects are mutually exclusive, what does it indicate?
a.
Both projects can be chosen
b.
Selecting one project renders it impossible to choose the other
c.
The projects have equal NPV
d.
Both projects must be rejected
Feedback
The correct answer is: Selecting one project renders it impossible to choose the other
Question 12
Correct
Mark 1.00 out of 1.00
Flag question
Question text
In later versions, what is the default file extension for an Excel workbook?
a.