contestada

ensure the sales worksheet is active. enter a function in cell b8 to create a custom transaction number. the transaction number should be comprised of the item number listed in cell c8 combined with the quantity in cell d8 and the first initial of the payment type in cell e8. use auto fill to copy the function down, completing the data in column b.

Respuesta :

azikennamdi

In the above Microsoft Excel scenario, note that the resulting data in column B will show the custom transaction numbers, which are comprised of the item number, quantity, and first initial of the payment type for each transaction.

What is the explanation of the process that gives the above results?

To create a custom transaction number in cell B8 on a sales worksheet, the following steps can be taken:

Ensure that the sales worksheet is active by selecting it from the tabs at the bottom of the screen.

In cell B8, enter the following function:

=CONCATENATE(C8,D8,LEFT(E8,1))

This function will combine the item number in cell C8 with the quantity in cell D8 and the first initial of the payment type in cell E8 to create the custom transaction number.

Use the auto-fill function to copy the formula in cell B8 down the column. This will create the custom transaction number for each row in the data.

Learn more bout Microsoft Excel:
https://brainly.com/question/10444759
#SPJ1

Otras preguntas