IC3 Spark - Key Applications Benchmark Assessment
-
Which one is a gallery in the below image?
-
A
-
B
-
C
-
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!
Quiz Preview
- 2.
Which button displays the Help Table of Contents?
-
A
-
B
-
C
-
D
-
E
Correct Answer
A. DExplanation
The correct answer is D. The button that displays the Help Table of Contents is button D.Rate this question:
-
- 3.
Which file name extension identifies a Word 2010 document?
-
.pdx
-
.docx
-
.pdf
-
.doc
Correct Answer
A. .docxExplanation
The file name extension .docx identifies a Word 2010 document. This extension is used to indicate that the file is in the XML-based document format introduced in Word 2007 and continued in Word 2010. The .docx extension signifies that the file is compatible with Word 2010 and can be opened and edited in this version of the software.Rate this question:
-
- 4.
Which tab would you use to merge three cells together in a table on a PowerPoint slide?
-
Design
-
Layout
Correct Answer
A. LayoutExplanation
In PowerPoint, the "Layout" tab is used to modify the structure and arrangement of elements within a slide, including tables. By selecting the "Layout" tab, users can access various options to customize the table layout, such as merging cells. Therefore, to merge three cells together in a table on a PowerPoint slide, one would use the "Layout" tab.Rate this question:
-
- 5.
Which symbol indicates that you can now move an object?
-
A
-
B
-
C
-
D
Correct Answer
A. CExplanation
The symbol that indicates that you can now move an object is C.Rate this question:
-
- 6.
Why would you want someone else to review you PowerPoint presentation before it is delivered to a live audience?
-
To make sure the file is sharable
-
To have a disinterested third party add notes to the slides
-
To ensure you have the best content, design elements, and timing for your audience
-
To determine which file format is best for the delivery of the presentation
Correct Answer
A. To ensure you have the best content, design elements, and timing for your audienceExplanation
Having someone else review your PowerPoint presentation before it is delivered to a live audience is important to ensure that you have the best content, design elements, and timing for your audience. This allows for a fresh perspective and valuable feedback that can help improve the overall quality and effectiveness of the presentation. It helps to identify any areas that may need clarification or improvement, ensuring that the message is clear and impactful to the intended audience.Rate this question:
-
- 7.
In PowerPoint, which view displays slides as a series of multiple miniature slides?
-
A
-
B
-
C
-
D
Correct Answer
A. BExplanation
The correct answer is B. The Slide Sorter view in PowerPoint displays slides as a series of multiple miniature slides. This view allows users to easily rearrange and organize their slides by dragging and dropping them into different positions. It provides a visual overview of the entire presentation, making it easier to manage and edit the slides.Rate this question:
-
- 8.
What are these called outlined in red in the image below?
-
Ribbon
-
Groups
-
Tabs
-
Menus
Correct Answer
A. TabsExplanation
The items outlined in red in the image are called tabs. Tabs are used to organize and categorize different sections or functions within a larger interface or application. They allow users to easily navigate and switch between different sets of content or features.Rate this question:
-
- 9.
Identify which formatting attributes have been applied to the following:
-
Company name is bold
-
Paragraph is justified
-
Paragraph is justified, company name is bold with with small caps
-
Company name is bold with small caps
Correct Answer
A. Paragraph is justified, company name is bold with with small capsExplanation
The given answer correctly identifies that the paragraph is justified, and the company name is bold with small caps. This means that the text is aligned evenly on both the left and right margins, and the company name is in bold and in small capital letters.Rate this question:
-
- 10.
Which option refers to the amount of space between lines of typed text?
-
Line spacing
-
Paragraph spacing
Correct Answer
A. Line spacingExplanation
Line spacing refers to the amount of space between lines of typed text. It determines the vertical distance between each line of text and can be adjusted to make the text more readable or to fit more content on a page. By increasing or decreasing the line spacing, the overall appearance and readability of the text can be altered.Rate this question:
-
- 11.
In Excel, which tab would you use to merge three cells together and also align the text at the top of the merged cell:
-
Number
-
Alignment
-
Font
-
Border
-
Fill
-
Protection
Correct Answer
A. AlignmentExplanation
The Alignment tab in Excel allows users to merge three cells together and also align the text at the top of the merged cell. This tab provides options to adjust the horizontal and vertical alignment of cell content, as well as options to wrap text, merge cells, and distribute text evenly across merged cells.Rate this question:
-
- 12.
What happens when you press Ctrl+N in an Office program?
-
A new blank file is created
-
The Save a New Document screen appears
-
A new session of the program starts
-
The New file screen appears
Correct Answer
A. A new blank file is createdExplanation
When you press Ctrl+N in an Office program, a new blank file is created. This keyboard shortcut is commonly used to quickly start a new document without having to go through the menu options. It is a convenient way to begin working on a new project or document within the program.Rate this question:
-
- 13.
What happens when you press Ctrl+C in an application program?
-
The selected item is centered between the margins
-
The selected item is copied to the Office Clipboard
-
The selected item is colored with the last color selected in the color palette
-
The selected item is removed from its current location
Correct Answer
A. The selected item is copied to the Office ClipboardExplanation
When you press Ctrl+C in an application program, the selected item is copied to the Office Clipboard. This means that a duplicate of the selected item is stored in the clipboard, allowing you to paste it elsewhere in the program or in a different program. This is a common shortcut for copying content and is widely used in various applications for efficient data transfer or duplication.Rate this question:
-
- 14.
In Excel, why would you rename a worksheet?
-
To match the name of the workbook
-
To help identify the contents
-
To help identify this as a 2010 workbook
-
To be able to add a color to the worksheet later
Correct Answer
A. To help identify the contentsExplanation
Renaming a worksheet in Excel helps to identify the contents of that particular sheet. By giving a descriptive name to the worksheet, users can easily understand what information is stored in that specific sheet. This can be particularly useful when working with multiple sheets within a workbook, as it allows for easy navigation and organization of data.Rate this question:
-
- 15.
In Excel, what do you need to enter to begin a formula in a cell?
-
"
-
'
-
\
-
=
Correct Answer
A. =Explanation
To begin a formula in a cell in Excel, you need to enter the equals sign (=). This signifies to Excel that you are entering a formula and not just a regular value. By starting with the equals sign, you can perform calculations, reference other cells, and use various functions to manipulate data within the spreadsheet.Rate this question:
-
- 16.
When should you press the Enter key when entering text?
-
When you reach the end of the first line to start word wrap for every following line
-
When you reach the end of every line at the right margin
-
When you reach the end of a paragraph or when you want to insert a blank line
-
When you first open the document to move the insertion point out of the header area
Correct Answer
A. When you reach the end of a paragraph or when you want to insert a blank lineExplanation
Pressing the Enter key when you reach the end of a paragraph or when you want to insert a blank line is the correct answer because it is a common practice to start a new paragraph or create a blank line by pressing Enter. This helps in maintaining proper formatting and readability in the text. Pressing Enter at the end of every line at the right margin is not necessary as word wrap automatically moves the text to the next line. Pressing Enter when opening a document to move the insertion point out of the header area is not a standard practice.Rate this question:
-
- 17.
In Word, which Ribbon tab would you use to place an object into a document?
-
A
-
B
-
C
-
D
-
E
Correct Answer
A. CExplanation
The correct answer is C. In Word, the Ribbon tab that you would use to place an object into a document is the "Insert" tab. This tab contains various options for inserting objects such as pictures, shapes, charts, and tables into the document.Rate this question:
-
- 18.
In PowerPoint, which keyboard shortcut will create a new blank presentation quickly?
-
Ctrl+N
-
F5
-
Ctrl+F
-
F12
Correct Answer
A. Ctrl+NExplanation
Ctrl+N is the correct answer because it is a commonly used keyboard shortcut in PowerPoint to quickly create a new blank presentation. By pressing Ctrl+N, users can easily start a new presentation without having to go through the menu options or toolbar buttons. This shortcut is widely known and used by PowerPoint users to save time and streamline the process of creating new presentations.Rate this question:
-
- 19.
In Excel, which filter command would you use to display any sales that are $40,000 or more?
-
Greater Than
-
Less Than
-
Equals
-
Greater Than or Equal To
Correct Answer
A. Greater Than or Equal ToExplanation
The "Greater Than or Equal To" filter command in Excel would be used to display any sales that are $40,000 or more. This filter will include values that are equal to or greater than the specified amount, in this case, $40,000.Rate this question:
-
- 20.
Which feature would you use to flow text around a picture?
-
A
-
B
-
C
-
D
-
E
Correct Answer
A. DExplanation
To flow text around a picture, you would use the "D" feature. This feature allows you to wrap the text around the image, creating a visually appealing layout. By selecting this option, the text will automatically adjust its position to accommodate the picture, creating a professional and organized look.Rate this question:
-
- 21.
Which file extension is automatically applied to a PowerPoint 2010 presentation file?
-
.potx
-
.pps
-
.pptx
-
.ppt
Correct Answer
A. .pptxExplanation
The correct answer is .pptx. In PowerPoint 2010, the .pptx file extension is automatically applied to presentation files. This file extension indicates that the file is in the XML-based format introduced in PowerPoint 2007 and is compatible with newer versions of PowerPoint. The .pptx format allows for enhanced features and functionality, such as improved file compression and the ability to include multimedia elements.Rate this question:
-
- 22.
Which three buttons appear on the Quick Access Toolbar by default, before any customizing is performed?
-
Save
-
Open
-
Undo
-
Redo
-
Print
-
New
Correct Answer(s)
A. Save
A. Undo
A. RedoExplanation
The three buttons that appear on the Quick Access Toolbar by default, before any customizing is performed, are Save, Undo, and Redo. These buttons are commonly used and provide quick access to essential functions. The Save button allows users to save their work, the Undo button allows users to undo their previous action, and the Redo button allows users to redo an action that was previously undone. These buttons are included by default to enhance user productivity and efficiency while working with documents.Rate this question:
-
- 23.
What happens when you change the font size of text characters?
-
The text characters adjust in height only
-
The text characters adjust in width only
-
The text characters adjust in height and width
-
More space is added between the characters to accommodate the new font size
Correct Answer
A. The text characters adjust in height and widthExplanation
When you change the font size of text characters, the characters adjust in both height and width. This means that they become larger or smaller in both dimensions to accommodate the new font size.Rate this question:
-
- 24.
In Excel, which keyboard shortcut moves you quickly to cell A1?
-
Home
-
Ctrl+Home
-
PgUp
-
Ctrl+Up arrow
Correct Answer
A. Ctrl+HomeExplanation
The keyboard shortcut Ctrl+Home in Excel moves the user quickly to cell A1. This shortcut is used to navigate to the top-left corner of the worksheet, which is cell A1. It is a convenient way to quickly return to the starting point of the spreadsheet, especially when working with large data sets or when navigating through different sections of the worksheet.Rate this question:
-
- 25.
In PowerPoint, which Fill option will display a light-to-dark background color?
-
Solid fill
-
Gradient fill
-
Picture or texture fill
-
Pattern fill
Correct Answer
A. Gradient fillExplanation
The correct answer is Gradient fill because it allows you to create a background color that transitions from light to dark. With a gradient fill, you can choose two or more colors and specify the direction and angle of the gradient to achieve the desired effect. This option is commonly used to create visually appealing backgrounds or to highlight specific elements in a slide.Rate this question:
-
- 26.
In PowerPoint, what can you do with the master slide?
-
Add the agenda items for the presentation
-
Add page numbers only
-
Set up header and footer information only
-
Set up items to appear on every slide such as the company logo or fonts
Correct Answer
A. Set up items to appear on every slide such as the company logo or fontsExplanation
With the master slide in PowerPoint, you can set up items that will appear on every slide, such as the company logo or fonts. This allows for consistent branding and formatting throughout the presentation. Other options mentioned, such as adding agenda items or page numbers, are not specific to the master slide and can be done on individual slides. Setting up header and footer information is also possible on individual slides, but the master slide provides a convenient way to apply this information to all slides at once.Rate this question:
-
- 27.
Why does Word display "Document #" whenever you create a new file?
-
To remind you that the file has not been saved with a descriptive name
-
To remind you to close the files that do not need changes
-
To let you know how many documents are open on the screen
-
To provide you with blank documents so you can add new text
Correct Answer
A. To remind you that the file has not been saved with a descriptive nameExplanation
Word displays "Document #" whenever you create a new file to remind you that the file has not been saved with a descriptive name. This serves as a prompt for you to save the file with a meaningful name that accurately represents its content. By displaying "Document #", Word encourages users to avoid leaving files unnamed or with generic names, making it easier to locate and identify specific documents in the future.Rate this question:
-
- 28.
In Word, which ribbon tab would you use to insert a comment?
-
A
-
B
-
C
-
D
-
E
Correct Answer
A. EExplanation
In Word, the ribbon tab that is used to insert a comment is the "Review" tab. This tab contains various tools and options related to reviewing and editing documents, including the "New Comment" button which allows users to insert comments into the document.Rate this question:
-
- 29.
Which mode is the following text placeholder in?
-
Select
-
Edit
Correct Answer
A. EditExplanation
The correct answer is "Edit" because the text placeholder is in a mode where the user can make changes to the text. This suggests that the user can modify or update the content of the text placeholder.Rate this question:
-
- 30.
Why might a chart be a more descriptive way of representing your data than a table in Microsoft Office programs?
-
More data can appear on the chart than in a table
-
A chart illustrates trends or patterns in the data clearly
-
A chart is more colorful
-
The chart can be printed on a larger sheet of paper than can a table
Correct Answer
A. A chart illustrates trends or patterns in the data clearlyExplanation
A chart is a more descriptive way of representing data than a table in Microsoft Office programs because it can illustrate trends or patterns in the data clearly. Unlike a table, which presents data in a structured and organized manner, a chart visually represents the data, allowing for easier identification of patterns or relationships. This visual representation can be particularly helpful when analyzing large datasets or complex information, as it enables users to quickly grasp the main insights and draw conclusions.Rate this question:
-
- 31.
How can you start Microsoft Excel?
-
Click Start, All Programs, Microsoft Excel 2010
-
Click Start, Microsoft Office, Microsoft Excel 2010
-
Click Start, Programs, Microsoft Excel 2010
-
Click Start, All Programs, Microsoft Office, Microsoft Excel 2010
Correct Answer
A. Click Start, All Programs, Microsoft Office, Microsoft Excel 2010Explanation
To start Microsoft Excel, you need to click on the Start button, then go to the All Programs option, and from there select Microsoft Office. Finally, click on Microsoft Excel 2010 to open the program.Rate this question:
-
- 32.
Which option enables you to print the entire workbook in Excel?
-
A
-
B
-
C
-
D
-
E
Correct Answer
A. AExplanation
Option A enables you to print the entire workbook in Excel.Rate this question:
-
- 33.
In PowerPoint, when you click the New Slide button, where will the new slide be inserted in the Slides tab?
-
Above the selected slide
-
Below the selected slide
Correct Answer
A. Below the selected slideExplanation
When you click the New Slide button in PowerPoint, the new slide will be inserted below the selected slide in the Slides tab. This means that the new slide will appear right after the selected slide in the sequence of slides.Rate this question:
-
- 34.
In PowerPoint, when might you use Quick Styles to apply formatting?
-
When the presentation is all text only
-
When you need to identify which data bars are represented in a chart
-
When the themes are not available
-
When you want to format specific types of text such as titles, headings, etc.
Correct Answer
A. When you want to format specific types of text such as titles, headings, etc.Explanation
Quick Styles in PowerPoint are used to apply formatting to specific types of text, such as titles and headings. This allows for consistent and professional formatting throughout the presentation. It is not related to the presentation being all text only, identifying data bars in a chart, or the availability of themes.Rate this question:
-
- 35.
Why might you want to customize a bullet style for a list?
-
To create a different look for the document
-
To change the list style from numbers to bullets
-
To indent the points from the left margin
-
To change the list style from bullets to numbering
Correct Answer
A. To create a different look for the documentExplanation
Customizing a bullet style for a list allows you to create a different look for the document. By customizing the bullet style, you can choose unique and visually appealing bullet designs that match the overall theme or style of the document. This can help make the document more visually interesting and engaging for the reader.Rate this question:
-
- 36.
Which feature can you use when you need to format several text blocks that share the same formatting options?
-
Home tab
-
Font dialog box
-
Styles
-
Copy and Paste
Correct Answer
A. StylesExplanation
Styles is the correct answer because it allows you to format multiple text blocks with the same formatting options. With styles, you can create a set of formatting attributes such as font, size, color, and apply them to different sections of text in your document. This saves time and ensures consistency throughout the document. Styles can be accessed and applied from the Home tab in most word processing software.Rate this question:
-
- 37.
In Word, what is the purpose of setting margins?
-
To determine the type of printer you have installed for your system
-
To determine the amount of space between the edges of paper and where text prints
-
To change the orientation of text on the page
-
To center every line of text horizontally
Correct Answer
A. To determine the amount of space between the edges of paper and where text printsExplanation
Setting margins in Word allows the user to determine the amount of space between the edges of the paper and where the text will be printed. This is important for formatting and ensuring that the text is aligned properly on the page. By adjusting the margins, the user can control the width of the text area and create visually appealing documents.Rate this question:
-
- 38.
In Word, which view displays the columns of text as one column, enabling you to focus on editing the text instead of the layout?
-
Full Screen Reading
-
Print Layout
-
Draft
-
Normal
Correct Answer
A. DraftExplanation
The Draft view in Word displays the columns of text as one column, allowing the user to concentrate on editing the text rather than the layout. This view is useful when working on the content of the document without distractions from formatting or design elements.Rate this question:
-
- 39.
What is the default file type applied to Excel 2010 workbooks?
-
.xls
-
.xlst
-
.xlsx
-
.xlsm
Correct Answer
A. .xlsxExplanation
The default file type applied to Excel 2010 workbooks is .xlsx. This file type was introduced in Excel 2007 and is the default format for saving workbooks in Excel 2010 and later versions. The .xlsx file type is an XML-based format that allows for better data storage and improved compatibility with other applications. It supports all the features and functionality of Excel, including macros and formulas, making it the preferred file type for most users.Rate this question:
-
- 40.
In Excel, which key enables you to select multiple cell ranges as seen in the image?
-
F4
-
Shift
-
F8
-
Ctrl
Correct Answer
A. CtrlExplanation
The Ctrl key enables you to select multiple cell ranges in Excel. By holding down the Ctrl key and clicking on different cells or ranges, you can select them simultaneously. This is useful when you want to perform operations on multiple cells or ranges at once, such as formatting or applying formulas.Rate this question:
-
- 41.
When you see the following symbol in Microsoft Excel, what does it indicate?
-
You can drag to adjust the width of column I
-
You can drag to adjust the width of column H
-
You can insert a new column in this location
-
You can drag to adjust the width of columns H and I
Correct Answer
A. You can drag to adjust the width of column HExplanation
The given answer suggests that the symbol in Microsoft Excel indicates the ability to drag and adjust the width of column H.Rate this question:
-
- 42.
What is happening in the image below?
-
The selected slide will be moved to this location
-
The Slides tab will be minimized
-
A new slide will be inserted in this location
-
The selected slide will be deleted
Correct Answer
A. The selected slide will be moved to this locationExplanation
The image shows a slide being dragged and moved to a different location within a presentation. This action allows the user to rearrange the order of the slides in their presentation.Rate this question:
-
- 43.
In Word, which print option you would click to specify which pages to print:
-
A
-
B
-
C
-
D
-
E
Correct Answer
A. BExplanation
In Word, you would click option B to specify which pages to print. This option allows you to select specific pages or a range of pages that you want to print, rather than printing the entire document.Rate this question:
-
- 44.
How does the Paste All command work from the Office Clipboard?
-
Pastes everything in the Clipboard in the same order you collected them
-
Empties the Clipboard
-
Pastes everything in the Clipboard into the current location but as plain text only
-
Applies the collective formatting of all items in the Clipboard to the selected text
Correct Answer
A. Pastes everything in the Clipboard in the same order you collected themExplanation
The Paste All command in the Office Clipboard allows you to paste everything that you have collected in the Clipboard in the same order in which you collected them. This means that if you have copied or cut multiple items, such as text or images, they will be pasted in the order in which you copied or cut them. This can be useful when you want to preserve the original order of the items when pasting them into a document or presentation.Rate this question:
-
- 45.
What is the keyboard shortcut to Paste?
-
Ctrl+C
-
Ctrl+P
-
Ctrl+S
-
Ctrl+V
Correct Answer
A. Ctrl+VExplanation
The keyboard shortcut to Paste is Ctrl+V. This shortcut is used to paste the copied or cut content into a new location or document. When you want to transfer text or other content from one place to another, you can use this shortcut instead of right-clicking and selecting the "Paste" option from the context menu. It is a commonly used shortcut in various applications and operating systems.Rate this question:
-
- 46.
How can you generate a copy of only the markups in a document?
-
Change the document view to final and then print the document
-
Use the List of Markup command from the Print All Pages option
-
Print the entire document
-
Use the Print option from the Reviewing Pane
Correct Answer
A. Use the List of Markup command from the Print All Pages optionExplanation
To generate a copy of only the markups in a document, you can use the "List of Markup" command from the "Print All Pages" option. This command will allow you to print a list of all the markups in the document without including the actual content. This is useful when you only want to review or share the changes made to the document without printing the entire document.Rate this question:
-
- 47.
Which key enables you to activate edit mode?
-
Enter
-
F4
-
F2
-
F1
Correct Answer
A. F2Explanation
Pressing the F2 key enables you to activate edit mode. This key is commonly used in various software applications, including text editors, spreadsheets, and file managers. In edit mode, you can modify or edit the selected item or text, such as renaming a file, editing a cell in a spreadsheet, or making changes to a document. The F2 key is a convenient shortcut that allows users to quickly access and start editing the selected content without the need for additional clicks or menu navigation.Rate this question:
-
- 48.
How can you tell PowerPoint to create a new slide when you are entering text in the Outline tab area?
-
Press Enter
-
Press Shift+Tab
-
Press Tab
-
Press Ctrl+Enter
Correct Answer
A. Press Ctrl+EnterExplanation
Pressing Ctrl+Enter in PowerPoint while entering text in the Outline tab area creates a new slide. This keyboard shortcut allows users to quickly add a new slide without having to switch to the Slide tab or use the mouse. It is a convenient way to efficiently create and organize content in a presentation.Rate this question:
-
- 49.
What is the following and how is it activated?
-
Mini toolbar that appears when you select text
-
Shortcut menu that appears when you right-click
-
Mini toolbar that appears when you press Ctrl+F
-
Font group on the Home tab when you press Ctrl+F
Correct Answer
A. Mini toolbar that appears when you select textExplanation
The mini toolbar appears when you select text and provides quick access to commonly used formatting options such as font style, font size, and text color. It is activated by selecting text with the mouse or keyboard shortcut and automatically appears near the selected text for easy access to formatting options.Rate this question:
-
.PNG "Which button displays the Help Table of Contents?")
.JPG "In Excel, which tab would you use to merge three cells together and also align the text at the top of the merged cell:")
.PNG "In Word, which ribbon tab would you use to insert a comment?")
.JPG "When you see the following symbol in Microsoft Excel, what does it indicate?")
Quiz Review Timeline (Updated): Mar 21, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Oct 03, 2015Quiz Created by
Jennifer
Back to top