NEW QUESTION 37
For which data visualization is the Histogram chart most suitable?

NEW QUESTION 38
When using the INDEX function, what is a common error if the function does not return the correct value?

NEW QUESTION 39
Which logical functions can be used to perform complex conditions in Excel?
(Choose two)

NEW QUESTION 40
Which features are available when protecting a workbook?
(Choose two)

NEW QUESTION 41
Which setting must be enabled to use macros in an Excel workbook?

NEW QUESTION 42
To configure data validation rules, navigate to ____ > Data Tools > Data Validation.

NEW QUESTION 43
Arrange the steps to enable workbook version control.
1. Go to File > Info
2. Click on Version History
3. Save the workbook
4. Access previous versions

NEW QUESTION 44
What is the purpose of the ‘Track Changes’ feature in Excel?

NEW QUESTION 45
To format only cells that contain numbers within a specified range, use the _____ feature under Conditional Formatting.

NEW QUESTION 46
Which function should you use to ensure that a date falls on a weekday, not a weekend, when performing date arithmetic?

NEW QUESTION 47
To remove duplicate records from a dataset, use ____ > Remove Duplicates.

NEW QUESTION 48
To manage workbook versions efficiently, enable ____.

NEW QUESTION 49
Which of these is NOT a type of data validation in Excel?

NEW QUESTION 50
You need to fill in a column of cells with numeric data based on a sequence, but only for workdays. Which Excel feature should you use?

NEW QUESTION 51
What action does protecting the workbook structure restrict?
Changing cell formats
Adding or deleting worksheets

NEW QUESTION 52
Which functions would you use to perform a what-if analysis?
(Choose Two)

NEW QUESTION 53
What does configuring formula calculation options allow you to manage?

NEW QUESTION 54
How can you make a cell turn green if the value is greater than 100 using conditional formatting?