Need help? We are here

# Computer Science ASSIGNMENT 1. VISUAL ANLAYSIS

Please answer all the questions highlighted in yellow, with supporting evidences such as screenshots. Answering the questions requires creating a worksheet in Microsoft Excel that keeps tracks of basic expenses and then charts those expenses.

DELIVERABLE

 Electronic file: 646_yourname_assignment1.doc  Electronic file: 646_yourname_assignment 1.xlsx (your messy working excel file)

 Submit all files through Assignment link, before next Monday. Late submission penalty will be applied. OBJECTIVE You’ll create a couple different chart types and modify the data that the chart is based on. You’ll learn quickly that it’s easy to visualize basic data, and that visualizations can help you quickly see differences in your underlying data. Activity 1: Create a Table of Data in Excel You will create a workbook and then add data in Microsoft Excel.

Create a workbook 1. Click New Blank Workbook to create your first Workbook. It will appear like this: 2. Add four column headers in row 1. Name them Place, Item, Price and Date 3. Add a few rows of data under your column headings to simulate some things you could imagine spending on things. 4. You can format your table using the toolbar in excel. Try bolding your column headings & formatting the price column as currency. Here’s an example of a worksheet with this data: Place Item Price Date Grocery Store Sandwich \$5.00 2/19/2017 Movie Theater Ticket \$7.50 2/21/2017 Gas Station Gasoline \$22.00 2/21/2017 Grocery Store Candy \$6.00 2/22/2017 Activity 2: Create a Chart in Excel You will create your first chart in Excel. Chart your data 1. Complete activity 1 above. You’ll need a worksheet with some data to create a chart. 2. Select Columns B and C, and then click Column on the Insert tab of the Excel toolbar, and choose one of the 2-D Column chart types. Here’s an image that shows the columns selected, and the Column icon selected: 3. After you click the Column icon, your column chart will be automatically added to your worksheet. Notice how easy it is to see in the chart the prices of your items relative to each other! Question 1: Please copy and paste the column chart automatically added.

#Computer #Science #ASSIGNMENT #VISUAL #ANLAYSIS

Pages (275 words)
Standard price: \$0.00

### Latest Reviews

Impressed with the sample above? Wait there is more

Related Questions

### Discuss the methods used to allocate the integrated marketing communications budget and how to measure its success by using marketing

Discuss the methods used to allocate the integrated marketing communications budget and how to measure its success by using marketing metrics. Support your essay with

### Health care is a continually evolving field driven by various

Health care is a continually evolving field driven by various changes. Nurse educators need an understanding of changes in health care and the driving

### Based on the data base you have created design a relational data base for the area of the company you

Based on the data base you have created design a relational data base for the area of the company you have selected. In other words,

### US foreign policy regarding Russian military aggression

There are four steps to completing this project: Step 1: Select a critical issue in the US foreign policy relationship with another country. Try to

### What are the societal and/or environmental factors that have contributed

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along

### Read the following article titled: Cross-Generational Networking Is A Win-Win

Read the following article titled: Cross-Generational Networking Is A Win-Win For Employees And Their Organization. So Why Don’t We Do It?. (hyperlinked). In the article,

### Please complete this assignment after listening to Black Trans Perspectives

Please complete this assignment after listening to Black Trans Perspectives and the Anniversary of the Stonewall Riots. Use complete sentences and appropriate spelling, grammar

### The American Cancer Society

The American Cancer Society(ACS) has many ways to give education on a newly diagnosed cancer patient. On their website, there is a tab that is

### In 1,500-2,000 words, describe the teaching experience OF EDUCATING PEOPLE

In 1,500-2,000 words, describe the teaching experience OF EDUCATING PEOPLE IN COMMUNITY ABOUT COVID-19 VIRUS, and discuss your observations OF YOUR AUDIENCE REGARDING THE EDUCATION.

### Thinking Like an Economist Short Paper In 2005, was Hurricane

Thinking Like an Economist Short Paper In 2005, was Hurricane Katrina’s major impact on the supply side of the economy or the demand side?

### Post a total of 3 substantive responses over 2 separate

Post a total of 3 substantive responses over 2 separate days for full participation. This includes your initial post and 2 replies to other students.  Due Thursday  Respond to

New questions