Mastering MS Excel Basics

What function would you use to sum a range of cells?

• TOTAL

• SUM

• CALCULATE

• ADD

How do you create a chart in Excel?

• Right-click on the data and choose 'Delete'

• Select data, go to 'Insert' tab, choose chart type.

• Go to 'View' tab and select 'Zoom'

• Click on 'File' and select 'New'

What is the shortcut for copying selected cells?

• Ctrl + X

• Alt + C

• Ctrl + V

• Ctrl + C

What does the VLOOKUP function do?

• The VLOOKUP function formats cells in a spreadsheet.

• The VLOOKUP function calculates the sum of a range of cells.

• The VLOOKUP function deletes rows from a table.

• The VLOOKUP function looks up a value in a table and retrieves corresponding data from another column.

How can you freeze panes in a worksheet?

• Right-click the cell and choose 'Freeze' from the context menu.

• Select the cell, go to 'Home' > 'Format' > 'Freeze Panes'

• Select the cell, go to 'File' > 'Save As' > 'Freeze Panes'.

• Select the cell, go to 'View' > 'Freeze Panes' > 'Freeze Panes'.

What is the purpose of the IF function?

• To sort data in ascending order.

• To perform conditional logic in calculations.

• To concatenate text strings together.

• To calculate the average of a set of numbers.

How do you format a cell to display currency?

• Select the cell, right-click, choose 'Format Cells', and select 'Currency'.

• Click on the cell, go to 'Home', and select 'Percentage'.

• Right-click the cell, choose 'Insert Comment', and type 'Currency' in the comment.

• Select the cell, right-click, choose 'Format Cells', and select 'Text'.

What is the difference between relative and absolute cell references?

• Relative references adjust based on the position, absolute references do not change.

• Both types of references are the same in functionality.

• Relative references are fixed and do not change.

• Absolute references adjust based on the position.

How can you sort data in Excel?

• Select data range, go to 'Data' tab, click 'Sort'.

• Right-click and select 'Delete'

• Go to 'Home' tab and click 'Format'

• Select data range and press 'Enter'

What feature allows you to automatically fill a series of numbers or dates?

• QuickFill

• SmartFill

• AutoFill

• DateSeries