MOS EXCEL CORE FUNCTION /FORMULAS
EXAM 2024
On the Cash worksheet, in cell B20, enter a formula to add the values
in cells B9 through B19. - ANSWER =SUM(B9:B19)
On the Cash worksheet, in cell B22, enter a formula using relative
cell addresses that finds the difference between total income in cell
B6 and total expenses in cell B20. - ANSWER =B6-B20
In cell R55, use a function to sum the Pledge value from the Pledges
table for all records whose Zip Code value is 66210. - ANSWER
SUMIF
Create a formula in cell H6 using a text that returns the first name
from the entry in cell A6. The formula should use cell G6 which
calculates the length of the first name. - ANSWER LEFT
For the range C6:C41, create a format that changes the font color to
red for values that are greater than or equal to 50. - ANSWER
Conditional Format
In the Sales Commission worksheet insert a formula in cell G4 that
references the data in the Total Sales column (column E) and the
Commission rate (cell I2) in cell J3 to calculate the values in the
Commission column. - ANSWER =E5*$I$2
On the Small Tree Sales worksheet insert a formula in cell F20 that
uses a built-in Excel function to return the value of the smallest value
in the Total column. - ANSWER MIN
On the Food Inventory worksheet enter a function in cell G1 that
counts the number of food items. - ANSWER COUNT
On the Revenue worksheet enter a formula in cell J10 that uses a
EXAM 2024
On the Cash worksheet, in cell B20, enter a formula to add the values
in cells B9 through B19. - ANSWER =SUM(B9:B19)
On the Cash worksheet, in cell B22, enter a formula using relative
cell addresses that finds the difference between total income in cell
B6 and total expenses in cell B20. - ANSWER =B6-B20
In cell R55, use a function to sum the Pledge value from the Pledges
table for all records whose Zip Code value is 66210. - ANSWER
SUMIF
Create a formula in cell H6 using a text that returns the first name
from the entry in cell A6. The formula should use cell G6 which
calculates the length of the first name. - ANSWER LEFT
For the range C6:C41, create a format that changes the font color to
red for values that are greater than or equal to 50. - ANSWER
Conditional Format
In the Sales Commission worksheet insert a formula in cell G4 that
references the data in the Total Sales column (column E) and the
Commission rate (cell I2) in cell J3 to calculate the values in the
Commission column. - ANSWER =E5*$I$2
On the Small Tree Sales worksheet insert a formula in cell F20 that
uses a built-in Excel function to return the value of the smallest value
in the Total column. - ANSWER MIN
On the Food Inventory worksheet enter a function in cell G1 that
counts the number of food items. - ANSWER COUNT
On the Revenue worksheet enter a formula in cell J10 that uses a
