Page 180 - MS Office 365 for Dummies 3rd Ed (2019)

TABLE 12-1
Features of the Home Tab
Home Tab Section
Description
Allows you to cut, copy, and paste data between cells within the spreadsheet
Allows you to adjust the font size and style
Sets the alignment of the data in the cells and allows text to wrap
Changes the formatting of numeric data
Sorts and filters tables or access the table options
Inserts or deletes cells in the spreadsheet
Clipboard
Font Alignment Number Tables Cells
A function performs some calculation, such as summing the values of cells. There are many different functions to choose from in Excel Online. Many would say that the functions are what make Excel so valuable. Adding functions is explored later in this chapter.
A table allows you to manipulate data with functionality, such as sorting the data in ascending or descending order or filtering the data based on specific criteria.
An Office add-in is like an app that extends the Excel environment. There is an online store that lists all of the Excel Online add-ins. You access the store by click- ing the Office Add-Ins button in the ribbon of the Insert tab.
A chart is a visualization of data. You can insert many different types of charts into your spreadsheet. Some of the most common types include bar charts, column charts, line charts, and pie charts.
A hyperlink allows you to create clickable text that, when clicked, opens up a new website. For example, you can create a hyperlink with text that says “Learn More” — clicking it takes the viewer of the Excel Online workbook to a news article.
The comment field allows you to insert a comment into the spreadsheet. A com- ment is metadata because it isn’t part of the actual data in the spreadsheet. The comment is data about the data in the spreadsheet, which is why it’s called meta- data. Comments are useful so that you can leave notes about the spreadsheet without actually modifying the spreadsheet data.
The Insert tab is shown in Figure 12-2.
164 PART4 DivingintoOfficeOnline