For this question I need the step-by-step instructions
on how to accomplish this task.

You work at ABC Electronic and this is your first day. Your
supervisor has given you a task to inventory all of the small
electronics such as mp3’s, iPods and tablets in MS Excel. Your
supervisor has a list of columns that are mandatory which are item
name, bar code number, item quantity, cost per item and total cost
for each item. Additionally, you must highlight, in yellow, any
item quantity below 5 so a refill order can be placed. Explain how
you will calculate the necessary values, format the titles,
headings and the data contents of each column, and organize the
data to facilitate management action.