Excel Quiz

What is the shortcut key to insert a new row in Excel?

• Shift + +

• Ctrl + Alt + +

• Ctrl + Shift + +

• Alt + Shift + +

Explain the difference between merging and centering cells in Excel.

• Merging adds borders, centering removes borders

• Merging combines cells, centering aligns content

• Merging changes font size, centering changes font color

• Merging splits cells, centering aligns content

How can you apply a currency format to a range of cells in Excel?

• Right-click on the cells and choose 'Currency Format'

• Type 'Currency' in the formula bar for the selected cells

• Select the range of cells, then go to the 'Number' group on the 'Home' tab, click on the drop-down arrow next to the 'Number Format' box, and select 'Currency' from the list.

• Use the 'Bold' formatting option for the cells

What is the purpose of data validation in Excel?

• To calculate formulas

• To change the font style

• To create charts and graphs

• To ensure that the data entered into a cell meets certain criteria.

Explain the steps to freeze panes in Excel.

• Select the row below and the column to the right of the rows and columns that you want to keep visible, then go to the View tab and click on Freeze Panes.

• Right-click on the cell and select Freeze Panes

• Go to the Insert tab and choose Freeze Panes

• Select the entire sheet and click Freeze Panes