Computer Science Excel Exam
Questions & Answers
center the contents of a cell horizontally - ANSWER-1. click on cell
2. click on center horizontal button on home screen in second row
apply the bad style to a cell - ANSWER-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) - ANSWER-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) - ANSWER-1. highlight cell range
2. click on number (in home page)
3. choose the comma button
bold a cell - ANSWER-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 - ANSWER-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) - ANSWER-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 - ANSWER-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 - ANSWER-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 Salary, less
Healthcare, for the employee by taking the value in cell C4, adding the product of cell C4 multiplied by
cell E4, and then subtracting the value in cell F4. - ANSWER-1. click on cell G4
2. type in the equal sign (=)
3. click on cell C4
4. type in the plus sign (+)
5. click on cell C4 (again)
6. type in the multiplication sign (*)
7. click on cell E4
8. type in subtraction sign (-)
9. click on cell F4
10. hit enter button
in a cell, enter a formula using the SUM function to total the values in a cell range (B4:B15) - ANSWER-1.
click on a cell
2. type in the equal sign (=)
3. type in SUM(
4. highlight cell range
5. hit enter
merge and center the contents of cell range (ex: A2:D2) - ANSWER-1. highlight cell range
Questions & Answers
center the contents of a cell horizontally - ANSWER-1. click on cell
2. click on center horizontal button on home screen in second row
apply the bad style to a cell - ANSWER-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) - ANSWER-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) - ANSWER-1. highlight cell range
2. click on number (in home page)
3. choose the comma button
bold a cell - ANSWER-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 - ANSWER-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) - ANSWER-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 - ANSWER-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 - ANSWER-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 Salary, less
Healthcare, for the employee by taking the value in cell C4, adding the product of cell C4 multiplied by
cell E4, and then subtracting the value in cell F4. - ANSWER-1. click on cell G4
2. type in the equal sign (=)
3. click on cell C4
4. type in the plus sign (+)
5. click on cell C4 (again)
6. type in the multiplication sign (*)
7. click on cell E4
8. type in subtraction sign (-)
9. click on cell F4
10. hit enter button
in a cell, enter a formula using the SUM function to total the values in a cell range (B4:B15) - ANSWER-1.
click on a cell
2. type in the equal sign (=)
3. type in SUM(
4. highlight cell range
5. hit enter
merge and center the contents of cell range (ex: A2:D2) - ANSWER-1. highlight cell range
