IC3 Spark - Key Applications Benchmark Assessment

87 Questions | Total Attempts: 159

SettingsSettingsSettings
Please wait...
 IC3 Spark - Key Applications Benchmark Assessment

This assessment is used as a benchmark to see if you have mastered the Key Applications concepts for the IC3 Spark Certification Exam! You must pass this benchmark assessment with a 90% or higher to show mastery of Key Applications. When you pass at 90% or higher, you will then move on to learning about the Living Online portion of IC3 Spark. Good Luck! You can do this. . . You are AWESOME!


Questions and Answers
  • 1. 
    In Excel, which filter command would you use to display any sales that are $40,000 or more?
    • A. 

      Greater Than

    • B. 

      Less Than

    • C. 

      Equals

    • D. 

      Greater Than or Equal To

  • 2. 
    How can you start Microsoft Excel?
    • A. 

      Click Start, All Programs, Microsoft Excel 2010

    • B. 

      Click Start, Microsoft Office, Microsoft Excel 2010

    • C. 

      Click Start, Programs, Microsoft Excel 2010

    • D. 

      Click Start, All Programs, Microsoft Office, Microsoft Excel 2010

  • 3. 
    Which three buttons appear on the Quick Access Toolbar by default, before any customizing is performed?
    • A. 

      Save

    • B. 

      Open

    • C. 

      Undo

    • D. 

      Redo

    • E. 

      Print

    • F. 

      New

  • 4. 
    What are these called outlined in red in the image below?
    • A. 

      Ribbon

    • B. 

      Groups

    • C. 

      Tabs

    • D. 

      Menus

  • 5. 
    Which one is a gallery in the below image? 
    • A. 

      A

    • B. 

      B

    • C. 

      C

  • 6. 
    Which button displays the Help Table of Contents?
    • A. 

      A

    • B. 

      B

    • C. 

      C

    • D. 

      D

    • E. 

      E

  • 7. 
    What is the name of the feature you can use to manage files within an Office program?
    • A. 

      File Options view

    • B. 

      Office File Manager

    • C. 

      Windows Explorer

    • D. 

      Backstage view

  • 8. 
    What happens when you press Ctrl+N in an Office program?
    • A. 

      A new blank file is created

    • B. 

      The Save a New Document screen appears

    • C. 

      A new session of the program starts

    • D. 

      The New file screen appears

  • 9. 
    What happens when you press Ctrl+C in an application program?
    • A. 

      The selected item is centered between the margins

    • B. 

      The selected item is copied to the Office Clipboard

    • C. 

      The selected item is colored with the last color selected in the color palette

    • D. 

      The selected item is removed from its current location

  • 10. 
    Select three methods you can use to share files so other can access these files quickly and easily:
    • A. 

      Store the files on a portable drive

    • B. 

      Save the files to a shared location such as an organization network

    • C. 

      Save the files to a Web destination such as SkyDrive or iCloud

    • D. 

      Save the files on your local drive only for security purposes

    • E. 

      Send the files as email attachments

  • 11. 
    When should you press the Enter key when entering text?
    • A. 

      When you reach the end of the first line to start word wrap for every following line

    • B. 

      When you reach the end of every line at the right margin

    • C. 

      When you reach the end of a paragraph or when you want to insert a blank line

    • D. 

      When you first open the document to move the insertion point out of the header area

  • 12. 
    Which key can you use to select non-consecutive text?
    • A. 

      Shift

    • B. 

      Fn

    • C. 

      Alt

    • D. 

      Ctrl

  • 13. 
    What does the following mouse cursor indicate?
    • A. 

      The clipboard contains text that can be pasted into the current location

    • B. 

      You can click here to position the insertion point and type new text into the document

    • C. 

      The mouse cursor is in the Selection Bar area and ready to select a block of text

    • D. 

      The mouse cursor is in the document and ready to select a block of text

  • 14. 
    Which file name extension identifies a Word 2010 document?
    • A. 

      .pdx

    • B. 

      .docx

    • C. 

      .pdf

    • D. 

      .doc

  • 15. 
    Why does Word display "Document #" whenever you create a new file?
    • A. 

      To remind you that the file has not been saved with a descriptive name

    • B. 

      To remind you to close the files that do not need changes

    • C. 

      To let you know how many documents are open on the screen

    • D. 

      To provide you with blank documents so you can add new text

  • 16. 
    Select two occasions when you might use the Recent command in the File tab:
    • A. 

      To open a file you worked on recently from this list

    • B. 

      To view files that other users have made changes

    • C. 

      To pin a file you work on frequently to the list so that it will always remain in the list

    • D. 

      To view only the files you've worked on during the current session of Word

  • 17. 
    Which button is the Page Layout button:
    • A. 

      A

    • B. 

      B

    • C. 

      C

    • D. 

      D

    • E. 

      E

  • 18. 
    Which view is applied to documents you receive externally via e-mail?
    • A. 

      Web Layout view

    • B. 

      Protected view

    • C. 

      Full Screen Reading view

    • D. 

      Read Only view

  • 19. 
    How does the Paste All command work from the Office Clipboard?
    • A. 

      Pastes everything in the Clipboard in the same order you collected them

    • B. 

      Empties the Clipboard

    • C. 

      Pastes everything in the Clipboard into the current location but as plain text only

    • D. 

      Applies the collective formatting of all items in the Clipboard to the selected text

  • 20. 
    What happens when you change the font size of text characters?
    • A. 

      The text characters adjust in height only

    • B. 

      The text characters adjust in width only

    • C. 

      The text characters adjust in height and width

    • D. 

      More space is added between the characters to accommodate the new font size

  • 21. 
    Identify which formatting attributes have been applied to the following:
    • A. 

      Company name is bold

    • B. 

      Paragraph is justified

    • C. 

      Paragraph is justified, company name is bold with with small caps

    • D. 

      Company name is bold with small caps

  • 22. 
    Why might you want to customize a bullet style for a list?
    • A. 

      To create a different look for the document

    • B. 

      To change the list style from numbers to bullets

    • C. 

      To indent the points from the left margin

    • D. 

      To change the list style from bullets to numbering

  • 23. 
    Which option refers to the amount of space between lines of typed text?
    • A. 

      Line spacing

    • B. 

      Paragraph spacing

  • 24. 
    Which feature can you use when you need to format several text blocks that share the same formatting options?
    • A. 

      Home tab

    • B. 

      Font dialog box

    • C. 

      Styles

    • D. 

      Copy and Paste

  • 25. 
    Where is the default paper size determined on your system?
    • A. 

      Language and Regional settings for your system

    • B. 

      Page Layout tab

    • C. 

      Advanced category in Word Options

    • D. 

      Printer settings

Back to Top Back to top