Excel Formatting Quiz

What does the Format Painter feature in Excel do?

• A. Copies the content of a cell to another cell

• B. Copies the formatting of a cell to another cell

• C. Deletes the content of a cell

• D. Changes the font style of a cell

Which tab in Excel's Format Cells dialog box allows you to change the position and alignment of the data within a cell?

• C. Font tab

• B. Alignment tab

• D. Border tab

• A. Number tab

What is the purpose of hiding columns or rows in Excel?

• D. To highlight the columns or rows

• C. To increase the size of the columns or rows

• B. To make the worksheet look cleaner

• A. To delete the columns or rows

How can you apply a border and color to a selection in Excel using the Format Cells dialog box?

• D. Click on the Font tab and select the desired color

• C. Use the AutoFormat feature in Excel

• B. Choose the Border tab and select the desired border style

• A. Select Format Cells and choose the Fill Color option

What is the purpose of using cell styles in Excel?

• D. To change the font size of a cell

• A. To delete the contents of a cell

• B. To quickly format a cell by choosing from predefined styles

• C. To merge cells together

How can you unhide a hidden worksheet in Excel?

• A. Right-click on the sheet tab and choose Unhide

• B. Select the hidden sheet and press Delete

• C. Use the AutoFit feature

• D. Change the font style of the hidden sheet

What does the AutoFormat feature in Excel use to format ranges of cells?

• A. Table styles

• B. Font styles

• C. Cell styles

• D. Border styles

Which tab in the Format Cells dialog box allows you to select the data type for a range of cells?

• B. Font tab

• D. Border tab

• C. Number tab

• A. Alignment tab

What happens when you enter the date 'January 1, 2001' into a cell in Excel?

• C. Excel automatically recognizes it as a date

• D. Excel displays an error message

• B. Excel changes the format to '01-01-2001'

• A. Excel recognizes it as text

How can you protect a worksheet in Excel against unauthorized editing?

• A. Use the Format Painter feature

• D. Give password protection to the worksheet contents

• B. Apply cell styles to the worksheet

• C. Hide the worksheet