Answered step by step
Verified Expert Solution
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started