Tuesday, January 31, 2012

Charts, Diagrams, Graphs

Spreadsheets and graphs are used together to show data visually and in regular columns and rows. Different types of graphs are used to organize for different reasons. Some graphs are used to show a change over a time period, to show a comparison, or percentages. The purpose of a graph or chart is to show information in a visual way. It is sometimes better to show data as a graphic, because data can be understood easily in a chart so that you can see the changes or comparisons within the data. For example, if you wanted to show the crime rate rising in numbers, you could put those numbers in a chart. You could also use a pie chart to show to population percentages in different continents.

Wednesday, January 25, 2012

Excel Enhancement

There are many features you can add to an Excel workbook. SmartArt is used to see data in a graph. Tab Color can be used for color coding and organizing information. The purpose of a background is to show people what the information is about. Borders are used to show the title. Cell styles are used to format your table in a certain way. Text alignment is used to keep the data in an organized format. Merge and center is used to make the title stand out. Renaming the sheet tab is so that you can look at different sheet tabs by their name.

Thursday, January 12, 2012

Using Math Formulas

Excel uses math formulas to help you with everyday life problems. It calculates the same way that people calculate when they’re in math class. Since there are certain rules in math, excel has to do the same. The order of precedence is multiplication, division, addition, and then subtraction.  You have to put the correct symbols for your calculations to be correct. Excel does the order of calculations as multiplication, division, addition, and subtraction. The order of precedence is important because you have to follow certain rules to get the correct answer.

Wednesday, January 4, 2012

Introduction to Excel

Excel is a spreadsheet that is used to store data. It can be used for grades, addresses, or when doing calculations. Excel is perfect for when you need to input numbers. Excel can automatically add, subtract, multiply, can divide. Excel has formulas made just for that. It makes calculations accurate and very fast. Businesses can use Excel when doing worksheet formulas or making charts with numbers in it. Excel is different from word because it has rows and columns throughout it. Word is a blank sheet of paper. Excel is easier to use than word when inputting data. Word is more for typing reports, while Excel is for data. I think that people prefer to use Microsoft Excel's formula instead of calculators because it's faster and easier to use. A person could use Microsoft Excel to make a calendar.