Guía de examen Informatics II 2p

What is the primary purpose of Conditional Formatting in Excel?

• To sort data alphabetically
• To automatically change the formatting of cells based on set conditions
• To create pivot tables for data analysis

Which of the following is NOT a common use of Conditional Formatting?

• Highlighting cells with values above a certain range
• Changing the background color of alternate rows
• Encrypting sensitive data in a cell

How do you activate Conditional Formatting in Excel?

• By right-clicking on a cell and selecting "Insert"
• By going to the "Home" tab and selecting "Conditional Formatting" from the "Styles" group
• By selecting "File" and then "Options" to configure advanced settings

Which of the following conditions for Conditional Formatting compares two columns for duplicate values?

• "Format cells that contain"
• "New Formatting Rule"
• "Duplicate Values"

What is the primary function of the Freeze Panes feature in Excel?

• To hide cells
• To keep specific rows or columns visible when scrolling
• To merge multiple cells into one

Where can you find the Freeze Panes option in Excel?

• Under the "Insert" tab
• Under the "Data" tab
• Under the "View" tab

If you want to freeze the first row and the first column which Freeze Panes option should you select?

• Freeze Top Row
• Freeze First Column
• Freeze Panes

What happens when you apply Unfreeze Panes to a worksheet?

• The selected rows or columns are duplicated
• The selected rows or columns are hidden
• The book can be viewed normally

What can you add to the header and footer section when printing an Excel worksheet?

• Macros and VBA code
• Page numbers, date, and file name
• Formulas and Functions

Which view must you be in to see and edit the header and footer in Excel?

• Normal View
• Page Layout View
• Data View