Which of the following will you select as X in the series of clicks to circle invalid data in a worksheet: Data tab > Data Tools group > Arrow next to X > Circle Invalid Data?
A) What-If Analysis
B) Data Validation
C) Remove Duplicates
D) Consolidate worksheet data.
Correct Answer:
Verified
Q2: Which of the following should you select
Q3: To change the text fill color of
Q4: Sophia wants to change the location of
Q5: To unprotect a workbook,open the Excel file,then
Q6: Martha and Mike are working on a
Q7: Ina wants to protect a worksheet with
Q8: Esperanza wants to record a macro to
Q9: Mila wants to restrict a cell to
Q10: To unprotect a workbook,open the Excel file,then
Q11: Kahir wants to delete a macro.To do
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