Excel Quiz Grade 7

What is the keyboard shortcut key to lock cell references in a formula?

• CTRL

• ALT

• F2

• F4

What are the shortcut keys for Auto Sum?

• ALT and S

• CTRL and S

• ALT and =

• CTRL and =

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

• =SUM PRODUCT(C2:C5,B2:B5)

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

• =AVERAGE(B2:B4)

• =AVERAGE(C2:C4)

Company A is looking into four potential projects and will accept them if the IRR is 10% or above, as shown in cell E2. What is the formula used in cell C2, which can be copied down to cell C3 through C5, to generate the results shown below?

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

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

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

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

What are the shortcut keys to insert a new row in an Excel spreadsheet?

• ALT + H + I + R

• ALT + H + I + C

• ALT + H + I + I

• ALT + H + I + S

What are the shortcut keys to group rows so you can expand/contract a section of data?

• ALT + A + U + U

• ALT + A + W + G

• ALT + A + G + G

• ALT + A + B

Which of the following Excel features allows you to select/highlight all cells that are formulas?

• Find

• Replace

• Go To

• Go To Special

What formula should be entered in cell A3 to display the results as shown below?

• ="Income Statement"&A

• ="Income Statement "&A1

• ="Income Statement "+A1

• ="Income Statement "&"A1"

What formula can be used in cell G2 to create a dynamic date which shows the last day of each month?

• =EOMONTH($B$2,B1)

• =EOMONTH($B$2,G1)

• =EOMONTH($B$2,C1)

• =MONTH($G$2)

What are the keyboard shortcut keys to paste special?

• ALT + H + V + F

• ALT + H + V + P

• ALT + H + V + O

• ALT + H + V + S