Mastering Cell Formatting Skills

What is the purpose of cell formatting in a spreadsheet?

• To change the font of the text

• To organize and present data clearly

• To perform calculations

• To delete data

Which of the following is NOT a type of cell formatting?

• Bold text

• Cell color

• Cell size

• Cell formula

How can you format a cell to display numbers as currency?

• By changing the font style

• By using the currency format option

• By adjusting the cell size

• By adding a border

What does the "Merge Cells" feature do in a spreadsheet?

• It combines multiple cells into one

• It splits a cell into multiple cells

• It changes the cell color

• It deletes the content of the cells

Which of the following is used to change the background color of a cell?

• Font style

• Cell border

• Fill color

• Text alignment

If you want text to appear at the top of a cell, which alignment option should you use?

• Center alignment

• Bottom alignment

• Top alignment

• Justify alignment

What is the effect of applying a border to a cell?

• It changes the text color

• It adds a line around the cell

• It merges the cell with another

• It deletes the cell content

Which of the following is a reason to use conditional formatting?

• To automatically adjust cell size

• To highlight important data based on criteria

• To change the font style of all cells

• To delete duplicate data