Download
1 / 3
30 likes | 55 Views
BIS 221T Week 3 Practice Excel Basics//tutorfortune.com<br><br>Click on below link to buy<br>https://tutorfortune.com/products/bis-221t-week-3-practice-excel-basics<br><br>BIS 221T Week 3 Practice Excel Basics<br> <br><br>Insert a new column between columns B and C. Label the new column (cell C3) u201cRecord IDu201d<br> <br><br>World Records!C3: Record ID<br><br>1 / 1 (100.0%)<br><br>Feedback:<br><br> <br>Use the u201cFillu201d feature of Excel to insert the numbers 1 to 47 in cells C4:C50.<br> 4 / 4 (100.0%)<br><br>Feedback:<br><br> Make the table headers (range B3:J3) bold<br> <br><br>2 / 2 (100.0%)<br><br>Feedback:<br><br> <br>Center the table headers (range B3:J3) horizontally<br> <br><br>2 / 2 (100.0%)<br><br>Feedback:<br><br> Make cell B2 bold<br> <br><br>World Records!B2: font.Bold=True<br><br>1 / 1 (100.0%)<br><br>Feedback:<br><br> Italizice cell B2<br> <br>World Records!B2: font.italic=True<br><br>1 / 1 (100.0%)<br><br>Feedback:<br><br>Make cell G2 bold<br> World Records!G2: font.Bold=True<br><br>1 / 1 (100.0%)<br><br>Feedback:<br><br> Italizice cell G2<br> <br><br>World Records!G2: font.italic=True<br><br>1 / 1 (100.0%)<br><br>Feedback:<br><br> Merge and center cell G2 across columns G:J<br> <br>2 / 2 (100.0%)<br><br>Feedback:<br><br> Change the format of the date range (G4:G73) to u201cShort Dateu201d<br> <br><br>2 / 2 (100.0%)<br><br>Feedback:<br><br>Resize column B to a width of 28.0 (2.4 inches)<br> <br>1 / 1 (100.0%)<br><br>Feedback:<br><br> Resize column C to 8.71 (.79 inches)<br><br>BIS 221T Week 3 Practice Excel Basics<br>Click on below link to buy<br>https://tutorfortune.com/products/bis-221t-week-3-practice-excel-basics<br>
E N D
BIS 221T Week 3 Practice Excel Basics//tutorfortune.com Click on below link to buy https://tutorfortune.com/products/bis-221t-week-3-practice-excel-basics B I S 2 2 1 T We e k 3 P r a c t i c e E x c e l B a s i c s I n s e r t a n e w c o l u mn b e t w e e n c o l u mn s B a n d C . L a b e l t h e n e w c o l u mn ( c e l l C 3 ) “ R e c o r d I D ” Wo r l d R e c o r d s ! C 3 : R e c o r d I D 1 / 1 ( 1 0 0 . 0 %) F e e d b a c k : U s e t h e “ F i l l ” f e a t u r e o f E x c e l t o i n s e r t t h e n u mb e r s 1 t o 4 7 i n c e l l s C 4 : C 5 0 . 4 / 4 ( 1 0 0 . 0 %) F e e d b a c k : Ma k e t h e t a b l e h e a d e r s ( r a n g e B 3 : J 3 ) b o l d 2 / 2 ( 1 0 0 . 0 %) F e e d b a c k : C e n t e r t h e t a b l e h e a d e r s ( r a n g e B 3 : J 3 ) h o r i z o n t a l l y 2 / 2 ( 1 0 0 . 0 %) F e e d b a c k :
Ma k e c e l l B 2 b o l d Wo r l d R e c o r d s ! B 2 : f o n t . B o l d = T r u e 1 / 1 ( 1 0 0 . 0 %) F e e d b a c k : I t a l i z i c e c e l l B 2 Wo r l d R e c o r d s ! B 2 : f o n t . i t a l i c = T r u e 1 / 1 ( 1 0 0 . 0 %) F e e d b a c k : Ma k e c e l l G 2 b o l d Wo r l d R e c o r d s ! G 2 : f o n t . B o l d = T r u e 1 / 1 ( 1 0 0 . 0 %) F e e d b a c k : I t a l i z i c e c e l l G 2 Wo r l d R e c o r d s ! G 2 : f o n t . i t a l i c = T r u e 1 / 1 ( 1 0 0 . 0 %) F e e d b a c k : Me r g e a n d c e n t e r c e l l G 2 a c r o s s c o l u mn s G : J 2 / 2 ( 1 0 0 . 0 %) F e e d b a c k : C h a n g e t h e f o r ma t o f t h e d a t e r a n g e ( G 4 : G 7 3 ) t o “ S h o r t D a t e ”
2 / 2 ( 1 0 0 . 0 %) F e e d b a c k : R e s i z e c o l u mn B t o a w i d t h o f 2 8 . 0 ( 2 . 4 i n c h e s ) 1 / 1 ( 1 0 0 . 0 %) F e e d b a c k : R e s i z e c o l u mn C t o 8 . 7 1 ( . 7 9 i n c h e s ) B I S 2 2 1 T We e k 3 P r a c t i c e E x c e l B a s i c s Click on below link to buy https://tutorfortune.com/products/bis-221t-week-3-practice-excel-basics
