Computer Science Excel Exam NEWEST WITH
QUESTI0NS AND CORRECT VERIFIED ANSWERS||
GRADED A+|| 100% PASS ||GRADED A+|| LATEST
UPDATE 2025/26
center the contents of a cell horizontally -CORRECTANSWER 1. click on cell
2. click on center horizontal button on home screen in second row
apply the bad style to a cell -CORRECTANSWER 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) -CORRECTANSWER 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) -
CORRECTANSWER 1. highlight cell range
2. click on number (in home page)
3. choose the comma button
, bold a cell -CORRECTANSWER 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 -
CORRECTANSWER 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)
-CORRECTANSWER 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 -CORRECTANSWER 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 -CORRECTANSWER 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. -
CORRECTANSWER 1. click on cell G4
2. type in the equal sign (=)
QUESTI0NS AND CORRECT VERIFIED ANSWERS||
GRADED A+|| 100% PASS ||GRADED A+|| LATEST
UPDATE 2025/26
center the contents of a cell horizontally -CORRECTANSWER 1. click on cell
2. click on center horizontal button on home screen in second row
apply the bad style to a cell -CORRECTANSWER 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) -CORRECTANSWER 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) -
CORRECTANSWER 1. highlight cell range
2. click on number (in home page)
3. choose the comma button
, bold a cell -CORRECTANSWER 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 -
CORRECTANSWER 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)
-CORRECTANSWER 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 -CORRECTANSWER 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 -CORRECTANSWER 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. -
CORRECTANSWER 1. click on cell G4
2. type in the equal sign (=)
