Question: please help me answer this question correctly . please do in computer please help me 3. Copy the table below to a new excel spreadsheet.
please help me answer this question correctly . please do in computer please help me
3. Copy the table below to a new excel spreadsheet. Make sure the position is exactly the same in the specific cell, for example Name must be in cell A1, Michael in cell A2, and so on. 1 Annual Name Surname Position Full Name Age Salary (RM) 2 Michael Jordan Chief Executive Michael Jordan 50 200,000 3 Albert Einstein Scientist Albert Einstein 38 600,000 4 Janice Alexis General Manager Janice Alexis 37 80,000 5 Smith Johnson Technician Smith Johnson 25 75,000 6 Jenny Peterpan Promoter Jenny Peterpan 23 60,000 Based on the above table in excel spreadsheet, complete the questions below: i) in Full Name column (D2-D6), replace it with a function that combines the name and the surname. [10 marks] ii) Use Conditional formatting to highlight all the Annual Salary (RM) less more than RM85,000. [10 marks] iii) Use Power point to create a presentation slides to explain all the steps used in 3 (i) and (ii). [30 marks]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
