Introduction to Computer Science Practice Exam - 2922 Verified Questions

Page 1


Introduction to Computer Science Practice Exam

Course Introduction

Introduction to Computer Science is a foundational course that explores the basic principles and concepts of computing and computational thinking. Students are introduced to the fundamental ideas of algorithms, programming languages, problem-solving methods, and the structure and function of computers. The course typically includes hands-on experience with programming, exposing students to coding environments and helping them develop logical reasoning skills. Topics may also encompass data structures, software development, and an overview of the impact of computing on society. This course serves as an entry point for further study in computer science and related disciplines.

Recommended Textbook

Emerge with Computers v. 5.0 5th Edition by Kenneth Baldauf

Available Study Resources on Quizplus

114 Chapters

2922 Verified Questions

2922 Flashcards

Source URL: https://quizplus.com/study-set/458 Page 2

Chapter 1: Intellectual Property Rights

Available Study Resources on Quizplus for this Chatper

21 Verified Questions

21 Flashcards

Source URL: https://quizplus.com/quiz/8112

Sample Questions

Q1) The .mp3 file extension signifies that an audio file is protected by digital rights management technology.

A)True

B)False

Answer: False

Q2) Turnitin is a software program used by schools to find and weed out plagiarized pieces of writing by students.

A)True

B)False

Answer: True

Q3) Which of the following organizations has been instrumental in fighting piracy through the use of lawsuits and legislation?

A) SOPA

B) Kazaa

C) RIAA

D) Napster

Answer: C

To view all questions and flashcards with answers, click on the resource link above.

Page 3

Chapter 2: Digital Literacy

Available Study Resources on Quizplus for this Chatper

26 Verified Questions

26 Flashcards

Source URL: https://quizplus.com/quiz/8113

Sample Questions

Q1) A computer relies on the combination of _____ and _____ to turn input into output.

A) analog waves,digital waves

B) the Internet,web sites

C) electrical devices,electrical charges

D) hardware,software

Answer: D

Q2) Personal music videos that combine user-generated photos with audio music are a good example of _____.

A) parallel processing

B) digital convergence

C) computer literacy

D) ASCII

Answer: B

Q3) It will be years before researchers can transform text from a book's page into a digital representation.

A)True

B)False

Answer: False

To view all questions and flashcards with answers, click on the resource link above.

Page 4

Chapter 3: Windows 7 Navigating

Available Study Resources on Quizplus for this Chatper

30 Verified Questions

30 Flashcards

Source URL: https://quizplus.com/quiz/8114

Sample Questions

Q1) The _____ keeps you informed about any problems on your computer and provides suggestions for how to resolve them.

A) Action Center

B) Control Panel Home

C) User Account Control Settings

D) Windows Update

Answer: A

Q2) Left-clicking the Taskbar opens a menu that provides functionality to customize the Taskbar.

A)True

B)False Answer: False

Q3) Clicking and dragging a Windows title bar to the top of your display automatically minimizes the window.

A)True

B)False Answer: False

To view all questions and flashcards with answers, click on the resource link above.

Page 5

Chapter 4: Computing Platforms

Available Study Resources on Quizplus for this Chatper

25 Verified Questions

25 Flashcards

Source URL: https://quizplus.com/quiz/8115

Sample Questions

Q1) The _____ computer platform provides a lot of computing power,such as for gaming,at a single location.

A) notebook

B) netbook

C) desktop

D) tablet

Q2) A tablet's key feature is its touch-sensitive display.

A)True

B)False

Q3) One thing to consider when choosing a mobile device is _____.

A) battery life

B) keyboard compatibility

C) desk space

D) netiquette

Q4) Information stored in the "cloud" is accessible at any time,with or without an Internet connection.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 6

Chapter 5: Windows 7 File Management

Available Study Resources on Quizplus for this Chatper

30 Verified Questions

30 Flashcards

Source URL: https://quizplus.com/quiz/8116

Sample Questions

Q1) You can customize Windows Explorer so that it displays menu commands.

A)True

B)False

Q2) Folders are used to organize related material together in many locations throughout the hard disk.

A)True

B)False

Q3) The Windows Explorer window has four panes,one of which is the Control Panel.

A)True

B)False

Q4) When a file or folder is deleted,it is sent to the _____.

A) Deleted Items folder

B) Tombstone

C) Recycle Bin

D) Trash

Q5) To view the contents of a file without opening it,use the Preview Pane.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 7

Chapter 6: Digital Life

Available Study Resources on Quizplus for this Chatper

26 Verified Questions

26 Flashcards

Source URL: https://quizplus.com/quiz/8117

Sample Questions

Q1) The Unlawful Internet Gambling Enforcement Act ____.

A) was signed in 1998

B) was declared unconstitutional

C) affects only U.S.-based casinos

D) has not eliminated online gambling

Q2) The idea of digital etiquette came into being ____.

A) with the advent of chat rooms and electronic mail

B) in 1999

C) with the original DARPANET in 1969

D) when 4G cell phone technology was released

Q3) Each person's digital shadow is ____.

A) the amount of digital information he or she produces in a year

B) the amount of digital information he or she produces in a lifetime

C) the complete list of digital equipment the person encounters in a day

D) the digital information generated about a person by organizations

Q4) Driving while texting increased ____ in 2011.

A) 10%

B) 15%

C) 20%

D) 50%

To view all questions and flashcards with answers, click on the resource link above. Page 8

Chapter 7: Processing

Available Study Resources on Quizplus for this Chatper

29 Verified Questions

29 Flashcards

Source URL: https://quizplus.com/quiz/8118

Sample Questions

Q1) Optical computing and quantum computing are two new promising types of mobile processing technology.

A)True

B)False

Q2) The CPU is a group of circuits that perform processing in a computer.

A)True

B)False

Q3) Transistors today are so small that over two billion can be stored on a surface the size of your thumbnail.

A)True

B)False

Q4) The speed of the _____ influences how fast the processor can process data.

A) critical transistor

B) storage device

C) software

D) internal clock

Q5) A transistor is an electronic component that opens or closes a circuit.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 9

Chapter 8: Windows 8 Navigating

Available Study Resources on Quizplus for this Chatper

26 Verified Questions

26 Flashcards

Source URL: https://quizplus.com/quiz/8119

Sample Questions

Q1) The _____ charm can be personalized to connect with your social media accounts.

A) Search

B) Share

C) Help

D) Settings

Q2) Pressing the Windows key plus the Z key brings up the apps bar.

A)True

B)False

Q3) Privacy controls can be assigned using the Settings charm.

A)True

B)False

Q4) The Help feature can be found in the Settings charm.

A)True

B)False

Q5) The Help feature can be accessed using any of the following features EXCEPT the _____.

A) Settings charm

B) Search charm

C) F1 key

D) Help tile

Page 10

To view all questions and flashcards with answers, click on the resource link above.

Chapter 9: Storage

Available Study Resources on Quizplus for this Chatper

20 Verified Questions

20 Flashcards

Source URL: https://quizplus.com/quiz/8120

Sample Questions

Q1) ROM is used for important programs like _____,which come(s)from the manufacturer.

A) RAM

B) VRAM

C) firmware

D) mobile apps

Q2) Solid-state storage is quickly replacing _____ for storing data on small devices like the iPod.

A) magnetic tape

B) microdrives

C) mylar film

D) sequential access

Q3) The process of writing to an optical disc is sometimes called laser-etching.

A)True

B)False

Q4) Magnetic disks are a _____ access storage medium.

A) direct

B) consecutive

C) volatile

D) sequential

To view all questions and flashcards with answers, click on the resource link above. Page 11

Chapter 10: Windows 8 File Management

Available Study Resources on Quizplus for this Chatper

26 Verified Questions

26 Flashcards

Source URL: https://quizplus.com/quiz/8121

Sample Questions

Q1) The Search feature displays the result of your query in all of the following categories EXCEPT _____.

A) Documents

B) Apps

C) Settings

D) Files

Q2) SkyDrive is automatically activated in Windows 8.

A)True

B)False

Q3) The address bar displayed under the File Explorer ribbon shows the current _____.

A) file path

B) file size

C) system status

D) documents folder

Q4) You can compress a folder using the _____ option.

A) Homegroup

B) My Documents

C) My Pictures

D) Send to

To view all questions and flashcards with answers, click on the resource link above. Page 12

Chapter 11: Input/Output (I/O)

Available Study Resources on Quizplus for this Chatper

28 Verified Questions

28 Flashcards

Source URL: https://quizplus.com/quiz/8122

Sample Questions

Q1) Output can be in the form of a vibration from your cell phone.

A)True

B)False

Q2) The speed of a printer is measured in _____ per minute.

A) rotations

B) pages

C) characters printed

D) dots

Q3) Resolution is measured by the physical size of your screen.

A)True

B)False

Q4) The iPad and other tablets take advantage of _____,allowing the user to use more than one finger to manipulate a display.

A) pointing devices

B) touch codes

C) optical scanners

D) multitouch displays

Q5) A touch screen monitor can serve as both an input and an output device.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 13

Chapter 12: Freedom of Speech

Available Study Resources on Quizplus for this Chatper

21 Verified Questions

21 Flashcards

Source URL: https://quizplus.com/quiz/8123

Sample Questions

Q1) Violence in a virtual world ____.

A) increases the likelihood of violence in the real world

B) decreases the likelihood of violence in the real world

C) may increase the likelihood of violence in the real world,but to date the studies are not conclusive

D) is illegal but difficult to enforce

Q2) An act of ____ would be posting a story to a blog saying that a neighbor is selling drugs,when you know that it's not true.

A) plagiarism

B) censorship

C) libel

D) CGM

Q3) One exception to the First Amendment to the U.S.Constitution is ____.

A) pornography

B) libel

C) religious sites

D) political statements

To view all questions and flashcards with answers, click on the resource link above.

Page 14

Chapter 13: Software Development

Available Study Resources on Quizplus for this Chatper

16 Verified Questions

16 Flashcards

Source URL: https://quizplus.com/quiz/8124

Sample Questions

Q1) Object-oriented programming languages are no longer used by software developers.

A)True

B)False

Q2) The Google Play store is very conservative about what it offers its users for phone apps.

A)True

B)False

Q3) With the help of ____,less experienced programmers can develop applications for mobile devices such as the iPhone.

A) SDKs

B) Android

C) Windows 8

D) Visual Studio

Q4) Many programming languages require a ____ to create executable files.

A) browser

B) text editor

C) compiler

D) debugger

To view all questions and flashcards with answers, click on the resource link above. Page 15

Chapter 14: Mac OS X Layout

Available Study Resources on Quizplus for this Chatper

30 Verified Questions

30 Flashcards

Source URL: https://quizplus.com/quiz/8125

Sample Questions

Q1) The Mac OS X operating system consists of four main areas: the Desktop,the Menu Bar,the ____,and the Dock.

A) Search

B) Finder

C) Toolbox

D) Keybox

