Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Beginner
Assuming we have two separate tables: one contains sales records, and the other contains details on the cost of the products sold. We want to use them in a standard Excel PivotTable… what do we need to do?
Use VLOOKUP (or some other function) to create one master table in order to act as a source for our PivotTable
Create a relationship between the two tables so that we can use them in a single PivotTable
Export our data and use a program other than Excel
Don’t know
2
Beginner
Assume we have the table of data shown below serving our PivotTable. We’d like to report the Total Sales $ for all products sold. Which is the easiest way to make this happen?
Add a column to the source table that multiplies the Sales Quantity by the Sales Price, then drop that field in the values area of the Pivot
Create a calculated field on the PivotTable that multiplies Quantity by Price
Drop Sales Quantity and Sales Price into the values area of the PivotTable, then run a formula down the side of the PivotTable to multiply the two against each other
Don’t know
3
Beginner
Assume you have a data set that is 4,000 rows long, and you need to add 16 columns of variations to display the data correctly in your PivotTable. What is the biggest drawback to this approach?
Setting up the extra columns is tedious work and leads to the potential of creating erroneous data or formulas that don’t update properly when the data source is updated
VLOOKUP formulas are difficult to write
Setting up the extra columns adds extra data which uses more memory and can slow down your Excel file
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement