Module 6 - End of Module Project 1 #part1
Description
Questions covered in the video:
- Padma Laghari is a content manager for Veritate Online, a website that sells electronics, home furnishings, and other goods throughout the United States. Padma oversees the contractors the company hires to research, write, and edit content for the website, including product descriptions and answers to customer questions. She is organizing information about the contractors in an Excel workbook, and asks for your help in updating and analyzing the data. Switch to the Contractors worksheet. Unfreeze the top row of the worksheet.
- Padma wants to sort and filter the contractor data. Format the range A4:G52 as a table with headers using Blue-Gray, Table Style Medium 9. Use Contractors as the name of the table.
- Apply the First Column table style option to separate the ID values from the rest of the data. Resize column A to its best fit.
- A new contractor started last week, and Padma wants to include her data with the other contractors. Insert the record shown in Table 1 to the end of the Contractors table at row 53. Table 1: New Record for the Contractors Table
ID First Last Specialty Start Year Pay Category Eval Rating c5496 Mai Vang Garden and home 2022 1 3
Support 💖 Buy me a coffee: https://www.buymeacoffee.com/taandar Join Patreon: https://www.patreon.com/Taandar
#sam #spreadsheet #excel ---
Disclaimer: This video is intended for educational purposes only. The purpose of this video is to help students understand how to solve problems in the Cengage business spreadsheet course. However, please note that any attempt to copy or replicate the solutions shown in this video may be considered a violation of academic integrity policies at your college or university. We strongly encourage you to use this video as a guide and to complete the assignments on your own, without resorting to cheating or plagiarism. We are not responsible for any consequences that may result from the use of this video in violation of academic integrity policies.
Transcript
1 00:00:00,000 --> 00:00:05,700 so this is module 6 project 1 and step
2 00:00:03,899 --> 00:00:09,120 one is switch to the contractor
3 00:00:05,700 --> 00:00:10,980 worksheet and unfreeze the top row so we
4 00:00:09,120 --> 00:00:13,320 are on the same worksheets just click
5 00:00:10,980 --> 00:00:15,540 here and then currently the drop row is
6 00:00:13,320 --> 00:00:17,820 free so if we scroll then it will stay
7 00:00:15,540 --> 00:00:22,640 here so it is starting to unfreeze the
8 00:00:17,820 --> 00:00:22,640 top Loop so let's expand this
9 00:00:23,580 --> 00:00:28,740 all right it is saying unfreeze so for
10 00:00:26,160 --> 00:00:30,660 that let's go to view and then here is a
11 00:00:28,740 --> 00:00:33,899 freeze panels click in this drop down
12 00:00:30,660 --> 00:00:36,420 and then click on freeze so now if it's
13 00:00:33,899 --> 00:00:39,300 cool then it will not stay at the top or
14 00:00:36,420 --> 00:00:41,219 you can also search here search here on
15 00:00:39,300 --> 00:00:44,219 free select select that row and then
16 00:00:41,219 --> 00:00:46,500 sorts on Wizard click here and click
17 00:00:44,219 --> 00:00:51,860 currently it is in a run free so it also
18 00:00:46,500 --> 00:00:51,860 on face you can do that by that way also
19 00:00:52,520 --> 00:00:59,460 want to sort and filter the contractor
20 00:00:55,140 --> 00:01:02,760 data format the range A4 through g52 so
21 00:00:59,460 --> 00:01:06,119 A4 select A4 and then scroll down and
22 00:01:02,760 --> 00:01:07,580 then hold shift and then click at g52 so
23 00:01:06,119 --> 00:01:12,360 it will select
24 00:01:07,580 --> 00:01:15,240 from a photo g52 as a table with headers
25 00:01:12,360 --> 00:01:18,900 with blue gray table style medium nine
26 00:01:15,240 --> 00:01:21,080 so medium nine blue gray
27 00:01:18,900 --> 00:01:24,840 so let's go to home
28 00:01:21,080 --> 00:01:28,439 phase layout it was oh insert Maybe
29 00:01:24,840 --> 00:01:31,439 and let's see oh it's it's in the Home
30 00:01:28,439 --> 00:01:34,560 tab format as table click here and it is
31 00:01:31,439 --> 00:01:37,200 saying medium blue gray style nine so
32 00:01:34,560 --> 00:01:39,780 this is it so just click here
33 00:01:37,200 --> 00:01:42,600 and then A4 through g52
34 00:01:39,780 --> 00:01:43,860 and then hit OK
35 00:01:42,600 --> 00:01:46,320 ah
36 00:01:43,860 --> 00:01:49,500 and the reducing use contractors as the
37 00:01:46,320 --> 00:01:52,200 name of the table so just click click at
38 00:01:49,500 --> 00:01:53,880 any cell inside the table and table tab
39 00:01:52,200 --> 00:01:57,720 will appear click on the table design
40 00:01:53,880 --> 00:01:59,880 Tab and in table one enter this as the
41 00:01:57,720 --> 00:02:02,820 table name and then hit OK hit enter
42 00:01:59,880 --> 00:02:05,579 after that apply the First Column table
43 00:02:02,820 --> 00:02:07,619 style option to separate the ID value
44 00:02:05,579 --> 00:02:10,619 from the rest of the data resize column
45 00:02:07,619 --> 00:02:14,459 A to its best feed so apply the First
46 00:02:10,619 --> 00:02:15,720 Column table style okay so just click on
47 00:02:14,459 --> 00:02:18,120 the ID
48 00:02:15,720 --> 00:02:20,400 and then go to table design and then
49 00:02:18,120 --> 00:02:23,099 select this First Column and it will
50 00:02:20,400 --> 00:02:27,180 have the separate design and then it is
51 00:02:23,099 --> 00:02:29,400 saying auto feed a resize column A to
52 00:02:27,180 --> 00:02:32,160 its best fit
53 00:02:29,400 --> 00:02:34,379 and so this is the column just go go
54 00:02:32,160 --> 00:02:36,060 here and then to double click and it
55 00:02:34,379 --> 00:02:39,480 will it will fit
56 00:02:36,060 --> 00:02:41,340 it will go to its best feed
57 00:02:39,480 --> 00:02:43,200 and then it is saying a new contractor
58 00:02:41,340 --> 00:02:46,800 started last week and Panama want to
59 00:02:43,200 --> 00:02:50,040 input our insert record uh instant
60 00:02:46,800 --> 00:02:53,760 triple one and row 53 so let's go to row
61 00:02:50,040 --> 00:02:56,099 53 and it is saying insert this so this
62 00:02:53,760 --> 00:02:58,260 is same as the previous data so just
63 00:02:56,099 --> 00:03:01,200 copy copy them all
64 00:02:58,260 --> 00:03:03,180 and then select and then click here hold
65 00:03:01,200 --> 00:03:05,640 shift and then click here so select all
66 00:03:03,180 --> 00:03:07,980 this row and then right click and then
67 00:03:05,640 --> 00:03:10,200 paste option just do just do this keep
68 00:03:07,980 --> 00:03:12,599 Source form or not this just do this
69 00:03:10,200 --> 00:03:15,540 match destination for formatting and
70 00:03:12,599 --> 00:03:17,519 then click so this is done
71 00:03:15,540 --> 00:03:19,819 so we'll continue from this day 5 in
72 00:03:17,519 --> 00:03:19,819 next video
