basics
where is the formula auditing group located
formulas tab
what is it called when a column letter and a row number location identifies a cell within a worksheet or table
cell reference
what finds and retrieves a value from data in a horizontal table
hlookup
what does module 8 cover
trendlines, pivot tables, pivot charts, and slicers
what performs powerful data analysis
powerpivot
where do you go to open the page layout view
view tab
what can help you arrange a worksheet to make the contents easier to read and understand
page break
what do you use when you want to total only certain values in a range that meets a specific criteria
dsum
what is used to analyze data details on different levels
drilling
what does module 10 cover
data analysis with power tools and creating macros
where do you go to apply a background
page layout tab
what does module 3 cover
working with large worksheets, charting, and what if analysis
applying a table style
what is used to show the general pattern of data over time and forecast's future data
trendlines
what is an an action or set of actions that run when you record your mouse clicks
macros
where do you go to add or delete comments
how do you increase column or row width
by using the split double arrow pointer
how can you sort and filter data quickly and easily using options on a drop down menu above each column
formatting the range as a table
what is a powerful too to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data
pivot table
what do you use to plot geographic and temporal data on a 3d globe or map
3D maps
where do you go to add filters
insert tab
what is a cell that is currently selected in the active sheet
active cell
what does module 6 cover
creating, sorting, and querying a table
what provides buttons that you can click to filter tables or pivot tables
slicers
what returns visible data from a pivot table
getpivotdata