Excel 2016: Core Data Analysis, Manipulation, and Presentation 온라인 연습
최종 업데이트 시간: 2024년11월08일
당신은 온라인 연습 문제를 통해 Microsoft 77-727 시험지식에 대해 자신이 어떻게 알고 있는지 파악한 후 시험 참가 신청 여부를 결정할 수 있다.
시험을 100% 합격하고 시험 준비 시간을 35% 절약하기를 바라며 77-727 덤프 (최신 실제 시험 문제)를 사용 선택하여 현재 최신 35개의 시험 문제와 답을 포함하십시오.
/ 1
Question No : 1
SIMULATION
Project 3 of 7: Tree Inventory
Overview
You are updating the inventory worksheet for a local tree farm.
Hide rows 29 and 30.
정답: See explanation below. Explanation:
Question No : 2
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.
정답: See explanation below. Explanation:
Question No : 3
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.
정답: See explanation below. Explanation:
Question No : 4
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]”.
정답: See explanation below. Explanation:
Question No : 5
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.
정답: See explanation below. Explanation:
Question No : 6
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.
정답: See explanation below. Explanation:
Question No : 7
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.)
정답: See explanation below. Explanation:
Question No : 8
SIMULATION
Project 1 of 7: Tailspin Toys
Overview
You recently opened an online toy store. You have sold products to 500 individual customers. You are evaluating customer data and order data.
On the “Customers by Order” worksheet, use an Excel data tool to remove all records with duplicate “CustomerID” values from the table. Do not remove any other records.
정답: See explanation below. Explanation:
Question No : 9
SIMULATION
Project 1 of 7: Tailspin Toys
Overview
You recently opened an online toy store. You have sold products to 500 individual customers. You are evaluating customer data and order data.
On the “Orders” worksheet, enter a formula in cell J2 that uses an Excel function to return the “OrderTotal” value of the individual order that has the highest “OrderTotal” value.
정답: See explanation below. Explanation:
Question No : 10
SIMULATION
Project 1 of 7: Tailspin Toys
Overview
You recently opened an online toy store. You have sold products to 500 individual customers. You are evaluating customer data and order data.
On the “Orders” worksheet, use an automatic formatting method to format cells in the “OrderTotal” column that contain above-average values by applying Green Fill with Dark Green Text. Use a technique that automatically updates the formatting if the column values change.
정답: See explanation below. Explanation:
Question No : 11
SIMULATION
Project 1 of 7: Tailspin Toys
Overview
You recently opened an online toy store. You have sold products to 500 individual customers. You are evaluating customer data and order data.
On the “Products” worksheet, apply a number format to display the numbers in the “Weight” column to three decimal places.
정답: See explanation below. Explanation:
Question No : 12
SIMULATION
Project 1 of 7: Tailspin Toys
Overview
You recently opened an online toy store. You have sold products to 500 individual customers. You are evaluating customer data and order data.
On the “Customers” worksheet, enter a formula in cell N2 that uses an Excel function to return the average age of the customers based on the values in the “CurrentAge” column.
정답: See explanation below. Explanation:
Question No : 13
SIMULATION
Project 1 of 7: Tailspin Toys
Overview
You recently opened an online toy store. You have sold products to 500 individual customers. You are evaluating customer data and order data.
On the “Customers” worksheet, sort the table to order the records by the “CountryOrRegion” field, with customers in the United States first and customers in Canada second. Then sort the customers in each country alphabetically (from A to Z) by the “StateOrProvince” field. Finally, sort the customers in each state or province in ascending order by the ‘PostalCode” field.
정답: See explanation below. Explanation:
Question No : 14
SIMULATION
Project 1 of 7: Tailspin Toys
Overview
You recently opened an online toy store. You have sold products to 500 individual customers. You are evaluating customer data and order data.
On the “Customers” worksheet, format the table so that every other row is shaded. Use a technique that automatically updates the formatting if you insert a new row.
