EXCEL 4

Question 1: The name Rate has been given to cell B1. Cell B4 contains the formula =$A4*Rate. If you copy this formula to C4, what will be the outcome?

• 0

• 135

• 1522.5

• 1350

Which function from the below options will get us the last name in both the cells when dragged after entering in cell B2 to B3?

• =RIGHT(A2,LEN(A2)-SEARCH(" ",A2))

• =LEFT(A2,SEARCH(" ",A2)-1)

• =RIGHT(A2,SEARCH(" ",A2)-1)

• =LEFT(A2,LEN(A2)-SEARCH(" ",A2))

I entered a date in cell B4 and I need to replace the value in that cell with 10.5 (to be used in the calculation) and have it displayed as “10.5” (without the quotes) how can I do this?

• I should change the formatting of the cell to Number

• First I should delete the date with the delete key

• I can only enter a date in cell B4, not any other type of value

• I should press the space-bar before entering the value 10.5

Expecting cell A1 is showing the number "14000.7489". What function ought to be utilized to round this number to the nearest integer?

• =ROUND(A1,0)

• =MROUND(A1,100)

• =MROUND(A1,10)

• =ROUND(A1,1

Assume an organization expected that its income should be $180,000 for 2014-2018. What function ought to be entered in cell E6 so it shows income in 2016 if it was above budget, else it'll display 0?

• =IF(E2<$B$6,E2,0)

• = IF(E2<$B$6,0,E2)

• =IF(E2>$B$6,0,E2)

• =IF(E2>$B$6,E2,0)

You entered below formula in cell E3 =VLOOKUP(2000,A2:C9,2,TRUE). What will be the outcome?

• Alameda

• #N/A

• Phoenix

• Antioch

What would be the result of this function shown in the image?

• 18.500%

• 17.5000%

• 4.340%

• 2.770%

Which formula should be entered in cell G2 to generate a dynamic date that displays the last day of each month?

• =EOMONTH($B$2,B1)

• =EOMONTH($B$2,G1)

• =EOMONTH($B$2,C1)

• =MONTH($G$2)

Which of the following is the correct formula to calculate the weighted average score in cell C8 as shown below?

• =AVERAGE(B2:B4)

• =SUMPRODUCT(C2:C4,B2:B4)

• =SUMPRODUCT(C2:C5,B2:B5)

• =AVERAGE(C2:C4)

Company A is looking at 4 possible activities and will accept them if the IRR is 10% or above, as appeared in cell E2. What is the formula utilized in cell C2, which can also be copied down to cell C3 through C5, to produce the required results?

• =IF(B2>=$E$2,"Accept","Reject")

• =IF(B2>=E2,"Accept","Reject")

• =IF(B2>=$E2,"Accept","Reject")

• =IF(B2>=E$2,"Accept""Reject")