Font size
WorksheetsExcel Quiz
Total questions: 5
Worksheet time: 3mins
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
