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 meplease help me answer this question correctly . please do in computer

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!