Quiz on MS Office - Excel

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 are the keyboard shortcut keys to paste special?

• ALT + H + V + F

• ALT + H + V + P

• ALT + H + V + O

• ALT + H + V + S

What are the keyboard shortcut keys to edit formula in a cell?

• F2

• F4

• CTRL + 1

• CTRL + F

What are the keyboard shortcut keys to insert a table?

• ALT + N + R

• • ALT + N + C

• • ALT + N + V

• ALT + N + T

In which tab of the ribbon can you change Workbook Views to Page Break Preview?

• View

• Review

• Page Layout

• Data