Excel Functions and Shortcuts (P3 FINAL)

Front

What is the shortcut key to save an Excel workbook?

Back

Ctrl + S

Front

Which function is used to sum a range of cells in Excel?

Back

=SUM()

Front

What does VLOOKUP function do in Excel?

Back

Searches for a value in the first column of a table and returns a value in the same row from another column

Front

Which Excel feature allows you to visually represent data using bars, lines, or pie slices?

Back

Charts

Front

Which keyboard shortcut is used to insert a new worksheet in Excel?

Back

Shift + F11

Front

What does the function CONCATENATE in Excel do?

Back

Combines text from multiple cells into one cell

Front

Which function would you use to round a number up to the nearest whole number in Excel?

Back

=ROUNDUP()

Front

What does the function COUNT in Excel do?

Back

Counts the number of cells that contain numbers in a range

Front

Which feature in Excel is used to identify and correct errors in formulas?

Back

Error Checking

Front

How do you freeze panes in Excel?

Back

Select the cells to be frozen, then right-click and choose Freeze Panes.