Question: ( The example table has a column called Country / Region which our dataset does not have ) . table [ [ Task #

(The example table has a column called Country/Region which our dataset does not have).
\table[[Task #,More detailed instructions:],[\table[[Task 1: Create a table for Arkansas and],[Louisiana data each and name the table],["Arkansas" for Arkansas and "Louisiana" for],[Louisiana]],\table[[1. Click on cell A 3 and highlight all of the columns and the rows of the data for the first state's data,],[including the data labels in row 3.],[2. From the HOME tab, click on 'Format as Table' and choose a (nice colorful) template in blue.],[3. A box should appear, make sure to check "My table has headirs"],[4. Click OK and a table should be created for that data table.],[5. Click on the table and now you see a new tab along the top menu called "Table Design".],[6. Use the Table Design, Table Name option to change name Table Name.],[7. Do the same for other state's data (which is a few columns over to the right).- Green color]]]]
Task 2: Create a new column named Daily
In the first state's table, right click on the cell at the top of the column for the Sum of Deaths in ord to highlight all cells in that column and use the dropdown option and click "Insert" to insert a column just to the left.
Name the new column "Daily Confirmed cases".
Right click on the cell at the top of the column for the Sum of Deaths in order to highlight all cells that column and use the dropdown option and click "Insert" to insert a column just to the right. Confirmed cases and Daily Deaths. Because the
Name the new column "Daily Deaths"
 (The example table has a column called Country/Region which our dataset

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!