Ribbon Royalty
This panel at the top of Excel houses tabs like "File," "Home," and "Insert."
(Answer: What is the Ribbon?)
This feature allows you to rearrange data in ascending or descending order.
(Answer: What is Sorting?)
This feature splits data from one cell into multiple cells.
(Answer: What is Text to Columns?)
This feature allows you to copy and paste only specific elements of a cell, like formatting or values.
(Answer: What is Paste Special?)
Name three groups found within the "Home" tab of the Ribbon.
(Answer: What are Font, Alignment, and Number?)
You want to sort a table by department first, then by last name within each department. What type of sorting should you use?
(Answer: What is Multi-Level Sorting?)
What is the symbol that all Excel formulas must begin with?
(Answer: What is the equal sign (=)?
Name two benefits of converting a range of cells into an Excel Table.
(Possible answers: What are structured references, automatic formatting, and easy filtering/sorting?)
True or False: The Ribbon's appearance and available options cannot be customized.
(Answer: What is False?)
This feature lets you temporarily hide rows that don't meet specific criteria.
(Answer: What is Filtering?)
This function calculates the average of a range of numbers.
(Answer: What is the AVERAGE function?)