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

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

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Practice Problem

Hard

Created by

Wayground Content

FREE Resource

This video tutorial guides students through setting up a loan workbook in Excel. It covers modifying headers and footers, adding comments, adjusting page margins, centering content, setting print titles, and printing the workbook. The tutorial concludes with saving and closing the file, preparing students for the next module on working with rows, columns, and cells.

Read more

5 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the first step in setting up the Excel workbook according to the tutorial?

Create a new workbook

Open the loan workbook and navigate to the detail sheet

Check for spelling errors

Insert a new worksheet

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Where should you add the date in the Excel workbook?

Top left corner

Bottom left corner

Top right corner

Bottom right corner

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What comment should be added to cell C9?

This is the beginning balance of this loan

This is the monthly payment

This is the interest rate

This is the loan term

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How should the page be centered after adjusting the margins?

Not centered

Horizontally

Diagonally

Vertically

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which rows should be set as print titles?

Rows 1 through 3

Rows 8 through 10

Rows 11 through 14

Rows 4 through 7

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?