You want to restrict the values entered in a cell to a specified set, such as Hop, Skip, Jump. Which type of data validation should you use?

You want to find the second-largest invoice in a column containing all the invoices in a given month. What function would you use?

What is one way to center text in a cell?

Cell D1 contains the value 7.877. You want cell D1 to display the value as 7.9 but keep the original number in calculations. How can yu=ou accomplish this?

To insert a new column to the left of a specific column, right-click the header containing the column's letter and select _.

Your transactions data set contains more than 10,000 rows. Some rows contain the same transaction. How would you remove the rows containing the identical transactions?

You can never open any workbook that has previously been saved and given a name.

Your spreadsheet is printing, but the grid lines aren't showing up. What is most likely the problem?

How do you control which cells are printed?

____ adds a range of cells together.

What tool allows you to summarize and analyze data in various categories?