Microsoft Excel Tutorial: Working with Sum Function

Microsoft Excel Tutorial: Working with Sum Function

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 sum function in Excel, explaining how to add numbers using cell references and ranges. It highlights the function's ability to ignore text, the use of keyboard shortcuts, and the handling of up to 255 arguments. The tutorial provides examples of using the sum function, demonstrates error handling when rows or columns are deleted, and shows how to modify the function and undo actions. The session emphasizes the importance of practice and offers a clear understanding of the sum function's utility.

Read more

2 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What error will you encounter if you delete a row or column that is referenced in a SUM formula?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

How can you undo a delete action in Excel?

Evaluate responses using AI:

OFF