click below
click below
Normal Size Small Size show me how
Tables
Microsoft Excel 2016
| Question | Answer |
|---|---|
| How can you add a new row to a table after you’ve created it? | Add a new row to a table by selecting the last cell and then pressing Tab |
| What are the steps for displaying table rows that have grades lower than a C in a column titled Grade? | Click the arrow in the Grade header and then click Number Filters and then Less Than. In the displayed dialog box you type C for the criteria and click OK |
| Name at least three actions that can be done with the Quick Analysis button | format data, create a chart, add a total, create a PivotTable, and add Sparklines. |
| Related data can be more easily managed and analyzed in a spreadsheet ____________. | Table |
| Tables are a __________ when you want to place information in a separate format with _______ , __________, and ____________ | good choice, borders, formatting, other features that improve data understanding. |
| What is a selected range of cells in a worksheet called? | Table |
| How is a table created? | select the range click Table on the Insert tab click OK |
| What should be done before creating any Table? | Verify the range and confirm that there are headers, |
| table headers include a(n) _____ for _______ a(n) _____ with _______ ___ __________ commands. | arrow, displaying, menu, sorting and searching |
| To add a new row to a table, ________________________________. | click in the last cell of the table and press Tab. |
| How is customizing the table formatting done? | with the Table Tools Design tab |
| Where is the Table Tools Design tab? When is available? | on the Ribbon when any table cell is selected |
| What can be done in the Table Tools Design tab? | select or clear Table Style Options to emphasize different aspects or click a different Table Style to change the entire look of the table. |
| To add a new row to a table __________. | click in the last cell of the table and press Tab |
| What is Convert to Range used for? Where is this function found? | To convert the table back to a cell range Table Tools Design tab. |