BCA-189 Test-Out Study Guide

Topics List for BCA-189 Microcomputer Literacy Test Out  

To evaluate your skills to determine if you are a good candidate for the Test Out, review the Windows 10 and Office 2019 topics below. The Test Out will consist of objective questions and tasks.  

Windows 10:  

WIN Module 1: Introduction to Windows 10  

• Describe Windows 10  

• Explain the following terms: app, operating system, workstation, and server  • Differentiate among the various editions of Windows 10  

• Use a touch screen and perform basic mouse operations  

• Start Windows 10 and sign in to an account  

• Identify the objects on the Windows 10 desktop  

• Start an app  

• Navigate within an app  

• Start the File Explorer  

• Switch between apps  

• Customize the Start menu  

• Search for an app or a file  

• Install an app  

• Use the search box  

• Add reminders  

• Sign out of an account and shut down the computer  

WIN Module 2: Working with the Windows Desktop  

• Create, name, and save a document directly in the Documents folder  

• Use WordPad to print and edit a document  

• Change the view and arrange objects in groups in the Documents folder  

• Create and name a folder in the Documents folder  

• Move documents into a folder  

• Add and remove a shortcut on the Start menu  

• Open a document using a shortcut on the Start menu  

• Open a folder using a desktop shortcut  

• Open, modify, and print multiple documents in a folder  

• Delete multiple files and folders  

• Work with the Recycle Bin  

WIN Module 3: File and Folder Management  

• View the contents of a drive and folder using the This PC window  

• View the properties of files and folders  

• Find files and folders from a folder window 

• Use Shake and Snap to manipulate windows  

• View, copy, and move contents of the Pictures folder  

• View and change the properties of a picture  

• Start and use the Photos app  

• View pictures as a slide show  

• Compress a folder and view the contents of a compressed folder 

• Back up files and folders using OneDrive  

Office 2019:  

Getting Started with Microsoft Office and OneDrive  

• Identify the versions of Office  

• Identify the Differences between Office Online and Office 2019/Office 365  • Sign up for a Microsoft Account  

• Save Files to OneDrive  

• Create a OneDrive Folder  

• Upload and Download Files into a OneDrive Folder  

• Sync Local Files with OneDrive  

MICROSOFT WORD: Creating and Modifying a Flyer  

• Start and exit Word  

• Enter text in a Word document  

• Adjust margins  

• Check spelling and grammar as you work in a document  

• Save a document  

• Format text, paragraphs, and document elements  

• Undo and redo commands or actions  

• Insert and format a picture  

• Add a page border  

• Change document properties  

• Open and close a document  

• Correct errors and revise a document  

• Cut, copy, and paste text  

• Print a document  

• Use Word Help  

MICROSOFT WORD: Creating a Research Paper  

• Describe the MLA documentation style for research papers  • Modify a style  

• Change line and paragraph spacing in a document  

• Use a header to number pages of a document 

• Apply formatting using keyboard shortcuts  

• Modify paragraph indentation  

• Insert and edit citations and their sources  

• Add a footnote to a document  

• Insert a page break  

• Create a bibliographical list of sources  

• Find text and replace text  

• Use the thesaurus  

• Check spelling and grammar at once  

• Look up and research information  

• Work with comments in a document  

MICROSOFT EXCEL: Creating a Worksheet and a Chart  

• Start an app  

• Identify the components of the Microsoft Office ribbon  • Describe the Excel worksheet  

• Enter text and numbers  

• Use the Sum button to sum a range of cells  

• Enter a simple function  

• Copy the contents of a cell to a range of cells using the fill handle  • Apply cell styles  

• Format cells in a worksheet  

• Create a pie chart  

• Change a worksheet name and sheet tab color  

• Change document properties  

• Preview and print a worksheet  

• Use the Auto Calculate area to display statistics  

• Correct errors on a worksheet  

• Use Microsoft Office Help  

MICROSOFT EXCEL: Formulas, Functions and Formatting  

• Use Flash Fill  

• Enter formulas using the keyboard  

• Enter formulas using Point mode  

• Apply the MAX, MIN, and AVERAGE functions  

• Verify a formula using Range Finder  

• Apply a theme to a workbook  

• Apply a date format to a cell or range  

• Add conditional formatting to cells  

• Change column width and row height  

• Check the spelling on a worksheet 

• Change margins and headers in Page Layout view  

• Preview and print versions and sections of a worksheet  

MICROSOFT POWERPOINT: Creating and Editing a Presentation with Pictures  

• Create a blank presentation  

• Select and change a document theme  

• Create a title slide and a text slide with a multilevel bulleted list  • Add new slides and change slide layouts  

• Change font size and color  

• Bold, italicize, and underline text  

• Insert pictures into slides with and without content placeholders  • Move and resize pictures  

• Arrange slides  

• Change theme colors  

• Check spelling  

• Review a presentation in different views  

• Enter slide notes  

• Save a presentation  

• Print a presentation  

MICROSOFT POWERPOINT: Enhancing a Presentation with Pictures, Shapes and WordArt  

• Search for and download an online theme  

• Insert a symbol  

• Insert a hyperlink  

• Convert text to SmartArt  

• Edit and format SmartArt text  

• Insert and resize a shape  

• Apply effects to a shape  

• Add text to a shape  

• Apply a shape style  

• Insert a picture as a shape fill  

• Move an object using grids, guides, and the ruler  

• Merge shapes  

• Add a footer  

• Add a slide transition and change effect options