Question: 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 B:J horizontally
Make cell B bold
Italizice cell B
Make cell G bold
Italizice cell G
Merge and center cell G across columns G:J
Change the format of the date range G:G to "Short Date"
Resize column B to a width of inches
Resize column C to inches
Resize column D to inches
Resize column E to inchesnotice this is smaller than needed to fit all cell contents
Resize column F to inches
Resize column G to inches
Resize column H to inches
Resize column I to inches
Resize column J to inches
Center the cells in the table range B:J horizontally
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.
Place a "Thick Bottom Border" from the border dropdown menu under the data labels range B:J
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.
Fill rows and of the table range B:J using any color not No Fill" from the "Fill Color" dropdown menu.
Use the "Wrap Text" feature in Excel to display all of the contents of cells E:E Resize the rows if necessary to fit the contents of the cells.
Set the print area of the worksheet to include only the area of the data table Range B:J
Set the left and right print margins of the worksheet to be inches
Set column B as "Columns to repeat at left" page titles
Notice that there is a blank worksheet in the workbook named "World Records Copied". Navigate to that worksheet and select cell A if it is not already selected.
Copy the records table without row range B:J 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 B of the "World Records Copied" worksheet.
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
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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
