Microsoft 77-727 Excel 2016: Core Data Analysis, Manipulation, and Presentation Online Training
Microsoft 77-727 Online Training
The questions for 77-727 were last updated at Dec 21,2024.
- Exam Code: 77-727
- Exam Name: Excel 2016: Core Data Analysis, Manipulation, and Presentation
- Certification Provider: Microsoft
- Latest update: Dec 21,2024
SIMULATION
Project 2 of 7: Donor List
Overview
You are an executive assistant for a non-profit organization named Bellows College. You are updating a workbook containing lists of donors.
Add a new worksheet named “$1,000 Donors” to the workbook.
SIMULATION
Project 2 of 7: Donor List
Overview
You are an executive assistant for a non-profit organization named Bellows College. You are updating a workbook containing lists of donors.
On the “$5,000 Donors” worksheet, hyperlink cell C3 to the email address “[email protected]”.
SIMULATION
Project 2 of 7: Donor List
Overview
You are an executive assistant for a non-profit organization named Bellows College. You are updating a workbook containing lists of donors.
On the “$5,000 Donors” worksheet, hyperlink cell C3 to the email address “[email protected]”.
SIMULATION
Project 2 of 7: Donor List
Overview
You are an executive assistant for a non-profit organization named Bellows College. You are updating a workbook containing lists of donors.
On the “$5,000 Donors” worksheet, hyperlink cell C3 to the email address “[email protected]”.
SIMULATION
Project 2 of 7: Donor List
Overview
You are an executive assistant for a non-profit organization named Bellows College. You are updating a workbook containing lists of donors.
Arrange the worksheets so that “$5,000 Donors” is first.
SIMULATION
Project 2 of 7: Donor List
Overview
You are an executive assistant for a non-profit organization named Bellows College. You are updating a workbook containing lists of donors.
Arrange the worksheets so that “$5,000 Donors” is first.
SIMULATION
Project 2 of 7: Donor List
Overview
You are an executive assistant for a non-profit organization named Bellows College. You are updating a workbook containing lists of donors.
Arrange the worksheets so that “$5,000 Donors” is first.
SIMULATION
Project 2 of 7: Donor List
Overview
You are an executive assistant for a non-profit organization named Bellows College. You are updating a workbook containing lists of donors.
Arrange the worksheets so that “$5,000 Donors” is first.
SIMULATION
Project 2 of 7: Donor List
Overview
You are an executive assistant for a non-profit organization named Bellows College. You are updating a workbook containing lists of donors.
Arrange the worksheets so that “$5,000 Donors” is first.
SIMULATION
Project 3 of 7: Tree Inventory
Overview
You are updating the inventory worksheet for a local tree farm.
Change the margins to 1.0’’ (2.54 cm) on the top and bottom, 0.75’’ (1.90 cm) on the left and right, with a 0.5’’ (1.27 cm) header and footer.