MGMT 1601 Study Guide - Final Guide: Purus River, Ignatius Jones, Mollis
28 Feb 2018
School
Department
Course
Professor
Document Summary
Excel automatically treats a range of continuous cells in a worksheet like a table that is, a set of related data set out in rows and columns. Right-click on any cell in the range and you will see a contextual pop-up menu that will allow you to manipulate the data in the table, including the useful tools filter and sort. You can also filter or sort the data in the table through the data tab and choosing sort or. You can also format a range of cells as a table: On a worksheet, select the range of cells that you want to include in the table. The cells can be empty or can contain data. On the home tab, in the styles section, click format as table, and then choose the table style you want (you can also press ctrl+l or ctrl+t).
