Task 3 - Recording Absolute Macros

Post Reply
User avatar
Mayank
Site Admin
Posts: 174
Status: Offline

Task 3 - Recording Absolute Macros

Post by Mayank » 11 Oct 2017, 15:26

Before you start recording a macro, take a copy of the current sheet so you have a replica to test your macro on later. Record a macro called FormatTable, with the shortcut CTRL + SHIFT + F, which will format the table and add a formula into column C to calculate the ratio of people who gave CT exams this time.
File: 
Task 3 - Recording Absolute Macros.zip

"The steps involved in this macro are:

In Cell C3 add in the header % People.

Highlight Columns A-C and centre the text within each column.

Align the main header Favourite Cheeses Data across Columns A-C.

Change the Font of the main header to Bold and Size 14pt.

Change the Font of the table headers in Row 3 to Bold and Size 12pt.

In Cell C5 type in a formula to calculate the ratio of the people who prefer that cheese.

AutoFill this down to the bottom of the list.

AutoSize the column widths."     
     
Answer: 
Task 3 ans - Recording Absolute Macros.zip
 References:
https://support.office.com/en-us/articl ... 74a0905f46
 https://www.howtogeek.com/232629/how-to ... -in-excel/
You do not have the required permissions to view the files attached to this post.
Mayank Goyal
Post Reply