If you would like to count the number of cells within a range that fit a specific criteria, which function would use?

Which worksheet function returns the F probability distribution?

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

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

You can download content from the net directly into Excel.

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

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

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?

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 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?

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