Q2) The Mac OS X (Mac Operating System 10)was developed by ____.

A) Apple Inc.

B) Microsoft

C) Mozilla

D) Acer

Q3) The Menu Bar is the semi-transparent bar that spans across the bottom of your screen.

A)True

B)False

Q4) Quick Look is a Finder feature that allows you to preview a document without actually opening it.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 16

Chapter 15: System Software

Available Study Resources on Quizplus for this Chatper

38 Verified Questions

38 Flashcards

Source URL: https://quizplus.com/quiz/8126

Sample Questions

Q1) Which of the following uses the New Technology File System (NTFS)for organizing and managing files?

A) Mac OS X

B) Linux

C) Windows 8

D) UNIX

Q2) The main function of the operating system is to synchronize your computer with the Internet.

A)True

B)False

Q3) When you combine a system's hardware configuration and operating system,it is sometimes called the computer's ____.

A) system interface

B) platform

C) application interface

D) API

Q4) Virtual machine software is most useful when connecting laptop computers.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 17

Chapter 16: Mac OS X Tools

Available Study Resources on Quizplus for this Chatper

30 Verified Questions

30 Flashcards

Source URL: https://quizplus.com/quiz/8127

Sample Questions

Q1) When you set up a user account,you cannot specify which programs that user is able to run.

A)True

B)False

Q2) To gain the ability to view all of your open windows,be sure you have properly configured _____ in System Preferences.

A) Spaces

B) Cover Flow

C) Exposé

D) Previews

Q3) ____ holds mini-applications and puts useful information at your fingertips.

A) Exposé

B) System Preferences

C) Spotlight

D) The Dashboard

Q4) As you create multiple desktops in ____,each one is numbered.

A) Spotlight

B) Spaces

C) the Finder

D) the Dock

To view all questions and flashcards with answers, click on the resource link above. Page 18

Chapter 17: Application Software

Available Study Resources on Quizplus for this Chatper

14 Verified Questions

14 Flashcards

Source URL: https://quizplus.com/quiz/8128

Sample Questions

Q1) Personal software is used to benefit an individual.

A)True

B)False

Q2) Some people worry that GPS capabilities on mobile devices could lead to privacy issues.

A)True

B)False

Q3) Productivity software controls the common hardware functionality on your computer.

A)True

B)False

Q4) A desktop calendar icon is an example of a(n)____.

A) widget

B) IDE

C) SDK

D) array

Q5) Software suites are one form of business software.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 19

Chapter 18: Mac OS X File Management

Available Study Resources on Quizplus for this Chatper

30 Verified Questions

30 Flashcards

Source URL: https://quizplus.com/quiz/8129

Sample Questions

Q1) If you intend to use a folder infrequently,you can hide it by placing it in the Sidebar.

A)True

B)False

Q2) To rename a folder,click the folder to select it and _____,which makes the name region editable.

A) type the new folder name

B) click File->Rename

C) press return on the keyboard

D) right-click the folder

Q3) If a folder is in the Trash and you want to restore it,you should move the folder out of the Trash and to another location.

A)True

B)False

Q4) The Trash icon is located on the _____.

A) Desktop

B) Finder

C) Spotlight

D) Dock

To view all questions and flashcards with answers, click on the resource link above. Page 20

Chapter 19: Managing Software

Available Study Resources on Quizplus for this Chatper

18 Verified Questions

18 Flashcards

Source URL: https://quizplus.com/quiz/8130

Sample Questions

Q1) Many businesses rely on ____ software to keep a competitive edge in today's marketplace.

A) custom-designed

B) system

C) word processing

D) personal

Q2) Selecting and managing software is one of the most important responsibilities of a computer user.

A)True

B)False

Q3) A typical computer comes with many software applications ____.

A) preinstalled

B) indexed

C) compiled

D) upgraded

Q4) Apps accessed on the web are commonly known as Air apps.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above.

Page 21

Chapter 20: Privacy

Available Study Resources on Quizplus for this Chatper

29 Verified Questions

29 Flashcards

Source URL: https://quizplus.com/quiz/8131

Sample Questions

Q1) Of the following,____ contains the most information about citizens of the United States.

A) Time Warner

B) LexisNexis

C) the federal government

D) Facebook

Q2) Surveillance cameras in public places are not considered a potential threat to privacy.

A)True

B)False

Q3) Studying the way people use the web-what sites they visit,what products they buy,etc.-is an example of ____.

A) mass marketing

B) mass-market segmentation

C) one-to-one marketing

D) a crime

Q4) Data mining involves collecting and analyzing large amounts of information stored in large databases.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 22

Chapter 21: Internet Technologies

Available Study Resources on Quizplus for this Chatper

37 Verified Questions

37 Flashcards

Source URL: https://quizplus.com/quiz/8132

Sample Questions

Q1) The Internet backbone refers to the Hypertext Transfer Protocol (HTTP)that makes up the very foundation of the Internet.

A)True

B)False

Q2) All devices connected to the Internet must have a unique IP address.

A)True

B)False

Q3) Some colleges can keep students from using controversial file-sharing software by closing off access to specific ports on the campus network.

A)True

B)False

Q4) ____ defines how information travels across the Internet.

A) POP

B) TCP/IP

C) SMTP

D) NP

Q5) Businesses often use VoIP systems to control file sharing on their networks.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 23

Chapter 22: Common Application Components

Available Study Resources on Quizplus for this Chatper

22 Verified Questions

22 Flashcards

Source URL: https://quizplus.com/quiz/8133

Sample Questions

Q1) An application can never be unpinned from the Start screen.

A)True

B)False

Q2) Using ____ gives you access to information on your computer and on the Internet as well.

A) Bing

B) Help

C) Reader

D) File

Q3) For easy access to Office 2013 programs,you can add a tile to the Windows 8 ____.

A) apps bar

B) Start screen

C) common task bar

D) All Apps screen

Q4) The tabs on the ribbon are always the same in all Office applications.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above.

24

Chapter 23: Web Technologies

Available Study Resources on Quizplus for this Chatper

34 Verified Questions

34 Flashcards

Source URL: https://quizplus.com/quiz/8134

Sample Questions

Q1) A webpage can be created using web development software such as ____.

A) Excel

B) VoIP

C) Dreamweaver

D) ICANN

Q2) Safari is an example of a web browser.

A)True

B)False

Q3) An HTML tag is displayed inside parentheses.

A)True

B)False

Q4) Thanks to ____,you can watch a movie as it is being downloaded from the Internet.

A) Acrobat Reader

B) Java Runtime

C) streaming media

D) content downloads

Q5) Podcasts and video podcasts are distributed using CSS technology.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 25

Chapter 24: Working with Files and Documents

Available Study Resources on Quizplus for this Chatper

25 Verified Questions

25 Flashcards

Source URL: https://quizplus.com/quiz/8135

Sample Questions

Q1) When you open a Word document for the first time,the last documents you worked on will appear on the left side of the screen.

A)True

B)False

Q2) The ____ link takes you to the Open screen.

A) More Options

B) Open Other Documents

C) More Documents

D) Open Options

Q3) The easiest way to switch between two open Word documents is to use the Ctrl+Shift key combination.

A)True

B)False

Q4) The best way to edit a document is in Read Mode.

A)True

B)False

Q5) Once you open a template,you cannot switch to a new one unless you delete the document.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 26

Chapter 25: Cloud Computing

Available Study Resources on Quizplus for this Chatper

10 Verified Questions

10 Flashcards

Source URL: https://quizplus.com/quiz/8136

Sample Questions

Q1) Multiple companies may take advantage of the ____ cloud to pool their cloud resources.

A) private

B) community

C) public

D) topology

Q2) The private cloud model for cloud computing can save businesses money.

A)True

B)False

Q3) Government agencies have not supported cloud computing due to the lack of ____.

A) Internet connectivity

B) data security

C) funding

D) server resources offered

Q4) Cloud computing's distinguishing characteristic is to provide users with access to services for free.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 27

Chapter 26: Common Editing Functions

Available Study Resources on Quizplus for this Chatper

30 Verified Questions

30 Flashcards

Source URL: https://quizplus.com/quiz/8137

Sample Questions

Q1) If you delete selected text by mistake,you can use the ____ to retrieve it.

A) Redo button

B) Alt+Tab key combination

C) Paste button

D) Undo button

Q2) To initially display Word's ____,first select some text,and then hover the pointer over the highlighted text.

A) Quick Access Toolbar

B) Mini Toolbar

C) HOME tab

D) Click menu

Q3) After you click a Word document's hyperlink,it changes from ____.

A) purple to blue

B) blue to maroon

C) blue to purple

D) purple to red

Q4) The Find Next button can be used to type in a new search string when replacing text.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 28

Chapter 27: Web Resources

Available Study Resources on Quizplus for this Chatper

41 Verified Questions

41 Flashcards

Source URL: https://quizplus.com/quiz/8138

Sample Questions

Q1) Job-specific discussion groups and forums on the web can be a good way to make valuable employment contacts.

A)True

B)False

Q2) In an effort to fight the illegal downloading of videos and movies,many ____ are working against networks such as BitTorrent.

A) ISPs

B) ASPs

C) GISs

D) GPSs

Q3) Downloaded music may include ____ technology that prevents or limits the user's ability to make copies.

A) DRM

B) cloud

C) BMG

D) MP3

Q4) Instant messaging (IM)is an example of asynchronous communication.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 29

Chapter 28: Common Formatting Functions

Available Study Resources on Quizplus for this Chatper

24 Verified Questions

24 Flashcards

Source URL: https://quizplus.com/quiz/8139

Sample Questions

Q1) Fonts are measured in points.

A)True

B)False

Q2) To find out what font characteristics are applied to a selected grouping of text in a document,you can view the Font group on the ____ tab.

A) HOME

B) PAGE LAYOUT

C) REVIEW

D) VIEW

Q3) Some font formatting options such as the Underline button also have ____.

A) a color palette

B) a dialog box requesting more info

C) a menu of options

D) a Font Size box

Q4) To view color changes assigned to a font within a document,use the ____.

A) Font Color palette

B) Font gallery

C) Page Color palette

D) Print Preview option

To view all questions and flashcards with answers, click on the resource link above. Page 30

Chapter 29: Working with Graphics

Available Study Resources on Quizplus for this Chatper

26 Verified Questions

26 Flashcards

Source URL: https://quizplus.com/quiz/8140

Sample Questions

Q1) Only screens that are minimized can be inserted into a document using the Screenshot button.

A)True

B)False

Q2) When working with illustrations,the Position button on the DRAWING TOOLS tab lets you adjust the height and width in inches.

A)True

B)False

Q3) The terms shape and image can be used interchangeably in a document and produce the same results.

A)True

B)False

Q4) During a search,you will note that some images are licensed under the _____ to protect copyright.

A) Microsoft Initiative

B) Creative Commons

C) Image Resource Library

D) Commons Photo

To view all questions and flashcards with answers, click on the resource link above.

