เสร็จสมบูรณ์

for maria and raz

(20 pts.) Do Capstone Exercise on page 199. Be sure to use Move Chart to move charts to their own chart sheets where directed, do not use Copy/Paste.

(20 pts.) Create a workbook named census_LastNameFirstName to display charts for some census data for five areas (ex. states, countries, counties) for two different years. Your worksheet should satisfy the following specifications. Your workbook must be unique and reflect your own data and design.

In cell A1 display your name merged and centered across used columns. Increase the font size and add a different font name than the default font.

In cell A2 use the Insert Link command to cite the source of your data. Paste the URL into the Address area.

Include row and column headings as appropriate for the area and time units.

Create a Clustered 2-D Bar chart chart plotting data for all the areas and time units such that there are five data series, one for each area. Edit the fill color of the series with the smallest bar to black. Add data labels to the end of the smallest series showing the numeric value. Use the Insert Shape command to add a shape containing text with a meaningful fact about this series. Insert an arrow shape to point to the smallest series. Include a chart title and move the legend to the left side with a legend command. Use the Move Chart to move the chart to its own sheet named Bar.

Create a Line chart with Markers comparing values for one time unit across the five. Format the markers to a diamond shape with an enlarged size. Add major vertical gridlines. Add a Y axis title. Add a data table which appears under the chart.

Use the Move Chart to move the chart to its own sheet named Line.

Give an appropriate name to the data sheet and move it to the left of the three sheets.

Add a header of your name in the left side, sheet name in the middle, and current date on the right side.

ทักษะ: คีย์ข้อมูล, การประมวลผลข้อมูล, Excel, Microsoft Office, Word

ดูเพิ่มเติม : activate default billing address magento, vbnet point sale projects source code, windows encoder url source, point sale free source code vbnet, restaurant point sales system source code net, php barcode address open source usps, url source live encoding, url source, right test stack using open source driver wwwfreebtnet, default magento admin url, hide url source, scramble address url, net point sales software source code, windows media encoder url source

เกี่ยวกับนายจ้าง:
( 1 บทวิจารณ์ ) Bath, United States

หมายเลขโปรเจค: #16616260

มอบให้กับ:

nanda1208

Here is the bid as we've agreed. It will be delivered within 2 hours, tops. Just writing here to have 100 characters.

$20 USD ใน 0 วัน
(11 บทวิจารณ์)
3.2

freelancer 5 คน กำลังเสนอราคาเฉลี่ยที่ $21 สำหรับงานนี้

anzarulislam

Hello.....! I'm interested,I'll complete the project a little budget and your full satisfaction. lets give me message so that we can discuss about the project details.. I'm waiting for your response....

$25 USD ใน 0 วัน
(12 บทวิจารณ์)
4.0
$18 USD ใน 10 วัน
(0 บทวิจารณ์)
0.0
$20 USD ใน 10 วัน
(0 บทวิจารณ์)
0.0
$20 USD ใน 10 วัน
(0 บทวิจารณ์)
0.0