Insert a Column ChartĬlick anywhere in your data and press the key that looks – a bit – like a column chart: F11. These two shortcuts work best in a table, as it won’t prompt you to shift cells or entire rows or columns.
Insert or Delete Rows and Columnsĭid you know you can press CTRL + SHIFT + plus sign to add cells to your workbook and CTRL + minus sign to delete cells? So, one less key for deleting – intuitive, right? AUNT SALLY are controlled exclusively by Dramatists Play Service, Inc., 440 Park. If you use CTRL + SPACEBAR in a column in an Excel table, it selects all data in that column, no matter where your cursor is. States, its territories, possessions and Canada for PLEASE EXCUSE MY DEAR. To remind myself whether to hold down CTRL or SHIFT, I use the first letter trick: C = CTRL = Column. In Excel, you can press CTRL + SPACEBAR to select a column and SHIFT + SPACEBAR to select a row. If F2 does something else on your laptop, you also need to hold down the Fn key. There were different events at the Math Olympics and I competed in Mental Math, a fierce battle to solve math problems without the use of a calculator or even. Yeah, in addition to being an athlete, I was a bit of a nerd. ?? is used to switch to edit mode and ????? + ?? is its big brother and will insert a sticky note. In sixth and seventh grade, I competed in the county Math Olympics. If you use F2 in Excel, you might also like ????? + ??. 2 Sets of Posters including the Order of Operations mnemonic PEMDAS (Please Excuse My Dear Aunt Sally).Click Here for the matching King Henry Metric System PostersClick Here for the matching Customary System Posters - Length, Capacity, and Weight Subjects: Basic Operations, Math, Order of Operations. Stuff from days when I'm phoning it in.Here are more handy Excel tips: Insert a Note.Words, please excuse my dear aunt sally works, but she has to start at the leftĪnd do the functions in the order they appear moving to the right.ĭuring the conversation, it dawned on me why I was a theater major at Ohio StateĪlthough everyone may have convinced me to change my answer, but they’ll never get me to abandon my belief that math and neckties are of the devil.Īnd, since it’s Monday and school is about to start… + 2 part was right because they were in parentheses.īut multiplication came last this time as the action of division was the first in line. He pointed out in his “calm I taught ( stupid) kids ( like you) math for 45 years way” that even tough please excuse my dear aunt sally was the way to go, the order of the actions took precedence.
I googled, I searched, and I used a calculator.Ĭonfused, I did the only thing I knew to do. If I was wrong, my new quest was to find out what I’d missed in Mr.
The wrong answer to a math question could mean we missed the spot whenĪttempting to land on the moon, I felt compelled to find the truth. Please Excuse My Dear Aunt Sally, She’s Leaving Math For Good Math Is Trending I presumed it was an excellent day when I saw that math was trending on Twitter until I saw some of the responses and that the overall math message was lost in the problem that was trending. Nerdy barbs such as “…look, I’ve got two math degrees, and I know it’s 1…” and “…I have taught math for 35 years and I know it’s 16…” were plenteous. The internet, there were those who agreed with me that it was 1 and there were I was confused, flummoxed, bewildered, and… Internet, there were those out there who said the answer was 16. Please Excuse My Dear Aunt Sally, Shes Leaving Math For Good Math Is Trending I presumed it was an excellent day when I saw that math was trending on. They would do math functions in the right order. My dear Aunt Sally was a learning tool math teachers taught kids to remember so I immediately remembered the old please excuse my dear Aunt Sall y line from all those tech level math classes I suffered through back in my days at Brookwood. I really don’t care who follows me because it’s the one place I don’t say much. I have reduced my followings to about 7, and The bathroom wall of the internet where no one is at there best. Much ado on the internet last week around a math equation.
It again, “math and neckties are of the devil.” 0 Flares Twitter 0 Facebook 0 Filament.io 0 Flares ×