Answer: Column F
Explanation: In Microsoft excel, for the sake of robustness and to aid the effectiveness of updating formulas across cells. The reference of cells are treated as relative which means that when formulas are copied across columns or within rows, they get updated automatically. However, some numbers may be treated as constants such that we do not want them to change or be updated as we move acisss cells. Thus, such numbers are treated Given absolute references, which is made possible by adding a '$' prefix before the colum alphabet or row number or both. in the scenario given above, the row has the $ prefix, hence, it is absolute and will not change but the column alphabet does not and hence, treated as relative.
Answer:
The function is as follows:
def concList(aList):
retList = ""
for i in aList:
if(str(i).isdigit()):
retList+=str(i)
else:
retList = "Not digits"
break;
return retList
Explanation:
This defines the function
def concList(aList):
This initializes the return string to an empty string
retList = ""
This iterates through aList
for i in aList:
This converts each element of the list to an empty list and checks if the string is digit
if(str(i).isdigit()):
If yes, the element is concatenated
retList+=str(i)
If otherwise
else:
The return string is set to "No digits"
retList = "Not digits"
And the loop is exited
break;
This returns the return string
return retList
Answer:
The correct option is D = regionNumber
Explanation:
In this scenario we want to know customers who owe more than $1000 each, in each of 12 sales regions. And the customer data variables include name, zip-code, balanceDue and regionNumber; based on the customer data variables names and zip-code will not really affect our output. It is based on balanceDue that we increment the number of customer owing in a particular region (regionNumber).
Therefore, we would add 1 to an array element whose subscript would be represented by regionNumber since we are interested to know the number of customer owing in each of the 12 sales regions.
Answer:
<fact>[ZRjKt9sw6V(gh6E)ehNM3]<zip>
Explanation: