MS Excel Vocab 3

What does the Page Break Preview View in Excel indicate?

• The start and end of pages in a sheet

• Where the page breaks are in a sheet

• The print area of a sheet

• The header and footer data

Which view in Excel allows for easier editing of header and footer data?

• Page Break Preview View

• Normal View

• Page Layout View

• Custom View

What is a PivotChart used for in Excel?

• To filter data in a PivotTable

• To visually represent the data in a PivotTable

• To summarize data between spreadsheets

• To set a print area

What is the primary function of a PivotTable?

• To create a chart from data

• To query, organize, and summarize data

• To restrict editing on a worksheet

• To manage different scenarios

What does the Print Area option in Excel allow you to do?

• Set an area of a spreadsheet to print

• Adjust cell references

• Create a PivotTable

• Edit headers and footers

What happens to relative references when they are copied or when using AutoFill?

• They remain constant

• They adjust and change

• They become absolute references

• They are deleted

What is the purpose of the Restrict Editing tool in Excel?

• To filter data in a PivotTable

• To set a print area

• To restrict the amount of editing on a worksheet

• To create a chart

What does the Scenario Manager tool allow users to do?

• Filter data by selecting the type of data desired

• View different scenarios of outputs as inputs change

• Create a tiny chart in a cell

• Set an area of a spreadsheet to print

What is a Slicer used for in a PivotTable?

• To create a visual representation of data

• To filter data by selecting the type of data desired

• To adjust cell references

• To restrict editing on a worksheet

What is a Sparkline in Excel?

• A tool to manage different scenarios

• A tiny chart in a cell that provides a visual representation of data

• A tool to restrict editing

• A method to set a print area