MS Excel
Not what you're looking for?
Your mother-in-law heard that you created the budget for the high school reunion picnic and has asked if you could help her to create a monthly household budget. She has created categories for groceries, entertainment, credit cards, mortgage, and utilities. She wants to track her expenses for a couple of months before she creates her budget considering that she has no idea how much she spends in certain areas. While she feels confident in collecting the data and entering it into an Excel workbook, she is unsure of what type of formulas or functions she might need to use and is not sure of the difference between a formula and a function. Explain to your mother-in-law the difference between formulas and functions, and then give her one example of how she might use each in her budget.
Purchase this Solution
Solution Summary
This posting contains answers to the given questions.
Solution Preview
Hi,
In Excel, the user can use formulas and functions to manipulate numerical data. Formulas and functions, although they have the same purpose, they are different in terms of usability.
A formula is a user-defined equation wherein the user has the control of what the operations will be used and how the equation is arranged. For example, the user can input in cell E1 the formula:
=30*(A1+B1+C1+D1)
The Excel will add ...
Purchase this Solution
Free BrainMass Quizzes
Word 2010: Tables
Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Javscript Basics
Quiz on basics of javascript programming language.
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
Basic Computer Terms
We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.