Excel Lesson 11

Lilly is making changes to a spreadsheet her FBLA Advisor created. She wants to add a note informing her advisor of an incorrect address for a member. What option in the comments group should she use? a. New. b. Delete Selected: c. Edit Comment d. Show Ink

New

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

Tracking changes

Conflicting changes between users

determines whose edits become part of the fi le if two or more people attempt to edit at the same time. The workbook owner's changes usually take precedence.

Include in personal view

enables each user who edits the workbook to see a personal view of the workbook.

Change history

includes the name of the person who made each change, when the change was made, and what data was changed.

Strong password

is one that combines uppercase and lowercase letters, numbers, and symbols

shared workbook

is set up to allow multiple users on a network to view and make changes at the same time.

Tracking Changes

is the ability to mark who makes what changes that have been made to a workbook.

password

text that must be entered before a user can access a workbook, worksheet, or worksheet elements.

Update changes

controls when changes made to the shared workbook are incorporated into the workbook.

All of the FBLA officers have access to the spreadsheet of member contact information. Which feature in Excel allows others to view which officer made changes to the spreadsheet, when the change was made and what changes were made? a. Track Changes b. Change History c. History d. Names Manager

Change History

Hidden rows, columns, and worksheets

Columns can be hidden to protect salary and and social security (US), social insurance (Canada), or national insurance (UK) data. Before removing hidden rows or columns, be sure that their removal will not change calculations in your worksheet.

Document properties and personal information

Document properties include the author, subject, and title, as well as the name of the person who most recently saved the workbook and the date the workbook was created.

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

Edit Comment

Headers and footers

Headers and footers can include the author's name, the date the file was created, and so on

Where is the spellchecker located? a. Home Ribbon b. Page Layout Ribbon Selected: c. Review Ribbon d. View Ribbon

Page Layout Ribbon

What command limits structural changes, such as adding, deleting, or moving sheets, that can be made in a workbook? a. Protect b. Protect Sheet c. Share d. Protection

Protect Worksheet

The FBLA Advisor at your school would like to create random ID numbers for FBLA members at your school. Which function would allow her to have Excel pick a random number between 1000 and 5000 for the new member ID numbers? a. RAND() b. RAND BETWEEN(1000,5000) c. BETWEEN(1000,5000) d. RANDOM(1000,5000)

RAND BETWEEN(1000,5000)

Which ribbon contains commands to add a comment about a selected cell in a worksheet? a. Home b. Insert c. Data d. Review

Review

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

Shared Workbook

RANDBETWEEN

This formula creates a random number for each employee that can be used for identification purposes.

Comments and annotations

This information enables other people to see the names of people who worked on your workbook, their comments, and changes that were made to the workbook