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.
B. Ribbon:This grey area is called the Ribbon, and contains tools for entering, manipulating, and visualizing data. There are also tabs that focus on specific features. Home is selected by default; click on the Insert, Page Layout, Formulas, Data, Review, or View tab to reveal a set of tools unique to each tab. Well cover this more in the “Navigating the Ribbon” section later on.
G. Row and Column Formatting Tools: The Insert drop_down menu puts cells, rows, or columns before or after a selected area on the sheet, and Delete removes them. The Format drop_down lets you change the height of rows and the width of columns. It also has options for hiding and unhiding certain sections.
How to Create a Spreadsheet in Excel _ The worlds most robust pure spreadsheet application, Excel, comes as part of both Microsoft Office and Office 365. There are two main differences between the two offerings: First, Microsoft Office is an on_premise application whereas Office 365 is a cloud_based app suite. Second, Office is a one_time payment, and Office 365 is a monthly subscription. Excel is available for both Mac and PC.