Computer Skills for College Practice Exam
Course Introduction
This course introduces students to essential computer skills necessary for academic success in college. Emphasizing practical applications, the curriculum covers fundamental concepts such as operating systems navigation, internet research techniques, word processing, spreadsheet management, presentation software, and digital communication tools. Students will also gain an understanding of digital security and responsible online behavior. The course is designed to equip learners with the technological proficiency required for coursework, collaboration, and independent study in a variety of disciplines.
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) A query is used to enter,edit,and view records in a database._________________________
A)True
B)False
Answer: False
Q2) The specific content of a field.
A)field value
B)primary key
C)Backstage view
D)data type
E)Current Record Box
F)Create tab
G)query
H)Simple Query Wizard
I)Print Preview
J)File tab
Answer: A
Q3) 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
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 field used to connect one table logically with another table is called a ____ field. A)common
B)primary
C)composite
D)data
Answer: A
Q2) When text is used as the Default Value for a field property,it is recommended that the text be enclosed within quotation marks to avoid an "invalid syntax" error message._________________________
A)True
B)False
Answer: True
Q3) ____________________ values are never allowed by Access in the primary key field.
Answer: Duplicate
Q4) The "many" side of a one-to-many relationship is represented by the ____________________ at the end of the join line.
Answer: infinity symbol
Page 4
To view all questions and flashcards with answers, click on the resource link above.
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) Logical operators must be used in order to combine two or more conditions in a query.____________________
A)True
B)False
Answer: True
Q2) Which aggregate function would be used to calculate the lowest field value for the selected records?
A)Average
B)Minimum
C)Maximum
D)Count
Answer: B
Q3) The default query type for Access is the Crosstab query.____________________
A)True
B)False
Answer: False
Q4) The ___________________ command allows hidden fields to be redisplayed. Answer: Unhide Fields
Q5) The default name for a new Access query is ____________________. Answer: Query1
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) The Form Wizard limits fields to be used in a form to one table or one query.____________________
A)True
B)False
Q2) The ____ is located to the right of the navigation buttons and is used to locate a specific record in a form.
A)Record number
B)Search box
C)Find box
D)Locate box
Q3) To resize an image without changing its proportions,simply drag ____ of the image.
A)the left side
B)the top
C)any corner
D)the bottom
Q4) Alignment of text in a field value may be changed using the ____________________ tab in the REPORT LAYOUT TOOLS contextual tabs when designing a report.
Q5) A report layout may be changed using options on the ____________________ tab.
To view all questions and flashcards with answers, click on the resource link above. Page 6
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) 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
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) When you use a public computer,you will be required to enter the password associated with your ____________________ account to access files you have saved on OneDrive.
Q4) Describe the differences between Office 365 and Office Online.
Q5) If you move a file to the OneDrive folder,the file will be ____________________ to OneDrive automatically.
Q6) Discuss how to coauthor documents using OneDrive.
Q7) Describe what happens when you open a file in OneDrive from a browser.
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) ____ is a computer's ability to start and run more than one program at a time.
A)Hyperthreading
B)Hypertexting
C)Synchronous networking
D)Multitasking
Q2) The most popular printers for business use are ____ printers.
A)dot-matrix
B)laser
C)inkjet
D)thermal drum
Q3) ____ is space on Windows Live servers where you can store files in public or private folders,or in folders that you make available to only people you specify.
A)HotDrive
B)MS Docs
C)i-Live
D)OneDrive
Q4) ____________________ are notebook computers that are smaller and less powerful than standard notebooks,but have a longer battery life.
Q5) The term GB stands for ____________________.
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) The formula bar displays the value or formula of the active cell._________________________
A)True
B)False
Q2) A common business practice is to include a worksheet named Documentation that contains a description of the workbook,the name of the person who prepared the workbook,and the date it was created._________________________
A)True
B)False
Q3) In the formula,=2+6*2,addition would be calculated after multiplication._________________________
A)True
B)False
Q4) The name of the active workbook appears in the status bar of the Excel window._________________________
A)True
B)False
Q5) The range reference for a(n)____________________ range includes the range reference to each range,separated by a semicolon.
To view all questions and flashcards with answers, click on the resource link above. Page 9
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) In Excel,to merge cells A1,B1,C1,D1,and E1,_____ is the correct reference for the merged cell.
A)A1!E1!
B)A1
C)E1
D)A1-E1
Q2) Information that prints on each page,like a company name or logo,may be set as a _____.
A)print setup
B)copied text
C)text header
D)print title
Q3) Each worksheet will contain a specific class with the students' grades for the entire term.In order to determine the current student grade,Antoinette would have to use the _____ function.
A)SUM
B)AVERAGE
C)COUNT
D)MEDIAN
Q4) A(n)____________________ is text printed in the top margin of each page.
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) Susan needs to use a lookup function to find an exact match of an inventory item,so she will set the range_lookup value to _______ .
A)EXACT
B)1
C)TRUE
D)FALSE
Q2) Lookup tables can be constructed for exact match or approximate match lookups._______________
A)True B)False
Q3) Not all functions have arguments,and some functions have ____________________ arguments,which are not required for the function to return a value,but can be included to provide more control over the returned value.
Q4) ____________________ is a set of rules which specifies how a function should be written.
Q5) Functions are organized in the Function Library group on the FORMULAS tab._______________
A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
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) Consider the impact of a poorly designed chart.Explain why it is important to have a well-designed chart,and name at least four tips for creating a good chart.
Q2) Line charts are best suited for representing data that follows some nonsequential order.___________
A)True
B)False
Q3) It's difficult to read the exact scale on some of Simon's data.Adding ____ would make it easier to read.
A)a legend
B)major tick marks
C)colors
D)more numbers
Q4) Simon wants to change the chart's border.To do this,he should select the CHART TOOLS ____ tab.
A)FORMAT
B)EDIT
C)DESIGN
D)LAYOUT
Q5) Each value from a data series is represented by a ________.
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) The website "flowers.org" is most likely a ____.
A)nonprofit
B)commercial organization
C)government website
D)network service provider
Q2) What is a copyright? What does a copyright protect? In the US,what are some of the stipulations of the 1976 Copyright Act?
Q3) Failure to cite the source of material that you use is called ____.
A)plagiarism
B)libel
C)right-warding
D)platonism
Q4) Most good search engines include deep web resources in their results.
A)True
B)False
Q5) "microsoft.com" is an example of a ____.
A)URL
B)IP address
C)domain name
D)DSL
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) the default view for all folders except in the Pictures library
A)backslash
B)Large icons
C)Clipboard
D)root directory
E)OneDrive
F)extension
G)folder
H)archive
I)Details
Q2) ____ is a Microsoft service that provides up to 15 GB of online storage space for your files at no charge.
A)Picasa
B)Flickr
C)OneDrive
D)Mozilla
Q3) A duplicate copy of important files is known as a(n)____________________.
Q4) Extracting a file means to compress a file into an archive.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 14
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) When you are finished working with a presentation,you can exit PowerPoint.If there is only one presentation open,you click the Close button in the ____ corner of the program window to exit the program.
A)upper-left
B)upper-right
C)lower-left
D)lower-right
Q2) In Slide Show view,the left pane shows the current slide._________________________
A)True
B)False
Q3) When you select an existing list and then click the Convert to SmartArt Graphic button in the Paragraph group on the ____________________ tab,a gallery of SmartArt layouts appears.
Q4) A commonly used layout is the ____ layout.
A)Blank
B)Section Header
C)Title and Content
D)Picture with Caption
Q5) In ____________________ view,each slide fills the screen,one after another.
Page 15
To view all questions and flashcards with answers, click on the resource link above.
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) When you choose the ____ compression level for videos the file will be compressed slightly and will maintain the quality of the videos.
A)Presentation Quality
B)Internet Quality
C)Television Quality
D)Digital Quality
Q2) If you need to use a custom theme frequently,you can store this file so that it appears in the Themes gallery on the DESIGN tab.Please describe how you go about saving a theme so that it appears in your Themes gallery.
Q3) To insert a shape,click a shape in the Shapes ____.
A)library
B)archive
C)clipboard
D)gallery
Q4) When you preview an animation,it plays automatically on the slide in the ____________________ pane.
Q5) ____________________ transitions are a combination of the Fade transition for the slide background and a different transition for the slide content.
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) To preview the document,click the FILE tab to open Stagefront view and then click the Print tab in the navigation bar.
A)True
B)False
Q2) To select the entire document,press _______.
A)Alt+A
B)Ctrl+A
C)Shift+A
D)Alt+Ctrl+A
Q3) The paragraph mark shows where characters will appear when you start typing.____________________
A)True
B)False
Q4) To move the insertion point left or right one character at a time,you would press
A)the down or up arrow key
B)the Home or End key
C)the left or right arrow key
D)the Ctrl + right arrow keys or the Ctrl +left arrow keys
Q5) Discuss the use of color and special effects in formal documents.
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 update a bibliography field that is not contained in a ____,right-click the bibliography,and then click Update Field on the Shortcut menu.
A)content control
B)template
C)font field
D)document index
Q2) You typed a paragraph on page 2 that should appear on page 27.To move that paragraph to the correct place in your document,you should use ____.
A)drag and drop
B)cut and paste
C)delete and replace D)copy and paste
Q3) The Numbering button is a ____ button,which means you can click it to turn numbering on or off.
A)hidden
B)toggle
C)live
D)show
Q4) You press ____________________ to paste the most recent copied item.
To view all questions and flashcards with answers, click on the resource link above. Page 18
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) Josephine's boss likes her table,but has asked that she also include each team member's home office number.What's the best way for Josephine to go about adding this information?
A)Press the Tab key at the end of the last row.
B)Click the Select button in the Table group, then press Delete.
C)Click the Add Column button at the top of the column border.
D)Delete the current table and insert a new table with the correct number of columns and rows.
Q2) To create a footnote,click Insert Footnote in the Footnotes group on the ____ tab.
A)FOOTNOTE
B)INSERT
C)REFERENCES
D)CITATIONS
Q3) The best way for Josephine to organize her data in Microsoft Word would be to use
A)a chart
B)a table
C)multiple text boxes
D)the shapes function
To view all questions and flashcards with answers, click on the resource link above.
Page 19
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) A(n)____________________ is a large letter that begins the text of a paragraph.
Q2) A text box is considered a(n)shape._________________________
A)True
B)False
Q3) To move a graphic to one of several preset positions on the page,click the ____________________ button in the Arrange group on the PICTURE TOOLS FORMAT tab.
Q4) The Flip Vertical and Flip Horizontal commands are available in the ____________________ menu.
Q5) Aligning a graphic relative to the _______ is usually the best choice because it ensures that you don't accidentally position a graphic outside the page margins.
A)edge of the page
B)section
C)margin
D)document end
Q6) A(n)____________________ object is attached,or anchored,to a specific paragraph.
Q7) A(n)____________________ graphics file stores an image as a mathematical formula.
Q8) A(n)____________________ frames the contents of a single page. Page 20
To view all questions and flashcards with answers, click on the resource link above.
Page 21