Free Excel Basic and Advance Questions and Answers

Question 1

What key combination on the keyboard locks cell references in a formula?

Accepted Answer

F4

Answer

CTRL

Answer

ALT

Answer

F2

Question 2

What are the AutoSum shortcut keys?

Accepted Answer

ALT and =

Answer

ALT and S

Answer

CTRL and S

Answer

CTRL and =

Question 3

Which of the following represents the weighted average score calculation algorithm for cell C8 as shown below?

Accepted Answer

=SUMPRODUCT(C2:C4,B2:B4)

Answer

=SUMPRODUCT(C2:C5,B2:B5)

Answer

=AVERAGE(C2:C4)

Answer

=AVERAGE(B2:B4)

Question 4

As indicated in column E2, Company A is considering four possible projects and will approve them if the IRR is 10% or above. What is the formula in cell C2 that produces the outcomes displayed below and can be duplicated down to cells C3 through C5?

Accepted Answer

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

Answer

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

Answer

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

Answer

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

Question 5

What are the short cuts in an Excel spreadsheet to add a new row?

Accepted Answer

ALT + H + I + R

Answer

ALT + H + I + C

Answer

ALT + H + I + S

Answer

ALT + H + I + I

Question 6

What shortcut keys can you use to quickly aggregate rows so you may enlarge or reduce an area of data?

Accepted Answer

ALT + A + G + G

Answer

ALT + A + W + G

Answer

ALT + A + U + U

Answer

ALT + A + B

Question 7

Which one of the aforementioned Excel capabilities enables you to select/highlight every cell that contains a formula?

Accepted Answer

Go To Special

Answer

Replace

Answer

Find

Answer

Go To

Question 8

What equation needs to be typed into cell A3 in order to reflect the outcomes as displayed below?

Accepted Answer

="Income Statement "&A1

Answer

="Income Statement"&A1

Answer

="Income Statement "&"A1"

Answer

="Income Statement "+A1

Question 9

How can a dynamic date that displays the final day of each month be created in cell G2?

Accepted Answer

=EOMONTH($B$2,G1)

Answer

=EOMONTH($B$2,B1)

Answer

=MONTH($G$2)

Answer

=EOMONTH($B$2,C1)

Question 10

What distinguishes the keyboard shortcuts for pasting?

Accepted Answer

ALT + H + V + S

Answer

ALT + H + V + P

Answer

ALT + H + V + F

Answer

ALT + H + V + O