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.