CIS Excel Test#1 Review

CIS Excel Test#1 Review - TEST #1 Preview Excel Chapters...

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: TEST #1 Preview Excel Chapters 1-4 Test #1 MyITLab will be the testing tool! The test will be totally automated: 20 Excel Simulation Questions Overall 53 specific tasks to do within the 20 questions NOW for a Preview of our very first Test! Test #1 Study Tips The tasks that we do/discuss in class are the ones to know/remember Use the Hands-On Exercises in the book to prepare for the test tasks! Chapter Summary and Multiple Choice Questions don't hurt either! By doing the Hands-On exercises and the Capstone Exercises you are preparing for the test! Automated Test #1 Tips READ ALL parts of the question Very Carefully Do one thing at a time (the one that is highlighted) Don't get "Click Happy" Relax and Remain Calm! Chapter 1 Study Topics Order of Precedence How to display formulas # Objects in Office 2007 Clipboard Workbook .vs. Worksheet Merge & Center Alignment Borders Format Cells, Inserting Rows/Columns Page Setup Cell Comments Chapter 2 Study Topics Formulas Fill Handle Absolute .vs. Relative Cell References AutoSum Functions: IF, PMT, VLOOKUP Chapter 3 Study Topics Chart Types & Parts Technique to Create a Chart Move a chart (Design Tab) Chart Layout Legend, Title, Data Points Chapter 4 Study Topics Freezing Table Creation/Convert back to Range Find & Replace Table Formatting Sorting & Filtering Table Total Row/Fields/Options! Design Tab: Table Style Options Sub-Totals Charts from sub-totals Good Luck! Remember to try to re-do ALL your homework assignments from scratch as the BEST way to prepare for the test. ...
View Full Document

Page1 / 9

CIS Excel Test#1 Review - TEST #1 Preview Excel Chapters...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online