1 / 9

Applications

Applications. We will use MS Word and MS Excel. Standard menu options File – Open, Close, Print, Save Edit -- Undo, Cut, Copy, Paste View – Different views of data (Header/Footer) Insert – Add things like slides, pictures, data Format – Format the data. General Editing Commands.

fausta
Download Presentation

Applications

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. Applications • We will use MS Word and MS Excel. • Standard menu options • File – Open, Close, Print, Save • Edit -- Undo, Cut, Copy, Paste • View – Different views of data (Header/Footer) • Insert – Add things like slides, pictures, data • Format – Format the data

  2. General Editing Commands • Ctrl-O – Open • Ctrl-S – Save • Ctrl-A – Highlight All • Ctrl-X – Cut • Ctrl-C – Copy • Ctrl-V – Paste • Ctrl-F – Find • Ctrl-H – Replace

  3. Word Processors • Let you write papers. • We will use Microsoft Word • Can choose • Font size, type • Bold/Indented/Underlined text. • Other options can be found by clicking on double arrows like >> or <<

  4. MS Word • Can write out files formatted and in plain text. • Most features can be accessed in a toolbar someplace or by opening a menu or by use of typed commands.

  5. Features • Formatting text • Justification – left, right, center, full. • View – Header and Footer • Insert • Autotext in headers and footers • Pictures • Data from other applications like spreadsheets.

  6. MS Excel • A Spreadsheet. • A grid of cells where you can place numbers and formulas and text. • Useful for analyzing data. • Each cell is in a certain row and column. • The rows are numbered starting at 1. • The columns are “numbered” starting with A.

  7. Cell Contents • Values – Constant numbers that can be used in calculations. • Labels – Strings of text that aren’t values or value rules. • Value rules – Formulas and functions that give a cell its value and can be changed when other numbers change.

  8. Features • Import formatted data. • Export tables and charts. • Perform calculations on data. • Many pre-made functions to use. • Relative and absolute names in formulas. • C4 F7 L12 are relative • $C4 F$7 $L$12 are at least somewhat absolute.

  9. Highlighting and Copying • Areas can be highlighted by mouse or by using the name box in the upper left corner. • Highlight several areas by holding Ctrl. • Highligting areas and then typing • Ctrl-D -- will copy down. • Ctrl-R – will copy right. • Can also copy/paste using Ctrl-C Ctrl-V

More Related