Page 31

Chapter 30: Working with Tables

Available Study Resources on Quizplus for this Chatper

18 Verified Questions

18 Flashcards

Source URL: https://quizplus.com/quiz/8141

Sample Questions

Q1) When working with a Word table,you can sort information numerically using the Sort button in the ____ group on the TABLE TOOLS LAYOUT tab.

A) Data

B) Merge

C) Rows & Columns

D) Alignment

Q2) In Word,text can be converted into a list but not into a table format.

A)True

B)False

Q3) You cannot adjust the width of a column in a Word table after the table is created.

A)True

B)False

Q4) To center the text in the header row of a table,use the _____ option.

A) Center

B) Align Center

C) Format

D) Align Middle

To view all questions and flashcards with answers, click on the resource link above.

32

Chapter 31: Printing & Publishing

Available Study Resources on Quizplus for this Chatper

21 Verified Questions

21 Flashcards

Source URL: https://quizplus.com/quiz/8142

Sample Questions

Q1) In Microsoft Word,selecting the Email option on the _____ tab allows you to directly send a document as an email file attachment.

A) HOME

B) MAILINGS

C) REVIEW

D) FILE

Q2) Only users with Microsoft Word can read a PDF document.

A)True

B)False

Q3) To save an open document in PDF format,begin the process by first clicking the FILE tab,and then clicking ____.

A) Edit

B) Save

C) Save As

D) New

Q4) If Outlook is installed on your computer,you can send a file as an attachment from within an Office application.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 33

Chapter 32: Sharing Content Between Applications

Available Study Resources on Quizplus for this Chatper

12 Verified Questions

12 Flashcards

Source URL: https://quizplus.com/quiz/8143

Sample Questions

Q1) Pressing the ____ gives you access to a list of ways to paste or embed an item linked to the Clipboard.

A) Paste button arrow

B) Paste button

C) Embed button

D) Copy button arrow

Q2) You want to copy an Excel chart from the Clipboard into an open Word document.You want all future changes made to the original chart reflected in the Word document.Which button should you click?

A) Merge Formatting

B) Keep Text Only

C) Keep Source Formatting & Link Data

D) Keep Source Formatting & Embed Workbook

Q3) When working with information that appears in two files,using ____ exports part of a document to another to ensure the information is consistent between the files.

A) Paste functionality

B) Object Linking and Embedding

C) the Format Painter

D) the Clipboard

To view all questions and flashcards with answers, click on the resource link above.

Page 34

Chapter 33: Collaborating with Office 2013

Available Study Resources on Quizplus for this Chatper

32 Verified Questions

32 Flashcards

Source URL: https://quizplus.com/quiz/8144

Sample Questions

Q1) You are tracking document changes,and you delete a sentence in a paragraph.The sentence shows the deleted words,but they are ____.

A) underlined and visible

B) crossed out and visible

C) inserted in a comment box

D) no longer visible

Q2) In SkyDrive,by default,new folders you create are ____.

A) private

B) public

C) shared

D) proprietary

Q3) In Excel,cells with a comment will have a red triangle in the upper-right corner.

A)True

B)False

Q4) By default,Office documents are protected when they are created.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 35

Chapter 34: Customizing Office Applications

Available Study Resources on Quizplus for this Chatper

14 Verified Questions

14 Flashcards

Source URL: https://quizplus.com/quiz/8145

Sample Questions

Q1) When you determine where new documents are to be stored,you are changing the application's ____ location.

A) default storage

B) AutoRecover

C) proofing

D) installation

Q2) A new tab cannot be renamed after it is created.

A)True

B)False

Q3) In Office,you can create a customized tab to improve your personal productivity.

A)True

B)False

Q4) After naming a new group on a new tab,you can ____ the group.

A) move it to another ribbon in

B) create new tabs and add them to

C) add buttons to

D) delete existing tabs from

Q5) You cannot change the order of Quick Access Toolbar buttons. A)True

B)False

To view all questions and flashcards with answers, click on the resource link above.

Chapter 35: Ethics

Available Study Resources on Quizplus for this Chatper

23 Verified Questions

23 Flashcards

Source URL: https://quizplus.com/quiz/8146

Sample Questions

Q1) The fastest growing segment of Internet users in the United States is senior citizens,ages 65 and over.

A)True

B)False

Q2) Personal ethics deals with ____.(Choose the best answer.)

A) the choices and behaviors made by individuals

B) the moral code of a society or nation

C) federal laws and other governmental codes of conduct

D) the way that industries and businesses collect and use electronic information

Q3) Programs such as ____ support energy conservation for electronic devices.

A) ConsumeLess

B) ENERGY STAR

C) Reuse-Recycle

D) Low Watt

Q4) Countries such as India and China are working with private companies and the World Bank to bring Internet services to rural and isolated villages around the world.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 37

Chapter 36: Infrastructure

Available Study Resources on Quizplus for this Chatper

20 Verified Questions

20 Flashcards

Source URL: https://quizplus.com/quiz/8147

Sample Questions

Q1) A device or software that filters the information coming onto a network is called a

A) bridge

B) gateway

C) firewall

D) repeater

Q2) ____ is the electronic transmission and reception of voice and data signals.

A) TCP/IP

B) Telecommunications

C) HTTP

D) Narrowband

Q3) Three types of physical cables that carry a signal are twisted pair,fiber optic,and

A) wave

B) coaxial

C) Ethernet

D) satellite

Q4) Ethernet is the most widely used network standard for private networks.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 38

Chapter 37: Overview of Word Processing

Available Study Resources on Quizplus for this Chatper

14 Verified Questions

14 Flashcards

Source URL: https://quizplus.com/quiz/8148

Sample Questions

Q1) ____ must be formatted professionally to communicate the importance of a proposal to potential investors.

A) Toolbars

B) Business plans

C) Document formats

D) Graphics and images

Q2) Microsoft Word is the perfect tool for building a spreadsheet of your monthly budget.

A)True

B)False

Q3) Applying a design ____ can change the whole look of a document.

A) layout

B) control

C) theme

D) transition

Q4) The recommended ordered document structure of business communication is ____.

A) introduction,body,and message

B) introduction,closing,and body

C) introduction,body,and closing

D) introduction,message,and body

To view all questions and flashcards with answers, click on the resource link above. Page 39

Chapter 38: Cellular Network

Available Study Resources on Quizplus for this Chatper

15 Verified Questions

15 Flashcards

Source URL: https://quizplus.com/quiz/8149

Sample Questions

Q1) A mobile networking standard defines the terms of service provided by a cellular carrier.

A)True

B)False

Q2) Most cell phone towers have a limited communication range of about one mile.

A)True

B)False

Q3) Code Division Multiple Access (CDMA)is the newest international mobile networking standard designed for high-speed 4G Internet access.

A)True

B)False

Q4) All of the following are cell phone service options EXCEPT ____.

A) electronic data interchange

B) games

C) alerts

D) text messaging

Q5) Today's cell phone networks use an analog signal.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 40

Chapter 39: Document Formatting Techniques

Available Study Resources on Quizplus for this Chatper

42 Verified Questions

42 Flashcards

Source URL: https://quizplus.com/quiz/8150

Sample Questions

Q1) To arrange text in columns,click the Columns button on the ____ tab.

A) PAGE LAYOUT

B) PAGE SETUP

C) DESIGN

D) LAYOUT

Q2) In MLA-formatted documents,a margin is set to one inch on the ____ of the document.

A) top and right only

B) top,left,right,and bottom

C) top and left only

D) top and bottom only

Q3) In Word,a header is text at the start of a paragraph that's formatted with a style.

A)True

B)False

Q4) In Word,the header and a heading are the same thing.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above.

Chapter 40: Wireless Data Communications

Available Study Resources on Quizplus for this Chatper

18 Verified Questions

18 Flashcards

Source URL: https://quizplus.com/quiz/8151

Sample Questions

Q1) Many cities have adopted ____ technology to provide faster Internet speed to their users.

A) DSL

B) WiMAX

C) near field communications

D) Bluetooth

Q2) Global positioning system (GPS)____ are primarily used to assist travelers in getting from one place to another.

A) receivers

B) infrared waves

C) transponders

D) tags

Q3) Wireless data communications refers to telecommunications that take place over the air.

A)True

B)False

Q4) Geotagging is the process of adding geographic identification metadata to digital media and messages.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 42

Chapter 41: Academic Publishing Tools

Available Study Resources on Quizplus for this Chatper

31 Verified Questions

31 Flashcards

Source URL: https://quizplus.com/quiz/8152

Sample Questions

Q1) To paste Excel data in its original formatting in Word,be sure to select the ____ paste option as part of the paste process.

A) Nest Table

B) Use Destination Styles

C) Keep Source Formatting

D) Picture

Q2) Adding a footnote adds a ____ number at the insertion point,and the footnote appears at the bottom of the page.

A) subscript

B) note

C) superscript

D) highlighted

Q3) Using the ____ group on the HOME tab,you can apply formatting features to data inserted from a spreadsheet into your Word document.

A) Insert

B) Styles

C) Paragraph

D) Design

To view all questions and flashcards with answers, click on the resource link above. Page 43

Chapter 42: Globalization

Available Study Resources on Quizplus for this Chatper

17 Verified Questions

17 Flashcards

Source URL: https://quizplus.com/quiz/8153

Sample Questions

Q1) A global company often has no easily defined home country.

A)True

B)False

Q2) The boom in collaboration between U.S.companies and workforces in India created a need for ____.

A) Internet 3.0

B) transatlantic telecommunications infrastructure

C) project management workflow software

D) all of these

Q3) A rise in global business relationships has meant a growing interdependence between cultures and nations.

A)True

B)False

Q4) A benefit to the United States of offshoring is ____.

A) an increase in the domestic labor market

B) growing prosperity in developing nations,which raises demand there for American goods and services

C) a higher income tax base

D) a reduction in global competition

To view all questions and flashcards with answers, click on the resource link above. Page 44

Chapter 43: Machine-Level Security

Available Study Resources on Quizplus for this Chatper

15 Verified Questions

15 Flashcards

Source URL: https://quizplus.com/quiz/8154

Sample Questions

Q1) The Mac computer employs the ____ system to encrypt its file data.

A) BitLocker Drive

B) FileVault

C) File Transfer Protocol

D) digital certificate

Q2) Biometrics uses a token system to authenticate users of a device.

A)True

B)False

Q3) An Internet-based crime is referred to as a(n)____ crime.

A) virtual

B) forensic

C) cyber

D) iTech

Q4) The only time it is considered safe to send private information over a public wireless network is if it has ____.

A) HTTPS

B) WPA

C) WPA2

D) none of the above; a public wireless network is never safe for private information

To view all questions and flashcards with answers, click on the resource link above. Page 45

Chapter 44: Overview of Spreadsheets

Available Study Resources on Quizplus for this Chatper

13 Verified Questions

13 Flashcards

Source URL: https://quizplus.com/quiz/8155

