Microsoft Excel 2021365 - Beginner to Advanced - Performing Calculations with the SUM Function

Microsoft Excel 2021365 - Beginner to Advanced - Performing Calculations with the SUM Function

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Quizizz Content

FREE Resource

The video tutorial covers the SUM function in Excel, explaining its popularity and basic usage. It demonstrates how to use the SUM function directly in a cell, through the Functions dialogue box, and using the Auto Sum button. The tutorial also addresses common errors indicated by green triangles and how to resolve them. Various methods and shortcuts for efficiently using the SUM function are discussed, providing a comprehensive understanding of its application in Excel.

Read more

3 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

How can you adjust the range selected by the Auto Sum function?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

What do the little green triangles in the corner of cells indicate?

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • 1 pt

What should you do if you see a warning icon next to a cell with a green triangle?

Evaluate responses using AI:

OFF