ETech: MS Productivity Tools Excel Skills Quiz

What is the symbol used to start a formula in Excel?

• =

• -

• +

• *

How can you insert a new row in Excel?

• Go to the 'Edit' menu and select 'Insert Row'.

• Press the 'Insert' key on your keyboard.

• Right-click on the selected row and choose 'Insert' from the context menu.

• Double-click on the row number and choose 'Insert' from the drop-down menu.

What is the shortcut key to save an Excel file?

• Ctrl + S

• Ctrl + X

• Ctrl + P

• Ctrl + A

How can you apply a currency format to a cell in Excel?

• Select the cell or range of cells, right-click and choose the 'Currency' option.

• Go to the 'Format' tab, click on 'Currency' in the 'Number' group.

• Type the currency symbol directly into the cell and format it as 'Currency'.

• Select the cell or range of cells, go to the 'Home' tab, click on the 'Number Format' dropdown, and choose the 'Currency' option.

What is the purpose of sorting data in Excel?

• To create charts and graphs

• To randomly shuffle the data

• To delete unnecessary data

• To organize and arrange data in a specific order.

How can you merge cells in Excel?

• Select the cells, left-click, and choose 'Merge Cells'

• Press Ctrl+M to merge cells

• Go to the 'Format' tab and click on 'Merge Cells'

• Select the cells, right-click, and choose 'Merge Cells'

What is the function used to find the maximum value in a range of cells in Excel?

• MAX

• MIN

• SUM

• AVERAGE

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

• Right-click on the cell and select 'Apply Border'

• Press Ctrl+B to apply a border to the cell

• Go to the 'Format' tab and choose 'Border' from the dropdown menu

• Select the cell or range of cells, go to the 'Home' tab, click on the 'Borders' button in the 'Font' group, and choose the desired border style.

What is the purpose of using formulas in Excel?

• The purpose of using formulas in Excel is to import and export data.

• The purpose of using formulas in Excel is to create charts and graphs.

• The purpose of using formulas in Excel is to perform calculations and automate tasks.

• The purpose of using formulas in Excel is to format cells and apply styles.

Which of the following is NOT a type of cell reference in Excel?

• Relative

• Absolute

• Mixed

• Parallel