1.
Which statement is TRUE about Cut and Copy?
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.
2.
Which of the following statements about tabs is true?
Correct Answer
D. Tabs can be set as left, right, center, or decimal tabs
Explanation
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.
3.
The purpose of the Search and Replace feature is to:
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.
4.
The word processing feature that prints text either above the top margin or below the bottom margin on a page is known as:
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.
5.
The word processing feature that compares every word in a document with the entries in its dictionary is known as:
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.
6.
The explanation for the spell check feature highlighting the word, MANTEO, even though it is spelled correctly is:
Correct Answer
C. Manteo is not in the spell check dictionary
Explanation
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.
7.
To quickly move the cursor 3 inches to the right in your document so that you can enter data, you should:
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.
8.
Which of the following features is NOT an editing feature?
Correct Answer
C. Save
Explanation
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.
9.
Which of the following statements about character formatting is true?
Correct Answer
A. Character formatting refers to the appearance of text on the page
Explanation
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.
10.
Line spacing refers to the:
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.
11.
The page margins of a document refer to the:
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.
12.
Which of the following terms is NOT a data type (determines they type of data a field can store):
Correct Answer
D. Query
Explanation
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.
13.
A field is a column in a table. A field represents a defined property that is stored for all records in a table.
Correct Answer
A. True
Explanation
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.
14.
Which best describes a form?
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.
15.
This view allows the you to see the underlying data for a database object in a tabular view.
Correct Answer
A. Datasheet View
Explanation
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.
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.
Correct Answer
A. True
Explanation
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.
17.
If you understand the basic features for other Microsoft applications, like Word and Excel, you are already familiar with many features in Access.
Correct Answer
A. True
Explanation
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.
18.
A fast way to add up this column of numbers is to click in the cell below the numbers and then:
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.
19.
###### means:
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.
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 ?
Correct Answer
A. Count
Explanation
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.
21.
Can an Excel spreadsheet be used as the "data source" for a Word Mail Merge ?
Correct Answer
A. Yes
Explanation
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.
22.
A Formula and a function are the same thing.
Correct Answer
A. True
Explanation
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.
23.
In order to multiply items in Excel you would use:
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 (*).
24.
On an Excel sheet the active cell is indicated by ____.
Correct Answer
A. A dark wide border
Explanation
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.
25.
To make one section of slides in your presentation use a different design template from the other slides, what do you do?
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.
26.
During a slide show, pressing the Esc key
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."
27.
To delete the slide currently displayed in the Slide pane
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.
28.
The Apply Design Template command is used to
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.
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?
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.
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?
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.
31.
What's the best way to design the layout for your slides?
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.
32.
Which key do you press to go into Slide Show view and always start on the first slide?
Correct Answer
B. F5
Explanation
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.
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?
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.
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.
Correct Answer
B. False
Explanation
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.
35.
The notes pane at the bottom of the PowerPoint window is the only place you can type and work with notes.
Correct Answer
B. False
Explanation
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.
36.
In the PowerPoint window, what's the main area for adding slide content?
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.
37.
PowerPoint has direct connections with which of the following from its toolbars or menu system?
Correct Answer
D. All of the above
Explanation
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.
38.
When you apply a design template to a presentation, it can be...
Correct Answer
B. Applied to all slides
Explanation
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.
39.
To place an organization chart on a slide, you must _____________.
Correct Answer
B. Update the presentation
Explanation
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.
40.
Graphics can be placed
Correct Answer
D. All of the answers
Explanation
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".
41.
You can re-arrange slides in
Correct Answer
B. Sorter view
Explanation
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.
42.
What is the best way to design the layout for your slides?
Correct Answer
A. Create layouts for slides, handouts, and notes using the Master Layout dialog box in slide master view
Explanation
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.
43.
Correct Answer
A. True
44.
Correct Answer
A. True
45.
Correct Answer
A. True