Excel Formatting and Cell Management Quiz

Which option is used to unmerge cells in Excel?

• Home > Merge & Center > Unmerge Cells

• Right-click > Unmerge Cells

• Home > Format > Unmerge Cells

• Ctrl + U

Which function can be used to combine text from multiple cells into one cell?

• SUM

• CONCATENATE

• IF

• AVERAGE

What is the shortcut key to merge cells in Excel?

• Ctrl + M

• Alt + M

• Ctrl + Shift + M

• Alt + Shift + M

How can you center align text in a cell in Excel?

• Home > Alignment > Center

• Right-click > Format Cells > Alignment > Center

• Ctrl + A

• Alt + C

What does the formula =ROWS(A1:A10) return?

• The number of columns in range A1:A10

• The sum of values in range A1:A10

• The number of rows in range A1:A10

• The average of values in range A1:A10

Which option is used to insert a new column in Excel?

• Right-click > Insert

• Home > Insert > Column

• Ctrl + C

• Alt + I

How can you protect a worksheet in Excel from being modified?

• Format Cells > Protection > Protect Worksheet

• Review > Protect Sheet

• Home > Protect Workbook

• Data > Protect Worksheet

How can you hide a column in Excel?

• Right-click on the column header > Hide

• Home > Format > Hide Column

• Ctrl + H

• Alt + H

How can you apply conditional formatting to highlight cells with values greater than 50?

• Home > Conditional Formatting > Highlight Cells > Greater Than > 50

• Home > Conditional Formatting > New Rule > Format cells that are greater than > 50

• Home > Conditional Formatting > Data Bars > Greater Than > 50

• Home > Conditional Formatting > Icon Sets > Greater Than > 50

How can you apply a border to a cell in Excel?

• Home > Font > Border

• Right-click > Format Cells > Border

• Home > Format > Border

• Ctrl + B