Charts, Graphs, and Diagrams

Spreadsheets and graphs are used to show information in a way that is visual and can be easily understood. Spreadsheets calculate data automatically for you. The graphs are a way to visually data that you want. There are different types of charts/graphs used. These charts are pie, bar, and line. You would usually use a pie chart to show percentages, an example would be if you wanted to show the religions of the people in a county. You would use a bar graph to compare information, an example would be comparing how many boys and girls played a game and who had the highest scores. You would use a line graph to show data over a period of time, an example would be showing shoe sales over the month. A diagram is used to present useful data in a more visual way that is easier to learn from. It is sometimes better to show information as a graphic than in numbers or word, because it can be remembered easily and it won’t appear as overcrowded things to look at and try to figure out. You could use a pie chart outside of school to present data such as how many people of each race live in a county. Basically the overall view on graphs and charts is that they are used to be more visual and to make sure things don’t appear sloppy on your spreadsheet.

 

Lesson 3 Features:

Features of Lesson 3:
Smart Art, Tab Color, Background, Border, Cell Style, Aligment, Merge/Center, Rename Sheet Tab

We learned many features in lesson 3. Some of these features are smart art, tab color background, border, cell style, alignment, and merge/center and rename sheet tab. All of these features help you to keep your spreadsheet organized. Smart art is used to organize things in a certain column or row, and used to organize things in a certain column or row, and put them in a design format that pops out. Tab color changes the color of the sheets in your workbook, this helps you be more organized and know the difference of each tab without having to read them. Background just adds a design making the spreadsheet appear more stylish, the border helps separate title from the rest of the work and not have a overcrowded look. Cell style gives more design, causing spreadsheet to be more vibrant and not boring. Alignment and merge and center, help to center titles. Renaming sheet tabs will help you stay organized so you do not have to search through the sheets and see which is which one is what. There are more features to excel that help you to stay organized, these are just a few.

Using MAth Formulas

Formulas are important because they help you calculate everyday things, without realizing it. You can use formulas to calculate how much money you will make from babysitting your aunts daughter for a week while she is on vacation. If you watch her daughter you will get paid $35 a day and if you take her places and teach her it’s an extra $15, but once you get the money you want to go to the movies and get your hair done.  So once you do this you have to calculate and see how much you will have left. Excel will use the order of precedence first it will multiply, then add and then subtract. 15 will be multiplied by 35, than add 15 and subtract the money from getting your hair done and going to the movies.

introduction To Excel

Summarize:

Excel is a type of spreadsheet software that can be used to organize and process numbers in rows and columns. It is used by businesses to organize data, including budgets, sales figures, expense statements, and time cards. This is helpful to students because it gives the ability to create your class schedule, your grades, your friends address and phone numbers, and your personal budget, There are many advantages to business using excel to store and process data, by using excel it is much easier to use numbers. With this spreadsheet there are ready made columns and rows. There are also built in formulas which can automatically calculate sums, averages, maximum values and minimum values. These built in formulas can be copied to other columns and rows to make quick and accurate calculations.

1. Businesses are one of the main users of Microsoft excel. They use it to organize data such as, budgets, sales figures, expense statements, and time cards. There are also other ways that excel is used in businesses. Some may use excel to determine how much each person will be paid and how many hours they have worked.
2.People use excel's built-in formula, becasue it is easier and quicker to use than getting a caculator and processing all the data.
3. Excel is different than Microsoft in many different ways. One way that it is different is that you do not have to create tables to set your information up into. In a spreadsheet there are ready made columns and rows. With excel formulas are given to you unlike in Microsoft you have to do the math yourself. Excel makes it easier for business to create schedules, teachers to create grade sheets and students to organize their class schedules. In Microsoft you would have to create a table with rows and columns taking up extra time.
4. On the internet i found out that excel can also be used to create calendars and schedules. you can create weekly, monthly and yearly calendars with excel. You can also shedule bill dates.