FCR 110 ACTUAL TEST PAPER PREMIUM
SOLVED QUESTIONS FULL SOLUTION
ALREADY PASSED
◉ Hide all of the dependency tracer arrows at once. Answer:
Formulas tab > in the Formula Auditing group, click the Remove
Arrows button
◉ In cell E15, enter a formula to find the lowest line item cost this
month (cells E2:E14).. Answer: Formulas tab > in the Function
Library click the arrow under AutoSum and select MIN, for E2 thru
E14
◉ On the Year1 sheet in cell B8, enter a formula to display the value
of cell B7 from the Salaries sheet.. Answer: select B8, enter = then
select Salaries sheet and then cell B7, press enter
◉ Insert the current date and time in cell A1. Answer: Formulas tab >
in Function Library, select arrow below Date & Time, then select
NOW
◉ In cell D15, enter a formula using a counting function to count the
number of cells in the Billable? column (cells D2:D14) than are not
blank.. Answer: Formulas tab > Function Library, click More
SOLVED QUESTIONS FULL SOLUTION
ALREADY PASSED
◉ Hide all of the dependency tracer arrows at once. Answer:
Formulas tab > in the Formula Auditing group, click the Remove
Arrows button
◉ In cell E15, enter a formula to find the lowest line item cost this
month (cells E2:E14).. Answer: Formulas tab > in the Function
Library click the arrow under AutoSum and select MIN, for E2 thru
E14
◉ On the Year1 sheet in cell B8, enter a formula to display the value
of cell B7 from the Salaries sheet.. Answer: select B8, enter = then
select Salaries sheet and then cell B7, press enter
◉ Insert the current date and time in cell A1. Answer: Formulas tab >
in Function Library, select arrow below Date & Time, then select
NOW
◉ In cell D15, enter a formula using a counting function to count the
number of cells in the Billable? column (cells D2:D14) than are not
blank.. Answer: Formulas tab > Function Library, click More