ITE39L-PreTest

What is the keyboard shortcut key to lock Cell References in a formula?

• CTRL

• ALT

• F2

• F4

What are the shortcut keys for AUTOSUM?

• 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?

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

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

• =AVERAGE(B2:B4)

• =AVERAGE(C2:C4)

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"&A1

• ="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

Assuming cell A1 is displaying the number "12000.7789". What formula should be used to round this number to the closest integer?

• =MROUND(A1,100)

• =MROUND(A1,10)

• =ROUND(A1,0)

• =ROUND(A1,1)