The shortcut for writing the number 5,000,000 in an Excel cell is by typing the following formula

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

How will you reverse the direction of a SmartArt graphic?

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?