Assume that a spreadsheet developer would like to limit the data entered in cell A2 to...

 

 

Transcribed Image Text:

Assume that a spreadsheet developer would like to limit the data entered in cell A2 to a number that contains 5 digits. The first 3 digits must be between 100 and 200 and the last two digits must be between 01 and 09. Which of the following steps can the developer take to accomplish this? O The developer can use Custom Validation and use the following formula for the criteria: -(LEFT(A2,3) "100"AND LEFT(A2,3) <"200" AND RIGHT(A2,2) "012 AND RIGHT(A2,2)<"09" AND LEN(A2)-5) O The developer can use Custom Validation and use the following formula for the criteria: -AND(LEFT(A2,3)+"100"LEFT(A2,3) <"200",RIGHT(A2.2) "01"RIGHT(A2.2)<"09" LEN(A2)-5) The developer can use List Validation and enter the following in the Source box: LEFT(A2,3)>"100".LEFT(A2,3) <"200",RIGHT(A2,2) "01"RIGHT(A2,2)<"09".LEN(A2)-5 O The developer can use List Validation and enter the following in the Source box: TEXT(A2,">100),TEXT(A2 <200").TEXT(A2,">01),TEXT(A2,"<09").LEN(A2,"=5") The Chief Financial Officer of a large department store would like to create a chart showing sales data. The sales data will be broken down by major product type sold (Clothing. Housewares, Garden Supplies, Furniture, Food, etc.) Within each major product type, sales will be further subdivided. Clothing, for example, can be subdivided into Men's, Women's and Children's. Which of the following chart types best illustrates the relationship between each of the categories and sub-categories of sales? O Treemap Funnel Clustered Column Waterfall Bubble Assume that a spreadsheet developer would like to limit the data entered in cell A2 to a number that contains 5 digits. The first 3 digits must be between 100 and 200 and the last two digits must be between 01 and 09. Which of the following steps can the developer take to accomplish this? O The developer can use Custom Validation and use the following formula for the criteria: -(LEFT(A2,3) "100"AND LEFT(A2,3) <"200" AND RIGHT(A2,2) "012 AND RIGHT(A2,2)<"09" AND LEN(A2)-5) O The developer can use Custom Validation and use the following formula for the criteria: -AND(LEFT(A2,3)+"100"LEFT(A2,3) <"200",RIGHT(A2.2) "01"RIGHT(A2.2)<"09" LEN(A2)-5) The developer can use List Validation and enter the following in the Source box: LEFT(A2,3)>"100".LEFT(A2,3) <"200",RIGHT(A2,2) "01"RIGHT(A2,2)<"09".LEN(A2)-5 O The developer can use List Validation and enter the following in the Source box: TEXT(A2,">100),TEXT(A2 <200").TEXT(A2,">01),TEXT(A2,"<09").LEN(A2,"=5") The Chief Financial Officer of a large department store would like to create a chart showing sales data. The sales data will be broken down by major product type sold (Clothing. Housewares, Garden Supplies, Furniture, Food, etc.) Within each major product type, sales will be further subdivided. Clothing, for example, can be subdivided into Men's, Women's and Children's. Which of the following chart types best illustrates the relationship between each of the categories and sub-categories of sales? O Treemap Funnel Clustered Column Waterfall Bubble

Answer rating: 100% (QA)

Answer Q1 The correct option ... View the full answer