1 / 8

Excel Test Review

Excel Test Review. Test date: Friday Dec. 6 th. Cell, Row, Column, Active Cell, Spreadsheet. Vertical line of data identified by a Number Row (Number) Horizontal line of data identified by a Letter Column (Letter) Contains rows and columns of data Spreadsheet (rows/columns data)

dino
Télécharger la présentation

Excel Test Review

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. Excel Test Review Test date: Friday Dec. 6th

  2. Cell, Row, Column, Active Cell, Spreadsheet • Vertical line of data identified by a Number • Row (Number) • Horizontal line of data identified by a Letter • Column (Letter) • Contains rows and columns of data • Spreadsheet (rows/columns data) • Intersection of a row and column • Cell (Intersection) • Cell that is selected • Active Cell (Cell selected)

  3. Cancel Box, Enter Box, Cell NameCell Indicator, Entry Bar • Shows active cell • Cell Indicator (shows active cell) • Column letter row number • Cell Name (Column letter row number) • Type info here and it will show up in cell • Entry Bar (Type info here) • Enters data into cell • Enter Box (Enters data) • Cancels current entry • Cancel Box (Cancels entry)

  4. Date/Time, Label, Value • Character or text data that may not be used in calculation • Label (Character data) • Numeric data that may be used in calculation • Value (Numeric) • Either a date/time • Date/Time (date/time)

  5. Borders, Range, Wrap TextMerging Cells • Group of highlighted cells • Range (Group cells) • Each cell have 4 (T, B, L, R) • Border (T, B, L, R) • Word wraps text in a cell • Wrap Text (Word wraps) • Select a range of cells to merge together • Merging Cells (Merge together)

  6. Sum, Fill Handle, Absolute ReferenceMarquee, Relative Reference, Formula • Mathematical statements used to calculate values • Formula (mathematical stmts) • Add a range of cells • SUM (add) • Range of cells to be used (Dancing Ants) • Marquee (dancing ants) • Small block box in right corner of cell • Fill Handle (Small black box R) • Place $ around column letter so cell reference doesn’t change • Absolute reference ($) • Cell reference of a coped formula that applies to new row or column • Relative Reference (applies to new row or column)

  7. X-axis, Y-axis, Pie, Line, ColumnEmbedded Chart, Legend • Used to show difference over time • Line (over time) • Used to show percentage of a whole • Pie (% of whole) • Chart that shows up on same sheet at data • Embedded chart (chart on same sheet as data) • Horizontal axis • X-axis (Horizontal – like laying down) • Shows differences in data • Column (differences) • Explains parts of the chart • Legend (explains parts of chart) • Verticle axis • Y-axis (Vertical – up/down like standing)

  8. Label Parts of Excel Window Cell Indicator Quick Access Toolbar Entry Bar Active Cell Column Row Are you ready for the test? Sheet Tabs Zoom Normal View Active Cell Cell Indicator Column Entry Bar Normal View Quick Access Toolbar Row Sheet Tabs Zoom

More Related