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 20,2024.
- Exam Code: 77-727
- Exam Name: Excel 2016: Core Data Analysis, Manipulation, and Presentation
- Certification Provider: Microsoft
- Latest update: Dec 20,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.
Beginning at cell A5 of the “$5,000 Donors” worksheet, import the data from the tab-delimited source file,
contributors.txt, located in the Documents folder. (Accept all defaults.)
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.
Beginning at cell A5 of the “$5,000 Donors” worksheet, import the data from the tab-delimited source file,
contributors.txt, located in the Documents folder. (Accept all defaults.)
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.
Beginning at cell A5 of the “$5,000 Donors” worksheet, import the data from the tab-delimited source file,
contributors.txt, located in the Documents folder. (Accept all defaults.)
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.
Navigate to the range named “Oregon”, and remove the contents of the selected cells.
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.
Navigate to the range named “Oregon”, and remove the contents of the selected cells.
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.
Navigate to the range named “Oregon”, and remove the contents of the selected cells.
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.
Navigate to the range named “Oregon”, and remove the contents of the selected cells.
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.
Navigate to the range named “Oregon”, and remove the contents of the selected cells.
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.
Add a new worksheet named “$1,000 Donors” to the workbook.