Excel - Intermediate 2

Use the following links to see training videos which will assist in answering the questionnaire:
Sumifs: - https://youtu.be/vmMHfVnsj6I
Countifs: - https://youtu.be/v5a4kCNuV8o
Naming cells: - https://youtu.be/NyyQ8WcM8_w

Excel Knowledge Test
Intermediate 2
General

Complete the questions first, then use the audio player at the
bottom of the page to hear answers and helpful tips

* Indicates required field

Name *

First

Last

Email *

Explain the use of SUMIFS *

Explain what you understand by "naming" of cells *

Write a short example of a basic SUMIFS formula using fictitious cell references *

Which tab would you use to see the "Name Manager" *

Explain the use of COUNTIFS *

What is a "Watch List" and what are its advantages? *

Write a short example of a basic COUNTIFS formula using fictitious cell references *

What is the keyboard combination to select the spreadsheet matrix? *

Use the audio player above to hear answers and helpful tips