IC3 Spark - Key Applications Benchmark Assessment

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Jennifer
J
Jennifer
Community Contributor
Quizzes Created: 7 | Total Attempts: 7,170
| Attempts: 290 | Questions: 87
Please wait...
Question 1 / 87
0 %
0/100
Score 0/100
1. Which one is a gallery in the below image? 

Explanation

In the given image, option B is a gallery.

Submit
Please wait...
About This Quiz
IC3 Spark - Key Applications Benchmark Assessment - Quiz

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... see moremove on to learning about the Living Online portion of IC3 Spark. Good Luck! You can do this. . . You are AWESOME! see less

Personalize your quiz and earn a certificate with your name on it!
2. Which symbol indicates that you can now move an object?

Explanation

The symbol that indicates that you can now move an object is C.

Submit
3. Which file name extension identifies a Word 2010 document?

Explanation

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.

Submit
4. Which tab would you use to merge three cells together in a table on a PowerPoint slide?

Explanation

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.

Submit
5. Which button displays the Help Table of Contents?

Explanation

The correct answer is D. The button that displays the Help Table of Contents is button D.

Submit
6. Why would you want someone else to review you PowerPoint presentation before it is delivered to a live audience?

Explanation

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.

Submit
7. In PowerPoint, which view displays slides as a series of multiple miniature slides?

Explanation

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.

Submit
8. In Excel, which tab would you use to merge three cells together and also align the text at the top of the merged cell:

Explanation

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.

Submit
9. Identify which formatting attributes have been applied to the following:

Explanation

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.

Submit
10. Which option refers to the amount of space between lines of typed text?

Explanation

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.

Submit
11. Match the types of data in Excel with its description:
Submit
12. What are these called outlined in red in the image below?

Explanation

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.

Submit
13. In Excel, why would you rename a worksheet?

Explanation

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.

Submit
14. What happens when you press Ctrl+N in an Office program?

Explanation

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.

Submit
15. What happens when you press Ctrl+C in an application program?

Explanation

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.

Submit
16. In Excel, what do you need to enter to begin a formula in a cell?

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.

Submit
17. In Word, which Ribbon tab would you use to place an object into a document?

Explanation

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.

Submit
18. In PowerPoint, which keyboard shortcut will create a new blank presentation quickly?

Explanation

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.

Submit
19. When should you press the Enter key when entering text?

Explanation

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.

Submit
20. Which file extension is automatically applied to a PowerPoint 2010 presentation file?

Explanation

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.

Submit
21. In Excel, which filter command would you use to display any sales that are $40,000 or more?

Explanation

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.

Submit
22. Which feature would you use to flow text around a picture?

Explanation

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.

Submit
23. What happens when you change the font size of text characters?

Explanation

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.

Submit
24. In Excel, which keyboard shortcut moves you quickly to cell A1?

Explanation

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.

Submit
25. In PowerPoint, which Fill option will display a light-to-dark background color?

Explanation

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.

Submit
26. In PowerPoint, what can you do with the master slide?

Explanation

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.

Submit
27. Which three buttons appear on the Quick Access Toolbar by default, before any customizing is performed?

Explanation

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.

Submit
28. Why does Word display "Document #" whenever you create a new file?

Explanation

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.

Submit
29. Which mode is the following text placeholder in?

Explanation

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.

Submit
30. In Word, which ribbon tab would you use to insert a comment?

Explanation

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.

Submit
31. Why might a chart be a more descriptive way of representing your data than a table in Microsoft Office programs?

Explanation

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.

Submit
32. In PowerPoint, when might you use Quick Styles to apply formatting?

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.

Submit
33. What is happening in the image below?

Explanation

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.

Submit
34. How can you start Microsoft Excel?

Explanation

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.

Submit
35. Which option enables you to print the entire workbook in Excel?

Explanation

Option A enables you to print the entire workbook in Excel.

Submit
36. In PowerPoint, when you click the New Slide button, where will the new slide be inserted in the Slides tab?

Explanation

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.

Submit
37. What is the default file type applied to Excel 2010 workbooks?

Explanation

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.

Submit
38. In Word, what is the purpose of setting margins?

Explanation

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.

Submit
39. Why might you want to customize a bullet style for a list?

Explanation

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.

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

Explanation

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.

Submit
41. In Excel, which key enables you to select multiple cell ranges as seen in the image?

Explanation

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.

Submit
42. In Word, which view displays the columns of text as one column, enabling you to focus on editing the text instead of the layout?

Explanation

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.

Submit
43. When you see the following symbol in Microsoft Excel, what does it indicate?

Explanation

