Course Hero Logo

Created in excel youll be able to format a range as a

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 8 - 11 out of 65 pages.

created in Excel. You’ll be able to format a range as a table, change a tablestyle, and convert a table to a range.Warm-upIn the previous lesson, you learned how to apply worksheet styles to cellsand remove formatting from worksheet cells.In this lesson, you will learn how similar formatting can be applied to a rangeof cells by formatting these as a table. With the help of theFormat as TableandTablecommands, you will learn two different processes to accomplishthis. TheFormat as Tablecommand creates a table and applies a style atthe same time. However, theTablecommand creates a table only. A stylecan be applied later if the user chooses.You will also learn how to convert a table back to a range.Get ready for discussions and step-by-step demonstrations, along withopportunities to put to practice what you learn along the way. But first, checkhow well you know the prerequisite concepts needed to follow this lesson.Use these questions to find out what you already know about this lesson’stopics:1.What keyboard shortcut can you use to insert a table?Select the correct option.a. Ctrl+Tb. Ctrl+Shift+=c. Ctrl+Shift+Ld. Ctrl+Shift+-8
8
Managing tables and range data2. ASelect here to enter text.provides the capability to select the arrowin the column header to narrow the data.3.What option is a unique combination of borders and shading to changethe appearance of the table?Select the correct option.9
4.A table can be converted to which of the following?Select the correct option.
Topic 1: Format data as a table andchange the table styleImagine you have been given an Excel workbook full of popular videogame data that has been collected over the past few years. You want to usethe data to find answers to some questions you have about your favoritegames. Trying to answer these questions by organizing the data can be atime-consuming and manual process. Converting the data into a table givesit structure to help you quickly manage and analyze it.There are several ways to insert a table.9
Managing tables and range dataCreate a table without a style applied1.Select a cell within your worksheet data range.5.Select theInserttab, go to theTablesgroup, and then selectTable.Figure 1:Tablecommand6. TheCreate Tabledialog box displays. TheWhere is the data for yourtable?field displays the range. If changes are needed to the range, selectthe range of cells in the worksheet or modify the range in the dialog boxfield.Figure 2:Create Tabledialog box7.Indicate if the table has headers by selecting theMy table has headerscheck box.Note: By default, a table has a header row. Every table column hasfiltering enabled in the header row so that you can filter or sort your tabledata quickly.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 65 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
Cullinan
Tags
Column, Table Name

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture