1 / 13

Microsoft Excel

MSBCS-BCSI-9 Students will develop and apply basic spreadsheet skills MSBCS-BCSII-5 The student will utilize spreadsheet software. Microsoft Excel. Study Guide Test 6 & 7 7 th grade. Functions. Spreadsheet software has built-in or predesigned formulas called functions

santos
Download Presentation

Microsoft Excel

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. MSBCS-BCSI-9 Students will develop and apply basic spreadsheet skills MSBCS-BCSII-5 The student will utilize spreadsheet software. Microsoft Excel Study Guide Test 6 & 7 7th grade

  2. Functions • Spreadsheet software has built-in or predesigned formulas called functions • One of the most commonly used functions is SUM • Another frequently used function is AVERAGE, which is used to calculate the average of the numbers in a range of cells in a column or row • Insert menu, Function

  3. Functions continued • Function have three parts: and equals (=) or plus (+) sign to signal the beginning of a mathematical operation; the function name (SUM or AVERAGE) to identify the operation • Examples of SUM and AVERAGE functions are =SUM(A1:F1) and =AVERAGE(A1:F1) • Insert menu, Function

  4. Merge cells • Merge cells- (Join cells) merge two or more cells into one cell • Format menu, Cells

  5. Wrap Text • You can choose to have the text wrap within the cell’s width in the same way sentences are wrapped in word processing documents • Format menu, Cells

  6. Indent Text • Use the Indent Text feature to help distinguish categories or set text apart within cells • Format menu, Cells

  7. Standard Column Width • Standard Column Width- the default number of characters that display in a column based on the standard font. You can change (widen or narrow) the column widths so that text or values fit the longest line or have a better appearance • Format menu, Column

  8. Printing a Worksheet • Orientation: Landscape (horizontal) or Portrait (vertical) • File menu, Page Setup

  9. Print area • By default, most spreadsheet software prints all the information in a worksheet. If you need to print only a portion (one or more pages, one cell, or a range of cells) you can specify to have only that portion printed. • File menu, Print area

  10. Margins • Margins- increase or decrease the top, bottom, left, or right margins to control the amount of data printed on a line. Print the worksheet centered horizontally or vertically on the page • File menu, Page Setup

  11. Scaling • Scaling- reduce or enlarge information through the Adjust to % normal size option. Use the Fit to pages option to compress worksheet data to fill a specific number of pages • File menu, Page Setup

  12. Print Preview • Print Preview- a worksheet should be previewed before it is printed to make sure it is arranged on the page as desired • File menu

  13. Header and Footers • Header- specify a line of text to print at the top of every page • Footer- Specify a line of text to print at the bottom of every page • File menu, Page Setup

More Related