Sample Questions

Q1) The main purpose of grouping data variables in their own area on a spreadsheet is so ____.

A) they can be easily referenced

B) you can delete them more easily

C) the data is easier to read

D) your data stays organized

Q2) Using a spreadsheet program allows you to make a decision based on ____ results.

A) qualitative

B) quantitative

C) coded

D) table

Q3) Which of the following is a valid cell reference?

A) 14B

B) Z92

C) E#6

D) T?56

Q4) In Excel,a worksheet and a spreadsheet are the same thing.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 46

Chapter 45: Network Security

Available Study Resources on Quizplus for this Chatper

14 Verified Questions

14 Flashcards

Source URL: https://quizplus.com/quiz/8156

Sample Questions

Q1) By default,the personal files and folders on Windows and Mac computers are open to others on the same network.

A)True

B)False

Q2) ____ permissions provide registered users with access to the files they need,while restricting access to private resources.

A) Server

B) Client

C) Protocol

D) User

Q3) By default,wireless access points are set to broadcast their presence so others can easily catch a wireless signal.

A)True

B)False

Q4) A Guest account is for someone who does not have a permanent account and needs to temporarily access computer or network resources.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 47

Chapter 46: Cells and Cell Data

Available Study Resources on Quizplus for this Chatper

35 Verified Questions

35 Flashcards

Source URL: https://quizplus.com/quiz/8157

Sample Questions

Q1) Cells in a spreadsheet that are selected as a group for a specific purpose are defined as a(n)____.

A) grouping

B) range

C) function

D) Autofit

Q2) You can reorganize the order of tabs in a workbook by ____ each tab and indicating a new position.

A) right-clicking on

B) dragging

C) pressing Ctrl+O for

D) pressing the right-arrow key on

Q3) When you move the mouse over a cell's ____,the pointer changes from a white cross to a black one.

A) fill handle

B) contents

C) formula bar

D) ribbon

To view all questions and flashcards with answers, click on the resource link above. Page 48

Chapter 47: Internet Security

Available Study Resources on Quizplus for this Chatper

36 Verified Questions

36 Flashcards

Source URL: https://quizplus.com/quiz/8158

Sample Questions

Q1) Website ranching is used by scammers to collect personal information from a user.

A)True

B)False

Q2) A ____ allows hackers to gain access to important code or information in a software program.

A) DNS

B) worm

C) security hole

D) firewall

Q3) The ____ was established to secure and monitor security risks to U.S.networks and the Internet.

A) NTSB

B) W3C

C) US-CERT

D) NSF

Q4) A zombie computer helps fight against intrusions by hackers.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above.

Page 49

Chapter 48: Formulas

Available Study Resources on Quizplus for this Chatper

23 Verified Questions

23 Flashcards

Source URL: https://quizplus.com/quiz/8159

Sample Questions

Q1) Formula analysis is called formula auditing.

A)True

B)False

Q2) After you have finished entering a formula,complete the process by pressing the Enter key.

A)True

B)False

Q3) To perform a division operation,use the ____ key on the keyboard or keypad.

A) colon

B) forward slash

C) hyphen

D) backward slash

Q4) A name assigned to a range of cells is called a ____ name.

A) range

B) function

C) defined

D) list

Q5) A defined name as a cell reference must always be unique.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 50

Chapter 49: Functions

Available Study Resources on Quizplus for this Chatper

40 Verified Questions

40 Flashcards

Source URL: https://quizplus.com/quiz/8160

Sample Questions

Q1) To define the average score in a range of test scores,you should use the ____ function.

A) AVERAGE

B) MEDIAN

C) MIDDLE

D) COUNTAVER

Q2) In an Excel calculation result,an expense will appear in red.

A)True

B)False

Q3) Which of the following formulas is an example of a 3-D reference?

A) =SUMS(O14Anders:Zhang!)

B) =SUM(Anders:Zhang!O14)

C) =SUMOF'Zhang:Andrews'!

D) =SUMOF(Anders:Zhang!O14)

Q4) A Logical_test function is any value or expression that can be evaluated as TRUE or FALSE.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above.

Chapter 50: Formatting Spreadsheets

Available Study Resources on Quizplus for this Chatper

33 Verified Questions

33 Flashcards

Source URL: https://quizplus.com/quiz/8161

Sample Questions

Q1) You specify a range of cells as an Excel table by applying a cell format such as bold to the selected cells.

A)True

B)False

Q2) When a cell is formatted in Accounting,a zero value will display as ____.

A) #DIV/0!

B) $0.00

C) 0

D) $ -

Q3) You can merge three cells together to create one bordered cell.

A)True

B)False

Q4) Excel's gallery of table styles is divided into three sections: ____.

A) Business,Education,and Personal

B) Short,Medium,and Long

C) Light,Medium,and Dark

D) Header,Body,and Totals

Q5) By default,numbers entered in cells display in the General format type.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 52

Chapter 51: Spreadsheet Graphics

Available Study Resources on Quizplus for this Chatper

31 Verified Questions

31 Flashcards

Source URL: https://quizplus.com/quiz/8162

Sample Questions

Q1) A sparkline is a mini-chart within an Excel worksheet cell.

A)True

B)False

Q2) Tools used to add a chart to a spreadsheet are located on the ____ tab,in the Charts group.

A) HOME

B) INSERT

C) CHART

D) LAYOUT

Q3) A line sparkline shows a data trend over a period of time.

A)True

B)False

Q4) To select a non-adjacent range of cells upon which to base a chart,press and hold the ____ key as you drag through the cells.

A) Shift

B) Alt

C) Esc

D) Ctrl

To view all questions and flashcards with answers, click on the resource link above.

Page 53

Chapter 52: Advanced Spreadsheet Tools

Available Study Resources on Quizplus for this Chatper

16 Verified Questions

16 Flashcards

Source URL: https://quizplus.com/quiz/8163

Sample Questions

Q1) In Excel,the term what-if analysis means trying out different values in a worksheet to see how the formula results change.

A)True

B)False

Q2) Data is added to an existing PivotTable by ____ from the PivotTable Field List to its label and filter areas.

A) creating tables

B) entering formulas

C) dragging fields

D) copying

Q3) A PivotTable can be formatted so that its output looks similar to a row.

A)True

B)False

Q4) When creating a PivotTable,the usual first step in the process is to convert the data in the worksheet to a table.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above.

Chapter 53: Digital Publications

Available Study Resources on Quizplus for this Chatper

15 Verified Questions

15 Flashcards

Source URL: https://quizplus.com/quiz/8164

Sample Questions

Q1) The launch of the _____ in 2010 resulted in various tablet devices entering the market.

A) Kindle

B) iPad

C) MacBook

D) Dell tablet

Q2) One way newspapers are staying profitable in the online delivery model is to _____.

A) charge readers for access to stories

B) use "citizen editors"

C) offer only columnist blogs for free

D) limit access at different times of the day

Q3) Designers,engineers,and architects are the sole users of digital media.

A)True

B)False

Q4) Online newspapers can be delivered through _____ to news readers.

A) MIDI

B) RSS

C) PDF

D) CAD

To view all questions and flashcards with answers, click on the resource link above. Page 55

Chapter 54: Overview of PowerPoint

Available Study Resources on Quizplus for this Chatper

17 Verified Questions

17 Flashcards

Source URL: https://quizplus.com/quiz/8165

Sample Questions

Q1) The 7x7 rule states that you should use no more than seven bullets on a slide,and no more than seven words in a bullet.

A)True

B)False

Q2) The points on which you elaborate as you speak represent the presentation's ____.

A) notes

B) animations

C) message

D) closing

Q3) A presentation might be used by a company's ____ department to promote a trade show event,highlight a new product,or reveal new services.

A) human resources

B) technical support

C) marketing

D) sales

Q4) The PowerPoint status bar displays the number of words in your presentation.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above.

Page 56

Chapter 55: Digital Audio

Available Study Resources on Quizplus for this Chatper

25 Verified Questions

25 Flashcards

Source URL: https://quizplus.com/quiz/8166

Sample Questions

Q1) Media player software locates,sorts,and arranges music by a variety of criteria such as artist and song length.

A)True

B)False

Q2) A digital _____ file can be copied and transferred to a variety of formats and media.

A) bit

B) speed

C) audio

D) radio

Q3) A digital voice recorder receives sound through a _____.

A) radio signal

B) speaker

C) keyboard

D) microphone

Q4) Most media players support all three digital music formats: .wma,.m4p,and .mp3.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 57

Chapter 56: Working with Slides and Text

Available Study Resources on Quizplus for this Chatper

27 Verified Questions

27 Flashcards

Source URL: https://quizplus.com/quiz/8167

Sample Questions

Q1) Only predefined equations are available to insert in your PowerPoint slide.

A)True

B)False

Q2) Adding a ____ to a slide means that the presenter can show content on a Web site during the presentation.

A) macro

B) hyperlink

C) transition

D) view

Q3) To select three slides and edit them simultaneously,click the first slide,hold down the ____ key,and continue to select the additional slides.

A) Alt

B) Function

C) Insert

D) Ctrl

Q4) There are three options available to align selected text in your PowerPoint slide.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above.

Page 58

Chapter 57: Digital Graphics

Available Study Resources on Quizplus for this Chatper

26 Verified Questions

26 Flashcards

Source URL: https://quizplus.com/quiz/8168

Sample Questions

Q1) A basic example of _____ is the use of graphs and charts to illustrate numeric data.

A) vectorization

B) visualization

C) animation

D) construction

Q2) Designers rely on _____ software to help them build prototypes for further research and testing.

A) CAD

B) CAC

C) CAX

D) CAE

Q3) All of the following are examples of graphics file formats EXCEPT _____.

A).tif

B).' JPG '

C).gif

D).xls

Q4) Three-dimensional modeling is also known as ray tracing.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 59

Chapter 58: Using Graphics Objects

Available Study Resources on Quizplus for this Chatper

25 Verified Questions

25 Flashcards

Source URL: https://quizplus.com/quiz/8169

Sample Questions

Q1) To set an animation to occur at the same time a slide appears,click ____ in the list of animation options.

A) Start After Previous

B) Start With Slide

C) Effect Options

D) Start With Previous

Q2) To add animation to a picture,select the picture and click the Add Animation button in the Advanced Animation group.

A)True

B)False

Q3) You can center a picture by clicking the Align button in the Arrange group on the PICTURE TOOLS contextual tab.

A)True

B)False

Q4) A table can only be added to a slide by clicking Table in the Tables group on the INSERT tab.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 60

Chapter 59: Digital Photography

Available Study Resources on Quizplus for this Chatper

18 Verified Questions

18 Flashcards

Source URL: https://quizplus.com/quiz/8170

Sample Questions

Q1) Some printers accept a camera's _____ card as input.

A) bitmap

B) memory

C) index

D) vector

Q2) Digital cameras use the .ppt file format for their photos.

A)True

B)False

Q3) A digital camera uses a _____ card as its storage device.

