midterms

• 1. A function used to search for value horizontally from lookup table-
  2. LOOKUP

• Helps to visually explore and analyze data, detect critical issues, and identify patterns and trends- CONDITIONAL FORMATTING

• Rearranges the rows based on the contents of a particular column- DATA SORTING

• PIVOT CHARTS


  Graphical representation of a data summary displayed in a pivot table
• Allows you to set up certain validation rules that what can be entered into a cell- DATA VALIDATION

• Allows you to view specific rows in an Excel spreadsheet, while hiding the other rows- FILTERING

• 1. A function used to search for value vertically from lookup table- LOOKUP

• Groups the items in a field by customized ways- PIVOT TABLE

• Translate the data into distances and plot data points in a way that their relative distances are kept- CHARTS/GRAPHS

• FORMULAS


  Greatly simplifies the task of number crunching
• REVIEW


  Let you proofread your Excel workbooks, add and delete comments, protect and unprotect Excel sheets/ workbooks & finally allow users to track changes in a multi-user Excel workbook
• INSERT


  Table, Charting, Links, Symbols, Text decoration and much more
• HOME


  Formatting, alignment, inserting and deleting rows or columns, sorting and filtering numbers, applying styles and formatting effects, finding and replacing data and much more
• PAGE LAYOUT


  Page setup, scaling, sheet options and much more
• VIEW


  Helps to change the view of Excel sheets and make it easy to view the data. - useful for preparing the workbook for printing
• DATA


  Import data from external sources including but not limited to a text files, Microsoft Access databases, web pages, xml documents, Microsoft Query, Microsoft SQL Server databases
• TIMELINE - Outlines events chronologically. - Can either be simple or complex. - It invites the viewer to go on a historical journey using interesting and relevant content and design.
• FLOWCHART - Designed to make theviewer answer a series of questions to reach a particular answer.
• NUMERICAL - An infographic whose primary content is comprised of numbers, charts, graphs, or statistical data
• PHOTO INFOGRAPHIC - An infographic whose primary content is composed of pictures or easy steps/tips about a certain topic.