I have no idea how to do the second question.

1. Create a macro that colors the range B2:B7 green and makes column C have a width of 25. Give this macro the shortcut command Ctrl e. 2. Create a new sheet for this next macro. Enter a block of data that is at least two columns wide and at least two rows deep, with the upper-left corner in Cell A1. Record a macro that first copies this data block onto the clipboard and then creates a new sheet and copies this set of data into the same cells in the new sheet. Your macro should assume that the size of the block of data is unknown. (Recall how to use the ,, and arrow keys to highlight a range.) Give this macro the shortcut command Ctrl q. File Page Layout Formulas Data Review View Help Share Comments Calibri AutoSum 11 A A = A = = DO 2 Wrap Text PZ B General EX 5 Y O FillV Paste Insert Delete Format Ideas E s $ Home Insert Cut Lo Copy v Format Painter Clipboard : x A B Clear Conditional Format as Cell Formatting Table Styles Sort & Find & Filter Select Merge & Center - [ % ) Number Font Alignment Styles Cells Editing Ideas BIU - DA Font v for C D 32 E F G H I J K L M N O P Q R S T U A mornm to 00 on two ooo Sheet1 Sheet2 Leady 0 - -_ _ + 100% 1. Create a macro that colors the range B2:B7 green and makes column C have a width of 25. Give this macro the shortcut command Ctrl e. 2. Create a new sheet for this next macro. Enter a block of data that is at least two columns wide and at least two rows deep, with the upper-left corner in Cell A1. Record a macro that first copies this data block onto the clipboard and then creates a new sheet and copies this set of data into the same cells in the new sheet. Your macro should assume that the size of the block of data is unknown. (Recall how to use the ,, and arrow keys to highlight a range.) Give this macro the shortcut command Ctrl q. File Page Layout Formulas Data Review View Help Share Comments Calibri AutoSum 11 A A = A = = DO 2 Wrap Text PZ B General EX 5 Y O FillV Paste Insert Delete Format Ideas E s $ Home Insert Cut Lo Copy v Format Painter Clipboard : x A B Clear Conditional Format as Cell Formatting Table Styles Sort & Find & Filter Select Merge & Center - [ % ) Number Font Alignment Styles Cells Editing Ideas BIU - DA Font v for C D 32 E F G H I J K L M N O P Q R S T U A mornm to 00 on two ooo Sheet1 Sheet2 Leady 0 - -_ _ + 100%