Computer Literacy
Final Exam
Course Introduction
Computer Literacy introduces students to the fundamental concepts and practical skills necessary for effective use of computers in personal, academic, and professional settings. The course covers basic computer hardware and software components, operating systems, and essential applications such as word processors, spreadsheets, and presentation tools. Additionally, students will learn about internet safety, online communication, digital citizenship, and critical thinking in the digital age. Emphasis is placed on developing confidence in navigating technology, troubleshooting common issues, and utilizing digital resources responsibly to enhance productivity and problem-solving abilities.
Recommended Textbook
Skills for Success with Office 2013 1st Edition Volume 1 by Kris Townsend
Available Study Resources on Quizplus
20 Chapters
2051 Verified Questions
2051 Flashcards
Source URL: https://quizplus.com/study-set/2707
Page 2
Chapter 1: Create Database Tables
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/54000
Sample Questions
Q1) Access draws a relationship ________ between two tables.
A) line
B) column
C) pie
D) bar
Answer: A
Q2) To filter records with the values you choose, your first step is to ________.
A) clear the (Select All) check box
B) uncheck each check box individually
C) click the Erase button
D) select Remove Filter
Answer: A
Q3) While importing an Excel spreadsheet into Access, if the user chooses Append a copy of the records to the table and the table exists, Access will add the records to the table.
A)True
B)False
Answer: True
Q4) ________ determine what displays in all datasheet, form, and report labels.
Answer: Captions
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Create Select Queries
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/54001
Sample Questions
Q1) Using the Don* criteria, which of the following would NOT be matched?
A) Adonna
B) Donna
C) Donald
D) Don
Answer: A
Q2) When two criteria are placed in different rows in the design grid, the ________ logical operator applies.
A) And
B) Null
C) Or
D) Not Null
Answer: C
Q3) It is okay to include spaces in labels.
A)True
B)False
Answer: True
Q4) The ________ logical operator creates a comparison of two criteria that is true only when both criteria outcomes are true.
Answer: And
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Create Forms
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/54002
Sample Questions
Q1) Forms are designed to input data into tables.
A)True
B)False Answer: True
Q2) The Form Wizard allows only the user to select one table for use with the form.
A)True
B)False Answer: False
Q3) You can create a form that is based on a query that displays only the records returned by the query's ________.
A) sort
B) conditions
C) criteria
D) placeholders
Answer: C
Q4) A form and subform are saved as two separate forms.
A)True
B)False Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Create Reports
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54003
Sample Questions
Q1) In Print Preview view, a report displays as it will appear on the screen.
A)True
B)False
Q2) Switch to Print Preview to filter data and drill down to get needed information.
A)True
B)False
Q3) To copy all the formatting of one control to other controls, use the Format Painter.
A)True
B)False
Q4) By default, a report is set to the width of a printed sheet of ________.
Q5) Reports can be created quickly by selecting a table or query in the Navigation Pane, and then clicking the ________ button.
Q6) If you do not see the entire contents of a field, you can adjust the column width to ________.
Q7) The Group, Sort, and Total pane appears when the Group & Sort button is selected.
A)True
B)False
Q8) Use the ________ to modify a report's design.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Common Features of Office 2013
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54004
Sample Questions
Q1) The method you use to start an Office application depends on your operating system and the way your PC is configured.
A)True
B)False
Q2) In Excel, boxes formed by the intersection of a row and column are called
Q3) The Copy command moves text out of the original document and into the Office Clipboard.
A)True
B)False
Q4) Objects such as reports are opened and closed without closing the Access ________ itself.
A) presentation
B) manuscript
C) application
D) script
Q5) A theme includes color and font choices.
A)True
B)False
Q6) Templates for Office applications can be opened from the ________.
Page 7
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Getting Started With Computer Concepts
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54005
Sample Questions
Q1) ________ computing delivers services provided via the Internet.
Q2) A DVD drive is commonly assigned the letter ________.
A) D
B) B
C) C
D) E
Q3) ________ performs commands or types text based on words spoken into a microphone.
A) Text talking
B) Voice translation
C) Vocal conversion
D) Speech recognition
Q4) A monitor, headphones, and printer are examples of ________ devices.
Q5) If you want to project text and graphics on a screen for an audience to view, it is best to use a(n) ________.
Q6) The touch screen gesture "tap" is equivalent to the ________ mouse command.
Q7) It is a good idea to exercise caution when installing free software so that you don't end up with a virus.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Create Workbooks With Excel 2013
Available Study Resources on Quizplus for this Chatper
114 Verified Questions
114 Flashcards
Source URL: https://quizplus.com/quiz/54006
Sample Questions
Q1) Themed Cell Styles is an option in the ________.
A) Conditional Formatting gallery
B) Cell Styles gallery
C) Format gallery
D) Format as Table gallery
Q2) The data visible in the worksheet is the ________ value.
Q3) When Excel opens, a new blank ________ is displayed.
A) presentation
B) document
C) workbook
D) database
Q4) Fill Series
A)Automatic adjustment of cell references in formulas or functions that are copied
B)Auto Fill Option that copies numeric content without incrementing values
C)Small green square in lower right corner of selection
D)Auto Fill Option that automatically increments, by one, copied numeric values
Q5) What is the address of the cell in the upper leftmost corner of a worksheet?
Q6) A prewritten Excel formula that uses values, performs arithmetic operations, and returns a value is a(n) ________.
Page 9
To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: Insert Summary Functions and Create Charts
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54007
Sample Questions
Q1) Clicking the ________ button displays additional decimal values in the active cell.
Q2) When there is a change in the worksheet data, the corresponding chart is updated automatically.
A)True
B)False
Q3) Which is NOT a category in the Quick Analysis gallery?
A) Formatting
B) Charts
C) AutoSum
D) Tables
Q4) Press the ________ key to close the range finder.
Q5) When the Function AutoComplete list is used to enter the MAX function into an active cell, ________.
A) single-click on the name of the function in the list
B) right-click on the name of the function and click Insert
C) double-click on the name of the function in the list
D) click and drag the name of the function into the active cell
Q6) The AutoSum button is in the ________ group on the Home tab.
Q7) When a chart is selected, the ________ contextual tab appears on the Ribbon.
Page 10
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Manage Multiple Worksheets
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/54008
Sample Questions
Q1) A deleted worksheet can be restored with the Undo button on the Quick Access Toolbar.
A)True
B)False
Q2) Content of a cell can be cleared by pressing the ________ key when the cell is active.
Q3) The ________ option stops a worksheet tab from being displayed at the bottom of a workbook.
Q4) According to operator precedence, the correct order of mathematical operations is
A) parentheses; multiplication or division; addition or subtraction
B) parentheses; addition or subtraction; multiplication or division
C) addition or subtraction; multiplication or division; parentheses
D) multiplication or division; addition or subtraction; parentheses
Q5) Select All Sheets
A)Groups selected worksheets.
B)Makes worksheet invisible
C)Inserts worksheet and is located to right of sheet tabs
D)Relocates worksheet tab in tab row
Q6) Mathematical operators on the same level of precedence are evaluated
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: More Functions and Excel Tables
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/54009
Sample Questions
Q1) The prebuilt function COUNT is in the ________ category of the More Functions option in the Function Library group of the Formulas tab.
A) Cube
B) Engineering
C) Statistical
D) Information
Q2) What conditional formatting option is useful in identifying higher and lower numbers in a large group of data?
Q3) The symbols >, <, >=, <=, =, and <> are ________.
Q4) In a table with manual or conditional formatting, a column can be sorted only by ________.
A) color
B) smallest to largest value
C) largest to smallest value
D) style
Q5) Once a column adjacent to a table becomes a calculated column, it also becomes part of the table.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Browse With Internet Explorer
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54010
Sample Questions
Q1) A site index links you to suggested websites.
A)True
B)False
Q2) A site index is a page of ________ that outline a website.
A) hyperlinks
B) slides
C) charts
D) tables
Q3) The ________ option button allows you to print only highlighted text.
Q4) The Favorites button is a ________.
A) house
B) star
C) cogwheel
D) magnifying glass
Q5) A(n) ________ is a collection of connected pages located at a single domain name.
A) website
B) host
C) browser
D) app
Page 13
To view all questions and flashcards with answers, click on the resource link above.
Chapter 12: Getting Started With Powerpoint 2013
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54011
Sample Questions
Q1) Words with the same meaning are called ________.
Q2) The Edit command allows you to change multiple occurrences of the same text in a presentation.
A)True
B)False
Q3) In ________ view, the PowerPoint window is divided into two areas-the Slide pane and the left pane.
Q4) Font ________ and effects emphasize text and include bold, italic, underline, shadow, and outline.
A) styles
B) face
C) pitch
D) lists
Q5) Bullet points are organized in a hierarchy similar to a(n) ________.
Q6) In the Header and Footer dialog box, a slide ________ appears on each slide if the option is selected.
A) outline
B) summary
C) table
D) number
Page 14
To view all questions and flashcards with answers, click on the resource link above.
Chapter 13: Format a Presentation
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54012
Sample Questions
Q1) A Bullets gallery is available that provides bullet characters to apply to a selection.
A)True
B)False
Q2) ________ is the default theme applied to a new presentation.
Q3) The Start screen, where you can search for online templates and themes, displays only when you first start PowerPoint.
A)True
B)False
Q4) ________ is a pre-built set of fills, outlines, and effects used to create decorative text.
A) SmartArt
B) Outline View
C) WordArt
D) Master View
Q5) Enter a lower number in the Transparency box to make a background image more transparent.
A)True
B)False
Q6) The ________ button provides options for formatting pasted text.
Page 15
To view all questions and flashcards with answers, click on the resource link above.
Chapter 14: Enhance Presentations With Graphics
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54013
Sample Questions
Q1) The video displays at the bottom of the slide when initially inserted into a slide.
A)True
B)False
Q2) Presentation slides CANNOT be shared-content needs to be recreated.
A)True
B)False
Q3) The entries made in the Office.com Clip Art box are called keywords.
A)True
B)False
Q4) You must click the mouse button to get a video to begin playing.
A)True
B)False
Q5) The SmartArt button is found in the Text group of the Insert tab.
A)True
B)False
Q6) When applying a picture border, the smaller the point size, the thicker the border.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 15: Present Data Using Tables, Charts, and Animation
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54014
Sample Questions
Q1) Appear, Fly in, and Grow & Turn are examples of ________ effects.
A) Entrance
B) Emphasis
C) Exit
D) Motion
Q2) A(n) ________ chart includes only one data series.
Q3) Which of the following statements about pie charts is NOT true?
A) Pie charts include multiple data series.
B) Pie charts are used to illustrate percentages.
C) Pie charts are used to illustrate proportions.
D) Pie charts do not require a legend.
Q4) The height and width of the entire table can be modified.
A)True
B)False
Q5) A(n) ________ with sample data is used when creating a chart in PowerPoint.
A) database
B) legend
C) spreadsheet
D) document
Page 17
Q6) Live ________ displays the table with the selected style.
To view all questions and flashcards with answers, click on the resource link above.
Page 18
Chapter 16: Getting Started With Windows 8
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54015
Sample Questions
Q1) Use the ________ pane to find your applications, files, and computer settings or to search the interne.
Q2) It is good practice to store files for a project in multiple folders.
A)True
B)False
Q3) The ________ contains commands named Save and Undo.
Q4) The Details pane displays details about a selected file.
A)True
B)False
Q5) A picture password might have areas that need to be ________ in a certain order. A) scanned B) spoken to C) authenticated D) touched
Q6) The shortcut keys to position the insertion point at the end of a document are [Ctrl] + [End].
A)True B)False
Q7) To select a continuous range of files, use ________.
Q8) A zipped folder contains a file or group of files that are ________.
To view all questions and flashcards with answers, click on the resource link above. Page 19
Chapter 17: Create Letters and Memos
Available Study Resources on Quizplus for this Chatper
114 Verified Questions
114 Flashcards
Source URL: https://quizplus.com/quiz/54016
Sample Questions
Q1) Footer content that is not obtained from the Footer gallery but is instead entered by the user is a(n) ________ footer.
Q2) The Undo button is located on the Home tab of the Ribbon.
A)True
B)False
Q3) Dialog boxes often contain content not on the Ribbon.
A)True B)False
Q4) Typing while text is selected inserts the typed text above the selected content. A)True
B)False
Q5) A selected field is shaded in ________. A) blue
B) black
C) gray
D) red
Q6) In a document, flagged errors are identified by red and green exclamation points. A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 20
Chapter 18: Create Business Reports
Available Study Resources on Quizplus for this Chatper
114 Verified Questions
114 Flashcards
Source URL: https://quizplus.com/quiz/54017
Sample Questions
Q1) The purpose of the Widow/Orphan control and "Keep with next" paragraph setting is to prevent a heading and the paragraph that follows from becoming separated across two pages.
A)True
B)False
Q2) Which is NOT an option in the Header & Footer group?
A) Header
B) Footer
C) Page Numbering
D) Text Box
Q3) Reports should have ________ blank line(s) between elements.
A) one
B) two
C) three
D) four
Q4) If paragraph 1 is selected and bold applied, paragraph 3 selected and underline applied, and paragraph 5 selected and the F4 key pressed, paragraph 5 will be both bold and underlined.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 21
Chapter 19: Create Flyers
Available Study Resources on Quizplus for this Chatper
107 Verified Questions
107 Flashcards
Source URL: https://quizplus.com/quiz/54018
Sample Questions
Q1) When the ________ text-wrapping layout option is applied to a picture, it enables the picture to move independent of its surrounding text.
Q2) When the insertion point is in the last cell of a table, pressing the Tab key
A) inserts a column to the right of the last column in the table
B) inserts a row at the bottom of the table
C) inserts a table below the current table
D) moves the insertion point to the paragraph below the table
Q3) Vertical Alignment
A)Table option that turns multiple adjacent cells into a large single cell
B)Series of evenly spaced dots preceding a tab stop
C)In a table, spacing above and below text or an object relative to top and bottom of cell
D)Set of prebuilt formatting options that are applied to a table with a single-click
E)Series of characters that fill the space preceding a tab
Q4) New tab stops are always inserted between the existing default tab stops.
A)True
B)False
Q5) Like a graphic, a table is associated with a(n) ________.
To view all questions and flashcards with answers, click on the resource link above. Page 22
Chapter 20: Create Newsletters and Mail Merge Documents
Available Study Resources on Quizplus for this Chatper
106 Verified Questions
106 Flashcards
Source URL: https://quizplus.com/quiz/54019
Sample Questions
Q1) Ctrl + mouse click
A)Document section that can be formatted differently from rest of document
B)Extra details or hooks at the end of each stroke in a character
C)Font in which characters lack extra details or hooks at the end of each stroke
D)A mark indicating the end of one section and the beginning of another
E)Aligns text with left margin and right margin
Q2) Merge Fields
A)Document section that can be formatted differently from rest of document
B)Extra details or hooks at the end of each stroke in a character
C)Font in which characters lack extra details or hooks at the end of each stroke
D)A mark indicating the end of one section and the beginning of another
E)Aligns text with left margin and right margin
Q3) A(n) ________ is a line that appears when an image is being moved and that can be used to align the image with specific areas of the document.
A) Alignment Guide
B) Anchor
C) Margin Guide
D) Smart Guide
Q4) When labels are mail-merged, the merged document displays the labels in a(n)
To view all questions and flashcards with answers, click on the resource link above. Page 23