A) flash memory

B) ROM

C) strike memory

D) video

Q4) Some photojournalists have been criticized for using photo-editing software to make photos more interesting than what was originally captured by their cameras.

A)True

B)False

Q5) Digital photography creates digital graphics through the manipulation of shapes.

A)True

B)False

Page 61

To view all questions and flashcards with answers, click on the resource link above.

Chapter 60: Formatting a Slide Show

Available Study Resources on Quizplus for this Chatper

21 Verified Questions

21 Flashcards

Source URL: https://quizplus.com/quiz/8171

Sample Questions

Q1) A slide master contains the content from the first slide in your presentation.

A)True

B)False

Q2) With the help of ____,you can easily change the look of a slide show at the press of a button.

A) themes

B) orientations

C) headers

D) variants

Q3) You intend to personally show your presentation to an audience.What type of slide show should you create?

A) Browsed by an individual

B) Presented by a speaker

C) Presenter View

D) Browsed at a kiosk

Q4) A header is text that appears at the top of every page in a document.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 62

Chapter 61: Digital Video

Available Study Resources on Quizplus for this Chatper

12 Verified Questions

12 Flashcards

Source URL: https://quizplus.com/quiz/8172

Sample Questions

Q1) A _____ graphics expert might be asked to prepare animated exhibits as evidence in a court proceeding.

A) forensic

B) kinesthetic

C) detective

D) digital

Q2) A video camcorder's image quality is measured by the number of pixels in each _____.

A) object

B) strip

C) photo

D) frame

Q3) Digital video can be transferred to a computer directly from a camcorder.

A)True

B)False

Q4) Law enforcement cannot consider the use of digital video to capture illegal activities.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 63

Chapter 62: Presenting and Publishing

Available Study Resources on Quizplus for this Chatper

18 Verified Questions

18 Flashcards

Source URL: https://quizplus.com/quiz/8173

Sample Questions

Q1) When you publish a presentation online,YouTube videos will play as you move through the slide show.

A)True

B)False

Q2) You want to publish a presentation so that people in another part of the world can view it as you present the material.From the FILE tab,click ____ to begin the process.

A) Custom Slide Show

B) the Save & Send option

C) Play Narrations

D) Share

Q3) If you want to view your presentation starting from the slide you are working on,use the From Current Slide button on the SLIDE SHOW tab.

A)True

B)False

Q4) The print options you assign in a PowerPoint presentation are saved as part of the file and appear the next time you open the slide show.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 64

Chapter 63: Interactive Media

Available Study Resources on Quizplus for this Chatper

17 Verified Questions

17 Flashcards

Source URL: https://quizplus.com/quiz/8174

Sample Questions

Q1) Interactive media combine digital audio,2D graphics,and photos.

A)True

B)False

Q2) The Nintendo Wii was the first game console to support a wireless,motion-sensitive game controller.

A)True

B)False

Q3) Smart phone apps that make use of augmented reality are available.

A)True

B)False

Q4) A game console relies on a fast _____ to handle the lively animations in a video game.

A) hard drive

B) microprocessor

C) display

D) joystick

Q5) Adding surround sound to a virtual,interactive experience is distracting and unrealistic.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 65

Chapter 64: Database Structure

Available Study Resources on Quizplus for this Chatper

26 Verified Questions

26 Flashcards

Source URL: https://quizplus.com/quiz/8175

Sample Questions

Q1) Primary keys ensure that ____.

A) all of the data is 100 percent accurate

B) duplicate records are not stored in the database

C) the data can be normalized

D) records are not accidentally deleted

Q2) The ability to connect data in different tables through a common field is sometimes referred to as a relationship.

A)True

B)False

Q3) A primary key is always made up of only one field.

A)True

B)False

Q4) In a database,a collection of related records is referred to as a table or a ____.

A) field

B) record

C) file

D) unit

To view all questions and flashcards with answers, click on the resource link above.

66

Chapter 65: Overview of Databases

Available Study Resources on Quizplus for this Chatper

18 Verified Questions

18 Flashcards

Source URL: https://quizplus.com/quiz/8176

Sample Questions

Q1) In a database record,a unique username can also be identified as the ____.

A) object key

B) key

C) primary key

D) table key

Q2) Microsoft Access is the perfect tool to use to analyze your grades for the semester and calculate your current grade point average in class.

A)True

B)False

Q3) The best software tool to use for monitoring daily business operations and quickly comparing expected activity to actual performance is a ____.

A) word processor

B) spreadsheet

C) database

D) file manager

Q4) Each record contains data relating to a single entity.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above.

Page 67

Chapter 66: Database Tools

Available Study Resources on Quizplus for this Chatper

17 Verified Questions

17 Flashcards

Source URL: https://quizplus.com/quiz/8177

Sample Questions

Q1) When a database problem occurs,its tables may be split up during the ____ process to correct a data problem.

A) GIGO

B) visualization

C) normalization

D) data integrity

Q2) The data manipulation language ____ is a popular tool when querying a relational database.

A) SQL

B) C++

C) HTML

D) CSS

Q3) Database tools include software and techniques for analyzing,maintaining,and manipulating data in a database.

A)True

B)False

Q4) A data dictionary provides a detailed description of each field and table in a database.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 68

Chapter 67: Database Tables

Available Study Resources on Quizplus for this Chatper

40 Verified Questions

40 Flashcards

Source URL: https://quizplus.com/quiz/8178

Sample Questions

Q1) In Access,related fields are grouped in the Data Type Gallery for quick and easy access.

A)True

B)False

Q2) To use a database for decision making,you must first create multiple,independent tables.

A)True

B)False

Q3) To begin importing Excel data into Access,click on the ____ tab.

A) EXTERNAL DATA

B) CREATE

C) DATABASE TOOLS

D) FILE

Q4) Rows in a spreadsheet are akin to ____ in a database table.

A) rows

B) records

C) fields

D) data types

To view all questions and flashcards with answers, click on the resource link above. Page 69

Chapter 68: Industrial Databases

Available Study Resources on Quizplus for this Chatper

22 Verified Questions

22 Flashcards

Source URL: https://quizplus.com/quiz/8179

Sample Questions

Q1) As data centers continue to grow in size to multi-acre facilities,the number of employees required to run them also grows proportionally.

A)True

B)False

Q2) A data mine is a large database that holds information to analyze pricing trends.

A)True

B)False

Q3) A data mine is a climate-controlled building or set of buildings that house servers that store and deliver mission-critical information and services.

A)True

B)False

Q4) A data center is used by large organizations to store older archived data that is no longer needed on a day-to-day basis.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above.

Page 70

Chapter 69: Data-sheets and Forms

Available Study Resources on Quizplus for this Chatper

27 Verified Questions

27 Flashcards

Source URL: https://quizplus.com/quiz/8180

Sample Questions

Q1) Once a calculated field is completed,it can subsequently be changed.

A)True

B)False

Q2) An Access subdatasheet displays records from the last database you created.

A)True

B)False

Q3) Changing the layout of a form changes the layout of its underlying table.

A)True

B)False

Q4) Which of the following is a valid expression in an Access table calculation?

A) [UnitPrice] x [NumPartic]

B) (UnitPrice)* (NumPartic)

C) {UnitPrice} x {NumPartic}

D) [UnitPrice] * [NumPartic]

Q5) When table data is sorted in ascending order,it is sorted ____.

A) by foreign key

B) by primary key

C) from A to Z

D) from Z to A

To view all questions and flashcards with answers, click on the resource link above. Page 71

Chapter 70: Queries and Reports

Available Study Resources on Quizplus for this Chatper

18 Verified Questions

18 Flashcards

Source URL: https://quizplus.com/quiz/8181

Sample Questions

Q1) When conditional formatting is applied to an Access report field,which of the following statements is true?

A) The cell's contents can be displayed in bold red font.

B) The cell can be formatted with a new image.

C) The cell's contents can be recalculated.

D) The column or row is sorted.

Q2) You want a query's result to include dates after December 1,2013.What will the properly formatted criteria look like in the query?

A) >12/1/2013

B) =>#12/1/2013#

C) >#12/1/2013#

D) #12/1/2013#

Q3) When tables are ____,you are able to construct queries that pull data from more than one table.

A) recorded

B) queried

C) joined

D) constructed

To view all questions and flashcards with answers, click on the resource link above.

72

Chapter 71: E-commerce Implementation

Available Study Resources on Quizplus for this Chatper

30 Verified Questions

30 Flashcards

Source URL: https://quizplus.com/quiz/8182

Sample Questions

Q1) Global supply management companies assist businesses in finding the best _____ relationships.

A) B2C

B) B2B

C) C2C

D) C2B

Q2) Auction fraud is one of the most prevalent types of fraud on the Internet.

A)True

B)False

Q3) Downloading apps,games,and media to your smartphone is an example of _____.

A) GSM

B) data commerce

C) mcommerce

D) electronic exchange

Q4) Craigslist,the online classifieds website,is a popular C2C site.

A)True

B)False

Q5) The business-to-consumer (B2C)model of ecommerce is also called etail.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 73

Chapter 72: Outlook

Available Study Resources on Quizplus for this Chatper

20 Verified Questions

20 Flashcards

Source URL: https://quizplus.com/quiz/8183

Sample Questions

Q1) In Outlook,you need to download and install the ____ program for each network you want to display.

A) Facebook

B) Social Connector add-in

C) LinkedIn

D) Connection

Q2) When you mark an email message as urgent,Outlook adds a green exclamation point to the message in the recipient's Inbox.

A)True

B)False

Q3) A thumbnail image appears in the People pane of an Outlook message with links to more information about that person.

A)True

B)False

Q4) To send and receive email using Outlook,you first need to set up an email account. A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 74

Chapter 73: E-commerce Technologies

Available Study Resources on Quizplus for this Chatper

13 Verified Questions

13 Flashcards

Source URL: https://quizplus.com/quiz/8184

Sample Questions

Q1) Ecommerce hosting companies offer _____ that provide all the necessary software tools to deliver ecommerce applications.

A) domains

B) certifications

C) servers

D) certificates

Q2) Ecommerce technologies include software and systems that support safe and secure transactions over _____ and the Internet,and make ecommerce possible.

A) networks

B) DHTML

C) GSM

D) Bluetooth

Q3) Using EDI drastically reduces the amount of paperwork and the need for human intervention.

A)True

B)False

Q4) Ecash provides privacy by shielding your credit card information from vendors.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 75

Chapter 74: OneNote

Available Study Resources on Quizplus for this Chatper

17 Verified Questions

17 Flashcards

Source URL: https://quizplus.com/quiz/8185

Sample Questions

Q1) A OneNote notebook typically contains one section.

A)True

B)False

Q2) You can share a OneNote notebook with a group so that everyone can work on its contents at the same time.

A)True

B)False

Q3) In OneNote,a section tab is ____ as the pages contained in that section.

A) the same size

B) the same color

C) not the same color

D) none of the above

