Excel Test Questions

What are the shortcut keys for AutoSum?
*

ALT and S

CTRL and S

ALT and =

CTRL and =

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

CTRL

ALT

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 insert a table?
*

ALT + N + R

ALT + N + C

ALT + N + V

ALT + N + T

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)

What are the shortcut keys to open up the Find and Replace window?
*

ALT + H + FD + R

CTRL + FD

ALT + H + R

ALT + H + FD

Which tab of the ribbon should you go to for removing gridlines on a worksheet?
*

Formulas

View

Review

Developer

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

View

Review

Page

Layout Data

Which of the following features cannot be found in the Data ribbon?
*

What-If Analysis

PivotTable

Data Validation

Text to Columns

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)

Suppose a company expected its revenue to be $180,000 for 2014-2018. What formula should be entered in cell E6 so it displays revenue in 2016 if it was above budget, otherwise it'll show 0?

*

=IF(E2<$B$6,E2,0)

=IF(E2<$B$6,0,E2)

=IF(E2>$B$6,E2,0)

=IF(E2>$B$6,0,E2)

Excel Test Questions

Excel Test Questions

What are the shortcut keys for AutoSum? *

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

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

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

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

What are the keyboard shortcut keys to paste special? *

What are the keyboard shortcut keys to insert a table? *

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

What are the shortcut keys to open up the Find and Replace window? *

Which tab of the ribbon should you go to for removing gridlines on a worksheet? *

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

Which of the following features cannot be found in the Data ribbon? *

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

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

Suppose a company expected its revenue to be $180,000 for 2014-2018. What formula should be entered in cell E6 so it displays revenue in 2016 if it was above budget, otherwise it'll show 0? *

What are the shortcut keys for AutoSum?
*

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

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

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

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

What are the keyboard shortcut keys to paste special?
*

What are the keyboard shortcut keys to insert a table?
*

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

What are the shortcut keys to open up the Find and Replace window?
*

Which tab of the ribbon should you go to for removing gridlines on a worksheet?
*

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

Which of the following features cannot be found in the Data ribbon?
*

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

*

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

*

Suppose a company expected its revenue to be $180,000 for 2014-2018. What formula should be entered in cell E6 so it displays revenue in 2016 if it was above budget, otherwise it'll show 0?

*