0 of 20 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:
0 of 20 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Microsoft Excel package helps one to do the following EXCEPT
Microsoft Excel is a part of the ___________ program
As a tool in the world business, Microsoft Excel has capabilities in all these fields EXCEPT
The intersection of a column and a row in Excel package is called
One of the following is NOT applicable to Financial Accounting in Microsoft Excel
One of the following is NOT applicable to Financial Management in Microsoft Excel
One of the following is NOT a method used in designing an amortization schedule
One of these is NOT a type of cell reference in Microsoft Excel
A group of related data points is called _________
A Cell can contain any of the following types of information EXCEPT
An agency obtained a facility from a commercial bank under the following terms and conditions:
If the principal is entered in cell E2, the formulae to calculate the interest due per month in Excel is:
Mr. Vincent invested ₦2,000,000 on paper manufacturing business with the cost of capital at 10% the project is to last for 3 years with the following cash flows, ₦1,200,000, ₦900,000 & ₦800,000 respectively. The NPV if discount factor is rounded to 4 decimal places using Excel is:
Given that cells A1, A2, A3 and A4 contains the following figures: 500,000; 750,000; 430,000 and 640,000 respectively. Cells B1, B2, B3 and B4 contains 230,000; 410,000; 320,000 and 80,000 respectively.
What is the Excel formula to get the total of Cells A1 to A4?
Given that cells A1, A2, A3 and A4 contains the following figures: 500,000; 750,000; 430,000 and 640,000 respectively. Cells B1, B2, B3 and B4 contains 230,000; 410,000; 320,000 and 80,000 respectively.
What is the Excel formula to get the total of Cells A1 to A4 and B1 to B4?
Given that cells A1, A2, A3 and A4 contains the following figures: 500,000; 750,000; 430,000 and 640,000 respectively. Cells B1, B2, B3 and B4 contains 230,000; 410,000; 320,000 and 80,000 respectively.
What is the Excel formula to get the average of Cells A1 to A4 multiplied by 6?
Given two numbers: A (2000) and B (405), what is the formula to obtain the total?
Given the following range of numbers:
Cell
B1 70
B2 60
B3 80
B4 90
B5 65
State the formula to multiply the sum of the numbers by 4.
Given the following range of numbers:
Cell
A1 30
A2 50
A3 30
A4 80
What is the formula to calculate the average?
The coordinates of the intersecting column and row is
There are ___________ columns, 1,048,576 rows for a total of 17,179,869 cells.