Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Center the table headers ( range B 3 :J 3 ) horizontally 5 2 Make cell B 2 bold 6 2 Italizice cell B 2

Center the table headers (range B3:J3) horizontally
52 Make cell B2 bold
62 Italizice cell B2
72 Make cell G2 bold
82 Italizice cell G2
94 Merge and center cell G2 across columns G:J
102 Change the format of the date range (G4:G73) to "Short Date"
112 Resize column B to a width of 28.0(2.4 inches)
122 Resize column C to 8.71(.79 inches)
132 Resize column D to 16.57(1.44 inches)
142 Resize column E to 29.43(2.53 inches)-notice this is smaller than needed to fit all cell contents
152 Resize column F to 15.14(1.33 inches)
162 Resize column G to 11.0(.99 inches)
172 Resize column H to 25.86(2.22 inches)
182 Resize column I to 29.14(2.5 inches)
192 Resize column J to 13.71(1.21 inches)
204 Center the cells in the table (range B4:J50) horizontally
213 Notice that both the "Place" and "Country" fields display the country where the record was established. Hide column I ("Place") to avoid redundency in the table.
222 Place a "Thick Bottom Border" (from the border drop-down menu) under the data labels (range B3:J3)
235 Place a dotted line border (the option directly under "None" in the "Border" tab of the "Format Cells" dialog window) under each subsequent row in the table.
243 Fill rows 2 and 3 of the table (range B2:J3) using any color (not "No Fill") from the "Fill Color" drop-down menu.
255 Use the "Wrap Text" feature in Excel to display all of the contents of cells E46:E50. Resize the rows if necessary to fit the contents of the cells.
264 Set the print area of the worksheet to include only the area of the data table (Range B2:J50)
274 Set the left and right print margins of the worksheet to be .5 inches
283 Set column B as "Columns to repeat at left" page titles
293 Notice that there is a blank worksheet in the workbook named "World Records Copied". Navigate to that worksheet and select cell A1 if it is not already selected.
304 Copy the records table without row 2(range B3:J50 from the "World Records" worksheet) to the "World Records Copied" worksheet using the "Copy" and "Paste" features of Excel. Paste the range starting in cell B3 of the "World Records Copied" worksheet.
318 Now, sort the table on the "World Records Sorted" worksheet by Country in ascending order (A to Z), then sort the table by 'Record Date' in descending order (Newest to Oldest).
328 Filter the table on the "World Records Sorted" worksheet to display only athletes whose "Nationality" listed as "Kenya" or "Jamaica"

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essential SQLAlchemy Mapping Python To Databases

Authors: Myers, Jason Myers

2nd Edition

1491916567, 9781491916568

More Books

Students also viewed these Databases questions