Q4) A OneNote page cannot be moved from one section to another section.

A)True

B)False

Q5) Which of the following functions is NOT available in the OneNote Notebook?

A) Search

B) Drag & Drop

C) Insert Citation

D) Add Page

To view all questions and flashcards with answers, click on the resource link above. Page 76

Chapter 75: Office Web Apps

Available Study Resources on Quizplus for this Chatper

20 Verified Questions

20 Flashcards

Source URL: https://quizplus.com/quiz/8186

Sample Questions

Q1) In the Excel Web App,to share your file with others,you click Home and then click the Share button in the Office group.

A)True

B)False

Q2) Document ____ are displayed in the same color code assigned to the app used to create them.

A) filenames

B) tabs

C) lists

D) tiles

Q3) Office 2013 Web Apps also support devices with touch screen capabilities.

A)True

B)False

Q4) In the Word Web App,a newly saved file will appear as a new tile with a checkmark in the upper-right corner.

A)True

B)False

Q5) The Windows Live offering of OneNote is called a Web App. A)True

B)False

To view all questions and flashcards with answers, click on the resource link above.

Chapter 76: Information Management

Available Study Resources on Quizplus for this Chatper

32 Verified Questions

32 Flashcards

Source URL: https://quizplus.com/quiz/8187

Sample Questions

Q1) In a proactive problem-solving approach,the problem solver seeks out potential problems before they become serious.

A)True

B)False

Q2) Businesses generate profits based on how well they collect,interpret,and act on information.

A)True

B)False

Q3) A graphical representation of a company's key performance indicators can be displayed in a(n)_____ for easier access to important data.

A) transaction processing system

B) executive dashboard

C) database

D) optimized model

Q4) Management information systems are typically powered by _____.

A) transactions

B) expert systems

C) key performance indicators

D) databases

To view all questions and flashcards with answers, click on the resource link above. Page 78

Chapter 77: Common Application Components

Available Study Resources on Quizplus for this Chatper

26 Verified Questions

26 Flashcards

Source URL: https://quizplus.com/quiz/8188

Sample Questions

Q1) Click the _____ at the top of the Ribbon to display different sets of tools.

A) tabs

B) menus

C) buttons

D) title

Q2) In addition to all of the tools included in a Ribbon group,you can find more options in the _____ bar.

A) Menu

B) Tab Group Indicator

C) Quick Access Launcher

D) Group Box Indicator

Q3) To resize an Office application window,move your mouse to the lower-right corner and then _____.

A) double-click the resize handle

B) hold down the left mouse button and drag

C) select Resize from the menu

D) none of the above

Q4) The options on the menu bar are the same in all Office applications.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 79

Chapter 78: Enterprise Systems

Available Study Resources on Quizplus for this Chatper

15 Verified Questions

15 Flashcards

Source URL: https://quizplus.com/quiz/8189

Sample Questions

Q1) Using a _____ system,employees can share their expertise in different areas of a company to build upon its success.

A) decision support

B) management information

C) business intelligence

D) knowledge management

Q2) __________ is another term for business,but often it connotes a large,complex business with many interacting business units.

A) E-tailer

B) Knowledge company

C) Organization

D) Enterprise

Q3) The sole function of enterprise resource planning is to manage the supply chain.

A)True

B)False

Q4) Many businesses use knowledge management systems that include social networking features.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 80

Chapter 79: Working with Files and Documents

Available Study Resources on Quizplus for this Chatper

37 Verified Questions

37 Flashcards

Source URL: https://quizplus.com/quiz/8190

Sample Questions

Q1) By default,the Sidebar appears on the left side of the Word window with the _____ pane open.

A) Document Map

B) Thumbnail

C) Reviewing

D) Find and Replace

Q2) If an Office file was recently opened,you can open it quickly by clicking the File menu and selecting Open from the list.

A)True

B)False

Q3) You can only open existing Word files when Word is running.

A)True

B)False

Q4) To clear existing search results so you can start another search,double-click the previous search term,and then press ____________________.

Q5) In Word,to leave Full Screen view,click the Exit button on the toolbar.

A)True

B)False

Q6) The ____________________ setting controls how your work is displayed on screen.

To view all questions and flashcards with answers, click on the resource link above. Page 81

Chapter 80: Common Editing Functions

Available Study Resources on Quizplus for this Chatper

42 Verified Questions

42 Flashcards

Source URL: https://quizplus.com/quiz/8191

Sample Questions

Q1) To insert new text in the body of a paragraph,click _____,and then type.

A) where you want to insert text

B) at the end of the document

C) at the beginning of the document

D) anywhere in the document

Q2) The _____ hyperlink type provides the option to create a link to an Excel workbook.

A) Document

B) Place in This Document

C) Existing Spreadsheet

D) Hyperlink to Excel

Q3) When the cursor is blinking,this indicates that you recently deleted text from that specific location in the document.

A)True

B)False

Q4) How is copied text inserted when you click the Paste button?

A) as unformatted text

B) with its original formatting

C) with new formatting

D) with the current Destination formatting

To view all questions and flashcards with answers, click on the resource link above. Page 82

Chapter 81: Common Formatting Functions

Available Study Resources on Quizplus for this Chatper

29 Verified Questions

29 Flashcards

Source URL: https://quizplus.com/quiz/8192

Sample Questions

Q1) The Paragraph group on the Home tab has four options for working with lists.

A)True

B)False

Q2) In Word,you cannot add spacing after a paragraph if you intend to print the document.

A)True

B)False

Q3) A _____ is a menu that shows examples of various options.

A) preview

B) format

C) template

D) gallery

Q4) In Office for Mac 2011,the Format Picture galleries show lists of options,but no previews.

A)True

B)False

Q5) Paragraphs can be aligned in ____________________ different ways.

Q6) If you need to copy formatting to multiple locations in a document,you can select the text with the formatting you want to copy,then ____________________ the Format Painter button.

Page 83

To view all questions and flashcards with answers, click on the resource link above.

Chapter 82: Working with Graphics

Available Study Resources on Quizplus for this Chatper

43 Verified Questions

43 Flashcards

Source URL: https://quizplus.com/quiz/8193

Sample Questions

Q1) To restore a picture to its original state,select the picture and click the ____________________ button.

Q2) When working with a picture,the Reflection effect adds a reflection _____ the picture.

A) above

B) to the immediate right of C) to the immediate left of D) below

Q3) When you see circles and squares on an illustration's border,_____.

A) it is legal

B) it cannot be resized C) it is selected

D) its position cannot be changed

Q4) A small collection of clip art is installed on your computer as part of Office.To use it in your Office files,it is necessary to contact Microsoft and pay its royalty fee.

A)True

B)False

Q5) In Office,____________________ are also known as drawing objects or drawn objects.

To view all questions and flashcards with answers, click on the resource link above. Page 84

Chapter 83: Working with Tables

Available Study Resources on Quizplus for this Chatper

23 Verified Questions

23 Flashcards

Source URL: https://quizplus.com/quiz/8194

Sample Questions

Q1) Word can sort _____ by clicking the Sort button in the Paragraph group on the Home tab.

A) bulleted lists

B) a series of paragraphs

C) both A and B

D) none of the above

Q2) In a Word table,press the _____ key to move from cell to cell.

A) shift

B) next

C) insert

D) tab

Q3) When sorting rows in a Word table,you must first click in the column to sort by.

A)True

B)False

Q4) To center selected text,use the Center Text button in the _____ group on the Home tab.

A) Font

B) Styles

C) Editing

D) Paragraph

To view all questions and flashcards with answers, click on the resource link above. Page 85

Chapter 84: Printing & Publishing

Available Study Resources on Quizplus for this Chatper

19 Verified Questions

19 Flashcards

Source URL: https://quizplus.com/quiz/8195

Sample Questions

Q1) The Size button on the Layout tab can switch the page between landscape and portrait layouts.

A)True

B)False

Q2) In Word,the default option for paper size is ____ inches.

A) 8.5 x 14

B) 8.5 x 11

C) 8 x 14.5

D) 8 x 11.5

Q3) By default,Word prints the entire open document.

A)True

B)False

Q4) With the Mac Mail application installed on your computer,you can send a file as an attachment from within an Office application.

A)True

B)False

Q5) Use the ____________________ button to change the layout of an entire document to Portrait or Landscape.

To view all questions and flashcards with answers, click on the resource link above. Page 86

Chapter 85: Sharing Content Between Applications

Available Study Resources on Quizplus for this Chatper

16 Verified Questions

16 Flashcards

Source URL: https://quizplus.com/quiz/8196

Sample Questions

Q1) Objects,such as charts and sentences,can be copied and pasted as needed between Word and Excel.

A)True

B)False

Q2) To link an Excel chart stored on the Office clipboard to a document in Word,click the ____.

A) Paste button

B) Paste button arrow

C) Copy button

D) Copy button arrow

Q3) An item you embed in a destination file is called a(n)____.

A) OLE

B) graph

C) object

D) document

Q4) An object can be a chart or a graph but not text.

A)True

B)False

Q5) After copying an item in Office,the next step is to ____________________ it to its final destination.

To view all questions and flashcards with answers, click on the resource link above.

Chapter 86: Collaborating with Office for Mac 2011

Available Study Resources on Quizplus for this Chatper

40 Verified Questions

40 Flashcards

Source URL: https://quizplus.com/quiz/8197

Sample Questions

Q1) In Office for Mac 2011,you can compare changes made to two versions of a document but you cannot combine them into one document.

A)True

B)False

Q2) The Comments group on the ____ tab contains the button for adding a new comment.

A) View

B) Home

C) Review

D) Insert

Q3) In Excel,cells with a comment have a red triangle in the upper-right corner.

A)True

B)False

Q4) You are viewing a change in a document and want to have all changes made integrated in the document when you save it.To start the process,click the ____ button arrow.

A) Track Changes

B) Accept All Changes

C) All Changes

D) Accept

88

To view all questions and flashcards with answers, click on the resource link above.

Chapter 87: Customizing Office Applications

Available Study Resources on Quizplus for this Chatper

17 Verified Questions

17 Flashcards

Source URL: https://quizplus.com/quiz/8198

Sample Questions

Q1) Every document you create must include your User Information,which consists of your name,your initials,and other personal information.

A)True

B)False

Q2) You customize the Ribbon by clicking the Word menu,and then clicking Preferences to open the Word Preferences dialog box.

A)True

B)False

Q3) You can customize the Ribbon by opening the Word ____ dialog box.

A) Options

B) Ribbon

C) Customization

D) Preferences

Q4) What are Compatibility preferences?

A) options for converting Word files for use on a PC

B) settings to make your document compatible with previous versions of Word

C) settings related to where you store your files

D) settings related to securing the information contained in your files

Q5) The file format compatible with Word 2007 and 2010 is ____________________.

To view all questions and flashcards with answers, click on the resource link above. Page 89

Chapter 88: AI Methodologies

Available Study Resources on Quizplus for this Chatper

