Computer Science 101 FINAL Excel Exam [100% PASS]

Computer Science 101 FINAL Excel Exam [100% PASS] center the contents of a cell horizontally *Ans* 1. click on cell 2. click on center horizontal button on home screen in second row apply the bad style to a cell *Ans* 1. click on the cell 2. click on cell styles 3. chose bad style Apply the Accounting number format, using the dollar sign ($) and two decimal places, to a cell range (ex: C4:C15) *Ans* 1. highlight cells 2. right click on cells 3. click on format cells 4. click on number, then choose accounting. 5. make sure to choose 2 decimal places and dollar sign apply the comma style number format to a cell range (ex: C4:C15) *Ans* 1. highlight cell range 2. click on number (in home page) 3. choose the comma button bold a cell *Ans* 1. click on cell 2. click on the dark B (bold button) under the font format column (ex: d) using auto fit so that all cell content is visible *Ans* 1. click on column 2. double click on column line change the color of the font in a cell (ex: D9) to blue (standard colors section, column 8) *Ans* 1. click on cell 2. go into home and click the letter with the underlined color 3. choose the desired color change the font of a cell to cambria *Ans* 1. click on the cell 2. click on the font style button arrow and change to desired font change the size of the font of a cell *Ans* 1. click on cell 2. click on font size number and change to desired font size Without using parentheses, enter a formula in cell G4 that determines the Projected 2021 Salar