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?

You have a column of dog breeds that are in all capital letters. What function would you use to convert those dog breeds so that only the first letter of each word is capitalized?

By default, numbers appear in the _____ and generally display values exactly as you type them.

____ 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.

If you want to highlight a row of numbers by less than, greater than or equal to, what should you use?

Where do you place a MACRO that is supposed to run automatically after every entry on a worksheet?