Computer Applications Key Exercises
GETTING STARTED WITH WINDOWS 7: An Introduction to the Operating System
1. The Windows 7 feature that alerts you to any maintenance or security concerns is the:
(a) Action Center.
(b) Security Center.
(c) Windows Defender.
(d) Control Pane.
2. Snapping windows means that you:
(a) Minimize all open windows simultaneously so that the desktop displays.
(b) Auto arrange all open windows so that they are of uniform size.
(c) Manually reposition all open windows so that you can see the content of each.
(d) Move any open windows to an opposing side of the desktop until they snap into place.
3. Which of the following accessory programs is primarily a text editor?
(b) Snipping Tool
4. A calendar, which is an example of a constantly changing desktop item, is a(n):
5. Open windows are displayed as icons, or buttons, on the:
(c) Notification area.
(d) Start menu.
6. A shortcut icon on the desktop is identified by:
(a) An arrow at the lower-left corner of the icon.
(b) The word shortcut included as part of the icon name.
(c) A checkmark at the lower-left corner of the icon.
(d) Its placement on the right side of the desktop.
7. Help and Support is available from which of the following?
(a) Start menu
(b) Desktop icon
(c) Notification area
8. Which of the following is NOT a method of switching between open windows?
(c) Click an open window icon on the taskbar.
(d) Windows logo+Tab
9. When you maximize a window, you:
(a) Fill the screen with the window.
(b) Prioritize the window so that it is always placed on top of all other open windows.
(c) Expand the window’s height but leave its width unchanged.
(d) Expand the window’s width but leave its height unchanged.
10. When you enter search keywords in the Search box of a folder window (such as the Documents window):
(a) The search is not limited to the selected folder.
(b) The search cannot be further narrowed.
(c) The search is automatically expanded to include every folder on the hard drive.
(d) The search is limited to the selected folder, but can be expanded if you like.
OFFICE FUNDAMENTALS AND FILE MANAGEMENT: Taking the First Step
1. The Recent Documents list:
(a) Shows documents that have been previously printed.
(b) Shows documents that have been previously opened.
(c) Shows documents that have been previously saved in an earlier software version.
(d) Shows documents that have been previously deleted.
2. Which of the following Windows Explorer features collects related data from folders and gives them a single name?
3. When you want to copy the format of a selection, but not the content:
(a) Double-click Copy in the Clipboard group.
(b) Right-click the selection, and then click Copy.
(c) Click Copy Format in the Clipboard group.
(d) Click Format Painter in the Clipboard group.
4. Which of the following is not an object that can be inserted in an Office document?
(b) Clip art
(c) Paragraph box
(d) Text box
5. What does a red wavy underline in a document, spreadsheet, or presentation mean?
(a) A word is misspelled or not recognized by the Office dictionary.
(b) A grammatical mistake exists.
(c) An apparent word-usage mistake exists.
(d) A word has been replaced with a synonym.
6. When you close a file:
(a) You are prompted to save the file (unless you have made no changes since last saving it).
(b) The application (Word, Excel, or PowerPoint) is also closed.
(c) You must first save the file.
(d) You must change the file name.
7. Live Preview:
(a) Opens a predesigned document or spreadsheet that is relevant to your task.
(b) Provides a preview of the results of a choice you are considering before you make a final selection.
(c) Provides a preview of an upcoming Office version.
(d) Enlarges the font onscreen.
8. You can get help when working with an Office application in which one of the following areas?
(a) Help tab
(b) Status bar
(c) The Backstage view
(d) Quick Access Toolbar
9. The Find and Replace feature enables you to do which of the following?
(a) Find all instances of misspelling and automatically correct (or replace) them.
(b) Find any grammatical errors and automatically correct (or replace) them.
(c) Find any specified font settings and replace them with another selection.
(d) Find any character string and replace it with another.
10. A document or worksheet printed in portrait orientation is:
(a) Taller than it is wide.
(b) Wider than it is tall.
(c) A document with 2” left and right margins.
(d) A document with 2” top and bottom margins.
INTRODUCTION TO WORD: Organizing a Document
1. How do you display the Backstage view Print options?
(a) Click Print on the Quick Access Toolbar.
(b) Click the File tab, and then click Print.
(c) Click the Print Preview command.
(d) Click the Home tab.
2. Which view removes white space, headers, and footers from the screen?
(a) Full Screen Reading
(b) Print Layout
(d) Print Preview
3. You are the only person in your office to upgrade to Word 2010. Before you share documents with coworkers you should do which of the following?
(a) Print out a backup copy.
(b) Run the Compatibility Checker.
(c) Burn all documents to CD.
(d) Have no concerns that coworkers can open your documents.
4. A document has been entered into Word using the default margins. What can you say about the number of hard and soft returns if the margins are increased by 0.5” on each side?
(a) The number of hard returns is the same, but the number and/or position of the soft returns increases.
(b) The number of hard returns is the same, but the number and/or position of the soft returns decreases.
(c) The number and position of both hard and soft returns is unchanged.
(d) The number and position of both hard and soft returns decreases.
5. Which of the following is detected by the contextual spelling checker?
(a) Duplicate words
(b) Use of the word their when you should use there
(c) Irregular capitalization
(d) Improper use of commas
6. If your cursor is near the bottom of a page and you want to display the next paragraph you type at the top of a new page, you should use which of the following?
(b) Ctrl+Page Down
(d) Page Layout, Breaks, Line Numbers
7. You need to insert a large table in the middle of a report that contains page numbers in the footer. The table is too wide to fit on a standard page. Which of the following is the best option to use in this case?
(a) Put the table in a separate document, and do not worry about page numbering.
(b) Insert a section break, and change the format of the page containing the table to landscape orientation.
(c) Change the whole document to use landscape orientation.
(d) Change margins to 0” on the right and left.
8. What feature adds organization to your documents?
(a) Print Preview
(c) Page Numbers
(d) Find and Replace
9. If you cannot determine why a block of text starts at the top of the next page, which toggle switch should you invoke to view the formatting marks in use?
(a) Word wrap
(c) Bold font
(d) Caps Lock
10. What visual clue tells you that a document is not in Word 2010 format?
(a) The status bar includes the text (Compatibility Mode).
(b) The file extension is .docx.
(c) The title bar is a different color.
(d) The title bar includes (Compatibility Mode) after the file name.
WORD 2: DOCUMENT PRESENTATION: Editing and Formatting
1. Which of the following is not true about typeface?
(a) A serif typeface helps the eye connect one letter with the next.
(b) A monospaced typeface allocates space according to the width of the character.
(c) A san serif typeface is more effective with titles and headlines.
(d) A typeface is a complete set of characters.
2. What is the easiest way to change the alignment of five paragraphs scattered throughout a document, each of which is formatted with the same style?
(a) Select the paragraphs individually, then click the appropriate alignment button.
(b) Use CTRL to select all of the paragraphs, then click the appropriate alignment button on the Home tab.
(c) Change the format of the existing style, which changes the paragraphs.
(d) Retype the paragraphs according to the new specifications.
3. If you want to be sure the date June 21, 2012, does not word wrap what should you do?
(a) Use a nonbreaking hyphen in place of the comma.
(b) Use expanded spacing on the whole number.
(c) Use nonbreaking spaces between the month, date, and year.
(d) Press Ctrl+Enter before you type the date.
4. Which wrap style enables text to wrap around the graphic frame that surrounds the image?
(c) Behind Text
(d) Right and Left
5. A(n) _________ occurs when the first line of a paragraph is isolated at the bottom of a page and the rest of the paragraph continues on the next page.
(b) section break
6. Which of the following is a false statement about the Outline view?
(a) It can be collapsed to display only headings.
(b) It can be expanded to show the entire document.
(c) It requires the application of styles.
(d) It is used to create a multilevel list.
7. What happens if you modify the Body Text style in a Word document?
(a) Only the paragraph where the insertion point is located is changed.
(b) All paragraphs in the document will be changed.
(c) Only those paragraphs formatted with the Body Text style will be changed.
(d) It is not possible to change a Word default style such as Body Text.
8. If you want to display text in side-by-side sections, what feature should you use to format the text?
(c) Multilevel lists
9. Which of the following is a true statement regarding indents?
(a) Indents are measured from the edge of the page.
(b) The left, right, and first line indents must be set to the same value.
(c) The insertion point can be anywhere in the paragraph when indents are set.
(d) Indents must be set within the Paragraph dialog box.
10. The spacing in an existing multipage document is changed from single spacing to double spacing throughout the document. What can you say about the number of hard and soft page breaks before and after the formatting change?
(a) The number of soft page breaks is the same, but the number and/or position of the hard page breaks are different.
(b) The number of hard page breaks is the same, but the number and/or position of the soft page breaks are different.
(c) The number and position of both hard and soft page breaks are the same.
(d) The number and position of both hard and soft page breaks are different.
WORD 3: COLLABORATION AND RESEARCH: Communicating Easily and Producing Professional Papers
1. Which of the following statements about comments is false?
(a) Comment balloons appear on the right side in Print Layout view by default.
(b) You cannot edit a comment that was created by another person.
(c) You cannot print comments with the rest of the document.
(d) You can use the Show Markup feature on the Review tab to filter markup balloons so only comments display on the page.
2. What option enables you to preview how a document will look if you accept all tracked changes?
(a) Final: Show Markup
(c) Original: Show Markup
3. How do you view and edit footnote text?
(a) Position the mouse pointer over the footnote reference mark and click inside the ScreenTip that appears.
(b) Open the Footnote and Endnote dialog box.
(c) Double-click the footnote reference mark and type in the footnote.
(d) Click Citation on the References tab.
4. Which option is not true about plagiarism?
(a) It is the act of using another person’s work and claiming it as your own.
(b) It is considered academic dishonesty in academic communities.
(c) It only applies to written works; ideas, spoken words, or graphics are not included.
(d) It has serious moral and ethical implications.
5. What document item directs a reader to another location in a document by mentioning its location?
6. A table of figures is generated from what type of entries?
7. What does a table of authorities display?
(a) A list of pictures, tables, and figures in a document
(b) A list of cases, rules, treaties, and other documents cited in a legal document
(c) A list of key words and phrases in the document
(d) A sequential list of section headings and their page numbers
8. Select the sequence of events to include a bibliography in your document.
(a) Select writing style, insert bibliography, and then insert citations.
(b) Type footnotes into document, insert bibliography, and then select writing style.
(c) Select writing style, mark legal references, and then insert bibliography.
(d) Insert a citation, select writing style, and then insert bibliography.
9. After you create and insert a table of contents into a document:
(a) Any subsequent page changes arising from the insertion or deletion of text to existing paragraphs must be entered manually.
(b) Any additions to the entries in the table arising due to the insertion of new paragraphs defined by a heading style must be entered manually.
(c) An index cannot be added to the document.
(d) You can right-click, then select Update Field to update the table of contents.
10. You are participating in a group project in which each member makes changes to the same document. Which feature in Word should you suggest the members use so each can see the edits made by fellow group members?
(a) Mark index entries.
(b) Track changes.
(c) Mark citations.
(d) Create cross-references.
WORD 4: DOCUMENT PRODUCTIVITY: Working with Tables and Mail Merge
1. You have created a table containing numerical values and have entered the SUM(ABOVE) function at the bottom of a column. You then delete one of the rows included in the sum. Which of the following is true?
(a) The row cannot be deleted because it contains a cell that is included in the sum function.
(b) The sum is updated automatically.
(c) The sum cannot be updated.
(d) The sum will be updated after you right-click the cell and click the Update Field command.
2. What happens when you press Tab from within the last cell of a table?
(a) A Tab character is inserted just as it would be for ordinary text.
(b) Word inserts a new row below the current row.
(c) Word inserts a new column to the right of the current column.
(d) The insertion point appears in the paragraph below the table.
3. What happens when you type more than one line of text into a cell?
(a) The cell gets wider to accommodate the extra text.
(b) The row gets taller as word wrapping occurs to display the additional text.
(c) The first line is hidden by default.
(d) A new column is inserted automatically.
4. Assume you created a table with the names of the months in the first column. Each row lists data for that particular month. The insertion point is in the first cell on the third row, which lists goals for April. You realize that you left out the goals for March. What should you do?
(a) Display the Insert tab, and then click the Table command.
(b) Display the Table Tools Design tab, and then click the Insert Cell command.
(c) Display the Table Tools Layout tab, and then click the Insert Left command.
(d) Display the Table Tools Layout tab, and then click the Insert Above command.
5. You have a Word document that contains a list of people who were sent an invitation to a wedding. You are responsible for monitoring their responses to the invitation, whether they will attend or not, and to determine the grand total of those attending. Using skills learned in the chapter, what would be a good way to track this information?
(a) Copy the names into an Excel spreadsheet, and then use mail merge to populate a table in Word.
(b) Convert the list of names to a table; add columns that enable you to mark their response, including the number who will attend, and use a formula to add up the numbers when all responses are received.
(c) Type the list of names into a Word table; add columns to mark a response, and a formula to add up responses.
(d) Insert a two-column table beside the names and mark the responses as declined or attending.
6. When you generate a new data source during the mail merge process, what type of file do you create when it saves?
(a) Document (.docx)
(b) Worksheet (.xlsx)
(c) Database (.mdb))
(d) Rich text (.rtf)
7. During a mail merge process, what operation can you perform on a data source so only data that meet specific criteria, such as a particular city, are included in the merge?
8. When you click Edit Individual Documents on the Mail Merge pane, and then click OK, the merged document _____.
(a) overwrites the main document
(b) is automatically printed
(c) is saved to a new document file
(d) appears in a new document window
9. When you use mail merge to create address labels, what option do you click to copy the address field from the first label to the rest of the labels before performing the merge?
(a) Copy and paste
(b) Update all labels
(c) Edit recipient list
(d) Sort and filter
10. Which of the following is not a good use for mail merge?
(a) To print mailing labels for Christmas cards from a list of addresses in an Excel spreadsheet
(b) To send the same personalized letter to all your business clients
(c) To create return address labels that display your home address
(d) To e-mail a meeting announcement to every member of your professional organization
INTRODUCTION TO EXCEL What Is a Spreadsheet?
1. What is the first step in planning an effective worksheet?
(a) Enter labels, values, and formulas.
(b) State the purpose of the worksheet.
(c) Identify the input and output areas.
(d) Decide how to format the worksheet data.
2. What Excel interface item is not displayed until you start typing or editing data in a cell?
(a) Insert Function
(b) Name Box
(c) Formula Bar
3. Given the formula =B1*B2+B3/B4∧2 where B1 contains 3, B2 contains 4, B3 contains 32, and B4 contains 4, what is the result?
4. Why would you press Ctrl+` in Excel?
(a) To display the print options
(b) To undo a mistake you made
(c) To display cell formulas
(d) To enable the AutoComplete feature
5. Which of the following is a nonadjacent range?
(d) A1:A10, D1:D10
6. If you want to balance a title over several columns, what do you do?
(a) Enter the data in the cell that is about midway across the spreadsheet.
(b) Merge and center the data over all columns.
(c) Use the Increase Indent command until the title looks balanced.
(d) Click Center to center the title horizontally over several columns.
7. Which of the following characteristics is not applicable to the Accounting Number Format?
(a) Dollar sign immediately on the left side of the value
(b) Commas to separate thousands
(c) Two decimal places
(d) Zero values displayed as hyphens
8. If you want to see a preview of how a worksheet will appear on a hard copy, what do you do?
(a) Change the Zoom to 100%.
(b) Click the Page Layout tab, and then click the Print check box in the Sheet Options group.
(c) Click the File tab, and then click Print.
(d) Click the Page Setup Dialog Box Launcher.
9. Assume that the data on a worksheet consume a whole printed page and a couple of columns on a second page. You can do all of the following except what to force the data to print all on one page?
(a) Decrease the Scale value.
(b) Increase the left and right margins.
(c) Decrease column widths if possible.
(d) Select a smaller range as the print area.
10. What should you do if you see a column of pound signs (###) instead of values or results of formulas?
(a) Increase the zoom percentage.
(b) Delete the column.
(c) Adjust the row height.
(d) Increase the column width.
EXCEL 2: FORMULAS AND FUNCTIONS: Performing Quantitative Analysis
1. If cell D15 contains the formula =$C$5* D15, what is the D15 in the formula?
(a) Mixed reference
(b) Absolute reference
(c) Circular reference
(d) Range name
2. What function would most appropriately accomplish the same thing as =(B5+C5+D5+E5+F5)/5?
3. When you type a function, what appears after you type the opening parenthesis?
(a) Function ScreenTip
(b) Formula AutoComplete
(c) Insert Function dialog box
(d) Function Arguments dialog box
4. A formula containing the entry =$B3 is copied to a cell one column to the right and two rows down. How will the entry appear in its new location?
5. Cell B10 contains a date, such as 1/1/2012. Which formula will determine how many days are between that date and the current date, given that the cell containing the formula is formatted with Number Format?
6. Given that cells A1, A2, and A3 contain values 2, 3, and 10, respectively, and B6, C6, and D6 contain values 10, 20, and 30, respectively, what value will be returned by the function =IF(B6>A3,C6* A1,D6* A2)?
7. Given the function =VLOOKUP(C6,D12:F18,3), the entries in:
(a) Range D12:D18 are in ascending order.
(b) Range D12:D18 are in descending order.
(c) The third column of the lookup table must be text only.
(d) Range D12:D18 contain multiple values in each cell.
8. The function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C7?
(b) Periodic interest rate
(c) Loan amount
(d) Number of payment periods
9. Which of the following is not an appropriate use of the SUM function?
10. Which of the following is not an acceptable range name?
(c) Goal for 2012
EXCEL 3: CHARTS Depicting Data Visually
1. Which type of chart is the least appropriate for depicting yearly rainfall totals for five cities for four years?
(a) Pie chart
(b) Line chart
(c) Column chart
(d) Bar chart
2. What is the typical sequence for creating a chart?
(a) Select the chart type, select the data source, and then size and position the chart.
(b) Select the data source, size the chart, select the chart type, and then position the chart.
(c) Select the data source, select the chart type, and then size and position the chart.
(d) Click the cell to contain the chart, select the chart type, and then select the data source.
3. Which of the following applies to a sparkline?
(a) Chart title
(b) Single-cell chart
(d) Multiple data series
4. If you want to show exact values for a data series in a bar chart, what chart element should you display?
(a) Chart title
(c) Value axis title
(d) Data labels
5. The value axis currently shows increments such as 50,000 and 100,000. What do you select to display increments of 50 and 100?
(a) More Primary Vertical Axis Title Options
(b) Show Axis in Thousands
(c) Show Axis in Millions
(d) Show Right to Left Axis
6. You want to create a single chart that shows each of five divisions’ proportion of yearly sales for each year for five years. Which type of chart can accommodate your needs?
(a) Pie chart
(b) Surface chart
(c) Clustered bar chart
(d) 100% stacked column chart
7. Currently, a column chart shows values on the value axis, years on the category axis, and state names in the legend. What should you do if you want to organize data with the states on the category axis and the years shown in the legend?
(a) Change the chart type to a clustered column chart.
(b) Click Switch Row/Column in the Data group on the Design tab.
(c) Click Layout 2 in the Chart Layouts group on the Design tab, and then apply a different chart style.
(d) Click Legend in the Labels group on the Layout tab, and then select Show Legend at Bottom.
8. Which tab contains commands to apply a predefined chart layout that controls what elements are included, where, and their color scheme?
(d) Page Layout
9. A chart and its related data source are located on the same worksheet. What is the default Print option if the chart is selected prior to displaying the Backstage view?
(a) Print Entire Workbook
(b) Print Selection
(c) Print Selected Chart
(d) Print Active Sheets
10. Which of the following is not a way to display the Format Data Series dialog box for the Arts data series in a column chart?
(a) Press and hold Shift as you click each Arts column.
(b) Click an Arts column, and then click Format Selection in the Current Selection group on the Layout tab.
(c) Right-click an Arts column, and then select Format Data Series.
(d) Click the Chart Elements arrow in the Current Selection group, select the Arts data series, and then click Format Selection in the Current Selection group on the Layout tab.
EXCEL 4: DATASETS AND TABLES Managing Large Volumes of Data
1. You have a large dataset that will print on several pages. You want to ensure that related records print on the same page with column and row labels visible and that confidential information is not printed. You should apply all of the following page setup options except which one to accomplish this?
(a) Set a print area.
(b) Print titles.
(c) Adjust page breaks.
(d) Change the print page order.
2. You are working with a large worksheet. Your row headings are in column A. Which command(s) should be used to see the row headings and the distant information in columns X, Y, and Z?
(a) Freeze Panes command
(b) Hide Rows command
(c) New Window command and cascade the windows
(d) Split Rows command
3. Which statement is not a recommended guideline for planning a table in Excel?
(a) Avoid naming two fields with the same name.
(b) Ensure no blank columns separate data columns within the table.
(c) Leave one blank row between records in the table.
(d) Include field names on the first row of the table.
4. You have a list of all the employees in your organization. The list contains employee name, office, title, and salary. You want to list all employees in each office branch. The branches should be listed alphabetically, with the employee earning the highest salary listed first in each office. Which is true of your sort order?
(a) Branch office is the primary sort and should be in A to Z order.
(b) Salary is the primary sort and should be from highest to lowest.
(c) Salary is the primary sort and should be from lowest to highest.
(d) Branch office is the primary sort and should be in Z to A order.
5. You suspect a table has several identical records. What should you do?
(a) Do nothing; a logical reason probably exists to keep identical records.
(b) Use the Remove Duplicates command.
(c) Look at each row yourself, and manually delete duplicate records.
(d) Find the duplicate records and change some of the data to be different.
6. Which check box in the Table Style Options group enables you to apply different formatting to the records in a table?
(a) Header Row
(b) Banded Rows
(c) Banded Columns
(d) Total Row
7. Which date filter option enables you to specify criteria for selecting a range of dates, such as between 3/15/2012 and 7/15/2012?
(c) All Dates in the Period
8. You want to display a total row that identifies the oldest date in a field in your table. What function do you select from the list?
9. What type of conditional formatting displays horizontal colors in which the width of the bar indicates relative size compared to other values in the selected range?
(a) Color Scales
(b) Icon Sets
(c) Data Bars
10. When you select the ______ rule type, the New Formatting Rule dialog box does not show the Format button.
(a) Format all cells based on their values
(b) Format only cells that contain
(c) Use a formula to determine which cells to format
(d) Format only unique or duplicate values
INTRODUCTION TO ACCESS: Finding Your Way Through a Database
1. Which sequence represents the hierarchy of terms, from smallest to largest?
(a) Database, table, record, field
(b) Field, record, table, database
(c) Record, field, table, database
(d) Field, record, database, table
2. You perform several edits in a table within an Access database. When should you execute the Save command?
(a) Immediately after you add, edit, or delete a record
(b) Each time you close a table or a query
(c) Once at the end of a session
(d) Records are saved automatically; the save command is not required.
3. You have opened an Access file. The left pane displays a table with forms, queries, and reports listed below a table name. Then another table and its objects display. You notice some of the object names are repeated under different tables. Why?
(a) The Navigation Pane has been set to Object Type. The object names repeat because a query or report is frequently based on multiple tables.
(b) The Navigation Pane has been set to Tables and Related Views. The object names repeat because a query or report is frequently based on multiple tables.
(c) The Navigation Pane has been set to Most Recently Used View. The object names repeat because an object has been used frequently.
(d) The database objects have been alphabetized.
4. Which of the following is not true of an Access database?
(a) Every record in a table has the same fields as every other record.
(b) Every table in a database contains the same number of records as every other table.
(c) Text, Number, Autonumber, and Currency are valid data types.
(d) Each table should contain a primary key; however, a primary key is not required.
5. Which of the following is true regarding the record selector box?
(a) A pencil symbol indicates that the current record already has been saved.
(b) An empty square indicates that the current record has not changed.
(c) An asterisk indicates the first record in the table.
(d) A gold border surrounds the active record.
6. You have finished an Access assignment and wish to turn it in to your instructor for evaluation. As you prepare to transfer the file, you discover that it has grown in size. It is now more than double the original size. You should:
(a) Zip the database file prior to transmitting it to the instructor.
(b) Turn it in; the size does not matter.
(c) Compact and repair the database file prior to transmitting it to the instructor.
(d) Delete extra tables or reports or fields to make the file smaller.
7. Which of the following will be accepted as valid during data entry?
(a) Adding a record with a duplicate primary key
(b) Entering text into a numeric field
(c) Entering numbers into a text field
(d) Omitting an entry in a required field
8. Which of the following conditions is available through Filter by Selection?
(a) The AND condition
(b) The OR condition
(c) An Equals condition
(d) A delete condition
9. You open an Access form and use it to update an address for customer Lee Fong. After closing the form, you later open a report that generates mailing labels. What will the address label for Lee Fong show?
(a) The new address
(b) The old address
(c) The new address if you remembered to save the changes made to the form
(d) The old address until you remember to update it in the report
10. You are looking at an Employees table in Datasheet view. You want the names sorted alphabetically by last name and then by first name—for example, Smith, Andrea is listed before Smith, William. To accomplish this, you must:
(a) First sort ascending on first name and then on last name.
(b) First sort descending on first name and then on last name.
(c) First sort ascending on last name and then on first name.
(d) First sort descending on last name and then on first name.
ACCESS 2: RELATIONAL DATABASES AND QUERIES: Designing Databases and Extracting Data
1. When entering, deleting, or editing table data:
(a) The table must be in Design view.
(b) The table must be in Datasheet view.
(c) The table may be in either Datasheet or Design view.
(d) Data may be entered only in a form.
2. Which of the following is true for the Query Wizard?
(a) You can only select tables as the source.
(b) No criteria can be added.
(c) Fields from multiple tables are not allowed.
(d) You do not need a summary.
3. Which of the following was not a suggested guideline for designing a table?
(a) Include all necessary data.
(b) Store data in its smallest parts.
(c) Avoid calculated fields.
(d) Link tables using common fields.
4. A query’s specifications providing instructions about which records to include must be entered:
(a) On the Show row of the query design grid.
(b) On the Sort row of the query design grid.
(c) On the Criteria row of the query design grid.
(d) On the Table row of the query design grid.
5. An illustration of a one-to-many relationship would be:
(a) A person changes his/her primary address.
(b) A customer may have multiple orders.
(c) A branch location has an internal BranchID code.
(d) A balance field is totaled for all accounts for each person.
6. When adding criteria to the query design view:
(a) The value you enter must be delimited by quotes (“)(”).
(b) The value you enter must be delimited by pound signs (#).
(c) The value you enter must be delimited by nothing ().
(d) Access will add the correct delimiters for you (“),(”), (#), or ().
7. Which of the following is true with respect to an individual’s hire date and years of service?
(a) Hire date should be a calculated field; years of service should be a stored field.
(b) Hire date should be a stored field; years of service should be a calculated field.
(c) Both should be stored fields.
(d) Both should be calculated fields.
8. When importing data into Access, which of the following statements is true?
(a) The Import Wizard only works for Excel files.
(b) The wizard can be found on the Create tab.
(c) You can assign a primary key while you are importing Excel data.
(d) The wizard will import the data in one step after you select the file.
9. The main reason to enforce referential integrity in Access is to:
(a) Limit the number of records in a table.
(b) Keep invalid data from being entered into a table.
(c) Make it possible to delete records.
(d) Keep your database safe from unauthorized users.
10. It is more efficient to make a copy of an existing query, rather than create a new query, when which of the following is true?
(a) The existing query contains only one table.
(b) The existing query and the new query use the same tables and fields.
(c) The existing query and the new query have the exact same criteria.
(d) The original query is no longer being used.
ACCESS 3: CUSTOMIZE, ANALYZE, AND SUMMARIZE QUERY DATA: Creating and Using Queries to Make Decisions
1. Which of the following correctly identifies the rules for the order of operations?
(a) Exponentiation, parentheses, addition, subtraction, multiplication, division
(b) Parentheses, exponentiation, addition, subtraction, multiplication, division
(c) Parentheses, exponentiation, multiplication, division, addition, subtraction
(d) Addition, subtraction, multiplication, division, exponentiation, parentheses
2. What is the result of the following expression?
(3 * 5) + 7 − 2 − 6 * 2
3. The Builder command that opens the Expression Builder is found in the:
(a) Manage group on the Databases Tools tab.
(b) Query Setup group on the Design tab.
(c) Database Management group on the Design tab.
(d) Design group on the Query Setup tab.
4. Which function enables you to insert today’s date into an expression?
5. You correctly calculated a value for the OrderAmount using an expression. Now you need to use the newly calculated value in another expression calculating sales tax. The most efficient method is to:
(a) Run and save the query to make OrderAmount available as input to subsequent expressions.
(b) Create a new query based on the query containing the calculated Order amount, and then calculate the sales tax in the new query.
(c) Close the Access file, saving the changes when asked; reopen the file and reopen the query; calculate the sales tax.
(d) Create a backup of the database, open the backup and the query, then calculate the sales tax.
6. If state law requires that a restaurant’s wait staff be at least 21 to serve alcohol and you have a database that stores each employee’s birth date in the Employee table, which of the following is the proper syntax to identify the employees’ year of birth?
(a) Age:DatePart(“yyyy”,[ Employee]![BirthDate])
(b) Age=DatePart(“yyyy”,[ Employee]![BirthDate])
7. Which statement about a totals query is true?
(a) A totals query is created in Datasheet view.
(b) A totals query may contain several grouping fields but only one aggregate field.
(c) A totals query is limited to only two fields, one grouping field, and one aggregate field.
(d) A totals query may contain several grouping fields and several aggregate fields.
8. After creating a calculated field, you run the query and a parameter dialog box appears on your screen. How do you respond to the Parameter dialog box?
(a) Click OK to make the parameter box go away.
(b) Read the field name specified in the parameter box, and then look for a possible typing error in the calculated expression.
(c) Type numbers in the parameter box, and then click OK.
(d) Close the query without saving changes. Re-open it and try running the query again.
9. An updatable query contains student names. You run the query and while in Datasheet view, you notice a spelling error on one of the student’s names. You correct the error in Datasheet view. Which statement is true?
(a) The name is correctly spelled in this query but will be misspelled in the table and all other queries based on the table.
(b) The name is correctly spelled in the table and in all queries based on the table.
(c) The name is correctly spelled in this query and any other queries, but will remain misspelled in the table.
(d) You cannot edit data in a query.
10. Which of the following is not true about the Total row in the query design grid?
(a) The Total row enables you to apply aggregate functions to the fields.
(b) The Total row can apply to fields stored in different tables.
(c) The Total row is located between the Table and Sort rows.
(d) The Total row can only be applied to numeric fields.
ACCESS 4: CREATING AND USING PROFESSIONAL FORMS AND REPORTS Moving Beyond Tables and Queries
1. Which form tool does not place controls onto a form automatically?
(a) Form Wizard
(b) Form tool
(c) Form Design tool
(d) Datasheet tool
2. The Design view for a form enables you to do all of the following except:
(a) Modify the form.
(b) Add a new group.
(c) View the data as it will be presented in the form.
(d) Add a background color.
3. Which of the following guides you as you create a new report?
(a) Report tool
(b) Report Wizard
(c) Blank Report tool
(d) Report Design tool
4. Use the ____________ to see exactly what the printed report will look like before printing.
(a) Report tool
(b) Report Wizard
(c) Report view
(d) Print Preview
5. The easiest way to modify control widths in a form is in:
(a) Layout view.
(b) Form view.
(c) Design view.
(d) Report view.
6. What happens if you click a text box control in Layout view, and then press Delete?
(a) The control is deleted from the report, but the other controls do not adjust to the empty space.
(b) Nothing; you cannot change fields in Layout view.
(c) The record is deleted from the report and from the database.
(d) An error message appears stating that you should not attempt to delete records in a report.
7. The mouse pointer shape changes to a ____________when you widen or narrow a column in Layout view.
(a) single arrow
(c) two-headed arrow
(d) four-headed arrow
8. Which of these is not a section in an Access form?
(a) Detail section
(b) Group section
(c) Form Header section
(d) Form Footer section
9. Which statement is true about controls?
(a) Unbound controls are not used in reports.
(b) Unbound controls are not used in the Detail section.
(c) A calculated field is created with a text box control.
(d) A form’s title is usually created with the title control.
10. To organize your data in categories, you would use:
(d) Calculated fields.
INTRODUCTION TO POWERPOINT Presentations Made Easy
1. Which of the following print methods would you use for a large detailed table in your presentation?
(a) Handout, 6 Slides Horizontal
(c) Notes Pages
(d) Full Page Slide
2. While displaying a slide show, which of the following will display a list of shortcuts for navigating?
3. PowerPoint’s predefined slide arrangements are:
(a) Placeholder views.
(b) Slide layouts.
(c) Slide guides.
(d) Slide displays.
4. To add an object such as clip art to a slide, use the ___________ tab.
5. Which of the following is a true statement regarding themes?
(a) A theme must be applied before slides are created.
(b) The theme can be changed after all of the slides have been created.
(c) Themes control fonts and backgrounds but not placeholder location.
(d) Placeholders positioned by a theme cannot be moved.
6. Which of the following views is best for reordering the slides in a presentation?
(a) Presenter view
(b) Reading view
(c) Slide Sorter view
(d) Slide Show view
7. Normal view contains which of the following components?
(a) Slide Sorter pane, Slides and Outline tabs pane, and Reading pane
(b) Slides and Outline tabs pane, Slide pane, and Reading pane
(c) Slides and Outline tabs pane, Slide pane, and Notes pane
(d) Slide pane, Notes pane, and Slide Sorter pane
8. Which of the following is the animation effect that controls how one slide changes to another slide?
9. Which of the following cannot be used to focus audience attention on a specific object on a slide during a slide show?
(a) Put nothing on the slide but the object.
(b) Apply an animation to the object.
(c) Use the pen tool to circle the object.
(d) Apply a transition to the object.
10. Which of the following bullet points concerning content development is not in active voice and is not parallel to the other bullets?
(a) Identify the purpose of the presentation.
(b) Storyboards are used to sketch out thoughts.
(c) Brainstorm your thoughts.
(d) Research your topic.
POWERPOINT 2: PRESENTATION DEVELOPMENT Planning and Preparing a Presentation
1. A format that incorporates a theme, a layout, and content that can be modified is a(n):
2. To create a presentation based on an installed template, click the:
(a) File tab, and then click New.
(b) File tab, and then click Open.
(c) Insert tab, and then select Add Template.
(d) Design tab, and then select New.
3. What is the advantage to collapsing the outline so only the slide titles are visible?
(a) More slide titles are displayed at one time, making it easier to rearrange the slides in the presentation.
(b) Transitions and animations can be added.
(c) Graphical objects become visible.
(d) All of the above
4. Which of the following is true?
(a) Slides cannot be added to a presentation after a template has been chosen.
(b) Themes applied to a template will not be saved with the slide show.
(c) Placeholders downloaded with a template cannot be modified.
(d) The slide layout can be changed after the template has been chosen.
5. Which of the following is the fastest and most efficient method for reusing a slide layout you have customized in another presentation?
(a) Open the slide with the customized layout, delete the content, and enter the new information.
(b) Open the slide with the customized layout, and cut and paste the placeholders to a new slide.
(c) Save the custom slide layout, and reuse it in the new presentation.
(d) Drag the placeholders from one slide to the next.
6. Which of the following is not an efficient method for adding existing content to a presentation?
(a) Reuse Slides
(b) Slides from Outline
(c) Copy and paste slides from an existing slide show into a new slide show.
(d) Retype the content from an existing slide show into a new slide show.
7. Which of the following demotes a bullet point from the first level to the second level in Outline view?
(c) Decrease List Level
8. Which of the following is not true of sections?
(a) A slide show can be divided into only six logical sections.
(b) Sections can be created in Normal view or Slide Sorter view.
(c) Sections can be collapsed.
(d) Sections can be renamed.
9. Which of the following formats cannot be imported to use as an outline for a presentation?
10. You own a small business and decide to institute an Employee of the Month award program. Which of the following would be the fastest way to create the award certificate with a professional look?
(a) Enter the text in the title placeholder of a slide, change the font for each line, and drag several clip art images of awards onto the slide.
(b) Access Microsoft Office Online and download an Award certificate template.
(c) Create a table, enter the award text in the table, and then add clip art.
(d) Select a Theme, modify the placeholders, and then enter the award text information.
POWERPOINT 3: PRESENTATION DESIGN: Illustrations and Infographics
1. Shapes are:
(a) Images that you search for in the Shape Clip Organizer.
(b) Graphics such as lines, arrows, and squares, which you add using the Shapes gallery.
(c) A category of SmartArt.
(d) Graphics that you create by clicking in the Shape group on the Design tab.
2. To rotate a shape on your slide:
(a) Drag the green handle at the top of the image.
(b) Drag one of the corner adjustment handles.
(c) Double-click the lightning bolt, and then enter the number of degrees to rotate.
(d) Do nothing because shapes cannot be rotated.
3. Which of the following is a reason for grouping shapes?
(a) To be able to change each shape individually
(b) To move or modify the objects as one
(c) To connect the shapes with connectors
(d) To create a relationship diagram
4. Which of the following is a reason for ungrouping a clip art object?
(a) To resize the group as one piece
(b) To move the objects as one
(c) To add text on top of the group
(d) To be able to individually change shapes used to create the composite image
5. You have inserted a clip art image of the ocean with a palm tree on the right side of the beach. If you flip the image vertically, what would the resulting image look like?
(a) The image would show right side up, but the palm tree would be on the left side.
(b) The image would be rotated 270°, and the palm tree would be at the top.
(c) The image would be upside down with the palm tree pointing down.
(d) The image would be rotated 90°, and the palm tree would be on the bottom.
6. Which of the following might be a reason for changing the stacking order of shapes?
(a) To show a relationship by placing shapes in front of or behind each other
(b) To hide something on a shape
(c) To uncover something hidden by another shape
(d) All of the above
7. Which of the following is not available from the SmartArt gallery?
(a) Data table
(b) Pyramid diagram
(c) Process graphic
(d) Matrix block
8. You have items needed for a camping trip in a bullet placeholder. Which of the following SmartArt diagrams would you use to display the data as an infographic?
9. You are trying to align a shape directly on top of another, but it always jumps above or below where you need to place it. What feature should you deactivate?
(a) Align to
(b) Snap to
(d) Line Snap
10. Which of the following may be used to add emphasis to text on a slide?
(a) Apply a WordArt Quick Style to the selected text.
(b) Apply a Text Effect to the selected text.
(c) Create the text using the WordArt feature.
(d) All of the above
POWERPOINT 4: POWERPOINT RICH MEDIA TOOLS Enhancing with Multimedia
1. Which of the following file formats supports 16 million colors, is optimized for photographs and complex graphics, and is the format of choice for most photographs on the Web?
2. To transform a picture from cool colors (lower K) to warm colors (higher K), which of the following should you do?
(a) Sharpen the picture.
(b) Adjust the contrast of the picture.
(c) Increase the saturation of the picture.
(d) Change the tone of the picture.
3. Which of the following Picture Tools would help you adjust a scanned photograph that appears muddy and does not show much difference between the light and dark areas of the image?
(d) Compress Pictures
4. Which of the following is not permitted for a student project containing copyrighted material?
(a) The educational project is produced for a specific class and then retained in a personal portfolio for display in a job interview.
(b) Only a portion of copyrighted material was used, and the portion was determined by the type of media used.
(c) The student received permission to use copyrighted material to be distributed to classmates in the project.
(d) The student markets the project on a personal Web site.
5. Which of the following can be obtained from the Clip Art pane?
(a) Windows Video files (.avi)
(b) Moving Picture Experts Group movies (.mpg or .mpeg)
(c) Animated GIF files (.gif)
(d) Windows Media Video files (.wmv)
6. All of the following can be used to play a selected sound clip for preview except:
(a) Click Play in the Preview group on the Audio Tools Format tab.
(b) Click Play/Pause on the Media Controls bar.
(c) Click Play in the Preview group on the Audio Tools Playback tab.
(d) Click the blue bar on the right side of the clip in the Clip Art pane, and then select Preview/Properties.
7. Which of the following is a true statement regarding recording a narration?
(a) Narration cannot play at the same time as other audio clips.
(b) Narration is embedded on the slide on which it is recorded.
(c) Narration time cannot be recorded for use in a self-running presentation.
(d) Narrations cannot be paused during recording.
8. The Photo Album dialog box enables you to make all but this edit to pictures:
9. Which of the following formatting options is available for video?
(a) Brightness adjustment
(b) Sharpen adjustment
(c) Artistic effect application
(d) Background removal
10. Audio Playback tools enables you to do all of the following except:
(a) Add a bookmark.
(b) Fade the audio out.
(c) Loop the audio.
(d) Apply an artistic effect.