Excel: How to Use an Excel Function

The video tutorial demonstrates how to sum a column of salaries in a spreadsheet. Initially, it shows a manual method of adding each salary individually, which is time-consuming. Then, it introduces a more efficient approach using the SUM function, which simplifies the process by allowing users to select a range of cells to sum automatically.

What is the initial method described for summing up salaries in a spreadsheet?

• Using a calculator

• Manually adding each salary with the plus operator

• Using the SUM function

• Copying and pasting values

What is one drawback of the manual addition method?

• It only works for small datasets

• It is inaccurate

• It requires internet access

• It is time-consuming

What action does the narrator take after demonstrating the manual method?

• Deletes the manual formula

• Shares the spreadsheet online

• Prints the spreadsheet

• Saves the spreadsheet

Which function is introduced as a more efficient way to sum salaries?

• AVERAGE

• COUNT

• PRODUCT

• SUM

How does the narrator suggest selecting the cells for the SUM function?

• By using a voice command

• By dragging through the cells

• By copying and pasting

• By typing each cell reference