Microsoft Excel Tutorial: Using Autosum Command and Shortcut Key

Microsoft Excel Tutorial: Using Autosum Command and Shortcut Key

Assessment

Interactive Video

Information Technology (IT), Architecture

10th Grade - University

Hard

Created by

Quizizz Content

FREE Resource

This video tutorial covers the use of the Autosum command in Excel, including its basics, shortcut keys, and limitations. It explains how to use the Autosum feature from the Home tab, the importance of understanding range selection, and how empty cells can affect this process. The tutorial also highlights the demerits of Autosum, such as incorrect range selection, and emphasizes the need for manual adjustments. The session concludes with a demonstration of manual range selection and encourages viewers to practice for better command over Excel functions.

Read more

5 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the purpose of the Autosum command in Excel?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

How can you manually select a range for the Autosum function?

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • 1 pt

Explain the demerit of the Autosum command when there is an empty cell in the range.

Evaluate responses using AI:

OFF

4.

OPEN ENDED QUESTION

3 mins • 1 pt

What should you do if the Autosum command does not select the correct range?

Evaluate responses using AI:

OFF

5.

OPEN ENDED QUESTION

3 mins • 1 pt

What steps should you follow to use the sum command from the dialog box?

Evaluate responses using AI:

OFF