Which of below functions will give you TRUE as an answer if Cell A1 contains 2 & Cell A2 contains 1?

Let's say you have rows of names & addresses, and you want to sort by Zip code. How would you do this?

How can you quickly display or hide the parts of a selected chart, like gridlines, axes and legend?

When using Goal Seek, the cell that you're setting must be:

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?

Which statement is incorrect?

What will be the result of calling the h() function in the following C++ code? const char* upwork[] = { 'Freelancers', 'Projects', 'Fixed', 'Hourly } const char* f(int i) { return upwork[i]; } void g(string s){} void h() { const string& r = f(0); g(f(1)); string s = f(2); cout << 'f(3): ' << f(3) << ' s: ' << s << ' r: ' << r <<

=SUM(IF(ISTEXT(A1:D5),1,0)) will return?

If you have values in a range named Data, you can determine the smallest value by using the following formulas?

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?