F. Slicers are big lists of buttons that make your data more interactive. You can select a PivotTable youve created, and then create a slicer from it _ this allows a viewer to click on buttons that correlate to the data they want to filter.
The Format paintbrush copies everything related to the formatting of a selected cell. When you select a cell and click Format, you can then highlight a whole range of cells, and each one will take on the formatting of the original cell, without changing their values.
The other tool in this section is Merge and Center. There are instances when you may want to combine several cells and have them act as one long cell. For example, you might want a header for an entire table to be clear and easy to read. Select all the cells you want combined, click Merge, and then type your header and format it. Though the default setting for headers is centered text, simply click the drop_down arrow to select different merging and unmerging options.
A. These tools control PivotTables, an important Excel function. Think of PivotTables as “reports,” a quick way to view all your data, analyze trends, and draw conclusions. By selecting at least two rows of data and clicking on PivotTable, you can quickly generate a visually_appealing table. Going through this process launches the PivotTable Builder, which helps you select columns to include, sort them, and drag_and_drop them to quickly construct your table. They can include collapsible rows to make reports interactive and uncluttered. There is also a button for Recommended PivotTables, which can help when you dont know where to start.