The Complete Excel Guide: Beginners to Advanced - Module 4 - Practice Exercise

The Complete Excel Guide: Beginners to Advanced - Module 4 - Practice Exercise

Assessment

Interactive Video

Information Technology (IT), Architecture, Business

University

Hard

Created by

Quizizz Content

FREE Resource

This video tutorial guides users through navigating Excel workbooks, focusing on a loan workbook with two sheets: terms of loan and detail sheet for a five-year loan. It covers navigating sheets, linking cells with formulas, freezing rows, and using the split screen option. The tutorial concludes with a transition to the next module on page setup and print options in Excel.

Read more

5 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What are the names of the two sheets available in the loan workbook?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

What information can you list on the 'terms of loan' sheet?

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • 1 pt

How do you link cell C9 on the detail sheet to D3 on the terms of loan sheet?

Evaluate responses using AI:

OFF

4.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the purpose of freezing rows one through seven in the detail sheet?

Evaluate responses using AI:

OFF

5.

OPEN ENDED QUESTION

3 mins • 1 pt

Describe the split option and its function in the workbook.

Evaluate responses using AI:

OFF