IC3 Certification Key Application
Questions and Answers
- 1.
Which statement is TRUE about Cut and Copy?
- A.
Cut removes selected text and copy moves selected text.
- B.
They serve the same purpose.
- C.
Cut removes selected text and copy duplicates selected text.
- D.
Cut duplicates selected text and copy removes selected text.
Correct Answer
C. Cut removes selected text and copy duplicates selected text.Explanation
The correct answer is that "Cut removes selected text and copy duplicates selected text." This statement accurately describes the functions of Cut and Copy. When you use Cut, the selected text is removed from its original location and can be pasted elsewhere. On the other hand, when you use Copy, the selected text is duplicated and can be pasted in multiple locations. Therefore, Cut and Copy serve different purposes, with Cut removing the text and Copy duplicating it.Rate this question:
-
- 2.
Which of the following statements about tabs is true?
- A.
Tabs can only be changed once in a document
- B.
Left tabs cannot be changed to right tabs
- C.
Tabs must be set every one-half inch
- D.
Tabs can be set as left, right, center, or decimal tabs
Correct Answer
D. Tabs can be set as left, right, center, or decimal tabsExplanation
Tabs can be set as left, right, center, or decimal tabs. This means that tabs can be adjusted and positioned in different ways within a document. They can be aligned to the left, right, center, or set at a specific decimal position. This flexibility allows for precise formatting and alignment of text in a document.Rate this question:
-
- 3.
The purpose of the Search and Replace feature is to:
- A.
Search for text strings and replace with new text strings.
- B.
Search for misspellings.
- C.
Search form words and suggest synonyms and antonyms.
- D.
Search for proper nouns.
Correct Answer
A. Search for text strings and replace with new text strings.Explanation
The purpose of the Search and Replace feature is to search for specific text strings and replace them with new text strings. This feature is commonly used in word processing programs and text editors to quickly make changes throughout a document or file. It allows users to easily find and modify multiple occurrences of a word, phrase, or combination of characters, saving time and effort in manually editing each instance individually.Rate this question:
-
- 4.
The word processing feature that prints text either above the top margin or below the bottom margin on a page is known as:
- A.
Sorting
- B.
Searching
- C.
Spell check
- D.
Header/Footer.
Correct Answer
D. Header/Footer.Explanation
The word processing feature that prints text either above the top margin or below the bottom margin on a page is known as a header/footer. This feature allows users to add information such as page numbers, document titles, dates, and author names to the top or bottom of each page in a document. It provides a consistent and professional look to the document and helps in organizing and identifying the pages.Rate this question:
-
- 5.
The word processing feature that compares every word in a document with the entries in its dictionary is known as:
- A.
Spell Check.
- B.
Search and replace.
- C.
Thesaurus.
- D.
Help.
Correct Answer
A. Spell Check.Explanation
The correct answer is Spell Check. Spell Check is a word processing feature that compares every word in a document with the entries in its dictionary. It helps to identify and correct any spelling errors in the document by highlighting them or suggesting alternative words. This feature is essential for ensuring the accuracy and professionalism of written documents. Search and replace, thesaurus, and help are other features commonly found in word processing software but they do not specifically compare words with a dictionary for spelling errors.Rate this question:
-
- 6.
The explanation for the spell check feature highlighting the word, MANTEO, even though it is spelled correctly is:
- A.
Manteo should not be capitalized.
- B.
Manteo is misspelled.
- C.
Manteo is not in the spell check dictionary
- D.
It is searching for a synonym.
Correct Answer
C. Manteo is not in the spell check dictionaryExplanation
The spell check feature highlights the word "Manteo" because it is not in the spell check dictionary. This means that the word is not recognized as a correctly spelled word according to the dictionary used by the spell check feature.Rate this question:
-
- 7.
To quickly move the cursor 3 inches to the right in your document so that you can enter data, you should:
- A.
Use the space bar.
- B.
Use the one-half inch preset tab stops.
- C.
Use the End key.
- D.
Set a tab stop at 3 inches.
Correct Answer
D. Set a tab stop at 3 inches.Explanation
Setting a tab stop at 3 inches allows you to quickly move the cursor to that specific position in the document. This is an efficient way to navigate and enter data without having to manually move the cursor using the space bar or other keys. Using preset tab stops or the End key may not provide the exact positioning needed, making setting a tab stop at 3 inches the most appropriate solution.Rate this question:
-
- 8.
Which of the following features is NOT an editing feature?
- A.
Cut
- B.
Copy
- C.
Save
- D.
Paste
Correct Answer
C. SaveExplanation
Save is not an editing feature because it does not involve modifying or manipulating the content of a document or file. Instead, it is a feature used to store or preserve the current version of the document or file. Editing features such as Cut, Copy, and Paste involve moving or duplicating content within a document or between different documents.Rate this question:
-
- 9.
Which of the following statements about character formatting is true?
- A.
Character formatting refers to the appearance of text on the page
- B.
Character formatting refers to changing the default side margins
- C.
Headers and footers are examples of character formatting
- D.
Printing is an example fo character formatting
Correct Answer
A. Character formatting refers to the appearance of text on the pageExplanation
Character formatting refers to the appearance of text on the page. This means that it includes changes such as font style, size, color, boldness, italics, underline, and other visual attributes that affect the way the text looks on the page. It does not refer to changing the default side margins, which is a page formatting option. Headers and footers are not examples of character formatting, as they refer to content that appears at the top and bottom of each page. Printing is also not an example of character formatting, as it refers to the process of producing a physical copy of the document.Rate this question:
-
- 10.
Line spacing refers to the:
- A.
Vertical spacing between lines of text.
- B.
Horixontal spacing between words.
- C.
Horizontal spacing between characters
- D.
Top and bottom margins.
Correct Answer
A. Vertical spacing between lines of text.Explanation
The correct answer is vertical spacing between lines of text. Line spacing refers to the amount of space between each line of text in a document or piece of writing. This spacing can be adjusted to make the text more readable and visually appealing. By increasing or decreasing the vertical spacing, the text can appear more compact or spread out on the page. This can be particularly useful in documents with a lot of text or when trying to create a specific visual effect.Rate this question:
-
- 11.
The page margins of a document refer to the:
- A.
Header on each page.
- B.
Page orientation.
- C.
Portrait orientation.
- D.
White space surrounding the page.
Correct Answer
D. White space surrounding the page.Explanation
The page margins of a document refer to the white space surrounding the page. Margins are the empty areas on the top, bottom, left, and right sides of a document where no text or images are present. They provide visual structure and help to improve readability by preventing the content from being too close to the edges of the page.Rate this question:
-
- 12.
Which of the following terms is NOT a data type (determines they type of data a field can store):
- A.
Text
- B.
Number
- C.
Currency
- D.
Query
Correct Answer
D. QueryExplanation
The term "Query" is not a data type. In database management systems, a query is used to retrieve, manipulate, and analyze data, but it is not a type of data itself. Text, Number, and Currency are all examples of data types that determine the type of data that can be stored in a field.Rate this question:
-
- 13.
A field is a column in a table. A field represents a defined property that is stored for all records in a table.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The statement is true because a field in a table represents a specific property or attribute that is stored for each record in that table. It is essentially a column that holds a particular type of data, such as a name, age, or address. Fields allow for the organization and categorization of data within a table, making it easier to retrieve and manipulate information.Rate this question:
-
- 14.
Which best describes a form?
- A.
It presents the data from a query in a pre-formatted and useful manner.
- B.
A graphical user interface to data.
- C.
A database object that lets you automate tasks in an Access database
- D.
It provides a link between the DBMS and the physical data on the hard disk.
Correct Answer
B. A graphical user interface to data.Explanation
A form is a graphical user interface to data, allowing users to view and interact with the data in a more user-friendly and organized manner. Forms provide a way for users to input, edit, and display data from a database. They can include various controls such as text boxes, buttons, and drop-down lists to facilitate data entry and manipulation. By presenting data in a visually appealing and structured way, forms enhance the user experience and make it easier to navigate and work with the underlying database.Rate this question:
-
- 15.
This view allows the you to see the underlying data for a database object in a tabular view.
- A.
Datasheet View
- B.
Form View
- C.
Design View
- D.
Table View
Correct Answer
A. Datasheet ViewExplanation
The correct answer is Datasheet View. Datasheet View is a view in a database that allows the user to see the underlying data for a database object, such as a table, in a tabular view. In this view, the data is displayed in rows and columns, similar to a spreadsheet, making it easy to view and manipulate the data. It provides a convenient way to browse, edit, and analyze the data in a database object.Rate this question:
-
- 16.
Microsoft Access 2010 allows you to share your database with other users via the web. This means that they don't need to have Access installed on their computers to be able to use the database.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Microsoft Access 2010 has a feature that allows users to share their database with others via the web. This means that other users can access and use the database without needing to have Access installed on their computers. This feature enables collaboration and accessibility, making it easier for multiple users to work on the same database simultaneously.Rate this question:
-
- 17.
If you understand the basic features for other Microsoft applications, like Word and Excel, you are already familiar with many features in Access.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The statement suggests that if someone understands the basic features of Microsoft applications like Word and Excel, they will also be familiar with many features in Access. This implies that there are similarities in the user interface, functionality, and features across these applications, making it easier for someone familiar with Word and Excel to navigate and use Access effectively. Therefore, the correct answer is True.Rate this question:
-
- 18.
A fast way to add up this column of numbers is to click in the cell below the numbers and then:
- A.
Click Subtotals on the Data menu.
- B.
View the sum in the formula bar.
- C.
Click the AutoSum button on the Standard toolbar, then press ENTER.
Correct Answer
C. Click the AutoSum button on the Standard toolbar, then press ENTER.Explanation
To quickly add up the column of numbers, you can use the AutoSum button on the Standard toolbar. By clicking this button, Excel automatically selects the range of cells above the active cell and inserts the SUM function in the formula bar. Pressing ENTER then calculates the sum of the selected range and displays it in the active cell. This method saves time and effort compared to manually typing the SUM function or using other menu options.Rate this question:
-
- 19.
###### means:
- A.
You've entered a number wrong.
- B.
You've misspelled something.
- C.
The cell is not wide enough.
Correct Answer
C. The cell is not wide enough.Explanation
The given answer suggests that the meaning of "######" in this context is that the cell is not wide enough. This implies that when entering data into a cell, if the content is too long, it will be displayed as "######" to indicate that the cell's width is insufficient to display the entire content.Rate this question:
-
- 20.
Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell ?
- A.
Count
- B.
Average
- C.
Sum
Correct Answer
A. CountExplanation
The Count formula counts the number of cells in a range that contain numeric values. It does not add the numeric values or place the result in a different cell. Therefore, the correct answer is not Count.Rate this question:
-
- 21.
Can an Excel spreadsheet be used as the "data source" for a Word Mail Merge ?
- A.
Yes
- B.
No
Correct Answer
A. YesExplanation
An Excel spreadsheet can be used as the "data source" for a Word Mail Merge. This means that the data from the Excel spreadsheet can be merged into a Word document, allowing for personalized documents to be created quickly and efficiently. The Mail Merge feature in Word allows users to combine a template document with a data source, such as an Excel spreadsheet, to create customized documents for mass mailing or other purposes.Rate this question:
-
- 22.
A Formula and a function are the same thing.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
A formula and a function are not the same thing. A formula is a mathematical expression used to calculate a value, while a function is a predefined operation or set of instructions that can be used to perform a specific task. Functions can be used within formulas to carry out specific calculations, but they are not interchangeable terms.Rate this question:
-
- 23.
In order to multiply items in Excel you would use:
- A.
^
- B.
@
- C.
*
- D.
#
Correct Answer
A. ^Explanation
To multiply items in Excel, you would use the asterisk symbol (*). The caret symbol (^) is used for exponentiation, the at symbol (@) is used for referencing cells in VBA code, and the pound symbol (#) is not used for any mathematical operation in Excel. Therefore, the correct symbol to use for multiplication in Excel is the asterisk symbol (*).Rate this question:
-
- 24.
On an Excel sheet the active cell is indicated by ____.
- A.
A dark wide border
- B.
A dotted border
- C.
A blinking border
- D.
None of the above
Correct Answer
A. A dark wide borderExplanation
The active cell on an Excel sheet is indicated by a dark wide border. This border helps users easily identify which cell they are currently working on or editing. It stands out from the other cells and provides a visual cue to the user. The dark wide border is a common feature in spreadsheet software like Excel and is used to enhance usability and navigation within the sheet.Rate this question:
-
- 25.
To make one section of slides in your presentation use a different design template from the other slides, what do you do?
- A.
Select the slide thumbnails in that section, and apply a different color scheme.
- B.
Select the slide thumbnails in that section, and apply a different design template.
- C.
Select one of the slides in the section you want to change, customize the fonts and colors, and use the Format Painter to apply those styles to the other slides in the section.
Correct Answer
B. Select the slide thumbnails in that section, and apply a different design template.Explanation
To make one section of slides in your presentation use a different design template from the other slides, you need to select the slide thumbnails in that section and apply a different design template. This means that you can choose a unique design for a specific section of your presentation, giving it a distinct look and feel compared to the rest of the slides. By selecting the slide thumbnails and applying a different design template, you can easily customize the appearance of that particular section.Rate this question:
-
- 26.
During a slide show, pressing the Esc key
- A.
Displays the last slide.
- B.
Displays slide 1.
- C.
Ends the slide show.
- D.
Displays the previous slide.
Correct Answer
C. Ends the slide show.Explanation
Pressing the Esc key during a slide show is commonly used to end the slide show. This key is often programmed to trigger the exit function, allowing the presenter to quickly and easily stop the slide show and return to the normal view or exit the presentation entirely. Therefore, the correct answer is "ends the slide show."Rate this question:
-
- 27.
To delete the slide currently displayed in the Slide pane
- A.
Select the Delete Slide command.
- B.
Press the Backspace key.
- C.
Select the Removal command, type the slide number in the dialog box, and then select OK.
- D.
Select the Exit command.
Correct Answer
A. Select the Delete Slide command.Explanation
To delete the slide currently displayed in the Slide pane, the correct action is to select the Delete Slide command. This command specifically allows the user to remove the slide that is currently being viewed. By selecting this command, the user can easily delete the slide without any additional steps or input.Rate this question:
-
- 28.
The Apply Design Template command is used to
- A.
Change the order of the slides.
- B.
Change the shape of the slides.
- C.
Change the background and fonts of the entire presentation.
- D.
Create a new, empty presentation.
Correct Answer
C. Change the background and fonts of the entire presentation.Explanation
The Apply Design Template command allows users to change the background and fonts of the entire presentation. This command is useful when wanting to give a consistent and professional look to the presentation by applying a predefined design template. It saves time and effort by automatically applying the desired background and font styles to all slides in the presentation, ensuring a cohesive and visually appealing look throughout.Rate this question:
-
- 29.
You've customized a design template in one presentation and you want to use it in another presentation. What's the best way to do this?
- A.
Use the Browse feature in the Slide Design task pane to find the file that has your design template and apply it to the current file.
- B.
Copy and paste the slide with the design template you want into the new presentation; inserted slides will inherit the design.
- C.
Save the presentation that has the design template with a new name, and then use the new file for your presentation.
Correct Answer
A. Use the Browse feature in the Slide Design task pane to find the file that has your design template and apply it to the current file.Explanation
The best way to use a customized design template from one presentation in another presentation is to use the Browse feature in the Slide Design task pane. This feature allows you to locate the file that contains your design template and apply it to the current file.Rate this question:
-
- 30.
You're giving your presentation, and you need to click to a slide that's a few slides back. How do you get there?
- A.
Press ESC to get back into normal view; click the correct slide thumbnail in normal view; then click the Resume Slide Show button.
- B.
Press BACKSPACE until you hit the slide you're looking for.
- C.
Right-click, point to Go on the shortcut menu, point to By Title, and click the slide you want to go to.
Correct Answer
C. Right-click, point to Go on the shortcut menu, point to By Title, and click the slide you want to go to.Explanation
To go back to a specific slide during a presentation, you can right-click and select "Go" from the shortcut menu. Then, point to "By Title" and click on the slide you want to navigate to. This method allows you to quickly jump to the desired slide without interrupting the flow of your presentation.Rate this question:
-
- 31.
What's the best way to design the layout for your slides?
- A.
Create layouts for slides, handouts, and notes using the Master Layout dialog box in slide master view.
- B.
For each new slide, select a layout from the Slide Layout task pane.
- C.
Apply templates from the Slide Design task pane.
Correct Answer
B. For each new slide, select a layout from the Slide Layout task pane.Explanation
The best way to design the layout for your slides is to select a layout from the Slide Layout task pane for each new slide. This allows you to choose a pre-designed layout that suits your content and presentation style. By selecting a layout, you can ensure consistency and professionalism throughout your slides.Rate this question:
-
- 32.
Which key do you press to go into Slide Show view and always start on the first slide?
- A.
ESC
- B.
F5
- C.
F7
- D.
F9
Correct Answer
B. F5Explanation
Pressing the F5 key is the correct answer to go into Slide Show view and always start on the first slide. When the F5 key is pressed, the PowerPoint presentation will start from the beginning, displaying the first slide. This key is commonly used during presentations to quickly enter the Slide Show mode and ensure that the audience sees the presentation from the beginning.Rate this question:
-
- 33.
You've put a layout on your slide that contains a placeholder for a picture. But you'd rather use the Clip Art task pane to insert the art than the options you get when you click the Insert Clip Art icon in the placeholder. What do you do?
- A.
Apply a Blank layout instead, and then use the Insert menu (point to Picture, and then click Clip Art) to open the Clip Art task pane and insert the picture.
- B.
Make sure the picture placeholder is selected, and then use the Insert menu (point to Picture, and then click Clip Art) to open the Clip Art task pane and insert the picture.
- C.
Select the placeholder on the slide, and then press DELETE. Then use the Insert menu (point to Picture, and then click Clip Art) to open the Clip Art task pane and insert the picture.
Correct Answer
B. Make sure the picture placeholder is selected, and then use the Insert menu (point to Picture, and then click Clip Art) to open the Clip Art task pane and insert the picture.Explanation
To insert the picture using the Clip Art task pane instead of the options in the placeholder, the user should make sure that the picture placeholder is selected. Then, they should go to the Insert menu, point to Picture, and click Clip Art to open the Clip Art task pane and insert the desired picture. This allows the user to bypass the options provided by the Insert Clip Art icon in the placeholder and have more control over the image selection process.Rate this question:
-
- 34.
To apply a design template to all your slides, you need to select all the slide thumbnails on the Slides tab before you apply the template.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
To apply a design template to all your slides, you do not need to select all the slide thumbnails on the Slides tab before applying the template. Instead, you can simply apply the template to one slide, and it will automatically be applied to all the slides in your presentation.Rate this question:
-
- 35.
The notes pane at the bottom of the PowerPoint window is the only place you can type and work with notes.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The notes pane at the bottom of the PowerPoint window is not the only place where you can type and work with notes. In fact, you can also type and work with notes in the Notes Page view, which allows you to see both the slide and the associated notes on the same screen. Additionally, you can print the notes pages separately from the slides, allowing you to have a physical copy of your presentation with the accompanying notes.Rate this question:
-
- 36.
In the PowerPoint window, what's the main area for adding slide content?
- A.
The Slides tab, on the left of the window.
- B.
The notes pane.
- C.
The slide pane, in the middle of the window.
Correct Answer
C. The slide pane, in the middle of the window.Explanation
The slide pane, located in the middle of the PowerPoint window, is the main area for adding slide content. This is where users can create and edit the actual slides of their presentation, including adding text, images, shapes, and other elements. The slide pane provides a visual representation of each slide and allows users to easily manipulate and arrange the content as desired.Rate this question:
-
- 37.
PowerPoint has direct connections with which of the following from its toolbars or menu system?
- A.
Microsoft Word
- B.
Internet Explorer
- C.
You EMail program
- D.
All of the above
Correct Answer
D. All of the aboveExplanation
PowerPoint has direct connections with Microsoft Word, Internet Explorer, and your Email program. This means that you can easily import and export content between PowerPoint and these applications, as well as access web content and send presentations via email directly from within PowerPoint. This integration allows for seamless collaboration and enhances the functionality of PowerPoint by connecting it to other commonly used tools.Rate this question:
-
- 38.
When you apply a design template to a presentation, it can be...
- A.
Applied along with another template to the same slide
- B.
Applied to all slides
- C.
Modified in slide show view
- D.
None of the above
Correct Answer
B. Applied to all slidesExplanation
When you apply a design template to a presentation, it can be applied to all slides. This means that the design elements, such as the background, color scheme, fonts, and layout, will be applied to every slide in the presentation. This helps to maintain consistency and a professional look throughout the entire presentation. Applying a design template to all slides saves time and effort as you don't have to manually apply the design to each individual slide.Rate this question:
-
- 39.
To place an organization chart on a slide, you must _____________.
- A.
Save the presentation
- B.
Update the presentation
- C.
Close the file
- D.
None of the above
Correct Answer
B. Update the presentationExplanation
To place an organization chart on a slide, you must update the presentation. This means that you need to make sure that the changes or additions you have made to the organization chart are saved and reflected in the current version of the presentation. Simply saving the presentation may not be enough as it does not guarantee that the organization chart will be added or updated on the slide. Closing the file is also not necessary for placing an organization chart on a slide.Rate this question:
-
- 40.
Graphics can be placed
- A.
In a text box
- B.
Behind another graphic
- C.
Off the slide itself
- D.
All of the answers
Correct Answer
D. All of the answersExplanation
Graphics can be placed in a text box, behind another graphic, or off the slide itself. Therefore, the correct answer is "all of the answers".Rate this question:
-
- 41.
You can re-arrange slides in
- A.
Slide view
- B.
Sorter view
- C.
Notes Page View
- D.
Slide Show View
Correct Answer
B. Sorter viewExplanation
In Sorter view, you can easily re-arrange slides by dragging and dropping them into the desired order. This view displays all the slides in a thumbnail format, allowing you to have a visual overview of your presentation. It is particularly useful when you want to quickly organize and rearrange the sequence of your slides. Slide view, Notes Page View, and Slide Show View do not provide the same level of flexibility and ease in re-arranging slides.Rate this question:
-
- 42.
What is the best way to design the layout for your slides?
- A.
Create layouts for slides, handouts, and notes using the Master Layout dialog box in slide master view
- B.
For each new slide, select a layout from the Slide Layout task plane
- C.
Apply templates from the Slide Design task plane
Correct Answer
A. Create layouts for slides, handouts, and notes using the Master Layout dialog box in slide master viewExplanation
The best way to design the layout for your slides is to create layouts for slides, handouts, and notes using the Master Layout dialog box in slide master view. This allows you to have consistent and customized layouts throughout your presentation. By using the slide master view, you can make changes to the master layout, such as adding placeholders, formatting text, and inserting logos or graphics, which will be applied to all slides in your presentation. This ensures a cohesive and professional look for your slides.Rate this question:
-
- 43.
- A.
True
- B.
False
Correct Answer
A. True -
- 44.
- A.
True
- B.
False
Correct Answer
A. True -
- 45.
- A.
True
- B.
False
Correct Answer
A. True -
.png)
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 20, 2023Quiz Edited by
ProProfs Editorial Team -
Dec 01, 2014Quiz Created by
Abolila
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Server Quizzes
Back to top