The given answer suggests that the symbol in Microsoft Excel indicates the ability to drag and adjust the width of column H.

Submit
44. How can you tell PowerPoint to create a new slide when you are entering text in the Outline tab area?

Explanation

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.

Submit
45. In Word, which print option you would click to specify which pages to print: 

Explanation

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.

Submit
46. What is the following and how is it activated?

Explanation

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.

Submit
47. Which key enables you to activate edit mode?

Explanation

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.

Submit
48. What is the keyboard shortcut to Paste?

Explanation

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.

Submit
49. How does the Paste All command work from the Office Clipboard?

Explanation

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.

Submit
50. How can you generate a copy of only the markups in a document?

Explanation

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.

Submit
51. How can you tell if an object is selected in the document?

Explanation

When an object is selected in the document, eight handles appear around it. These handles serve as a visual indicator that the object is currently selected and can be manipulated or edited. The presence of these handles allows the user to easily identify which object is selected among others in the document.

Submit
52. In Excel, how is a workbook different than a worksheet?

Explanation

A workbook in Excel refers to the entire file that contains multiple worksheets. It is the main container that holds all the worksheets and other data. Each workbook can have one or more worksheets, which are individual sheets where data can be entered and manipulated. Therefore, the correct answer is that a workbook is the entire file that includes worksheets.

Submit
53. In Excel, which tab in the Page Setup dialog box would you use to center a report horizontally or vertically?

Explanation

In Excel, the "Margin" tab in the Page Setup dialog box would be used to center a report horizontally or vertically. This tab allows users to adjust the margins of the printed page, including the top, bottom, left, and right margins. By setting equal values for the left and right margins, the report can be centered horizontally on the page. Similarly, by setting equal values for the top and bottom margins, the report can be centered vertically on the page.

Submit
54. Why you would apply cell borders when there are gridlines in the worksheet in Excel?

Explanation

Gridlines in Excel are used to help users visually distinguish between cells, but they do not appear when the worksheet is printed. Therefore, if you want the gridlines to be visible in the printed version of the worksheet, you need to apply cell borders. This allows you to have a clear visual representation of the cells and their boundaries when the worksheet is printed.

Submit
55. In PowerPoint, which option would you use to create a new presentation using a presentation template that was saved a few months ago?

Explanation

The option "New from existing" would be used to create a new presentation using a presentation template that was saved a few months ago. This option allows the user to select a template that has been previously saved and use it as a starting point for a new presentation.

Submit
56. Which button is the Page Layout button:

Explanation

The correct answer is A because the Page Layout button is typically located on the top toolbar or menu of a software application, and it is usually represented by an icon that resembles a page or a document. In this case, button A is the only option provided, so it is likely to be the correct answer.

Submit
57. In PowerPoint, why should you use the Slide Pane to enter text instead of the Slides tab?

Explanation

The Slide Pane is used to enter text in PowerPoint instead of the Slides tab because you cannot enter text directly into the slides in the Slides tab. The Slides tab is primarily used for organizing and rearranging slides, while the Slide Pane allows for editing and adding content to individual slides.

Submit
58. Which setting determines how dates are displayed in Excel by default?

Explanation

The Region and Language setting in the Control Panel determines how dates are displayed in Excel by default. This setting controls the formatting of dates according to the specific region and language preferences selected. By adjusting this setting, users can customize the default display format for dates in Excel based on their preferred regional and language conventions.

Submit
59. Which key can you use to select non-consecutive text?

Explanation

Ctrl is the correct answer because it is commonly used to select non-consecutive text. By holding down the Ctrl key and clicking on different parts of the text, you can select multiple sections that are not next to each other. This is a useful feature when you want to edit or format specific parts of a document without affecting the rest of the text.

Submit
60. What is the keyboard shortcut to Undo?

Explanation

The correct answer is Ctrl+Z. This keyboard shortcut is commonly used to undo the previous action in various software applications, including word processors, spreadsheets, and graphic design programs. By pressing Ctrl+Z, the user can quickly revert back to the previous state or undo any changes made. This shortcut is widely known and used because it provides a convenient and efficient way to undo mistakes or unintended actions.

Submit
61. Choose four categories that appear in the Animation gallery in PowerPoint:

Explanation

The correct answer is Exit, Entrance, Emphasis, and Motion Paths. These four categories appear in the Animation gallery in PowerPoint. Exit animations are used to make objects disappear from the slide. Entrance animations are used to make objects appear on the slide. Emphasis animations are used to draw attention to specific objects on the slide. Motion Paths animations are used to make objects move along a specified path on the slide.

