wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel Lesson 11 Quiz

Total questions: 9

Worksheet time: 9mins

Name
Class
Date
1.

Lilly is making changes to a spreadsheet her FBLA Advisor created. She would like to make a change to the comment she made in the spreadsheet. What option in the comments group should she choose?

a)

New

b)

Delete

c)

Edit Comment

d)

Show Ink

2.

Where is the spell checker feature located in Microsoft Excel?

a)

Home Ribbon

b)

Page Layout Ribbon

c)

Review Ribbon

d)

View Ribbon

3.

The FBLA Advisor at Hilltop High School would like to create random ID numbers for FBLA members. Which function would be used to have Excel pick a random number between 1,000 and 5,000 for the new member ID numbers?

a)

RAND()

b)

RAND BETWEEN(1000,5000)

c)

BETWEEN(1000,5000)

d)

RANDOM(1000,5000)

4.

What command limits structural changes, such as adding, deleting, or moving sheets, that can be made in a workbook?

a)

Protect Workbook

b)

Protect Sheet

c)

Share

d)

Protection

5.

Lilly is creating a spreadsheet for FBLA and would like all of the advisors at her school to be able to make changes to the spreadsheet at the same time. What command allows her to do this?

a)

Share Workbook

b)

Protect Workbook

c)

Tracking Changes

d)

Export

6.

Which ribbon contains commands to add a comment about a selected cell in a worksheet?

a)

Home

b)

Insert

c)

Data

d)

Review

7.

Lilly is creating a spreadsheet for FBLA and would like to see the changes advisors have made to the workbook. What command allows her to do this?

a)

Share Workbook

b)

Protect Workbook

c)

Tracking Changes

d)

Export

8.

Lilly is making changes to a spreadsheet created by her FBLA advisor. She wants to add a note informing her advisor of an incorrect address for a member. What option in the comments group should be used?

a)

New

b)

Delete

c)

Edit Comment

d)

Show Ink

9.

All of the FBLA officers have access to the spreadsheet of member contact information. Which feature of Excel allows others to view who made changes to the spreadsheet, when the changes were made, and what was changed?

a)

Track Changes

b)

Change History

c)

History

d)

Names Manager