Download
1 / 3
30 likes | 32 Views
BIS 221T Week 2 Practice Working with Tables//tutorfortune.com<br><br>Click on below link to buy<br>https://tutorfortune.com/products/bis-221t-week-2-practice-working-with-tables<br><br>BIS 221T Week 2 Practice Working with Tables<br> <br><br>Working With Tables<br><br>This assignment has a total of 100 points.<br><br>Practice problems are designed to help you apply what you have learned. It may be a good idea to complete the assignment on your own without help to see where you might need the most practice. Make only those changes that are specified in these directions. The Atlas Grader depends on existing text to identify portions of the document for grading.<br><br>Manipulating Tables<br><br>This taskset is to provide practice working with tables. The document that you start with has a single table already defined without boundary lines. To facilitate viewing the cells in the table, you should make sure that gridlines are visible. If gridlines are not visible turn them on by first clicking on any cell in the table. This makes the table menu tabs visible. Click on the Layout tab to show the Layout ribbon. Click on the View Gridlines menu icon.<br> <br>Task #<br>Points<br>Task Description<br>1<br>5<br>Add a new row to the top of the table, merge the new row so that it only has one cell. Cut the title above the table and paste the text into the new table row.<br>2<br>3<br>Insert a new column to the right of the fourth column.<br>3<br>5<br>Enter the title u201cPercentage Changeu201d in the second row of the new column. Autofit the column to the new text.<br>4<br>2<br>Now that you have added another column, you need to merge that new cell into the heading. Merge the two cells in the first row.<br>5<br>10<br>Enter the percent of change values in the Percentage Change column to reflect the percent of change between the two years. <br><br> <br>Percentage Change<br>0.93<br>2.59<br>1.61<br>2<br>1.67<br>3.09<br>4.13<br>3.23<br>-0.03<br>-0.21<br> <br><br> <br>6<br>6<br>If gridlines are showing on the table, turn them off. Add borders to the table. Select all the cells in the entire table and choose u201cAll bordersu201d using the Borders icon on the Table-Design ribbon.<br>7<br>5<br>Below the first table create a new table with four columns and five rows using the Graphic Grid on the Insert Table drop down.<br>8<br>5<br>Merge the first row of the table to make it one large cell.<br>9<br>7<br>Enter the title u201cSales by Division 2016u201d without the quotes in the merged cell. Change the alignment to center and the font size to 14pt.<br>10<br>6<br><br>BIS 221T Week 2 Practice Working with Tables<br><br>Click on below link to buy<br>https://tutorfortune.com/products/bis-221t-week-2-practice-working-with-tables<br>
E N D
BIS 221T Week 2 Practice Working with Tables//tutorfortune.com Click on below link to buy https://tutorfortune.com/products/bis-221t-week-2-practice-working-with-tables B I S 2 2 1 T We e k 2 P r a c t i c e Wo r k i n g w i t h T a b l e s Wo r k i n g Wi t h T a b l e s T h i s a s s i g n me n t h a s a t o t a l o f 1 0 0 p o i n t s . P r a c t i c e p r o b l e ms a r e d e s i g n e d t o h e l p y o u a p p l y w h a t y o u h a v e l e a r n e d . I t ma y b e a g o o d i d e a t o c o mp l e t e t h e a s s i g n me n t o n y o u r o w n w i t h o u t h e l p t o s e e w h e r e y o u mi g h t n e e d t h e mo s t p r a c t i c e . Ma k e o n l y t h o s e c h a n g e s t h a t a r e s p e c i fi e d i n t h e s e d i r e c t i o n s . T h e A t l a s G r a d e r d e p e n d s o n e x i s t i n g t e x t t o i d e n t i f y p o r t i o n s o f t h e d o c u me n t f o r g r a d i n g . Ma n i p u l a t i n g T a b l e s T h i s t a s k s e t i s t o p r o v i d e p r a c t i c e w o r k i n g w i t h t a b l e s . T h e d o c u me n t t h a t y o u s t a r t w i t h h a s a s i n g l e t a b l e a l r e a d y d e fi n e d w i t h o u t b o u n d a r y l i n e s . T o f a c i l i t a t e v i e w i n g t h e c e l l s i n t h e t a b l e , y o u s h o u l d ma k e s u r e t h a t g r i d l i n e s a r e v i s i b l e . I f g r i d l i n e s a r e n o t v i s i b l e t u r n t h e m o n b y fi r s t c l i c k i n g o n a n y c e l l i n t h e t a b l e . T h i s ma k e s t h e t a b l e me n u t a b s v i s i b l e . C l i c k o n t h e L a y o u t t a b t o s h o w t h e L a y o u t r i b b o n . C l i c k o n t h e V i e w G r i d l i n e s me n u i c o n . T a s k # P o i n t s T a s k D e s c r i p t i o n 1 5 A d d a n e w r o w t o t h e t o p o f t h e t a b l e , me r g e t h e n e w r o w s o t h a t i t o n l y h a s o n e c e l l . C u t t h e t i t l e a b o v e t h e t a b l e a n d p a s t e t h e t e x t i n t o t h e n e w t a b l e r o w . 2 3 I n s e r t a n e w c o l u mn t o t h e r i g h t o f t h e f o u r t h c o l u mn .
3 5 E n t e r t h e t i t l e “ P e r c e n t a g e C h a n g e ” i n t h e s e c o n d r o w o f t h e n e w c o l u mn . A u t o fi t t h e c o l u mn t o t h e n e w t e x t . 4 2 N o w t h a t y o u h a v e a d d e d a n o t h e r c o l u mn , y o u n e e d t o me r g e t h a t n e w c e l l i n t o t h e h e a d i n g . Me r g e t h e t w o c e l l s i n t h e fi r s t r o w . 5 1 0 E n t e r t h e p e r c e n t o f c h a n g e v a l u e s i n t h e P e r c e n t a g e C h a n g e c o l u mn t o r e fl e c t t h e p e r c e n t o f c h a n g e b e t w e e n t h e t w o y e a r s . P e r c e n t a g e C h a n g e 0 . 9 3 2 . 5 9 1 . 6 1 2 1 . 6 7 3 . 0 9 4 . 1 3 3 . 2 3 - 0 . 0 3 - 0 . 2 1 6 6 I f g r i d l i n e s a r e s h o w i n g o n t h e t a b l e , t u r n t h e m o ff . A d d b o r d e r s t o t h e t a b l e . S e l e c t a l l t h e c e l l s i n t h e e n t i r e t a b l e a n d c h o o s e “ A l l b o r d e r s ” u s i n g t h e B o r d e r s i c o n o n t h e T a b l e - D e s i g n r i b b o n . 7 5 B e l o w t h e fi r s t t a b l e c r e a t e a n e w t a b l e w i t h f o u r c o l u mn s a n d fi v e r o w s u s i n g t h e G r a p h i c G r i d o n t h e I n s e r t T a b l e d r o p d o w n . 8 5 Me r g e t h e fi r s t r o w o f t h e t a b l e t o ma k e i t o n e l a r g e c e l l . 9
7 E n t e r t h e t i t l e “ S a l e s b y D i v i s i o n 2 0 1 6 ” w i t h o u t t h e q u o t e s i n t h e me r g e d c e l l . C h a n g e t h e a l i g n me n t t o c e n t e r a n d t h e f o n t s i z e t o 1 4 p t . 1 0 6 B I S 2 2 1 T We e k 2 P r a c t i c e Wo r k i n g w i t h T a b l e s Click on below link to buy https://tutorfortune.com/products/bis-221t-week-2-practice-working-with-tables
