IC3 GS5 Key Applications Exam Study Guide - High-Score Study Material

IC3 GS5 Key Applications Exam Study Guide - High-Score Study Material Shortcut to undo - answer - Ctrl+Z / Cmd+Z = Undo Shortcut to redo - answer - Ctrl+Y / Cmd+Shift+Z = Redo What does AutoSave to OneDrive/Google Drive do? - answer - Saves automatically to cloud, enables version history Difference between Save and Save As - answer - Save = same file, Save As = new name/location/format What is real-time co-authoring? - answer - Multiple users editing same cloud file simultaneously seeing live changes File format best for final share that can't be easily edited - answer - PDF How to add a comment for a collaborator - answer - Review New comment or Ctrl+Alt+M How to check version history and restore old version - answer - File Info Version History or OneDrive Version History How to share with view-only vs edit permissions - answer - Share Enter email Click permission dropdown Viewer or Editor How to use Paste Special to link Excel data into Word that updates - answer - Copy in Excel In Word, Home Paste dropdown Paste Special Paste Link Excel Worksheet Object Feature that wraps text to next line - answer - Word Wrap Red wavy underline means? - answer - Spelling error Blue wavy underline means? - answer - Grammar / style suggestion How to make text Bold, Italic, Underline with keys - answer - Ctrl+B = Bold, Ctrl+I = Italic, Ctrl+U = Underline How to create bulleted vs numbered list - answer - Home Paragraph group Bullets or Numbering What does Format Painter do? - answer - Copies formatting from one text to another How to insert Table of Contents automatically - answer - Apply Heading Styles References Table of Contents Automatic Table How to insert header, footer, page number - answer - Insert Header/Footer/Page Number What are the 3 parts of mail merge? - answer - 1. Main document 2. Recipient list/data source 3. Merge fields How to use Section Breaks to have portrait and landscape in same doc - answer - Layout Breaks Next Page Section Break then change Orientation for that section only What is a cell? - answer - Intersection of row and column, e.g./ B3 Symbol that starts all formulas - answer - equals sign (=) =SUM(A1:A5) does what? - answer - Adds values in A1 through A5 =AVERAGE(A1:A5) does what - answer - Calculates average of range Difference between A1 and $A$1 when copying - answer - A1 = relative moves, $A$1 = absolute locked Green triangle in top-left of cell means? - answer - Number stored as text or formula error Function to count cells with numbers - answer - COUNT Function to count non-empty cells - answer - COUNTA Write IF formula: If A1=60 Pass else Fail - answer - =IF(A1=60,"Pass","Fail") What does VLOOKUP/XLOOKUP do and why is XLOOKUP better? - answer - Looks up value from table. XLOOKUP works left/right, no col index number, handles if not found What is a Record? - answer - One complete row about one person/item - e.g., one student What is a Field? - answer - One column/attribute - e.g., First Name What is a primary key? - answer - Unique ID field for each record - e.g., StudentID Where is all data stored in Access? - answer - In Tables What is a Query? - answer - Asks question/filters data - e.g., show only students from DE What is a One-to-Many relationship? - answer - One record in Table A links to many in Table B - One Customer Many Orders List 4 common data types in Access - answer - Short Text, Number, Date/Time, Yes/No, Currency What is a Form used for? - answer - User friendly screen to enter/edit data without seeing raw table What is a Report used for? - answer - Formatted grouped/sorted output for printing - e.g., sales by month How to create query where State='DE' and sort LastName A-Z - answer - Create Query Design Add table Set Criteria to 'DE' under State Sort Ascending under LastName What is a Slide? - answer - One page/screen of presentation View where you edit one slide at a time - answer - Normal View