This puzzle consists of protected sheets 1-9, each describing how to extract a letter. This is further complicated by most sheets being hidden, preventing solvers from even looking at the sheet directly (since unhiding is prevented by the protection). Here is how you can solve each one:
=columns('1. The center column'!1:1). This returns 15, indicating that there are 15 columns in the first row of the sheet. The center column is therefore the 8th, or H.
=rows('2. The number of rows'!A:A). This returns 9, corresponding to the letter I.
=join("", flatten('4. The one nonempty cell'!A:Z)). (There's no reason why the spreadsheet must only contain the default columns A-Z, so you might first choose to check how many columns there are in a strategy like in the first sheet.) This joins together all values in all cells, yielding D.
=rows('5. The total number of cells'!A:A) *columns('5. The total number of cells'!1:1)This yields 18, corresponding to the letter R.
='6. The shape formed by the nonempty cells'!A1from A1 of the working sheet to every cell, then look visually. A fancier formula is something like
=let(therows, byrow('6. The shape formed by the nonempty cells'!A:Z, lambda(therow, join("", bycol(therow, lambda(thecell, if(thecell="", " ", thecell)))))), join(char(10), filter(therows, len(trim(therows))>0)))The result of the fancier formula (when displayed in a fixed width font) is:
# # # # # # # # # ##### # # # # # #which is clearly the letter A.
=let(allvals, flatten('7. sum(even vals) - sum(odd vals)'!A:Z), sum(filter(allvals, mod(allvals,2)=0))-sum(filter(allvals, mod(allvals,2)=1)))yields 14, giving an N.
flatten()turns an array into a single column, in usual left-to-right, top-to-bottom reading order, and thus its last nonempty entry will be the desired result.
=right(join("", flatten('8. The bottommost nonempty cell'!A:Z)))is a simple way to get the answer, which is C.
Putting together these letters gives the answer HINDRANCE.