30 Verified Questions

30 Flashcards

Source URL: https://quizplus.com/quiz/8199

Sample Questions

Q1) An important element in exhibiting intelligence is our ability to communicate and use language.

A)True

B)False

Q2) A fuzzy system in computational intelligence guarantees results that are always certain and valid.

A)True

B)False

Q3) Advances in neural networks are providing insight into treatment for mental illness and other brain-related diseases.

A)True

B)False

Q4) Artificial intelligence methodologies consist of the various approaches to AI research that generally fall under one of two categories: pattern recognition or computational intelligence.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above.

90

Chapter 89: Overview of Word Processing

Available Study Resources on Quizplus for this Chatper

17 Verified Questions

17 Flashcards

Source URL: https://quizplus.com/quiz/8200

Sample Questions

Q1) In a Word document,a placeholder can be deleted.

A)True

B)False

Q2) When creating business documents,good communication results when you properly organize contents and use Word's formatting tools to provide professional polish.

A)True

B)False

Q3) To add content to a(n)____________________ box,just click it and type.

Q4) In written communication,a(n)____ tells the reader what the document is about.

A) introductory heading

B) placeholder

C) cover page

D) glossary

Q5) Templates make it easy to create pre-formatted documents such as a(n)____.

A) table

B) theme

C) envelope

D) table of contents

Q6) The default view in Word for Mac 2011 is ____________________ view.

Page 91

To view all questions and flashcards with answers, click on the resource link above.

Chapter 90: AI Applications

Available Study Resources on Quizplus for this Chatper

21 Verified Questions

21 Flashcards

Source URL: https://quizplus.com/quiz/8201

Sample Questions

Q1) Intelligent agents,or bots,can search for interesting items on the Web or in databases,but they do not field basic questions from customers.

A)True

B)False

Q2) Surgical robots are limited to a single arm due to the complexity of surgery and the surgeon's inability to watch two screens at once.

A)True

B)False

Q3) Three broad categories of pattern recognition are face recognition,cognitive recognition,and trend recognition.

A)True

B)False

Q4) Computer vision enables ________ to react to visual input.

A) data

B) animals

C) human eyes

D) software

To view all questions and flashcards with answers, click on the resource link above.

Chapter 91: Document Formatting Techniques

Available Study Resources on Quizplus for this Chatper

56 Verified Questions

56 Flashcards

Source URL: https://quizplus.com/quiz/8202

Sample Questions

Q1) A document stored on your hard disk opens in Secure View by default.

A)True

B)False

Q2) To apply one style to three headings at the same time,select the first heading,hold down the shift key,and then select the second and third headings.

A)True

B)False

Q3) When working in Word for Mac 2011,press the ____ keys together to select all the text in the document.

A) control + A

B) shift + S

C) command + A

D) option + A

Q4) You made a change to a document's default margin settings.To apply these settings to the next document,click Margins and then click ____.

A) Normal

B) Custom

C) Last Custom Setting

D) none of the above

To view all questions and flashcards with answers, click on the resource link above. Page 93

Chapter 92: Academic Publishing Tools

Available Study Resources on Quizplus for this Chatper

39 Verified Questions

39 Flashcards

Source URL: https://quizplus.com/quiz/8203

Sample Questions

Q1) A document's ____________________ include its number of pages,words,characters,paragraphs,and lines.

Q2) A formula is added to a document in the format of a(n)____________________.

Q3) Every business plan requires complete financial information to explain the viability of the idea being presented.

A)True

B)False

Q4) A(n)____ is a short comment that appears at the bottom of a document page.

A) footnote

B) endnote

C) footer

D) statistic

Q5) An Excel chart cannot be added as an illustration in a Word document. A)True

B)False

Q6) When creating a citation,a popular style is the ____ style.

A) APP

B) MLS

C) Chicago

D) Academic

To view all questions and flashcards with answers, click on the resource link above. Page 94

Chapter 93: Overview of Spreadsheets

Available Study Resources on Quizplus for this Chatper

15 Verified Questions

15 Flashcards

Source URL: https://quizplus.com/quiz/8204

Sample Questions

Q1) The first step in planning the layout of a spreadsheet is to ____.

A) gather relevant data

B) determine needed calculations

C) identify the problem

D) prepare an easy-to-read design

Q2) The Home tab provides tools for displaying charts.

A)True

B)False

Q3) Data presented in spreadsheets is not useful in the management process of making financial decisions for a business.

A)True

B)False

Q4) From the choices below,select a valid cell reference.

A) 14B

B) Z92

C) E#6

D) T?56

Q5) In Excel,a worksheet and a spreadsheet are the same thing.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 95

Chapter 94: Cells and Cell Data

Available Study Resources on Quizplus for this Chatper

40 Verified Questions

40 Flashcards

Source URL: https://quizplus.com/quiz/8205

Sample Questions

Q1) You can select a range of nonadjacent cells in a spreadsheet.

A)True

B)False

Q2) A row's height should be stated as ____.

A) 85

B) 85 pixels

C) 85 points

D) none of the above

Q3) How do you edit a cell's contents?

A) Press command+click.

B) Click the cell and start typing.

C) Click the cell and press return.

D) Double-click the cell.

Q4) A column's width should be stated as ____.

A) 85

B) 85 characters

C) 85 points

D) none of the above

Q5) A group of specific cells in a worksheet is called a(n)____________________.

To view all questions and flashcards with answers, click on the resource link above. Page 96

Chapter 95: Formulas

Available Study Resources on Quizplus for this Chatper

26 Verified Questions

26 Flashcards

Source URL: https://quizplus.com/quiz/8206

Sample Questions

Q1) Excel starts working on the left when calculating a formula,and then follows ____ as it moves to the right.

A) the order of precedence

B) the formula

C) operations

D) operators

Q2) You can make formulas easier to read by assigning ____ to specific cells,and then use them in formulas instead of cell addresses.

A) ranges

B) names

C) values

D) formulas

Q3) What is the value displayed in a cell that contains the formula =15*4/6?

A) 66

B) 25

C) 10

D) 2/3

Q4) Formulas should begin with a(n)____________________ sign.

Q5) Click the ____________________ key to exit Edit mode.

To view all questions and flashcards with answers, click on the resource link above. Page 97

Chapter 96: Functions

Available Study Resources on Quizplus for this Chatper

47 Verified Questions

47 Flashcards

Source URL: https://quizplus.com/quiz/8207

Sample Questions

Q1) You can create an absolute cell reference by adding dollar signs to the column and row references in a formula.

A)True

B)False

Q2) From the choices listed below,which function determines the number of times the word "YES" appears in a range of cells?

A) =COUNT(G7:G12,"YES")

B) =COUNTIF(G7:G12,"YES")

C) =COUNTA(G7:G12,"YES")

D) =SUMIF(G7:G12,"YES")

Q3) In Excel,to calculate the cost of any loan,three pieces of information are needed. A)True

B)False

Q4) The PMT function requires the duration of an auto loan to be entered as payment periods per ____________________.

Q5) In the formula =IF(B4=120,B3,B2),the first part of the function is B4=120 and it is called the ____________________ test.

To view all questions and flashcards with answers, click on the resource link above. Page 98

Chapter 97: Formatting Spreadsheets

Available Study Resources on Quizplus for this Chatper

41 Verified Questions

41 Flashcards

Source URL: https://quizplus.com/quiz/8208

Sample Questions

Q1) In Excel,filtering a column's data means that you temporarily exclude data from screen visibility.

A)True

B)False

Q2) Using Conditional Formatting,text in a range of cells can be formatted to display a certain color depending on the function in the cell.

A)True

B)False

Q3) Number formatting options are found on the Home tab on the Ribbon.

A)True

B)False

Q4) A border can be applied to a cell or to a range of cells.

A)True

B)False

Q5) When the "My list has headers" check box is not selected,Excel excludes column headings when it sorts data.

A)True B)False

Q6) ____________________ data makes it easier to read large sets of data.

Page 99

To view all questions and flashcards with answers, click on the resource link above.

Chapter 98: Spreadsheet Graphics

Available Study Resources on Quizplus for this Chatper

40 Verified Questions

40 Flashcards

Source URL: https://quizplus.com/quiz/8209

Sample Questions

Q1) To select a range of cells upon which to base a chart,press and hold the ____ key as you drag through the cells.

A) shift

B) alt

C) esc

D) command

Q2) To insert a spreadsheet footer,click the View menu and then click the ____ option.

A) Footer

B) Page Options

C) Header and Footer

D) Print Options

Q3) To ensure that column F does not print on its own page,on the Layout tab,in the Scale to Fit group,click to set the column width to Automatic.

A)True

B)False

Q4) To move a chart to a new workbook location,click the ____________________ menu,and then click Move Chart.

To view all questions and flashcards with answers, click on the resource link above. Page 100

Chapter 99: Advanced Spreadsheet Tools

Available Study Resources on Quizplus for this Chatper

19 Verified Questions

19 Flashcards

Source URL: https://quizplus.com/quiz/8210

Sample Questions

Q1) Working in a PivotTable causes the ____ tab to appear on the Ribbon.

A) PowerPivot Tools

B) PivotTable

C) PowerPivot

Q2) The purpose of Solver is to find the optimal solution to a problem,given certain

A) formats

B) data

C) formulas

D) constraints

Q3) A PivotTable is an Excel table that is used to provide different views of a range of data to assist in the analysis of the data.

A)True

B)False

Q4) A PivotTable can be formatted so that its output looks similar to a row.

A)True

B)False

Q5) In the Goal Seek dialog box,Excel asks for three pieces of data.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above.

Chapter 100: Overview of PowerPoint

Available Study Resources on Quizplus for this Chatper

17 Verified Questions

17 Flashcards

Source URL: https://quizplus.com/quiz/8211

Sample Questions

Q1) The ____ pane in a presentation is often utilized by presenters to recall key points.

A) Outline

B) Notes

C) Notepad

D) Recall

Q2) A presentation might be used by a company's ____ department to discuss a company's plan with its vendors.

A) human resources

B) technical support

C) marketing

D) sales

Q3) When creating a new presentation,the first consideration should be to determine ____.

A) sources for research on the presentation's topic

B) the presentation's formatting

C) the purpose of the presentation

D) how much practice you should invest to perfect your presentation skills

Q4) PowerPoint ____________________ add visual uniformity to your slides.

To view all questions and flashcards with answers, click on the resource link above.

Page 102

Chapter 101: Working with Slides and Text

Available Study Resources on Quizplus for this Chatper

29 Verified Questions

29 Flashcards

Source URL: https://quizplus.com/quiz/8212

Sample Questions

Q1) Clicking the ____________________ layout option allows you to arrange slide contents into two columns.

Q2) When an outline is imported into a presentation,PowerPoint inserts text on a slide as bullet point sub-text when it encounters ____ formatting.

A) Heading 1

B) Heading 2

C) Arial 12

D) New Slide

