Neco 2022 Data Processing Question 15

Practice objective / multiple choice question 15 from the 2022 Neco Data Processing examination.

Neco 2022 Data Processing Objective / Multiple Choice Hard Difficulty

Question 15 NECO • 2022 • DATA_PROCESSING • objective

In a spreadsheet, cell B2 contains a salesperson's monthly sales amount (in Naira). The commission structure is:\n\n- 5 % on the first \u20A6 200,000,\n- 7 % on the next \u20A6 300,000 (i.e., from \u20A6 200,001 to \u20A6 500,000),\n- 10 % on any amount above \u20A6 500,000.\n\nWrite the Excel formula (using IF and arithmetic operators) that calculates the total commission in cell C2 based on the value in B2. Provide the formula exactly as it should be entered.

A. =IF(B2<=200000,0.05*B2,IF(B2<=500000,0.05*200000+0.06*(B2-200000),0.05*200000+0.07*300000+0.10*(B2-500000)))

Correct Answer B. =IF(B2<=200000,0.05*B2,IF(B2<=500000,0.05*200000+0.07*(B2-200000),0.05*200000+0.07*300000+0.10*(B2-500000)))

C. =IF(B2<200000,0.05*B2,IF(B2<=500000,0.05*200000+0.07*(B2-200000),0.05*200000+0.07*300000+0.10*(B2-500000)))

D. =IF(B2<=200000,0.05*B2,IF(B2<=500000,0.05*200000+0.07*(B2-200000),0.05*200000+0.07*300000+0.08*(B2-500000)))

Correct Answer

Correct Option:

=IF(B2<=200000,0.05*B2,IF(B2<=500000,0.05*200000+0.07*(B2-200000),0.05*200000+0.07*300000+0.10*(B2-500000)))

This is Neco 2022 Data Processing Question 15. It is one of the objective questions from the 2022 Neco Data Processing examination.

Difficulty level: Hard .

You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.

Unlock Full Access Available for Android & Windows

Chat with Support