Chapter 1 Practice 2 - Formatting and Cell Movement

Chapter 1 Practice 2 - Formatting and Cell Movement - A B C...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: A B C D E F G H I Your Name in 16-Point White Text on Blue Background Move to cell B5 and change text appropriately Center black text with yellow background this text in green Italicize This is red text underlined Boldface this text in violet Italicize in Times New Roman and center Boldface the first word only Boldface and Italicize in Orange Arial Indent this text and color it bold green Right align blue text Format the cell on the right as currency with two decimals 123.45 Format the cell on the right as percent with one decimal 0.99 Format the cell on the right as a fraction 0.75 Format the cell on the right as date to include the printed month 36973 Format the cell on the right as a social security 111223333 number DELETE THIS CELL (All other cells move up in the column) Delete the cell that originally above this cell change to blue text. Split the text originally in this merged cell into two cells. Type "Do this first" in 18-point blue text in the resulting blank cell on the right. Change row height to 42 Change the width of column A to 55 Change the width of column B to AutoFit Do this last. Merge and center the two cells in this row. Change the row height to 27. Wrap the text in the merged cells. Change the font to red. This was a gre 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Insert this cell two rows above the last row in column A J K L M N O P 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 p the text in the merged cells. Change the font to red. This was a great exercise. I can move, insert, and delete individual cells. 17 18 19 20 ...
View Full Document

This note was uploaded on 08/21/2011 for the course COMP 230 taught by Professor Phil during the Spring '11 term at DeVry NY.

Ask a homework question - tutors are online