Q3) You ____________________ multiple bullets on a slide at the same time by first selecting them and then clicking the Increase Indent button.

Q4) To create a hyperlink,first select the text for the link,then click the Text button in the Insert group on the Home tab.

A)True

B)False

Q5) In the View menu,there are two alignment options.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above.

Page 103

Chapter 102: Using Graphics Objects

Available Study Resources on Quizplus for this Chatper

24 Verified Questions

24 Flashcards

Source URL: https://quizplus.com/quiz/8213

Sample Questions

Q1) To remove an animation associated with an object,click to open the ____ tab on the Toolbox.

A) Custom Animation

B) Navigation

C) Remove Animation

D) none of the above; animations cannot be removed from objects

Q2) To change the coloring of a slide's SmartArt,on the SmartArt tab,click the ____________________ button.

Q3) When a presentation calls for quantitative data,you can include data from a spreadsheet directly on a slide in the presentation.

A)True

B)False

Q4) A table can only be added to a slide by clicking Table in the Table group on the Insert tab.

A)True

B)False

Q5) Clip art is accessed from the Clip Art button in the ____________________ group on the Insert tab.

Q6) SmartArt graphics can be found on the ____________________ tab.

To view all questions and flashcards with answers, click on the resource link above. Page 104

Chapter 103: Formatting a Slide Show

Available Study Resources on Quizplus for this Chatper

18 Verified Questions

18 Flashcards

Source URL: https://quizplus.com/quiz/8214

Sample Questions

Q1) You can change a slide's page orientation by selecting either Landscape or ____________________.

Q2) When you make a change to a slide master,changes made to the ____ for a slide are applied to any slide that uses the master layout.

A) layout

B) master theme

C) master layout

D) theme

Q3) In PowerPoint,you cannot insert a header onto slides.

A)True

B)False

Q4) In PowerPoint,you cannot insert a header on a handout.

A)True

B)False

Q5) When working with slide masters,hovering over a slide's thumbnail reveals ____. A) footer formatting

B) header formatting

C) the number of slides in the presentation using special font formats

D) how many slides in the presentation use that slide master

To view all questions and flashcards with answers, click on the resource link above. Page 105

Chapter 104: Presenting and Publishing

Available Study Resources on Quizplus for this Chatper

24 Verified Questions

24 Flashcards

Source URL: https://quizplus.com/quiz/8215

Sample Questions

Q1) You can press the esc key to exit a slide show.

A)True

B)False

Q2) Which of the following options is NOT available from the list of views you can print in PowerPoint?

A) Slides

B) Handouts (12 slides per page)

C) Handouts (9 slides per page)

D) Outline

Q3) In the Print dialog box,click ____ to change the orientation of a presentation from Landscape to Portrait.

A) Page Setup

B) Orientation

C) Frame Slides

D) Setup

Q4) PowerPoint presentations can be published to ____.

A) an online source

B) a CD

C) Windows Live

D) all of the above

To view all questions and flashcards with answers, click on the resource link above. Page 106

Chapter 105: Outlook

Available Study Resources on Quizplus for this Chatper

29 Verified Questions

29 Flashcards

Source URL: https://quizplus.com/quiz/8216

Sample Questions

Q1) In Outlook,to schedule an event that involves other people,you can create a new ____________________.

Q2) You can flip through calendar pages in Outlook by clicking the Up and Down buttons next to the date.

A)True

B)False

Q3) When you compose an e-mail,you type the ____________________ e-mail address in the "To" field.

Q4) If the message requires special attention,you should click the ____________________ button.

Q5) A document sent as part of an e-mail is known as an attachment. A)True

B)False

Q6) To better ____________________ e-mail messages you receive,it is good practice to create folders.To do this,control-click the Inbox in the Navigation pane,and then click New Folder.

Q7) When you send an e-mail attachment,it appears below the Subject field. A)True

B)False

107

To view all questions and flashcards with answers, click on the resource link above.

Chapter 106: Navigating in Google Docs

Available Study Resources on Quizplus for this Chatper

29 Verified Questions

29 Flashcards

Source URL: https://quizplus.com/quiz/8217

Sample Questions

Q1) In Google Docs,the Export option lets you convert a document into the Google Docs file format and download it to your PC.

A)True

B)False

Q2) In the navigation menu,"Owned by me" shows you documents that others have shared with you.

A)True

B)False

Q3) Google Docs only allows users to create folders in which documents can be stored.

A)True

B)False

Q4) The "Who has access" list in the "Sharing settings" window provides a list of people who ____ the document.

A) own

B) can edit

C) can view

D) all of the above

To view all questions and flashcards with answers, click on the resource link above. Page 108

Chapter 107: Word Processing

Available Study Resources on Quizplus for this Chatper

30 Verified Questions

30 Flashcards

Source URL: https://quizplus.com/quiz/8218

Sample Questions

Q1) To remove an existing document footer,____ the footer and select Delete Footer from the list.

A) click

B) right-click

C) point at

D) none of the above

Q2) After placing an image in a document,you decide to move it.To move the image,you must delete it and re-insert it in the document.

A)True

B)False

Q3) Google periodically changes the appearance and interactivity of Google Docs.

A)True

B)False

Q4) By default,a Google Docs document has no headers or footers defined as part of the document.

A)True

B)False

Q5) Bookmarks are made up of a word or phrase and a footer entry in the document.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 109

Chapter 108: Spreadsheets Part 1

Available Study Resources on Quizplus for this Chatper

29 Verified Questions

29 Flashcards

Source URL: https://quizplus.com/quiz/8219

Sample Questions

Q1) In Google Spreadsheets,____ is an example of an absolute reference.

A) V$456

B) $V$456

C) V456

D) $V*456

Q2) Wrapping text in a Google spreadsheet means that ____.

A) text in a cell may use more than one row to display its contents

B) cells will wrap together to properly display the cell contents

C) formulas will round results and display them as currency

D) either A or B

Q3) To edit a worksheet cell,you can click the Formula bar and type your text or formula.

A)True

B)False

Q4) In Google Spreadsheets,____ is an example of a relative reference.

A) V$456

B) $V$456

C) V456

D) $V*456

To view all questions and flashcards with answers, click on the resource link above. Page 110

Chapter 109: Spreadsheets Part 2

Available Study Resources on Quizplus for this Chatper

29 Verified Questions

29 Flashcards

Source URL: https://quizplus.com/quiz/8220

Sample Questions

Q1) A spreadsheet form can be formatted with a theme.

A)True

B)False

Q2) On the Revision history toolbar,you want to work with an older version of a shared spreadsheet.Click ____ to accomplish your goal.

A) Use this version

B) Select this revision

C) Open this version

D) Restore this revision

Q3) How are you made aware by Google Docs that another user is viewing a spreadsheet you have open in your browser?

A) A popup displays the other person's user name.

B) The spreadsheet's URL turns red.

C) The cell changes color as the other user types.

D) none of the above

Q4) To use a Google Apps Script,you need to create your own code.

A)True

B)False

To view all questions and flashcards with answers, click on the resource link above. Page 111

Chapter 110: Presentations

Available Study Resources on Quizplus for this Chatper

30 Verified Questions

30 Flashcards

Source URL: https://quizplus.com/quiz/8221

Sample Questions

Q1) Once a table created in a presentation is copied to the ____,it can be copied into any other Google Docs application.

A) Gmail storage area

B) Windows clipboard

C) Web clipboard

D) Internet

Q2) A new slide can be inserted into a presentation,but an existing slide cannot be duplicated.

A)True

B)False

Q3) You can insert a text box onto a slide by ____.

A) pressing Alt+I

B) clicking Insert->Text box

C) clicking Slide->New Text box

D) pressing Shift+T

Q4) Examining ____ tells you when a revision was made to a presentation.

A) edits

B) changes

C) the document properties

D) the revision history

To view all questions and flashcards with answers, click on the resource link above. Page 112

Chapter 111: Project Management

Available Study Resources on Quizplus for this Chatper

30 Verified Questions

30 Flashcards

Source URL: https://quizplus.com/quiz/8222

Sample Questions

Q1) Project management software stores,manipulates,and presents project-related data in a timely and cost-efficient manner.

A)True B)False

Q2) If a task's duration is an estimate,a question mark appears immediately to the left of the time listed in the Duration field.

A)True B)False

Q3) Resources refers only to the human resources allocated for a specific project.

A)True B)False

Q4) Project management software is widely used in restaurants.

A)True B)False

Q5) Project management software is very useful for ____ projects.

A) large-scale

B) personal

C) small-scale

D) data-driven

To view all questions and flashcards with answers, click on the resource link above. Page 113

Chapter 112: Personal Information Management

Available Study Resources on Quizplus for this Chatper

30 Verified Questions

30 Flashcards

Source URL: https://quizplus.com/quiz/8223

Sample Questions

Q1) With Google Calendars,you can add other calendars to your list by clicking ____ in the Other Calendars list.

A) Add

B) Download

C) Subscribe

D) Link

Q2) "In the cloud" means on the Web.

A)True

B)False

Q3) Today,anyone can manage his or her own ____ online.

A) tasks

B) calendaring

C) contacts

D) all of the above

Q4) In Google Calendar,you can share calendars by going to ____,and then assigning the correct sharing levels.

A) Permit Access

B) Sharing

C) Permission Settings

D) Actions

To view all questions and flashcards with answers, click on the resource link above. Page 114

Chapter 113: Web Research

Available Study Resources on Quizplus for this Chatper

30 Verified Questions

30 Flashcards

Source URL: https://quizplus.com/quiz/8224

Sample Questions

Q1) A(n)____ is useful when you need to get more specific results from your Web search.

A) query

B) modification

C) search engine

D) advanced search

Q2) Microsoft refers to Google's Web site as a "decision engine."

A)True

B)False

Q3) When you begin research using Web resources,you must be able to differentiate between sources that are credible and current and those that are not.

A)True

B)False

Q4) ____ provides access to full-length journal articles,but you must pay a fee to read the material.

A) Google

B) Bing

C) LexisNexis

D) Mahalo

To view all questions and flashcards with answers, click on the resource link above. Page 115

Chapter 114: Web Publishing

Available Study Resources on Quizplus for this Chatper

30 Verified Questions

30 Flashcards

Source URL: https://quizplus.com/quiz/8225

Sample Questions

Q1) A single entry in your blog is known as a(n)____.

A) Web note

B) post

C) text message

D) e-mail

Q2) With the growing abundance of online social applications,____ are becoming real concerns.

A) speed and connectivity

B) size and networking

C) privacy and information security

D) usernames and identity

Q3) YouTube 101 is a free tutorial offered by Yahoo! to help you understand how to prepare and post video to its site.

A)True

B)False

Q4) ____ is blogging where your posts are limited in length to a sentence or two.

A) Microblogging

B) Googling

C) Posting

D) Short blogging

To view all questions and flashcards with answers, click on the resource link above. Page 116

Turn static files into dynamic content formats.

Create a flipbook