Excel Mastery Challenge

What is the formula to total a range of cells in Excel?

• =TOTAL(range)

• =ADD(range)

• =SUM(range)

• =SUMMATION(range)

How do you apply conditional formatting to highlight cells with specific text?

• Select cells > Home > Styles > Cell Styles > Choose a style > Apply.

• Select cells > Home > Data > Filter > Set criteria > Apply filter.

• Select cells > Home > Conditional Formatting > New Rule > Format only cells that contain > cell value > Set format > OK.

• Right-click cells > Format Cells > Choose color > Apply to all > OK.

What is the paste type, that when you copy it will auto update?

• Paste Special

• Paste Formats

• Paste Link

• Paste Transpose

What is the fastest way to create a name?

• Name Box

• Define Name

• Create from Selection

• i don't know

How can you quickly format a cell to currency in Excel?

• Press 'Ctrl + Alt + C' to format a cell to currency.

• Right-click and select 'Format as Currency' from the menu.

• Press 'Ctrl + Shift + $' to format a cell to currency.

• Use the 'Currency' option in the Data tab to format a cell.

What is the shortcut for saving a workbook in Excel?

• Shift + S

• Ctrl + S

• Alt + S

• Ctrl + P

What type of selection is not next to each other?

• Random

• Non-Random

• Drag and Drop

• Shift+ Click

What feature allows you to change the color of a cell based on its value?

• Value Highlighting

• Data Visualization Tool

• Cell Color Picker

• Conditional Formatting

Which key combination can be used to undo the last action in Excel?

• Alt + U

• Shift + Z

• Ctrl + Y

• Ctrl + Z

How do you use the VLOOKUP function to find data in a table?

• Use the VLOOKUP function to search for a value in the first column.

• VLOOKUP can only return values from the first column.

• You can use VLOOKUP to search for multiple values at once.

• Use VLOOKUP to find data in any column of the table.