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