Correct Answer: ignore the text value and add the numeric values
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
Which worksheet function returns the skewness of a distribution?
What is the fastest way to convert an array containing unrelated formulas that begin with the equal sign, but are stored as text into real formulas?
What is the formula for the Mean of a set of numbers?
Function to find the intersection of a row & a coulmn in a given range
What VLOOKUP parameter provides the multicolumn range or name of the range or date table to be searched?
Which of the following is/are array formulas?
Which of the following function accepts a range as an input?
What does the Excel 'Reduce file size....' option do? (choose all that apply)
Shape Data include the following steps?
To create an outline in Excel in order to easily expand a heading and show the summary below it, you would select from the menu: