![]() ![]() Values Version - this is the default view and lets you see the results of the formulas and functions in each cell.įormulas Version - this lets you see the functions and formulas in each cell instead of the value from the computation.ĭebugging - the process of checking your formulas or functions to find errors. It also lets you see if you have a stray character that will cause you to print 100 pages instead of just 1. This allows you to check to see what is being cut off and placed on a separate page. Previewing the Worksheet - When you print an Excel Worksheet you should ALWAYS print preview before printing. Normal View - the default view of Excel allowing you to adjust the margins, header or footer. Page Layout - a view of the worksheet that lets you edit the worksheet while seeing how it will look in printed form. ![]() Spell Checker - An operation in Excel that looks for possible spelling errors in a worksheet, comparing the words against a standard dictionary of words. A resolution of 1024X768 means that you have 1024 pixels across and 768 pixels down the screen. The size of the dot is based on your screen resolution. It represents on dot of color on a screen. Pixel - The smallest element of a graphic. You could change the color of numbers to blue for any number over 1,000,000 for example.Ĭondition - A relation between at least two values. Theme - a set of predefined colors, fonts, chart styles, cell styles,a nd fill effects in an Excel Workbook.Īccounting Number Format - displays the numbers as a dollar value with the dollar sign to the left of the numbers, a comma every three digits and rounded to the nearest hundredth.įixed dollar sign - the dollar sign in a cell is to the far leftįloating dollar sign - the dollar sign is just to the left of the numbersĬomma Style Format - uses commas but no dollar signs in the numbersĬonditional Formatting - Formatting that changes depending on the value in the cell, or what condition the value meets. Very convenient if you have accidentally clicked on the wrong row or column for one of the values. Range Finder - A helping function in Excel that checks which cells are referenced in a formula. Min - A function that will display the lowest value in a range of cells Max - A function that will display the highest value in a range of cells In a SUM function it would be the list of cells you want to add together: =SUM(C2:C15) This means to add the values in the cells from C2 down to C15.Īverage - Sums the numbers in a range and then divides by the number of cells in that range. Smart Tag Indicator - the small purple triangle itself is the indicator that a smart tag is availableĪrguments - The values that you plug into a function are called the arguments. Clicking on this purple triangle gives a list of actions you can perform for that cell Smart Tags - Dates, financial symbols, people's names, indicated by a small purple triangle in the cell. Point Mode - selecting cells for a formula by clicking on them with the mouse A & S - Addition and Subtraction taken left to right.M & D - Multiplication and Division taken left to right.Order Of Operations - PMDAS (Please Excuse My Dear Aunt Sally) 2.4 Verify a formula with the range finderįunction - pre-written formula built into Excel that takes different values and performs an operation: SUM, AVERAGE, MAX, MIN.2.1 Type in the following Table into Excel.* No Expensive software (Microsoft Excel) needed!ġ) This is an instant digital download no physical product will be shipped to you.Ģ) No refunds, exchanges, or cancellations on digital purchases.ģ) FOR PERSONAL USE ONLY- files may not be shared or re-sold.Ĥ) This budget is meant to be a best guess when forecasting. ![]() * Make adjustments to reoccurring transactions if needed * Make adjustments to spending and/or saving now based on what you see in the future! * Answer questions like: "Can I go on vacation now and still have enough money to pay the bills later in the year?" * Most budget plans only look at the now or the past. No Google Sheets Experience Necessary! Get control of your finances! Get answers to questions like "Will I have enough money 6 months from now if I go on this Vacation?" or "When will I have enough money to buy that new Car?" Start to give each dollar a home. Use this budget to plan your finances as far out as 3 Years! Set up in as little as 10-15 minutes. Take the stress out of managing your money!! Once you purchase, you'll be given a link to a PDF download which will have a link to my Work Smarter Budget Template. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |