MS Excel Formatting Quiz

What is cell formatting in Excel?

• It refers to changing the appearance of a cell, such as its font, color, alignment, and borders.

• It is the method of creating a new cell in Excel

• It refers to the process of merging cells together

• It is the process of converting a cell into a different type of data

How can you apply number formatting in Excel?

• By clicking on the 'Bold' button in the 'Font' group on the Home tab

• By using the 'Insert Function' option in the 'Formulas' tab

• By selecting the cell or range of cells, then choosing the desired format from the 'Number Format' drop-down menu in the 'Number' group on the Home tab.

• By right-clicking on the cell and selecting 'Format Cells' from the context menu

What are the different types of text formatting options available in Excel?

• strike through

• text wrapping

• highlighting

• bold, italic, underline, font size, font color, text alignment

Explain font formatting in Excel.

• Font formatting in Excel refers to the way text is calculated

• Font formatting in Excel refers to the way text is styled, such as font type, size, color, and style (bold, italic, underline).

• Font formatting in Excel refers to the way text is sorted

• Font formatting in Excel refers to the way text is aligned

How can you change the font style in Excel?

• By changing the page layout

• By using the Insert tab

• By using the options in the Font Style box in the Home tab

• By adjusting the cell size

What is the shortcut key to apply bold formatting to a cell in Excel?

• Alt + B

• Shift + B

• Ctrl + A

• Ctrl + B

Explain the process of applying conditional formatting in Excel.

• Click on the 'Insert' tab and choose 'Conditional Formatting'

• Apply the formatting rule first and then select the range of cells

• Use the 'Format Painter' tool to apply conditional formatting

• Select the range of cells, go to the 'Home' tab, click on 'Conditional Formatting' in the 'Styles' group, and choose the formatting rule to apply.

What is the significance of using custom number formats in Excel?

• Custom number formats in Excel only work for text, not numbers

• Custom number formats in Excel allow users to display numbers in a specific way.

• Custom number formats in Excel have no significance

• Custom number formats in Excel are difficult to use

How can you align cell content in Excel?

• Apply a border to the cell

• Change the font size

• Use the 'Insert' tab

• Use the alignment options in the 'Home' tab or the 'Format Cells' dialog box.

Explain cell border formatting in Excel.

• Cell border formatting in Excel refers to the way text is calculated

• Cell border formatting in Excel refers to the way cell borders are styled, such as border type, color, and thickness.

• Cell border formatting in Excel refers to the way text is sorted

• Cell border formatting in Excel refers to the way text is aligned