Computer Concepts and Applications
Exam Questions
Course Introduction
This course provides an overview of fundamental computer concepts and explores their practical applications in everyday life and professional settings. Topics include an introduction to computer hardware and software, operating systems, networking essentials, internet tools, word processing, spreadsheets, presentations, and database management. Students will develop digital literacy skills, learn about current trends in technology, and understand ethical and security considerations in the digital world, preparing them to use computers effectively in academic and workplace environments.
Recommended Textbook
New Perspectives Microsoft Office 365 and Office 2016 Introductory 1st Edition by Patrick Carey
Available Study Resources on Quizplus
18 Chapters
1311 Verified Questions
1311 Flashcards
Source URL: https://quizplus.com/study-set/1430 Page 2
Chapter 1: Creating a Database
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28362
Sample Questions
Q1) There are two ways to move vertically from one record to another in a table; use the vertical scroll bar or the ____________________.
Answer: navigation buttons
Q2) In a relational DBMS,a user may create a database structure that contains which of the following?
A)data, fields, and table relationships
B)numbers, tables, and fields
C)symbols, numbers, and tables
D)fields, tables, and table relationships
Answer: D
Q3) The default ____________________ provided by Access is the ID field.
Answer: primary key
Q4) Which button is used to open and close the Navigation Pane?
A)Navigation Bar
B)Record
C)Shutter Bar Open/Close
D)Table View
Answer: C
Q5) All of the data in a relational database are contained in ____________________.
Answer: tables
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Building a Database and Defining Table
Relationships
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28363
Sample Questions
Q1) A primary key that consists of two or more fields in a table.
A)Cascade Update Related Fields Option
B)Cascade Delete Related Records Option
C)Composite key
D)data redundancy
E)Data Type gallery
F)Design
G)orphaned record
H)propagate
I)Quick Start selection
J)referential integrity
Answer: C
Q2) A field in an Access database table that has no value is determined by Access to have a ____ value.
A)custom
B)zero
C)null
D)number
Answer: C
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Maintaining and Querying a Database
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28364
Sample Questions
Q1) The contents of query datasheet are permanent.____________________
A)True
B)False
Answer: False
Q2) When a question is asked of a database using a select query,the answer is returned as a data sheet.____________________
A)True
B)False
Answer: True
Q3) A sort field is unique if more than one record can have the same value for the sort field.__________________
A)True
B)False
Answer: False
Q4) The ascending sort order for the Date/Time data type sorts dates from ____________________.
Answer: oldest to most recent date
Q5) The ___________________ command allows hidden fields to be redisplayed. Answer: Unhide Fields
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Creating Forms and Reports
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28365
Sample Questions
Q1) A form layout is a set of controls grouped together in a form or report that can be manipulated as a single control.____________________
A)True
B)False
Q2) A form must be displayed in ____________________ view to navigate,view,and edit data.
Q3) To print two records from a form,select the ____ option in the Print dialog box.
A)Selected Page(s)
B)Current Page
C)Range
D)Selected Record(s)
Q4) Before applying a conditional format in a report,the ____ box must be selected.
A)field label
B)caption
C)field value
D)design
Q5) The default theme for a form as well as additional themes may be found in the ____________________ when viewing a form in Layout view.
Q6) A report layout may be changed using options on the ____________________ tab.
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Introduction to Cloud Computing and Office 365
Available Study Resources on Quizplus for this Chatper
36 Verified Questions
36 Flashcards
Source URL: https://quizplus.com/quiz/28366
Sample Questions
Q1) If you want to perform a task that is not available in Office Online,open the file in the full version of the application._________________________
A)True
B)False
Q2) You have a Microsoft account if you use any of the following EXCEPT ____.
A)Microsoft Edge
B)Windows 10 user account
C)Xbox account
D)Outlook.com
Q3) The ability to work on files at the same time as others
A)Office 365
B)Office Online
C)OneDrive
D)Cloud
E)Coauthoring
F)Microsoft Account
Q4) You cannot save to OneDrive from Backstage view in Access.
A)True
B)False
Q5) Describe the differences between Office 365 and Office Online.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Essential Computer Concepts
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28367
Sample Questions
Q1) Monitors are divided into a matrix of small dots called ____.
A)pixels
B)pixies
C)picas
D)points
Q2) An ergonomic keyboard is one that has been designed to fit the natural placement of your hands.
A)True
B)False
Q3) A data file contains instructions for a computer on how to perform a specific task.
A)True
B)False
Q4) An inkjet printer's speed is measured in ____.
A)cps
B)pps
C)ppm
D)dpi
Q5) Expansion cards plug into electrical connectors on the motherboard called ____________________.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Getting Started With Excel
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28368
Sample Questions
Q1) What is the syntax for a SUM formula adding the values of cell F6 to F9?
A)/SUM(F9:F6)
B)=SUM(F6/F9)
C)=END(F6:F9)
D)=SUM(F6:F9)
Q2) ____ displays the location of the different page breaks within the worksheet.
A)Normal
B)Page Preview
C)Page Break Preview
D)Page Break Layout
Q3) Which of the following takes precedence over multiplication?
A)division
B)exponentiation
C)addition
D)subtraction
Q4) "AZ" is an example of a ____.
A)column heading
B)row heading
C)cell reference
D)Name box
Page 9
To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: Formatting Workbook Text and Data
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28369
Sample Questions
Q1) When creating an Excel document,you should avoid using _____ text and background together,since this is the most common form of color blindness.
A)red and green
B)yellow and blue
C)black and white
D)red and yellow
Q2) Use the ____________________ button in the Alignment group on the Home tab to increase the size of the indention used in a cell.
Q3) One way to ensure that you are using consistent formats is to copy and paste your formats using the Format _____.
A)Master
B)Gallery
C)Palette
D)Painter
Q4) Fonts,colors,and cell styles are organized in _____ categories.
A)theme and non-theme
B)numbers and text
C)color and black and white
D)form and function
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Performing Calculations With Formulas and Functions
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28370
Sample Questions
Q1) The ____ function returns the maximum value in the range.
A)TOP
B)FIRST
C)MAX
D)MOST
Q2) Use ____ references when you want different formulas to refer to the same cell.
A)mixed
B)relative
C)absolute
D)fixed
Q3) When a formula includes a cell reference,Excel interprets that cell reference as being located relative to the position of the current cell._________________
A)True
B)False
Q4) Which of the following is not an Excel function category? ____
A)Math & Trig
B)Algebra
C)Statistical
D)Text
11
Q5) The ____________________ is the middle value from a sample.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Analyzing and Charting Financial Data
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28371
Sample Questions
Q1) Category values are usually located in the ____ of the data source.
A)first row
B)first column
C)either a or b
D)neither a nor b
Q2) Mya has decided she needs to move her chart so that it appears below her data source. Before she can move or resize her chart she must ______.
A)select the chart
B)hold down the SHIFT key
C)adjust the sizing handles
D)move the mouse pointer to the center of the chart.
Q3) Sometimes Mya might want to see information on only specific slices.Rather than creating a new chart that includes only those selections,she can _____ an existing chart.
A)search
B)filter
C)find
D)examine
Q4) ______ are horizontal and vertical lines that help you compare data and category values.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Internet Basics and Information Literacy
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28372
Sample Questions
Q1) ____ browsing displays multiple webpages in the same browser window.
A)Banded
B)Tabbed
C)String
D)Linked
Q2) Including two sentences from someone else's work in your research paper,without using quotation marks or attribution,is an example of libel.
A)True
B)False
Q3) A search engine results page displays links that are ____ at the top of the list.
A)more recent
B)longer and more detailed
C)more related to your search
D)shorter and more succinct
Q4) In the History list,within each site folder,the webpages you visited appear in ____________________ order.
Q5) MLA stands for ____________________ Association.
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Managing Your Files
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28373
Sample Questions
Q1) A computer is like a file cabinet that has two or more drawers.
A)True
B)False
Q2) ____ a file places a duplicate version of the file in a new location that you specify.
A)Doubling
B)Moving
C)Copying
D)Replicating
Q3) Sorting files means listing them in ascending order or descending order by a file detail._________________________
A)True
B)False
Q4) Windows stores folders and important files that it needs when you turn on the computer in the ____________________ directory.
Q5) The File Explorer window is divided into two sections,called ____________________.
Q6) A duplicate copy of important files is known as a(n)____________________.
Q7) What are the text's three main guidelines for creating folders?
Page 14
To view all questions and flashcards with answers, click on the resource link above.
Chapter 13: Creating a Presentation
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28374
Sample Questions
Q1) After opening PowerPoint,Ethan sees buttons to execute commands in the ____ area.
A)Ribbon
B)Slides tab
C)Placeholder
D)Access Spot
Q2) A(n)____,like any presentation,has a theme applied,but it also contains text,graphics,and placeholders to help direct you in creating content for a presentation.
A)format
B)template
C)outline
D)placeholder
Q3) When Kamilla clicks in the Title placeholder a contextual tab,the ____ tab,appears on the ribbon.
A)TEXT HELPER
B)DRAWING HELPER
C)TEXT TOOLS FORMAT
D)DRAWING TOOLS FORMAT
Q4) In ____________________ view,each slide fills the screen,one after another.
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 14: Adding Media and Special Effects
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28375
Sample Questions
Q1) To insert a table,in a content placeholder,click the INSERT tab on the ribbon,click the Table button in the ____ group,and then click Insert Table.
A)Data
B)Tables
C)Charts
D)Boxes
Q2) When you use ____________________ rows or columns,alternating rows or columns are filled with different shading.
Q3) The start timing setting is on the VIDEO TOOLS PLAYBACK ____.
A)slider
B)tab
C)button
D)group
Q4) A(n)____________________ is information arranged in horizontal rows and vertical columns.
Q5) A(n)____________________ is the manner in which a new slide appears on the screen in place of the previous slide during a slide show.
Q6) The ____________________ is the formatting of the area inside a shape.
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 15: Creating and Editing a Document
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28376
Sample Questions
Q1) In the _______ group on the HOME tab,you use the Line and Paragraph Spacing button to adjust paragraph and line spacing.
A)File
B)Fonts
C)Insert
D)Paragraph
Q2) Preformatted files in Word (e.g.,fax cover sheets,memos)are known as _______.
A)indices
B)templates
C)staged documents
D)default documents
Q3) Gabrielle is very excited and rushing.She continually types "teh" instead of "the." Fortunately,the _______.
A)AutoCorrect feature corrects it automatically
B)spelling checker corrects it automatically
C)AutoComplete feature corrects it automatically
D)grammar checker corrects it automatically
Q4) On the ____________________ ruler the 0-inch mark is like the origin on a number line.
Q5) The ____________________ allow you to change the way the document is displayed.
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 16: Navigating and Formatting a Document
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28377
Sample Questions
Q1) To hide the shaded space between pages,____.
A)right-click the shaded space and select Hide
B)double-click the shaded space
C)single-click the shaded space
D)press the Page Up key
Q2) To use cut and paste,click the Cut button from the ____ group on the HOME tab.
A)Styles
B)Clipboard
C)Paragraph
D)Editing
Q3) One of the most useful features of a word-processing program is the ability to move text easily.
A)True
B)False
Q4) The text you type in the Find what text box is known as the ____________________.
Q5) To move text with ____________________,select the text you want to move,press and hold down the mouse button,drag the text to a new location,and then release the mouse button.
Q6) You press ____________________ to paste the most recent copied item.
Page 18
To view all questions and flashcards with answers, click on the resource link above.
Chapter 17: Creating Tables and a Multipage Report
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28378
Sample Questions
Q1) After using the table for a few weeks,Josephine has gotten tired of having to look through every row for the name she wants to find.What would be the easiest way for Josephine to organize her data?
A)Use the Sort feature to arrange rows based on the contents of one column.
B)Open the table and do a Find each time she wants to locate information.
C)Use banded shading to make the table easier to read.
D)There is no way to organize this data in Microsoft Word.
Q2) Monica wants insert a cover page for her report.She needs to be sure her insertion point is at the beginning of the report.Then she would click the Cover Page button from the ____.
A)VIEW tab
B)INSERT tab
C)HOME tab
D)LAYOUT tab
Q3) A(n)____________________,or row of dots between tabbed text,makes it easier to read a long list of tabbed material.
Q4) You can add or delete rows and columns by using the buttons in the ____________________ group on the Mini toolbar,for example.
Q5) The area where a row and column intersect is called a(n)____________________.
Page 19
To view all questions and flashcards with answers, click on the resource link above.
Chapter 18: Enhancing Page Layout and Design
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28379
Sample Questions
Q1) To delete a drop cap,click the paragraph that contains it,open the Drop cap dialog box,and then click _______.
A)Delete
B)Remove
C)None
D)No Cap
Q2) Most clip art websites include a search box where you can type some descriptive clues to help you narrow down your selection to a smaller range of clip art._________________________
A)True
B)False
Q3) By default,a page border in Microsoft Word is positioned 24 points from the edges of the page._________________________
A)True
B)False
Q4) To begin cropping a graphic,you click the Crop button in the Size group on the GRAPHICS TOOLS FORMAT tab._________________________
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 20