excel

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

pivot table

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

view

What are the shortcut keys for AutoSum?

Alt and =

Which of the following is the correct formula to calculate the weighted average score

=sumproduct(cell:cell ,cell:cell)

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

ALT + A + G + G

The shortcut keys to increase the number of decimal places are

ALT + H + FD + R

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

ALT + H + I + R

What are the keyboard shortcut keys to paste special?

ALT + H + V + S

What are the keyboard shortcut keys to insert a table?

ALT + N + T

What is the best practice for financial modeling in excel?

Use blue font for hard-coded numbers and black font for formulas

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

View

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

f2

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

f4

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

find