Excel: Applications, Formatting in Excel Quiz

What does it mean to merge cells?

Combine 2 or more cells into a single cell.

Which of these number formats would you want to apply to a cell showing the total sales for the month?

Currency

What is the fastest way to copy the format from one cell to multiple other cells?

Double-click on the Format Painter.

Which of these is NOT a number format in Microsoft Excel?

Roman numeral

What happens when you hide a column in Microsoft Excel?

The column doesn't appear, but the data is still there.

You can use the Formulas Tab to change the Excel View, to hide the Heading, Gridlines and Ruler.

false

Microsoft Excel can use Headers and Footers, just like Microsoft Word.

true

Which of these statements are true?

You can use borders to create a group of cells or make specific cells stand out.

When would you use conditional formatting on a cell?

You want to highlight negative numbers by using red text.