Submit
62. What does the following symbol indicate?

Explanation

The symbol indicates that you can write or emphasize items on slides during the presentation. This means that you have the ability to add annotations, notes, or highlights directly onto the slides while delivering the presentation. It allows for real-time editing or emphasizing of specific content to enhance the audience's understanding or attention.

Submit
63. Which proofing tools are included with PowerPoint?

Explanation

The correct answer is "Spelling, Thesaurus" because PowerPoint includes these two proofing tools. Spelling allows users to check for and correct any misspelled words in their presentation. Thesaurus provides synonyms and antonyms for words, helping users enhance their vocabulary and improve their writing. Grammar, on the other hand, is not included in PowerPoint's proofing tools, so the option "Spelling and Grammar" is not correct.

Submit
64. Which chart type compares continuous trends?

Explanation

The line chart type is used to compare continuous trends because it displays data points connected by lines, allowing for the visualization of the progression of data over time or any continuous variable. This chart type is particularly useful for showing trends, patterns, and relationships between variables in a clear and concise manner. It is commonly used in various fields such as finance, economics, and scientific research to analyze and interpret data.

Submit
65. Choose the method that will create a new slide in PowerPoint that does not use the Title and Content layout?

Explanation

To create a new slide in PowerPoint without using the Title and Content layout, you need to click on the arrow for New Slide and then select the desired layout to use. This will allow you to choose a different layout for the new slide instead of automatically using the Title and Content layout.

Submit
66. Match the visual clues to the type of proofing error Word has detected:
Submit
67. In PowerPoint, why might you apply a built-in theme to the presentation?

Explanation

Applying a built-in theme in PowerPoint allows the user to achieve a consistent look for fonts and color scheme throughout the presentation. This ensures that all the slides have a cohesive design and professional appearance. It saves time and effort by providing pre-designed templates that can be easily applied to the presentation. By using a built-in theme, the user can maintain a consistent visual style and branding, making the presentation more visually appealing and engaging for the audience.

Submit
68. What does the following mouse cursor indicate?

Explanation

The given answer states that the mouse cursor is in the Selection Bar area and ready to select a block of text. This means that the cursor is positioned in a specific area of the document where text can be selected. It suggests that the user can click and drag the cursor to highlight a block of text for various purposes such as copying, cutting, or formatting. This cursor indicates the user's ability to manipulate the text in the document.

Submit
69. What is the name of the feature you can use to manage files within an Office program?

Explanation

Backstage view is the correct answer because it is a feature in Office programs that allows users to manage files. It provides options for creating, opening, saving, and printing files, as well as other file-related tasks like sharing and protecting files. Backstage view is accessed by clicking on the File tab in the ribbon, and it provides a centralized location for managing files within the Office program.

Submit
70. Choose four ways you can increase PowerPoint presentation readability and keep your audience focused on your presentation?

Explanation

The correct answer suggests four ways to increase PowerPoint presentation readability and keep the audience focused. First, using pictures or tables only when relevant or for emphasis ensures that visual elements support the content. Second, limiting the number of colors used helps maintain a clean and professional appearance. Third, using consistent formatting on the slides creates a cohesive and organized presentation. Lastly, limiting the number of points per slide to 6 prevents overcrowding and allows for better comprehension and retention of information.

Submit
71. In PowerPoint, what two ways can you use to insert a clip art image onto a slide?

Explanation

To insert a clip art image onto a slide in PowerPoint, you can use two ways. First, click the Insert tab, then in the Images group, click Clip Art. Second, you can click the Insert Clip Art icon in a Title and Content slide layout.

Submit
72. How can you create most shape objects on a slide after selecting it from the Shapes menu?

Explanation

To create most shape objects on a slide after selecting it from the Shapes menu, you need to click where you want to begin drawing the object and then drag to set the height and width. This allows you to have control over the size and position of the shape on the slide.

Submit
73. Select two occasions when you might use the Recent command in the File tab:

Explanation

The Recent command in the File tab can be used to open a file that you have worked on recently from the list. This is helpful when you want to quickly access a file that you have been working on without having to search for it. Additionally, the Recent command can also be used to pin a file that you work on frequently to the list. By pinning the file, it will always remain in the list, making it easily accessible for future use.

Submit
74. What is important to remember about the Undo history list?

Explanation

The important thing to remember about the Undo history list is that you can only undo commands in the same sequence they were performed. This means that if you want to undo a specific action, you need to undo all the actions that were performed after it in the same order. The Undo history list does not allow you to selectively undo individual commands, but rather follows a sequential order.

Submit
75. In Word, which tab on the Ribbon do you use to work with page numbers?

