1 / 18

Excel Formulas and Functions Review for Beginners

Explore essential Excel formulas, functions, and features in this comprehensive review session. Learn about order of operations, merging cells, data display, chart creation, cell management, and more to enhance your Excel skills.

elom
Télécharger la présentation

Excel Formulas and Functions Review for Beginners

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Integrated Technology IExcel Review Mr. Ursone

  2. Using Excel • Things to Remember: • Formulas you type in will always follow order of operations • Merging cells combines multiple cells into one cell • If you see a series of ##### signs in a cell that denotes the data in the cell is too large and you must increase the width of the column • A cell is the intersection of a row and a column • An absolute formula does not change when the formula is copied or filled down

  3. Review Questions • Data displays in the ________ as you type. • Insert function box • Status bar • Formula bar • Name box Formula Bar

  4. Review Questions • A pie chart with one or more of the slices offset from the main portion is called a(n) ___________ pie chart. Exploded

  5. Review Questions • How can you clear out contents within a cell? • Delete key • Use the shortcut menu • Use the Clear Contents command

  6. Review Questions • One cell on the worksheet, designated the __________, is the one into which you can enter data. Active Cell

  7. Review Questions • In order to make the worksheet easier to read and understand and to emphasize certain entries you can ________ cells in the worksheet • Proofread • Edit • Format • Print Format

  8. Review Questions • What formula must you type into a cell in order to display the highest value in a selected range? MAX

  9. Review Questions • The area on a worksheet where the chart appears is called the ________ . • x-axis • chart location • chart bed • chart cell Chart Location

  10. Review Questions • What is the small black square located in the lower-right corner of the cell called? CELL TIP

  11. Review Questions • A column letter above the grid, also called a _______________, identifies each column. Column Heading

  12. Review Questions • The horizontal and vertical lines on a worksheet are called ____________. Gridlines

  13. Review Questions • A(n) _____ is a group of adjacent cells. • Area • List • Section • Range RANGE

  14. Review Questions • What formatting style displays a dollar sign to the left of the number in a cell and numbers to the nearest cent? CURRENCY

  15. Review Questions • Every time you enter a new value into a cell in the worksheet, Excel will __________ all formulas • Highlight • Recalculate • Display • Cancel RECALCULATE

  16. Review Questions • ____________ involves creating a single cell by combining two or more selected cells. Merging Cells • Use the _____________ button on the formatting toolbar to do this. Merge and Center

  17. Review Questions • What formula must you type into a cell in order to display the lowest value in a selected range? MIN

  18. What formula would you type in if you were trying to add cells B1, B2, B3, and B4 =SUM(B1:B4) Review Questions

More Related