City Guilds Model Questions Vol1 2018 Information Technology Question 1

Practice objective / multiple choice question 1 from the 2018 City Guilds Model Questions Vol1 Information Technology examination.

City Guilds Model Questions Vol1 2018 Information Technology Objective / Multiple Choice Medium Difficulty
Question 1 CITY_GUILDS_MODEL_QUESTIONS_VOL1 • 2018 • INFORMATION_TECHNOLOGY • objective

In a spreadsheet, cell D1 contains the tax rate 0.05 and cell C2 contains a fixed fee of 30. Column A lists the amounts: A2=50, A3=80, A4=120, A5=200. In cell B2 the formula is =IF(A2>150, A2*$D$1*0.9 + $C$2, A2*$D$1 + $C$2). When this formula is copied down to cell B5, what value appears in B5?

Answer Options

A. 40
B. 38
Correct Answer C. 39
D. 45
Correct Answer
C
Correct Option:
39

About This Question

This is City Guilds Model Questions Vol1 2018 Information Technology Question 1. It is one of the objective questions from the 2018 City Guilds Model Questions Vol1 Information Technology examination.

Difficulty level: Medium .

View More City Guilds Model Questions Vol1 2018 Information Technology Questions More City Guilds Model Questions Vol1 Practice Questions Back to Questions

Master the Exam!

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