Latest:
LinkedIn Microsoft Excel Certification 

The text filter in column A is designed to display only those rows where column A entry has a particular attribute. What is this attribute?

Editorial Staff
  • The second character in the cell is 9.
  • The number 9 appears one or more times within the cell.
  • The cell is comprised of 9 characters.
  • the number 9 apperars once and only once within the cell.

The correct answer is:

  • The second character in the cell is 9.

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

You May Also Like

In this PivotTable, the continuous variable weight is shown in the Row field. Another continuous variable is in the Sum Values field. It is important to reduce a long list of body weights to a smaller set of weight categories. How do you do this?

Editorial Staff 0

Your worksheet has the value 27 in cell B3. What value is returned by the function =MOD (B3,6)?

Editorial Staff 0

For an IF function to check whether cell B3 contains a value between 15 and 20 inclusively, what condition should you use?

Editorial Staff 0