PART 1
| What is the formula on cell B5 that will allow you to calculate Total Current Assets/Total Current Liabilities? |
| a. =SUM(B1:B3)/B4 |
| b. =(B1+B2+B3)/B3 |
| c. =B1+B2+B3/B4 |
| d. =SUM(B1:B3)/3 |
| e. =SUM(B1:B4)/B4 |
| What is the formula on cell B4 that will allow you to calculate the compound annual stock return from 2004 to 2008? | |
| a. =(E2/A2^1/4)-1 | |
| b. =E3/A3^1/4-1 | |
| c. =(E3/A3)^(1/4)-1 | |
| d. =(E3/(A3^1/4))-1 | |
| e. =(E3/A3)^(1/4)+1 |
| What solution would you get in cell A4? | |
| a. 17.541 | |
| b. -4782.9 | |
| c. 2582.5 | |
| d. -2163.6 | |
| e. -5385.3 |
| What custom category was used to format cell A2 using the data on cell A1? | |
| a. #,##0.00, | |
| b. #,##0.00 | |
| c. #,###.00 | |
| d. #,##0, | |
| e. #,##0 |
| What is the value of cell A4? | |
| a. 20 | |
| b. 33 | |
| c. 18 | |
| d. 35 | |
| e. 13 |
To access towards the answers towards the above questions email : [email protected] or chat with us live.
