Excel 2016: formula not calculating

Home computer use can mean self-tutoring. The tutor shares an idea about cell formatting in Excel.

Yesterday, using Excel 2016, I began a new spreadsheet and discovered a formula wouldn’t calculate. When I entered, for instance, =6+7, it wouldn’t evaluate to 13; the cell would simply continue to say =6+7. I’ve never encountered that behaviour.

I looked around the internet for a solution. The cell, many suggested, might be formatted as Text, in which case it would remain what was literally entered.

Checking its format, however, it said General.

Perhaps I accidentally changed the format to Text. (I can’t easily imagine that happening.) Anyway, what I seem to have learned is that just changing the format, once it’s been Text, won’t cause the formula to calculate. First you need to delete the cell’s contents, then change its format to General (for instance), then re-enter the formula. Then, the formula will calculate.

Source:

answers.microsoft.com

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

Lifestyle: cooking: what is freezer temperature meant to be?

Lifestyle, for me, leads to endless self-tutoring. The tutor shares the answer to a question he’s often wondered.

ideal freezer temperature

Freezer temperature is meant to be -18C or below (0F or below).

Apparently, food stored at -18C will remain safe to eat, although it may eventually lose its tastiness, depending on the duration.

Source:

www.fda.gov

www.thekitchn.com

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

Java: running program when path not set

Tutoring comp sci, you experiment a lot. The tutor shares one.

The java command, in Windows, anyway, seems to like a space between the directory and the filename you are running.

java -cp f:/dir1/dir2 program_file

not

java -cp f:/dir1/dir2/program_file

Source:

stackoverflow.com

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

History: Battle of Hastings: what was William’s claim?

Tutoring history or social studies, you might be asked about the Battle of Hastings. The tutor explains why it happened.

William’s claim

William of Normandy was a cousin of Edward the Confessor, King of England 1042-1066. Supposedly, William visited Edward, in England, in 1051. Some believe that, during that visit, Edward promised he would name William to succeed him as King of England.

Edward the Confessor died in January 1066; just before, he named Harold Godwine to take over as England’s king. Thinking the English crown had already been promised to him, William invaded England in September 1066 to claim his right.

Source:

www.history.com

www.bbc.co.uk

www.historylearningsite.co.uk

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

English: what does opprobrium mean?

Tutoring English, vocabulary is always important. The tutor defines opprobrium.

opprobrium (noun):

1. disgrace or criticism for disapproved behaviour

2. a cause of disgrace.


Source:

Mish, Frederick C. The Merriam-Webster Dictionary. Springfield: Merriam-Webster, 2004.

Barber, Katherine C. Oxford Canadian Dictionary of Current English. Don Mills: Oxford University Press, 2005.

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

English, economics, history: what is mercantilism?

Tutoring a number of subjects, the term mercantilism might arise. The tutor defines it.

mercantilism

economic policy that favours exports, discourages imports, and has the objective of amassing precious metals.

Source:

Barber, Katherine et al. Oxford Canadian Dictionary of Current English. Don Mills: Oxford University Press, 2005.

www.investopedia.com

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

Coordinating conjunctions: yet

Tutoring English, the coordinating conjunctions are important. The tutor brings up yet.

Yet is a coordinating conjunction that can add meaning. Consider the following two sentences:

The owner threw the ball far away, but his dog fetched it.

The owner threw the ball far away, yet his dog fetched it.

Perhaps the word yet can give a livelier sense sometimes.

Source:

Hodges, Horner et al. Harbrace Handbook for Canadians. Scarborough: Nelson Education, 2003.

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

Math: commutative operations

Tutoring math, you encounter definitions. The tutor defines commutative.

commutative adj
describes an operation for which the order of the inputs doesn’t change the output. Since 6×7=7×6, multiplication is commutative. So is addition.

Source:

Gallian, Joseph A. Contemporary Abstract Algebra. Toronto: D.C. Heath and Company, 1994.

Jack of Oracle Tutoring by Jack and Diane Campbell River, BC.

Math: what does associative mean?

Tutoring math, you mention definitions. The tutor defines associative.

associative(adj):

independent of grouping: for instance, (a+b)+c = a+(b+c), meaning that addition is associative. Multiplication is associative as well.

Source:

Gallian, Joseph A. Contemporary Abstract Algebra. Toronto: D.C. Heath and Company, 1994.

Oracle Tutoring by Jack and Diane, Campbell River, BC.

Lifestyle, cooking: microwave cooking: standing time

Still more lifestyle tutoring evolves as the tutor researches cooking with the microwave.

Standing time:

similar to resting time, it’s a period food is left alone after being cooked in the microwave.

The microwave targets some food molecules – water, for instance – preferentially. They absorb energy during microwave cooking. After removal from the microwave, that energy can transfer to surrounding food molecules, causing the portion to heat up. Therefore, the temperature of the portion can rise during standing time.

Source:
www.fsis.usda.gov

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.