=SUM(IF(ISTEXT(A1:D5),1,0)) will return?
Correct Answer: Count of text cells in a range A1:D5
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Excel Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Excel MCQ Questions
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 <<
Which statement is incorrect?
How will you reverse the direction of a SmartArt graphic?
How would you locate the last filled cell on a worksheet?
Which chart displays axes but cannot display axis titles?
How can you quickly display or hide the parts of a selected chart, like gridlines, axes and legend?
Let's say you have rows of names & addresses, and you want to sort by Zip code. How would you do this?
Which function will give you TRUE as an answer if Cell A1 contains 2 & Cell A2 contains 1?
The shortcut for writing the number 5,000,000 in an Excel cell is by typing the following formula
What is the formula to find the first day of the following month?