LinkedIn Microsoft Excel Certification

Which two functions check for the presence of numerical or nonnumerical characters in cells?

October 27, 2022 Editorial Staff

ISNUMBER and ISTEXT
ISNUMBER and ISALPHA
ISVALUE AND ISNUMBER
VALUE and ISTEXT

The correct answer is:

ISNUMBER and ISTEXT.

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers

← Some of your data in Column C is displaying as hashtags (#) because the column is too narrow. How can you widen Column C just enough to show all the data?
You need to determine the commission earned by each Sales Rep, based on the Sales amounts in B3:B50 and the Commission rate specified in cell A1. You want to enter a formula in C3 and copy it down to C50. Which formula should you use? →