IT Tools

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

• F2

• F4

• CTRL

• ALT

What are the shortcut keys for AutoSum?

• ALT and S

• CTRL and S

• CTRL and =

• ALT and =

In Microsoft Excel spreadsheets, rows are labelled as

• 1,2,3,…..

• A,B,C,….

• A1,B1,C1….

• I,II,III,…..

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

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)