How do you remove only the conditional formatting from a cell and leave all other formatting intact?

If a range name is used in a formula and the name is deleted, what happens to the formula?

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?

How do you change the orientation of a spreadsheet from portrait to landscape?

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.