1
To clear a tab stop, ____.
drag it off the ruler
press the Delete Tab button
double-click it
press the Remove button
Drag it off the ruler
Jessica encounters text in a document that appears blue and underlined. When she presses CTRL and clicks the text, she is taken to a website. She wants the text to appear and behave like normal text. Which of the following should she do?
Right-click the text and select Remove Hyperlink.
Change the font color and remove the underline using buttons in the Font group of the Home tab.
Delete the text and then retype it.
Leave the text as is; it will appear normal when the document is printed.
Right-click the text and select Remove Hyperlink.
How can you identify the format of a file?
Check what program opens the file
Check what program created the file
Check the file size
Check the file name extension
Check the file name extension
Jamie recently downloaded a photo editing app that some of her friends said had some exciting features. Two days later, she found out her email account had been hacked. What kind of malware infected Jamie's computer?
Virus
Ransomware
Worm
Trojan
Trojan
One of the great advantages of ____ references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations.
cell
relative
absolute
formula
relative
If you want to see many slide thumbnails on the screen at the same time, which view should you use?
Normal
Outline
Slide Show
Slide Sorter
Slide Sorter view
To make your presentation more interesting, you should consider converting lists to which of the following?
Tables
Complete paragraphs
Slides
SmartArt graphic
SmartArt Graphics
Teagan is fixing a leak under the sink and asks her phone to display a video about making the repair. What technology is Teagan using to complete her plumbing task?
XY
AI
IoT
NFC
AI
Eric just signed up for his first college class after being out of school for nearly a decade. He goes to the bookstore the week before class starts to get his book, and he is surprised to learn that he only needs an access card. How will Eric be accessing the course material for his college class?
BYOD
Telecommuting
LMS
Social networking
Use the LMS also known as course management system (CMS)
What type of memory contains the instructions needed to start a computer?
ROM chips
RAM modules
Virtual memory
Flash memory
ROM (Read-Only Memory) is a type of computer memory that stores permanent data and instructions for the device to start up.
What is the minimum password length recommended by most security experts?
15-20 characters
8 characters
12-15 characters
30-40 characters
15-20 Characters
The ____ is mounted on the motherboard and is responsible for executing instructions to process data.
Command Bank
CPU
hard disk
dataport
CPU
To change the order of operations, enclose part of the formula in ____.
brackets
italics
parentheses
quotation marks
parentheses
Each range is identified with a range reference that includes the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a ____.
semi-colon
period
colon
comma
Colon
The first part of a URL is the ____.
web server's location
protocol
file path
type of website
Protocol
In the world of academics, style guides emphasize the proper way to create ____.
bibliographies
citations
sources
resources
citations
The _______ group on the HOME tab includes a button for each of the four major types of alignment.
Font
Styles
Editing
Paragraph
Paragraph
Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?
A5
$A$5
$A5
A$5
$A$5
Under which tab will you click the Rewind After Playing checkbox?
Format
Options
Playback
Slideshow
Playback
Adrian has made a list of his family's grocery expenses over the past year. He wants to highlight all the weeks where expenses exceeded the grocery budget so he can budget more accurately for the coming year. Which spreadsheet tool will allow him to do this automatically?
Sorting
Conditional formatting
Filtering
Font formatting
Conditional Formatting