Explanation

The Insert tab in Word is used to work with page numbers. This tab contains various options related to inserting and formatting page numbers, such as inserting page numbers at different locations, customizing the format of page numbers, and managing page number settings.

Submit
76. In PowerPoint, which two ways do placeholders help you enter information on slides?

Explanation

Placeholders in PowerPoint help in entering information on slides by containing some basic formatting to help identify the information type and including a tip about the type of content that can be entered. The basic formatting in placeholders helps in maintaining consistency and uniformity in the presentation. The tips provided by placeholders guide the user in understanding the purpose of the placeholder and what kind of information is expected to be entered. This makes it easier for the user to input the relevant content in the correct format.

Submit
77. Which view is applied to documents you receive externally via e-mail?

Explanation

Protected view is the correct answer because it is a security feature in Microsoft Office that helps protect your computer from potentially harmful content in email attachments. When you open a document that is received externally via email, it is automatically opened in protected view. In this view, the document is opened in a restricted mode, which disables editing and the execution of potentially malicious code. This helps to prevent any potential harm to your computer system.

Submit
78. In Word, which option would you use to automatically create a table with 12 evenly sized columns and 7 evenly sized rows?

Explanation

The correct answer is "On the Insert tab, in the Tables group, click Table, and then click Insert Table." This option is the most appropriate because it specifically mentions the steps to create a table with 12 evenly sized columns and 7 evenly sized rows. The other options do not provide the same level of detail and may not result in the desired table format.

Submit
79. Match the keyboard shortcut to the movement that occurs:
Submit
80. Select three methods you can use to share files so other can access these files quickly and easily:

Explanation

The three methods mentioned in the answer are effective ways to share files quickly and easily. Saving the files to a shared location such as an organization network allows multiple users to access the files simultaneously. Saving the files to a Web destination like SkyDrive or iCloud provides easy access to the files from any device with an internet connection. Sending the files as email attachments is a common method to share files with individuals or small groups. These methods ensure efficient file sharing and accessibility for different scenarios and requirements.

Submit
81. In PowerPoint, what's the quickest way to insert a table on a new slide?

Explanation

The quickest way to insert a table on a new slide in PowerPoint is to create a new Title and Content slide and click Insert Table in the content placeholder. This option allows the user to easily add a table to the slide without having to draw it manually or insert it into a text box.

Submit
82. Which option would you use to specify to PowerPoint to print handouts?

Explanation

Option B is the correct answer because in PowerPoint, the option to print handouts is usually found under the "Print" menu or tab. This option allows users to choose the number of slides per page, the orientation, and other settings for printing handouts. Therefore, selecting option B would be the appropriate choice to specify PowerPoint to print handouts.

Submit
83. Where is the default paper size determined on your system?

Explanation

The default paper size on your system is determined by the Language and Regional settings. These settings control various aspects of your system, including the default paper size for printing. By selecting a specific language and region, you are also specifying the default paper size that will be used when printing documents.

Submit
84. Why apply a cell style instead of simply formatting worksheet cells individually in Excel?

Explanation

Applying a cell style instead of formatting cells individually in Excel is beneficial because changes made to the cell style will automatically be reflected in all cells that have the style applied. This saves time and effort as there is no need to manually update each individual cell. It also helps maintain consistency throughout the worksheet, ensuring that all cells with the same style have the same formatting.

Submit
85. Select the two areas where you can add speaker notes for the slides in the PowerPoint presentation:

Explanation

You can add speaker notes for the slides in the PowerPoint presentation in two areas. The first area is the Notes box in the Notes Page view, where you can enter detailed notes for each slide. The second area is the Notes pane in the Slide pane, where you can add additional information or reminders for the speaker. These speaker notes are not visible to the audience during the presentation but can be helpful for the presenter in delivering the content effectively.

Submit
86. In Excel, why might you want to check the My data has headers option in the Sort dialog box?

Explanation

By checking the "My data has headers" option in the Sort dialog box in Excel, you are indicating to Excel that the first row of the data contains column headings. This allows Excel to exclude the header row from the sorted list, ensuring that the column headings are not included in the sorting process. This is useful when you want to sort the data without affecting the header row, as the header row typically contains labels or titles for each column and should not be sorted along with the data.

Submit
87. Select two reasons why you should click to indicate a header row exists in your table data:

Explanation

Clicking to indicate a header row exists in the table data is important for two reasons. Firstly, it allows the names of each column to be displayed when choosing the sort order. This helps in easily identifying and selecting the desired column for sorting. Secondly, by indicating a header row, it ensures that the column titles row is not included in the sort. This is important as including the column titles row in the sort can lead to incorrect sorting results.

