D. Use these tools to create charts and graphs. Most of them work only if you select one or more data sets (numbers only, with words for headers or categories). Charts and graphs function like youd expect _ just select the data you want to visualize, then select your desired type of visual (bar charts, scatter plots, pie charts, or line graphs). Creating one will bring up formatting options where you can change the color, labels, and more.
However, spreadsheets have grown from simple grids to powerful tools, functioning like databases or apps that perform numerous calculations on a single sheet. You can use a spreadsheet to determine your mortgage payments over time, or to help calculate the depreciation of assets and how it will affect your businesss taxes. You can also combine data between several sheets, and visualize it in color_coded tables for an at_a_glance understanding. With all the new functionality, using a spreadsheet program can be intimidating for new users.
Table builds a simple table that includes any number of columns you select. Rather than placing the table elsewhere on the worksheet, it turns the data into a table on the spot, and applies customizable color formatting.
The Clear button lets you either clear the value, or just clear cell formatting.