Which of the following happens when you enter the formula =G15 into a cell?
a. Excel recalculates all formulas in the worksheet
b. Excel assigns the sum of the values in the previous 15 cells to the active cell
c. Excel assigns the value in cell G15 to the active cell
d. Nothing; =G15 is an invalid formula
Which of the following is the Ribbon path to the Cell Styles button?
a. (HOME tab | Styles group)
b. (STYLES tab | Home group)
c. (HOME tab | Format group)
d. (FORMAT tab | Styles group)
What is the World Wide Web?
a. a database of every document stored on computers worldwide
b. the wiring and cabling used to connect computers on the Internet
c. a worldwide collection of electronic documents
d. a set of electronic documents diagramming and charting all the worldwide Internet
connections
Although a variety of different styles of documentation exist for report preparation,
each style requires the same basic information.
a. True
b. False
How many peripheral devices can you connect with a USB port?
a. up to 32
b. up to 45
c. up to 57
d. up to 127
The PATRIOT Act gives law enforcement the right to monitor people’s activities,
including web and email habits.
a. True
b. False
The default slide layouts are set up in portrait orientation.
a. True
b. False
Which of the following is a special-purpose computer that functions as a component in
a larger product?
a. hard-coded computer
b. embedded computer
c. soft computer
d. indexed computer
You can select a word by using the ____ key.
a. CTRL+SHIFT+LEFT ARROW
b. CTRL+A
c. SHIFT+RIGHT ARROW
d. CTRL+W
When you magnify a worksheet, Excel enlarges the view of the characters on the screen
and displays more rows and columns.
a. True
b. False
____ is a communications protocol for incoming email.
a. ISP
b. HTML
c. SMTP
d. POP
Press the ENTER key in all of the following circumstances EXCEPT ____.
a. to insert a blank line into a document
b. when the insertion point reaches the right margin
c. to begin a new paragraph
d. in response to prompts in Word dialog boxes
A port replicator is similar to a docking station, but it has more functionality.
a. True
b. False
After adding a shape to a slide, you cannot change its default characteristics.
a. True
b. False
Which of the following is NOT a popular programming language?
a. Java
b. Visual C#
c. C++
d. Chrome
A friend of yours was talking on a mobile phone and her attention was diverted from
something that was happening around her while she was on the phone. What
phenomenon does this illustrate?
a. inattentional blindness
b. failure to integrate
c. distracted vision
d. visual inactivity
What term means to make a copy of a file?
a. restore
b. back up
c. concatenate
d. decipher
You can remove selected text from a slide by pressing the CTRL+X keyboard shortcut
keys.
a. True
b. False
Which of the following are valid steps toward virus protection?
a. purchase a reputable antivirus program, update antivirus definitions regularly
b. delete a personal firewall, scan your computer for malware
c. open e-mail attachments and then scan them for viruses, install operating system
updates
d. stay informed about viruses, never visit web sites unless they are approved by the
Virus Protection Agency (VPA)
To find all customers whose returns are greater than $0.00 and whose book rep is book
rep number 42, enter each criterion on the same row.
a. True
b. False
The input from a POS terminal serves as output to other computers to maintain sales
records, update inventory, verify credit, and perform other activities associated with
sales transactions.
a. True
b. False
Which of the following gestures would you use if you want to display a bar that
contains commands on an edge of the screen of your new tablet?
a. swipe
b. stretch
c. pinch
d. press and hold
To use the Report Wizard to create a report for a query, select the query in the
Navigation Pane, tap or click ____ on the ribbon, and then tap or click the Report
Wizard button.
a. CREATE
b. DATABASE TOOLS
c. REPORT
d. FILE
Which of the following terms means in a location separate from the computer site?
a. off-scope
b. off-shore
c. off-line
d. off-site
What kind of software consists of programs designed to make users more productive
and/or assist them with personal tasks?
a. application
b. utility
c. operating
d. system
One common method of thwarting a smartphone thief is not to use the phone to check
the time.
a. True
b. False
What effect does the Comma Style format have on the selected cells?
a. Converts decimals to commas within a cell
b. Converts decimals to commas within merged cells
c. Displays cell contents with two decimal places and commas as thousands separators
d. Allows for substitution of selected characters
The Notes pane is ____ until you tap or click the Notes button on the status bar to open
the pane.
a. visible
b. hidden
c. highlighted
d. outlined
After you have created at least four slides, a scroll bar containing scroll arrows and
scroll boxes will appear on the right edge of the window.
a. True
b. False
A ____ is a personal computer designed to be in a stationary location, where all of its
components fit on or under a desk or table.
a. keyboard
b. tablet
c. scanner
d. desktop
In Excel, a number can contain the characters ____.
a. 0 1 2 3 4 5 6 7 8 9
b. + – ( ) , /
c. . $ % E e
d. all of the above
Most systems require that a user selects this on his or her own.
An encrypted code that a person, website, or organization attaches to an electronic
message to verify the identity of the message sender.
Displays the Find dialog box.
You can tap or click the up or down arrows in the Transparency box to move the
____________________ slider in the Format Background dialog box in one-percent
increments.
The ____________________ at the bottom of the Fill Color and Font Color buttons
changes to the most recently selected color.
To sort records by amount paid within book rep number, specify Book Rep Number as
the ____________________ key.
Gallery of decorative effects
Insert a new slide.
Allows two or more people to share text messages
A comparison operator.
Run a slide show.
A(n) ____________________ is a set of programs that coordinates all the activities
among computer or mobile device hardware.
____________________ view shows five workdays in columnar style.
List at least five different practices to adopt in order to avoid being a victim during an
ATM visit.
List at least five commonly used AutoFormat As You Type options. In your response,
provide both what the initially typed text is and what the AutoFormat result is.
Computer viruses like the kind in the accompanying figurealong with worms, and
Trojan horsesdeliver their ____________________ on a computer or mobile device
when a user opens an infected file or runs an infected program.
Break an illustration into its component objects
Uses points as the units of measurement.