After adding data validation criteria to a worksheet, which of the following features can you use to locate data that doesn't satisfy the criteria?
A) What-If Analysis
B) Circle Invalid Data
C) Remove Duplicates
D) Trace Precedents
Correct Answer:
Verified
Q40: When you click the Add to Data
Q41: Joyce wants to calculate the monthly payment
Q42: You can use the Evaluate Formula button
Q44: What information do you need to provide
Q46: The COUNTIF function counts blank cells.
Q47: The SUMIF function totals only the cells
Q48: Tracer arrows help you determine which cells
Q49: Excel provides a tool for tracing formula
Q50: Which of the following are Excel what-if
Q56: Which of the following will you select
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents