A. Number Rules
B. Range Rules
C. Cell Value Rules
D. Highlight Cell Rules
A. Apply a cell style
B. Use the 'Text that Contains...' option under Conditional Formatting
C. Use a formula to determine which cells to format
D. Use data validation
A. Review > Protect Workbook
B. File > Options > Trust Center
C. Data > Connections
D. Developer Tab
A. View
B. Data
C. Home
D. Insert
A. Sorts data automatically
B. Fills cells with random numbers
C. Creates a sequence of dates
D. Automatically fills in values based on patterns it detects in the data
A. Conditional Formatting
B. Protect Workbook
C. Use Encryption
D. Allow Edit Ranges
A. Sunburst Chart
B. Histogram
C. Waterfall Chart
D. Line Chart
A. Using a digital signature
B. Enabling all macros in Trust Center Settings
C. Setting macros to run automatically upon opening
D. Using a password-protected section in the workbook
A. Solver
B. Data Table
C. Goal Seek
D. Scenario Manager
