Answer:
The answer is given below in explanation section.
Explanation:
As asked in the question Sanford is creating an excel spreadsheet and needs to insert many workbooks sheets to organize his data, then what is the limit of the number of worksheets excel con contain.
The excel spreadsheet contains as many worksheets as you want but it is limited by the available memory of your computer and system resources. If you have very little memory then you cannot create many worksheets. If you have memory in GBs then you can create thousands of worksheets.
However, it is noted that to create the worksheet is not limited by Excel but it is limited by avilabe memory and system resources. If you have enough computer memory and resources like CPU power etc, then you can create worksheet as many as you want.
It is also noted that the excel worksheet is limited by its number of rows and number of columns it contains e.g. the total number of rows and columns on a worksheet are 1,048,576 rows by 16,384 columns.
If you want to study more about Excel limitation and specifications, the following link may help you
https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3
Best to have as many as possible. However usually 3
Answer:
TreeNode minimum(TreeNode root) {
if (root != null) {
if (firstChild == null && nextSibling == null) {
return root;
} else {
TreeNode begin = minimum(root.firstChild);
TreeNode last = minimum(root.nextSibling);
if (begin == false && (last == false || begin.data < last.data)) {
return begin;
} else {
return last;
}
} else {
return null;
}
}
Explanation:
The Java program defines a recursive method called minimum that calls itself twice with the first and last leaf of the treenode as the respective arguments. and returns the minimum value of the treenode if the root argument is not undefined.
