What function can be used to identify duplicate values in Column A?

On a worksheet, you have 12 columns showing monthly sales figures, and 15 rows, 1 row per product. How could you create 15 yearly trendline charts for each product, and fit them neatly on the page?

When you've created a table, what's a quick way of getting a total for the last column of numbers?

Which of the following is not a standard Excel cell format?

An .xlsx file cannot store VBA macro code or Excel 4.0 macro sheets.

What is the correct answer: A1 value = 10 A2 value = 0 =IFERROR(A1/COUNT(A1:A2),'Err')

Which formula needs to be typed in B3 to increase sales by 3.5% from the cell above, and then take advantage of autofill to fill the rest of the cells in the column instead of retyping the formula for every cell?

Which of the following feature correctly represents the following statement? In Excel we can use text series (such as January, February, March, or Sunday, Monday, Tuesday) and numeric series (such as 1, 3, 5, or 2014, 2015, 2016). Instead of entering these series by hand, you can use the fill handle to create them automatically.

Suppose that you have a worksheet that you update frequently by adding new data to columns. You may need a way to reference the last value in column A (the value most recently entered at bottom of column A). If column A contains no empty cells which of the formula returns the last value entered in column A (bottom one)?

To combine data of two or more columns into another column, you can usually use the concatenation operator _____ in a formula.

Which options are available for Auto Fill?