Computer Science Excel
Exam LATEST 2025-2026
WITH QUESTI0NS AND
CORRECT VERIFIED
ANSWERS GRADED A+
100% PASS
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
2. click on merge and center in alignment tab
rename the sheet 1 worksheet with the new name "Sales" - ANSWER-1. right click on
the worksheet
2. click on rename
3. type in new name "Sales"
4. hit enter button
enter the text "2020 Sales" in the bar chart title placeholder - ANSWER-1. click on chart
title on bar chart
2. delete current title
3. enter the text "2020" sales
4. click any cell
change the color of the income statement sheet tab to green (standard colors section,
column 6) - ANSWER-1. right click on the income statement sheet tab
2. click on tab color
3. choose desired color
apply chart style 5 to the chart - ANSWER-1. click on chart
2. click on design tab
3. choose desired chart style
Add the data labels chart element to the Bar chart at the Outside End position. -
ANSWER-1. click on chart
2. click on green plus size
3. click data labels and choose outside end
change text direction of vertical axis to horizontal - ANSWER-1. right click on vertical
title and choose format
2. choose alignment
3. change text direction to horizontal
split worksheet - ANSWER-1. click on cell
2. click on view tab
Exam LATEST 2025-2026
WITH QUESTI0NS AND
CORRECT VERIFIED
ANSWERS GRADED A+
100% PASS
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
2. click on merge and center in alignment tab
rename the sheet 1 worksheet with the new name "Sales" - ANSWER-1. right click on
the worksheet
2. click on rename
3. type in new name "Sales"
4. hit enter button
enter the text "2020 Sales" in the bar chart title placeholder - ANSWER-1. click on chart
title on bar chart
2. delete current title
3. enter the text "2020" sales
4. click any cell
change the color of the income statement sheet tab to green (standard colors section,
column 6) - ANSWER-1. right click on the income statement sheet tab
2. click on tab color
3. choose desired color
apply chart style 5 to the chart - ANSWER-1. click on chart
2. click on design tab
3. choose desired chart style
Add the data labels chart element to the Bar chart at the Outside End position. -
ANSWER-1. click on chart
2. click on green plus size
3. click data labels and choose outside end
change text direction of vertical axis to horizontal - ANSWER-1. right click on vertical
title and choose format
2. choose alignment
3. change text direction to horizontal
split worksheet - ANSWER-1. click on cell
2. click on view tab
