Applied Computer Skills
Exam Questions
Course Introduction
Applied Computer Skills is a practical course designed to equip students with essential digital competencies for academic, professional, and personal use. The curriculum covers a range of topics, including word processing, spreadsheets, presentations, online collaboration tools, internet research techniques, and data management. Emphasis is placed on real-world applications, problem-solving, and the effective use of software suites such as Microsoft Office and Google Workspace. By the end of the course, students will have gained the confidence and proficiency to efficiently utilize computer technology in various contexts and adapt to continually evolving digital environments.
Recommended Textbook
Your Office Microsoft Office 2010 Volume I 2nd Edition by Amy S. Kinser
Available Study Resources on Quizplus
24 Chapters
1775 Verified Questions
1775 Flashcards
Source URL: https://quizplus.com/study-set/1539 Page 2
Chapter 1: Integrated Projects, workshop 1: Integrating Word and Excel
Available Study Resources on Quizplus for this Chatper
26 Verified Questions
26 Flashcards
Source URL: https://quizplus.com/quiz/30394
Sample Questions
Q1) An object copied to the ________ can be pasted into any Office program.
A) file
B) program
C) Clipboard
D) application
Answer: C
Q2) The program that you insert an object into is called a(n)________ program.
A) embedded
B) destination
C) linked
D) source
Answer: B
Q3) When a destination file is closed and then opened,the linked object must be manually updated unless you turn OFF automatic updates in the Links options.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above.
Page 3
Chapter 2: Integrated Projects, workshop 2: Integrating
Word, excel, and Access
Available Study Resources on Quizplus for this Chatper
26 Verified Questions
26 Flashcards
Source URL: https://quizplus.com/quiz/30405
Sample Questions
Q1) When the Mail Merge Wizard is started in Access,it gives you the option to
A) create a new Word document or use an existing one
B) create a new report to export to a Word document
C) select an existing Word document
D) create a new query to export to a Word document
Answer: A
Q2) The ________ bar reports that certain features of Access have been disabled to maintain security and prevent viruses from infecting your computer.
Answer: Security Warning
Q3) Data is stored in Excel in ________.
A) a chart
B) a flat table
C) a relational table
D) multiple tables
Answer: B
Q4) Before you can import Excel data into Access,you must make sure that there are no ________ rows in the Excel file.
Answer: blank
4
To view all questions and flashcards with answers, click on the resource link above.
Chapter 3: Integrated Projects, workshop 3: Integrating
Available Study Resources on Quizplus for this Chatper
26 Verified Questions
26 Flashcards
Source URL: https://quizplus.com/quiz/30408
Sample Questions
Q1) Importing data from an Access database into an Excel worksheet creates a(n)________ connection.
Answer: permanent
Q2) The ________ button allows you to show the lower levels in an outline after they have been collapsed.
A) Display
B) Expand
C) Show/Hide
D) Collapse
Answer: B
Q3) A(n)________ is a group of paragraphs in a hierarchical format that Word recognizes by end-of-paragraph marks.
A) report
B) sentence
C) outline
D) document
Answer: C
Q4) A hierarchical representation of paragraphs is called a(n)________.
Answer: outline
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Integrated Projects, workshop 4: Integrating
Available Study Resources on Quizplus for this Chatper
41 Verified Questions
41 Flashcards
Source URL: https://quizplus.com/quiz/30409
Sample Questions
Q1) HTML and PDF are two of the formats used to send Access data by e-mail as a(n)________.
A) data form
B) information request
C) data message
D) attached object
Q2) When you create an e-mail message in mail merge,only ________ listed in the To line are recognized.
A) addresses
B) names
C) contacts
D) links
Q3) To collect new data from a recipient or to update existing data,you would use a(n)________ form.
A) Access
B) data collection
C) Word
D) PowerPoint
Q4) A(n)________ is a saved collection of fonts,colors,effects,and backgrounds which can be applied to an e-mail message.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Microsoft Access 2010,workshop 1: Understanding
the Four Main Database Objects
Available Study Resources on Quizplus for this Chatper
80 Verified Questions
80 Flashcards
Source URL: https://quizplus.com/quiz/30410
Sample Questions
Q1) To prevent data entry clerks from having access to data that is not needed in their jobs,such as salaries or social security numbers of employees,a form can be developed that gives them only the access they need to complete their work.
A)True
B)False
Q2) In Access,data is stored in an arrangement of columns and rows called ________.
Q3) Copying data from another file in an Excel worksheet is called ________.
Q4) A database and a database management system are not the same thing.A database is a collection of data,while a database management system is a software program that manages the data.
A)True
B)False
Q5) Once you run a virus scan,you can trust a file permanently.
A)True
B)False
Q6) While it is possible to import data from an Excel file,it is NOT possible to import data from a Word file.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Microsoft Access 2010,workshop 2: Gathering
Data Into a Database
Available Study Resources on Quizplus for this Chatper
84 Verified Questions
84 Flashcards
Source URL: https://quizplus.com/quiz/30411
Sample Questions
Q1) In Access,the relationship information is stored in the ________ window.
Q2) Design changes are not saved until you save,but data changes are automatically saved.
A)True
B)False
Q3) Delimited text has a special character such as a tab or a comma separating field entries.
A)True
B)False
Q4) When cutting and pasting columns from Excel to Access,they must be the exactly the same.
A)True
B)False
Q5) When you delete an individual field from a table,the deletion is ________.
A) permanent
B) invariable
C) temporary
D) constant
Page 8
Q6) Before you can create a relationship between two tables,they have to have a(n)________ in common.
To view all questions and flashcards with answers, click on the resource link above.
Page 9
Chapter 7: Microsoft Access 2010,workshop 3: Accessing
Information From an Access Database
Available Study Resources on Quizplus for this Chatper
89 Verified Questions
89 Flashcards
Source URL: https://quizplus.com/quiz/30412
Sample Questions
Q1) The view that allows you to view all records in a table at one time is the design view.
A)True
B)False
Q2) In Query Design view,you can select up to ________ fields to sort by.
A) 50
B) 10
C) 25
D) 5
Q3) When you want to describe one field in terms of two or more other fields in a table you use a(n)________.
A) find duplicates query
B) cross-tab query
C) matched query
D) find unmatched query
Q4) A(n)________ query makes trouble-shooting more difficult if the query does not work.
Q5) A single table query pulls data from two or more tables.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 8: Microsoft Access 2010,workshop 4: Maintaining and Presenting Data
Available Study Resources on Quizplus for this Chatper
86 Verified Questions
86 Flashcards
Source URL: https://quizplus.com/quiz/30413
Sample Questions
Q1) Page breaks display in the Report view.
A)True
B)False
Q2) When you create a form using two related tables,the main form will display the first table one record at a time,while the ________ will display as a datasheet below the main form record.
Q3) A control whose data source is a calculated expression that you create is called a(n)________ control.
A) bound
B) calculated
C) unbound
D) text box
Q4) If you need to have calculations performed on a group in a report,they are added to the ________ section.
Q5) Groups are added to a section of the report called the ________.
A) group header
B) group footer
C) group window
D) group area
Page 11
Q6) You can apply a(n)________ to a single object or to all matching objects.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 9: Microsoft Excel 2010,workshop 1: Understanding and Manipulating Microsoft Excel 2010
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/30414
Sample Questions
Q1) The part of a document that does not contain data is known as ________.
Q2) Which of the following represents a cell range?
A) C6-E10
B) $B$6
C) A4 + D14
D) N8:P9
Q3) By clicking on a worksheet tab,a user makes it the ________ worksheet.
Q4) Page breaks can NOT be inserted into an Excel worksheet.
A)True
B)False
Q5) Sheet1 is an example of a default ________ within a workbook.
A) worksheet
B) row
C) cell
D) column
Q6) The intersection of column F and row 5 has the cell reference ________.
Q7) Changing values in spreadsheet cells to investigate the effects is known as what-if analysis.
A)True
B)False Page 13
To view all questions and flashcards with answers, click on the resource link above.
Page 14
Chapter 10: Microsoft Excel 2010, workshop 2: Formatting, formulas,
and Functions
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/30395
Sample Questions
Q1) A value in a cell that is referenced in a formula or function is known as a variable. A)True
B)False
Q2) If you would like values between 25 and 50 in a range of cells to appear in yellow,use conditional formatting.
A)True
B)False
Q3) Rather than hard-code a value,it is considered good practice to use a(n)________ instead.
A) function
B) parameter
C) constant
D) argument
Q4) Not all formulas start with the equal sign (=).
A)True
B)False
Q5) If cell J6 contains 14 and cell J7 contains 6,the ________()function would return 10 if applied to that range.
Q6) Variables or values inside a function's parentheses are known as ________.
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 11: Microsoft Excel 2010,workshop 3: Conducting
Excel Analysis Through Functions and Charts
Available Study Resources on Quizplus for this Chatper
62 Verified Questions
62 Flashcards
Source URL: https://quizplus.com/quiz/30396
Sample Questions
Q1) To perform a comparison and make a decision based on that decision,use a ________ function.
A) logical
B) math & trig
C) statistical
D) financial
Q2) All arguments MUST be separated by commas.
A)True
B)False
Q3) The Statistical Function Category is used when working with ________ calculations.
Q4) Some functions have optional arguments that can remain blank.
A)True
B)False
Q5) Which of the following is the function in the following formula: =AVERAGE(E2:E5)
A) =
B) E2:E5
C) AVERAGE
D) None of the above are functions.
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 12: Microsoft Excel 2010,workshop 4: Using Charts
Available Study Resources on Quizplus for this Chatper
54 Verified Questions
54 Flashcards
Source URL: https://quizplus.com/quiz/30397
Sample Questions
Q1) Bar charts and column charts are identical in function aside from the direction the bars are drawn in.
A)True
B)False
Q2) Which of the following chart types are most similar in function?
A) area and pie
B) area and line
C) column and scatter
D) scatter and pie
Q3) If a user wants to compare categorized data sets,they can do so effectively using a bar chart.
A)True
B)False
Q4) Two chart types can be combined,for example,by overlaying a line chart on top of a column chart.
A)True
B)False
Q5) A(n)________ chart is a variation of a stacked line chart that emphasizes the magnitude of change over time and visually depicts a trend.
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 13: Microsoft Office Outlook 2010, workshop
1: Communicating With E-Mail, and Managing Contacts, calendars, and Tasks
Available Study Resources on Quizplus for this Chatper
86 Verified Questions
86 Flashcards
Source URL: https://quizplus.com/quiz/30398
Sample Questions
Q1) Mail sent through the U.S Postal Service is sometimes called ________.
A) postcards
B) letters
C) snail mail
D) paper mail
Q2) A feature that provides a quick overview of the calendar,upcoming appointments,and tasks is the ________.
A) To-Do Bar
B) Date Navigator
C) Notes Bar
D) Daily Calendar
Q3) Before sending an e-mail,you should double-check the addresses entered into the address boxes to ensure they are accurate.
A)True
B)False
Q4) When you receive new mail,by default,it goes into the Outlook ________ folder on your computer.
Q5) The ________ component of Outlook allows you to store personal information,notes,and a photograph of the person on the card. Page 18
To view all questions and flashcards with answers, click on the resource link above.
Page 19
Chapter 14: Microsoft Powerpoint 2010 workshop 1:
Communicating With Presentations
Available Study Resources on Quizplus for this Chatper
84 Verified Questions
84 Flashcards
Source URL: https://quizplus.com/quiz/30399
Sample Questions
Q1) The size of placeholders can be adjusted by dragging the ________ handles that appear when you click the content area.
Q2) Fonts that look better on hard copies are also known as ________-friendly fonts.
Q3) Which of the following statements about serif fonts is TRUE?
A) Serif fonts generally are used for the content of a slide.
B) Serif fonts were designed specifically for screens.
C) Serif fonts have small lines at the end of the letters.
D) Serif fonts include Arial, Verdana, and Trebuchet.
Q4) Placeholder size can be adjusted by dragging which of the following?
A) Format Painter
B) Slide tab
C) Sizing handle
D) Template
Q5) The view used to edit a slide is also called the ________ view.
Q6) If a presentation has a format that a user wishes to copy to a number of other locations,they can use the Format ________ tool to do so.
Q7) The Slide ________ view allows users to review transitions and rearrange slides.
Q8) PowerPoint presentations have many pre-built slide ________,which contain different slide setups,such as title slide,and title and content. Page 20
To view all questions and flashcards with answers, click on the resource link above.
Page 21
Chapter
15: Microsoft Powerpoint 2010,workshop 2: Applying and Modifying Text and Graphics
Available Study Resources on Quizplus for this Chatper
65 Verified Questions
65 Flashcards
Source URL: https://quizplus.com/quiz/30400
Sample Questions
Q1) Conceptual drawings of what will appear on your slides are known as ________.
A) layouts
B) storyboards
C) bitmaps
D) vectors
Q2) PowerPoint does not include animated clip art.
A)True
B)False
Q3) Combining two cells in a table is known as ________.
Q4) Information appearing at the bottom of a slide is known as a slide ________.
Q5) Another term for color temperature is color ________.
Q6) Which of the following is NOT an example of a graphic?
A) transitions
B) clip art
C) photographs
D) charts
Q7) Pecha Kucha presentations generally display 20 slides for 20 seconds each.
A)True
B)False
Page 22
Q8) ________ charts show proportions that add up to 100%.
To view all questions and flashcards with answers, click on the resource link above.
Page 23
Chapter 16: Microsoft Powerpoint 2010,workshop 3: Applying and Modifying Multimedia
Available Study Resources on Quizplus for this Chatper
69 Verified Questions
69 Flashcards
Source URL: https://quizplus.com/quiz/30401
Sample Questions
Q1) To play a sound on an object that already contains animation,use a(n)________.
Q2) Custom slide shows are a subset of slides in a larger presentation.
A)True
B)False
Q3) A special shape with predefined actions that can be added to a presentation is also known as a(n)________.
A) hyperlink
B) transition
C) trigger
D) Action Button
Q4) PDF and XPS files can contain audio and video.
A)True
B)False
Q5) If an object has an Emphasis,Entrance,and Exit effect,the ________ effect generally will be the last one to be shown.
Q6) A caption is a text box that describes a photograph.
A)True
B)False
Q8) A(n)________ slide show is a subset of slides in a larger presentation. Page 24
Q7) Though you can use a text box,you can alternately insert a(n)________.
To view all questions and flashcards with answers, click on the resource link above.
Page 25
Chapter
Customizing, Collaborating, and Presenting
Available Study Resources on Quizplus for this Chatper
62 Verified Questions
62 Flashcards
Source URL: https://quizplus.com/quiz/30402
Sample Questions
Q1) Slide sections can be expanded and collapsed.
A)True
B)False
Q2) PowerPoint presentations are saved by default in the ________ folder.
Q3) PowerPoint includes proofing tools such as the slide master and annotations.
A)True
B)False
Q4) Custom templates are found the same way as other templates.
A)True
B)False
Q5) Speaker notes allow you to write words to be said during a presentation and store them with the electronic presentation.
A)True
B)False
Q6) PowerPoint enables you to ________,or make notations or marks on slides during your presentation.
Q7) The notes master and handout master are two examples of PowerPoint's
Q8) Annotations can not be saved within a presentation. A)True Page 26
To view all questions and flashcards with answers, click on the resource link above.
Page 27
Chapter 18: Microsoft Word 2010,workshop 1: Reviewing and Modifying a Document
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/30403
Sample Questions
Q1) By displaying the nonprinting characters,you can troubleshoot a document to remove unnecessary tabs and spaces.
A)True
B)False
Q2) Sarah wants to move the insertion point to a location further down the document page.To do this,she must ________.
A) use the Tab button to move to the location where she wants to type text
B) use the vertical scrollbar to scroll down to the location where she wants to type text
C) use the horizontal scrollbar to scroll to the location where she wants to type text
D) click at the location where she wants to type text
Q3) Documents of all types are created using ________ software.
A) word processing
B) multimedia
C) documentation
D) writing
Q4) Nonprinting characters are also known as ________.
Q5) Files sent to the web from Word 2010 are saved to a(n)________ account.
To view all questions and flashcards with answers, click on the resource link above. Page 28
Chapter 19: Microsoft Word 2010,workshop 2: Creating and Editing a Document
Available Study Resources on Quizplus for this Chatper
89 Verified Questions
89 Flashcards
Source URL: https://quizplus.com/quiz/30404
Sample Questions
Q1) Word's ________ has a set of related features for getting around in a document and searching for content.
A) Navigation Pane
B) Search and Find feature
C) Search Pane
D) Find and Replace feature
Q2) Word considers a report title,a salutation in a letter,and a bullet all to be a ________.
A) unique style
B) paragraph
C) document section
D) block of text
Q3) When you center a page evenly between the ________,you center it vertically.
A) top and bottom page edges
B) left and right page edges
C) top and bottom margins
D) left and right margins
Q4) ________ is an easy to use tool that allows you to copy the format from one area of text to another.
Q5) All new Word documents use the default style called ________.
To view all questions and flashcards with answers, click on the resource link above. Page 29
Chapter 20: Microsoft Word 2010,workshop 3: Including
Tables and Objects
Available Study Resources on Quizplus for this Chatper
89 Verified Questions
89 Flashcards
Source URL: https://quizplus.com/quiz/30406
Sample Questions
Q1) If you can't locate the clip art you need for your document,you can search Microsoft's ________ gallery.
Q2) The green handle that displays at the top center of a selected WordArt object is used to ________ the object.
A) resize
B) rotate
C) move
D) format
Q3) An item that you can work with independently of surrounding text is a(n)________.
A) image
B) object
C) textbox
D) clip art
Q4) To delete a picture from your document,you first select the picture,and then press Delete.
A)True
B)False
Q5) To navigate through a table,use the Tab or ________ keys to move to adjacent cells.
To view all questions and flashcards with answers, click on the resource link above. Page 30
Chapter 21: Microsoft Word 2010,workshop 4: Formatting
Special Documents and Using Mail Merge
Available Study Resources on Quizplus for this Chatper
86 Verified Questions
86 Flashcards
Source URL: https://quizplus.com/quiz/30407
Sample Questions
Q1) Word incorporates all the parts of a mailing address ,the recipient name,street address,city,state,and zip,into a unit called the ________.
A) merge block
B) address section
C) merge section
D) address block
Q2) In Word's Mail Merge function,the ________ block contains all the components needed to print labels or envelopes.
Q3) Using a(n)________ will help to balance and align columns more evenly.
Q4) In a business letter,the ________ typically includes a title and a last name followed by a colon.
Q5) A set of standards for citations,margins,spacing,headers,footers,and page numbers are detailed in a(n)________.
A) document guide
B) citation guide
C) newsletter guide
D) style guide
To view all questions and flashcards with answers, click on the resource link above. Page 31
Q6) A reference or ________ is necessary,even when you paraphrase someone else's work.
Chapter 22: Appendix: Microsoft Windows 8: Understanding
the Windows 8 Interface
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/30415
Sample Questions
Q1) All versions of Windows contain a text editing program named ________.
Q2) The edge of the display screen in Windows 8 is commonly called the bezel.
A)True
B)False
Q3) In Windows 8 to zoom-out the user pinches the screen.
A)True
B)False
Q4) The default screen for Windows 8 is the ________ screen.
A) Introduction
B) Start
C) Opening
D) Go
Q5) Windows 8 has added a search option to the Charm Bar.
A)True
B)False
Q6) The ________ tool allows users to take a picture of their current screen.
Q7) The Charm menu in Windows 8 has twelve options to choose from.
A)True
B)False
Page 32
Q8) Windows 8 has removed the ________ button from its display screen.
To view all questions and flashcards with answers, click on the resource link above. Page 33
Chapter 23: Common Features,workshop 1: Understanding
the Common Features of Microsoft Office
Available Study Resources on Quizplus for this Chatper
88 Verified Questions
88 Flashcards
Source URL: https://quizplus.com/quiz/30416
Sample Questions
Q1) As you work,you should save your word at least every ________.
A) two minutes
B) twenty minutes
C) ten minutes
D) thirty minutes
Q2) Microsoft OneNote is a program used to develop presentation slides.
A)True
B)False
Q3) The two tabs all Microsoft Office applications have in common are the ________.
A) Home tab and the Charts tab
B) Home tab and the File tab
C) Design tab and the File tab
D) Insert tab and the Mailing tab
Q4) The Formulas tab is specific to the ________ application.
A) Excel
B) Access
C) Publisher
D) OneNote
To view all questions and flashcards with answers, click on the resource link above. Page 34
Q5) The Microsoft Office application that is referred to as an information management program is ________.
Chapter 24: Windows 7, workshop 1: Understanding the Windows 7
Desktop and Managing Windows
Available Study Resources on Quizplus for this Chatper
85 Verified Questions
85 Flashcards
Source URL: https://quizplus.com/quiz/30417
Sample Questions
Q1) The ________ button turns open windows transparent to reveal the desktop,letting you peek at the desktop for a moment.
A) Unhide desktop
B) Show desktop
C) Peek
D) Display desktop
Q2) A bar that appears on the right side of the menu when all items are not visible on the menu list is the ________.
A) scan bar
B) jump bar
C) roll bar
D) scroll bar
Q3) To make frequently used programs always available on the Start menu,you can ________ them to the top of the Start menu.
Q4) Icons are images used as background on the computer desktop.
A)True
B)False
Q5) When a program is pinned to the ________,only one click is required to open it.
To view all questions and flashcards with answers, click on the resource link above. Page 35
Q6) You can double-click the ________ of a window to maximize it or to restore it.