Chapter 1.1, Problem 2QC

what are the sixteen constraints

Why is it that a numeric field is usually allocated substantially more space than the data it contains at the start?

Disjoint restrictions overlap?

Please see the image below. Choose the corrrect answer

Why is it that a numeric field is typically given significantly more space than the initial data it stores?

Explain the importance of using cell references rather than constant values when creating formulas in a spreadsheet.

Please explain both correct and incorrect answer with explanation otherwise will dislike

A real Estate Company has in its poššession a long list of landlords and the rent cost of their two bedroom apartments, as shown on table 1. There is the need for an Application program that will allow a user at the company to load the said list into a computer program, i.e. the list of landlords and the cost of rent. The app must also allow users to search for apartments they can afford. Apart from the list in the table, the App should be able to take as input the maximum amount a tenant is willing to spend on a two-bedroom apartment and then display a list of landlords whose apartments can be rented with that amount. Table 1: Landlords and Cost of rent Landlord Ama Dua Ali Dulon John Togbe Abena Nyame Kofi Duku Cost of rent (GHC) 800.00 950.00 2,500.00 600.00 2,300.00