Excel Quiz

Which function is used In Excel to perform a conditlonal check and return one of two values?

• IF()

• CHECK)

• WHETHERO

• EITHER)

What is the purpose of Quick Sort in Excel?

• To automatically apply cell farmatting

• To sort data based on multiple criteria

• To sort data numerically from high to low

• To quickly alphabetize text in a range

What is the purpose of using color scales in Excel's conditional formatting?

• To visuolize data using color gracients based on cell values

• To highlight cells with specific text values

• To format all cells in the same color

• To create colorful charts and graphs

What is complex sorting in Excel?

• Sorting data using only one critenon

• Sorting dota in random order

• Sorting data based on multiple criteria

• Soring data using a custom formula

What is the moin purpose of the Find and Replace feature in Excel?

• To search for specific formulas in a worksheet

• To locate and highlight cells with errors

• To sart data in ascending order

• To find and replace specific data or formatting in cells

What are functons ond their codes in the context of subtotals in Excel?

• Codes used to hide subtotals in a worksheet

• Formulas used to calculate subtotals and the corresponding color codes

• Descriptions of different subtotal functions available in Excel

• Shortcut keys to appiy subtotals to selected data

What is a PivotChart in Excel?

• A tool for merging cells

• A visual representation of PivotTable data

• A way to filter data in a worksheet

• A type of data validation rule

How can you display dates and times more effectively in a PivotTable using a graphical representation?

• By using a Sparkline

• By adding a Timeline

• By adding a Data Bar

• By creating a Slicer

In Excel, If you want to test multiple conditions to ensure they are all met within a range, you would use:

• Cell check

• Range check

• Condition check

• Value check

If you want to create a visual representation of a PivotTable, which feature would you use?

• Data Graph

• Excel Chart

• TableChart

• PivotChart