Formulas and Functions 1. Microsof t Office 2010 Excel Seminar Xander Jackson. Getting Familiar with Microsoft Office 2010: Excel. The Ribbon Laid out with multiple Tabs File, Home, Insert, Page Layout, Formulas, Data, Review, View Each tab has multiple Groups of Functions
Formulas and Functions 1
Microsoft Office 2010
In this exercise we will download and edit an existing spreadsheet. The goal of this exercise is to get familiar working in the Microsoft Office 2010: Excel environment. This spreadsheet is a simple budget of household expenses. We will use the most common functions:
Sum, Avg, Min, Max
We will also write a custom formula while using some of the nifty built-in features of Excel. Finally, we will add a pie-chart based on our custom formula.
This exercise covers more of the formulas included in Excel. Here we will use formulas from Date & Time, Text, Lookup & Reference, and Logical.
We will also use View tools to help examine the spreadsheet, and some formatting options to make it more visually appealing.