Understanding Excel - Identifying Variables
Not what you're looking for?
Details: Your Aunt Sally has entered all of her stuffed animal data into an Excel workbook. She took your advice and used headings to organize the information. She now wants to have the information sorted in the fields Name, Date Purchased, Purchase Price, Color, Size, and Location for each of her stuffed animals. In addition, her husband, your Uncle Bob, wants to know how much money she has invested in this hobby, and her daughter wants to know the date she started this collection.
Sally would also like to be able to quickly identify what stuffed animals were bought before the year 2000. Advise her regarding how she can accomplish these tasks.
Purchase this Solution
Solution Summary
The solution shows in steps how to identify specific variables in excel by using the columns and excel tools.
Solution Preview
After Aunt Sally has entered the fields:
Name
Date Purchased
Purchase Price
Color
Size
Location
She now can add the purchase price column. To do so: skip a line in the column "Purchase Price" because this will the be total Aunt Sally has invested in the stuffed animal. To total: go to the Total line in the column (see previous sentence). Select ...
Purchase this Solution
Free BrainMass Quizzes
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
Basic Networking Questions
This quiz consists of some basic networking questions.
C++ Operators
This quiz tests a student's knowledge about C++ operators.
C# variables and classes
This quiz contains questions about C# classes and variables.
Excel Introductory Quiz
This quiz tests your knowledge of basics of MS-Excel.