Submit
View My Results

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, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Oct 03, 2015
    Quiz Created by
    Jennifer
Cancel
  • All
    All (87)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
Which one is a gallery in the below image? 
Which symbol indicates that you can now move an object?
Which file name extension identifies a Word 2010 document?
Which tab would you use to merge three cells together in a table on a...
Which button displays the Help Table of Contents?
Why would you want someone else to review you PowerPoint presentation...
In PowerPoint, which view displays slides as a series of multiple...
In Excel, which tab would you use to merge three cells together and...
Identify which formatting attributes have been applied to the...
Which option refers to the amount of space between lines of typed...
Match the types of data in Excel with its description:
What are these called outlined in red in the image below?
In Excel, why would you rename a worksheet?
What happens when you press Ctrl+N in an Office program?
What happens when you press Ctrl+C in an application program?
In Excel, what do you need to enter to begin a formula in a cell?
In Word, which Ribbon tab would you use to place an object into a...
In PowerPoint, which keyboard shortcut will create a new blank...
When should you press the Enter key when entering text?
Which file extension is automatically applied to a PowerPoint 2010...
In Excel, which filter command would you use to display any sales that...
Which feature would you use to flow text around a picture?
What happens when you change the font size of text characters?
In Excel, which keyboard shortcut moves you quickly to cell A1?
In PowerPoint, which Fill option will display a light-to-dark...
In PowerPoint, what can you do with the master slide?
Which three buttons appear on the Quick Access Toolbar by default,...
Why does Word display "Document #" whenever you create a new...
Which mode is the following text placeholder in?
In Word, which ribbon tab would you use to insert a comment?
Why might a chart be a more descriptive way of representing your data...
In PowerPoint, when might you use Quick Styles to apply formatting?
What is happening in the image below?
How can you start Microsoft Excel?
Which option enables you to print the entire workbook in Excel?
In PowerPoint, when you click the New Slide button, where will the new...
What is the default file type applied to Excel 2010 workbooks?
In Word, what is the purpose of setting margins?
Why might you want to customize a bullet style for a list?
Which feature can you use when you need to format several text blocks...
In Excel, which key enables you to select multiple cell ranges as seen...
In Word, which view displays the columns of text as one column,...
When you see the following symbol in Microsoft Excel, what does it...
How can you tell PowerPoint to create a new slide when you are...
In Word, which print option you would click to specify which pages to...
What is the following and how is it activated?
Which key enables you to activate edit mode?
What is the keyboard shortcut to Paste?
How does the Paste All command work from the Office Clipboard?
How can you generate a copy of only the markups in a document?
How can you tell if an object is selected in the document?
In Excel, how is a workbook different than a worksheet?
In Excel, which tab in the Page Setup dialog box would you use to...
Why you would apply cell borders when there are gridlines in the...
In PowerPoint, which option would you use to create a new presentation...
Which button is the Page Layout button:
In PowerPoint, why should you use the Slide Pane to enter text instead...
Which setting determines how dates are displayed in Excel by default?
Which key can you use to select non-consecutive text?
What is the keyboard shortcut to Undo?
Choose four categories that appear in the Animation gallery in...
What does the following symbol indicate?
Which proofing tools are included with PowerPoint?
Which chart type compares continuous trends?
Choose the method that will create a new slide in PowerPoint that does...
Match the visual clues to the type of proofing error Word has...
In PowerPoint, why might you apply a built-in theme to the...
What does the following mouse cursor indicate?
What is the name of the feature you can use to manage files within an...
Choose four ways you can increase PowerPoint presentation readability...
In PowerPoint, what two ways can you use to insert a clip art image...
How can you create most shape objects on a slide after selecting it...
Select two occasions when you might use the Recent command in the File...
What is important to remember about the Undo history list?
In Word, which tab on the Ribbon do you use to work with page numbers?
In PowerPoint, which two ways do placeholders help you enter...
Which view is applied to documents you receive externally via e-mail?
In Word, which option would you use to automatically create a table...
Match the keyboard shortcut to the movement that occurs:
Select three methods you can use to share files so other can access...
In PowerPoint, what's the quickest way to insert a table on a new...
Which option would you use to specify to PowerPoint to print handouts?
Where is the default paper size determined on your system?
Why apply a cell style instead of simply formatting worksheet cells...
Select the two areas where you can add speaker notes for the slides in...
In Excel, why might you want to check the My data has headers option...
Select two reasons why you should click to indicate a header row...
Alert!

Advertisement