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?

A colleague shared an excel file with you, and you want to display a worksheet that is hidden in it. How you can do that?

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?

You can download content from the net directly into Excel.