I'm not quite sure how one could make it even more obvious without punching the user in the face.
Looks kind of like someone filtered / hid some data and then just highlighted the cells. This captures the range of all cells from the top selection to the bottom selection. Not just the visible cells. The subtotal function will operate on just the visible cells. And there is some menu option for selecting only visible cells too.
I have been bitten by this but you are correct - after unfiltering the data excel very clearly shows me my mistake with a colored border around many cells I didn't want selected.
By the time book 4 is ready copyright has expired on book 1. It's not really worth anyone else printing book 1 as its available on e-readers for free. No-one else will make a deal with Ms Moss under better terms for book 5 because they can't do the group deal for books 2-4. I can negotiate Ms Moss down to almost nothing. I can keep printing book 1 and pay her nothing.
First, I am not sure that Ms Moss could not find a decent deal for her next book. She has shown a track record of bringing in money. Surely some publishers could find a way to make money off a successful author's next book.
Second, the publishing industry is changing, and this sounds like it may hasten that change. More self-publishing opportunities will emerge. Advertising will be much more social - people will get book ideas from trusted review and recommendation sites rather than expensive glossy advertising in magazine and on TV (note: I don't actually know if that advertising exists still since I don't read magazines or watch TV
Third, the short copyright period makes Ms. Moss need to create more fantastic works to keep her royalty checks coming in, thus enriching the culture with her memorizing stories, inspiring new authors to pursue writing stories of their own. Granted - this will result in a glut of crap flooding into the market but that will result in more opportunities for people to create curated lists of recommended books (see point #2 above).
Looks like a nice future to me.
... so employees don't have to head out to the local BJ's
So you're saying Apple is going to start supplying in-house BJ's next?
The response to my comments on Sample Item 7 for SC.4.E.6.2 (page 42), I was told: "Here again I don't disagree with your science; however, elementary educators consistently told us that glass plates are not used in elementary classrooms for safety reasons. They did not feel that 5th graders would be familiar with using glass plates to test hardness."
Hmmm... This is interesting logic. We don't send 5th graders to war either so should we not teach about WWI, WWII, etc? That would certainly make history class a lot shorter.
The IQ of the group is the lowest IQ of a member of the group divided by the number of people in the group.