CSCI Final
Program
A _____ is a list of instructions that a computer uses to perform a task
theme
A _____ is a predefined set of colors, fonts, cell styles, and fill effects that can be applied to an entire workbook
CPU
A _____ is considered a processing device
template
A _____ is similar to a form with prewritten text
line break
A _____ will advance the insertion point to the beginning of the next physical line, ignoring any paragraph formatting
table of contents
A ______ allows a reader to navigate quickly through your document by CTRL+clicking on the specific page number they wish to view
Program
A ______ is a list of instruction that a computer uses to perform a task
task pane
A ______ is a window inside the Word window that can remain open and visible while you work in a document
protocol
A ______ is an agreed-upon standard for communication
cell
A ______ is the intersection of a column and row in an Excel spreadsheet
style set
A _______ consists of a group of frequently used styles formatted so they look pleasing when used together
trojan horse
A _______ is a harmful program disguised to look helpful
header
A _______ is text and graphics you want printed at the top of each page in a document
resume
A _______ usually contains an applicant's educational background and job experience
template
A ________ is a document with preset content, formatting, or other objects
worm
A ________ is a self-replicating software that is capable of self-propagation from machine to machine
green
A ________ wavy underline indicated that text may be incorrect grammatically
virus
A _________ is a self-replicating software the propagates by inserting copies of itself into other programs or documents
drive
A __________ is like a filing cabinet that stores many folders and files
write programs
A programmers job is to
8x8
A general rule for adding text to a slide is ____.
tab stop
A location on the horizontal ruler that tells Word where to position the insertion point when you press the TAB key is called a ______ _____
Demonstrative
A presentation that went through the instructions of "how to" change the tire on a car would most likely be a ______ presentation.
a clear, concise subject line a greeting a clear closing
A proper professional email must contain which of the following components
false
A slide show should contain every word of your presentation and should be read like a script.
Insertion point
The _______ is represented by a blinking cursor and indicated where information will be entered into your document
Central Processing Unit
The _______ is the "brain: of the computer; it reads and executes program instructions, performs calculations, and makes decisions
active cell
The _______ on a Worksheet is the currently selected cell in which data can be entered
Quick Access toolbar
The _______ provides easy access to frequently used commands
ribbon
The _______, located near the top of the Excel window, is the control center in Excel
mouse cursor
The ________ becomes different shapes depending on the task you are performing
insert options
The ________ button lists formatting options following an insert of cells, rows, or columns
Undo
The ________ button on the Quick Access Toolbar allows you to reverse your recent commands or actions
insertion point
The ________ is a blinking vertical line that indicates where the next typed character will appear
ribbon
The ________, located near the top of the window, is the control center in Excel as well as most other Microsoft Office Applications
home tab
The ________, the primary tab, contains the most frequently used commands
=PMT()
The _________ function takes rate, payment, and loan amount and outputs a monthly loan payment amount
EFF (Electronic Frontier Foundation)
The __________ is an organization dedicated to protecting freedom and rights of consumers in this digital age
the PAGE UP and PAGE DOWN
The __________ keys can be used to scroll up or down in a document
mini
The __________ toolbar appears automatically based on tasks you perform and contains commands related to changing the appearance of text in a document
Internet
The ___________ is a worldwide collection of networks
back & forward buttons
The ____________ allow you step through web pages that you have visited one page at a time
Ribbon
The ____________ located near the top of the Word window, is the control center in Word
line spacing
The amount of vertical space between line of text in a document is called ______
13
The answer to the formula below following the order of operations is ________. =4+3*(2+1)
task manager
The application built into windows that can be used to monitor applications and processes that are currently running on the system is
the system tray
The area of the desktop with the system clock and a list of background programs is called what?
The Taskbar
The area of the screen that gives you thumbnail previews and allows you to easily switch between currently running programs is called the _____________?
slide
The basic unit of a PowerPoint presentation is the ____.
True
The body of an email contains the message itself
column boundary
The border to the right of a column is called the ________
hanging indent marker
The bottom triangle on the horizontal ruler is the _______
placeholders
The boxes with dotted borders that are displayed on new slides are ____ for text.
true
The combination of the less than and greater than operators next to each other, like <> is commonly used as the "not equal" to symbol
true
The largest network in the world is the internet
the file extension
The last part of a file name, after the period, is known as what?
all slides
The scroll bar allows you to scroll through _____ .
CTRL+1
The shortcut keys for formatting a paragraph with single spacing are _______
false
The size button of the page setup group on the page layout tab allows you to quickly change the margins of your document based on the most used paper sizes
left indent marker
The small square on the horizontal ruler is the _______
CTRL
To select nonadjacent ranges, select the first range, hold down the ______ key, then select the next range (For example: A2 and F4)
Merge and center
To split a merged cell, select the cell and click the ________ button
merge and center
To split a merged cell, select the cell and click the _________ button
windows task bar
To start Google Chrome, click the Start button on the _________, then scroll down to google chrome, the click Google Chrome
false
To start collaborating on a document using Word, all you need to do is give another person the file on a flash drive
true
To turn on text wrapping, in a cell you can use the Wrap Text Button on the Ribbon
view page source
To view the HTML code for a specific web page in Google Chrome, you right click the page and select _________
view page source
To view the HTML code for a specific web page in Google Chrome, you right click the page and select __________
internet address
URL (uniform resource locator) is just a fancy name for ________
spam
Unsolicited bulk email is typically referred to as _______
=NOW()
Use the ______ function to enter the system date into a cell in the worksheet
MIN
Use the _______ function to determine the lowest number in a range
so that the recipient doesn't ignore it or think it is spam
Using an appropriate email subject line is important...
disk defragmenter
What application puts files that are stored on a hard drive back together, making them more contiguous?
While there are many steps that can be taken to lower the chances of your computer from being infected by a virus or malware, no option or set of options will completely protect your computer from viruses and malware
What can you do to ensure that your computer is completely 100% protected from malware/viruses?
Use the safely remove option
What can you do to prevent data corruption issues when using USB flash memory?
'(an apostrophe)
What character should proceed a number with leading zeros (ex. 006) to ensure that the zeros will be displayed in the cell?
when a folder is zipped, the files it contains are compressed into a single file
What does it mean to "zip" a folder in windows?
the alignment of two or more celestial bodies
What does syzygy mean? (remember that Google can define words)
this PC
What icon on your desktop do you click on to access all of the drives connected to your computer
a fill in which the color gradually changes between colors
What is a gradient fill?
favorites
What is the White Star with Black Outline button in Google Chrome used for?
snap
What is the feature that allows you to resize open windows simply by dragging them to the edges of your screen?
F11
What is the keyboard shortcut for setting the Google Chrome window to Fullscreen?
high point
What points in your range of data can Sparklines show?
disk cleanup
What program can delete temporary files and empty your Recycle Bin to free up space on your hard drive?
Picture Tools
When a picture is selected in Word, a new category named _______ opens in the ribbon
right-clicking the image, clicking save image as, specifying the location to which you want to save the image, and clicking the save button
When an image is displayed on the page, you can save the image by
numbering
When dealing with an "ordered list" of items inside of PowerPoint it is best to use _____ to organize them.
false
When doing research for a paper on the controversial topic of Global Warming, all you really need is one or two websites that confirm your point of view. Looking for more sites is unnecessary
maintaining eye contact
When giving a presentation, _____ helps keep the audience's attention.
Edit the text on individual slides
Which of the following cannot be preformed while in the slide sorter view?
=Sum(A1:A3) =A1 + A2 + A3
Which of the following formulas correctly finds the sum of cells A1, A2, and A3 (following proper excel formula formatting)? (Select all that apply)
pie
Which of the following is NOT a type of Sparkline?
hiding
_____ cells is a technique you can use to hide data that might be sensitive or not relevant to a report
MLA and APA
______ are two of the major styles of writing used at ETSU
E-commerce
______ is a practice of selling goods and services over the internet
clip art
______ is a predesigned graphic
Paragraph
______ spacing is the amount of space above and below a paragraph
quick styles
_______ allow you to quickly apply predefined formatting to your document, and can be found in the Styles group
all of the above
_______ allows a reader to better follow the flow of your document
hard disk
_______ drives are used to store data inside the computer
false
Disk defragmentation occurs when a file, stored continuously on the hard disk drive, is split into smaller files that are placed throughout the hard disk drive
metadata
Document properties, also known as ______, can include such information as the project author, title, or subject
open files, open folders (directions), and execute shortcuts
Double-clicking (pressing the left mouse button twice, in rapid succession) is commonly used to accomplish which tasks?
left aligned
Excel automatically positions text ________ in a cell
#DIV/0!
Excel displays the error message ______ in cells to indicate a divide by zero error
spell checker
Excel has a _____ you can use to check the worksheet for spelling errors
SUM
Excel's _____ function allows you to add all of the numbers in a range of cells
settings
In Google Chrome, ________ in the more drop down menu allows you to control Internet Options, set your default home page, and manage your pop-up blocker
History option in the More drop down menu
In Google Chrome, the ___________ allows you to view a list of web sites that you have previously visited
styles
In Microsoft Word, a Table of Contents can be created from sections of a Word document. What Word feature do you need to use to select the sections of the Word document?
watermark
In Microsoft Word, a ________ can be used to apply a background image to a document
print preview
In Microsoft Word, the Review tab allows users to do all but one of the following options. Select the option that is not available on the Review tab
endnote
In Microsoft Word, you can place a ______ at the top of a document to further clarify a point in the document or even list a reference for a quote used in the document
design
In Powerpoint, which "tab" gives you the option for changing a presentations theme?
desktop
In Windows 10, the _________ is the first screen you see when the operating system is up and fully running (& logged in)
insert
In ______ mode, as you type a character, Excel inserts the character and moves all characters to the right of the typed character one position to the right
true
In a presentation, a variety of font styles and font colors can distract the audience from the presentation's content.
hardware, software
In class we categorized the components of a computer as being either ______ or _________
refresh
In google chrome, if you want to get the most recent information from a specific web page that you are already viewing, you can use the _______ button
OneDrive
In office, the online storage location that is used for collaboration is called ________
All of the above
In order to fine-tune Windows for optimal performance, you should
multiplication
In the formula: = A4 - B4 + C5 - D5 * E6 the _____ operation is performed first
false
In word, multiple people can edit a document that is stored on your computer at the same time
=B22-A3
Please select the formula that subtracts the contents of A3 from B22
line wraps
PowerPoint ____ text that exceeds the width of the placeholder.
maximize
Press the ________ button to have the window fill the entire screen
backstage view
The ______ is a feature in Microsoft Word and is the primary location for creating new documents, printing or saving your documents
clipboard
The ______ is a temporary windows storage area
snipping tool
The ______ is a utility for quickly grabbing screen shots and images. It also allows for easy annotations
subject line
The ______ is where the topic of an email is placed
page layout
The ______ tab contains the paragraph group, where you can set up indents and spacing
justify
The _______ alignment is commonly used in newspapers and books, and spreads the text out on the line with even spacing
status
The _______ bar presents information about the document, the progress of current tasks, and provides controls for viewing the document
font size
The _______ box arrow on the home tab allows you to change the font size of text
Auto Fill Options
The _______ button gives for how to fill cells following a fill operation
Wordwrap
The _______ feature in Word allows you to type continually without pressing the ENTER key at the end of each line
accounting number
The _______ format causes the cells to display with two decimal places so that the decimal places in cells below align vertically
spam
unsolicited bulk email is typically referred to as
true
Outlook is ETSU's student email system
True
A USB hard drive is a portable storage device that allows you to transfer information from one computer to another
insertion point
A blinking vertical bar that shows where text will be inserted as you type is called the _________
cell reference
A cell is referred to by its unique address, called a(n) _______, which is the coordinates of the intersection of a column and a row
formatting mark
A character that displays on the screen but not on a printed document is called a _______
column heading
A column letter above the grid, also called a _______, identifies each column
.com
A commercial organization, business, or company would have the domain name extension of _____________
windows key + M
A commonly used keyboard shortcut to minimize all windows and show the desktop is ________
windows key + E
A commonly used keyboard shortcut to open file explorer is _________
Input, output, processing, storage
A computer performs what four basic operations?
True
A computer program is considered software, as opposed to hardware
theme
A document ________ is a set of unified formats for fonts, colors, and graphics
files
A drive is like a filing cabinet full of folders that hold all of your information stored on a disk
folders
A drive is like a filing cabinet that holds many _________ full of files
-Remind the student of the professor's office hours. -Showing the student the Microsoft Office Help website, for further clarification on how to use powerpoint.
A fellow student needs help on a powerpoint assignment. Select all of the following ways you can help, that Do Not constitute as cheating.
false
A network drive is located inside the computer
Output device
A peripheral device that displays, prints, or transmits the results of processing from the computer memory is an
exploded
A pie chart with one or more slices offset from the main portion is called a(n) ________
1/72
A point is approximately ________ of an inch in height
file
A saved document is referred to as a ______
sizing handles
A selected graphic appears surrounded by a selection rectangle, which has small squares and circles, called ________
false
A soft page break is a break that you manually insert into a document
paragraph border
A solid line that can be drawn at any edge of a paragraph is called a _________
true
A style set controls the formatting for your entire document
both hardware and software
A user interface is ______ that you use to control and communicate with your PC
true
A zip file will compress files that you place inside of it?
research paper
A(n) _____ is a document you can use to communicate the results of research findings
manual
A(n) ______ page break is one that you force into a document at a specific location
pie
A(n) _______ chart is used to show the relationship of the parts to a whole
function
A(n) _______ is a prewritten formula that is built into Excel
endnote
A(n) _______ is an explanatory note located at the end of the document
function
A(n) ________ is a prewritten formula that is built into Excel
range
A(n) ________ is a series of two or more adjacent cells in a column or row or rectangular group of cells
footer
A(n) is text that you want printed at the bottom of the page
false
According to ITS's acceptable use policy, it is OK to search for pornography on ETSU's network
increase the width of the cell
After typing numbers into a cell, if the cell contents display as pound signs (#####), this means the number is wider than the cell current width. What can be done to fix this problem?
true
An embedded chart is simply a chart on a worksheet
true
An intranet is an internetwork made up of interconnected LAN's within a single organization
true
As you type, autocorrect automatically corrects most spelling, capitalization, and grammar errors
Z:
At ETSU all students have a designated network drive for individual storage. This is called the ________ drive
1: Select the "Reference" tab 2: Select "Manage Sources" 3: Select the "New" button 4: Enter the Cited Resource's information 5: Select the "Ok" button
Below are some of the steps taken to add a citation to the Microsoft Word Source Manager. Please place these steps in order
.5 inch
By default, Word places a tab stop at every _____ mark on the ruler
False
Cell phones cannot get viruses because they have strong virus protection
true
Charts automatically update in Excel if the data changes
references tab
Click the insert citation button on the _______ to display the insert citations menu
Backstage
Clicking on the File button brings up the _______ View
source document
Copied items come from a(n) _____
power on self test
During the startup of a computer, when the BIOS is first loaded, a "POST" is initiated. What does the acronym "POST" stand for?
false
Dynamic Host Configuration Protocol or DHCP associates IP addresses with the URLs
URL
Each Web page has a unique address called a(n) ____________
end-of-cell mark
Each cell has a(n) _____ which is a formatting mark that assists you with selecting and formatting cells
sheet tab
Each worksheet has a sheet name that appears on a(n) _______ at the bottom of the workbook
1,048,576
Each worksheet in a workbook has _____ rows
16,384
Each worksheet in a workbook has ______ columns
False
Email attachments are always safe to open
True
Email is no more private than a postcard
Social networking websites
Facebook, Instagram, and Twitter are all examples of
hierarchical view
File explorer displays folders in which type of view by default?
points
Font size is determined by a measurement system called _____________
CSCI 1100
For this computer course, what should be in the subject of each email you send?
1: How Beethoven wrote music while deaf site:.gov 2: Beethoven wrote music while deaf 3: deaf Beethoven 4: Beethoven music
For your music history class you need to find an article on how Beethoven wrote music even after he became deaf. List the following search entries from 1 "Most specific" to 4 "Least specific"
true
Fragmentation occurs when files on the hard drive are not stored contiguously
faulty hardware
Generally, what does it mean when the POST fails to load?
friend locator
Google's web search has advanced features that allow all of the following EXCEPT ____________
type the program name in the search box to the right of the Windows button
How can one find a program in Windows 10 without browsing through the program list in the Start Menu?
1
How many worksheets are created when you open a new workbook in Excel?
system software
Microsoft windows 10 is an example of what type of software?
true
IP addresses can be either public or private
absolute
If a cell reference contains the dollar sign ($), like $A$1 the reference is _______
false
If a document is Public Domain, it does not need to be cited. If it's Public Domain, then it is public knowledge
view
If rulers are not displayed, click the ________ tab to turn the ruler on
Excel Workbook (*.xlsx)
If saving Excel the save as file type should be _______
the magnifier tool
If you are having problems with hard-to-see text or pictures, you can use _____ to enlarge them for easier viewing
Undo
If you do not want to keep a change made by the Autocorrect feature, you can click the ______ button on the Auto Correction Options menu
compress
If you have multiple large files, that you want to group into a single, smaller file (usually for email) you should _________ it
Suggests appropriate spellings and allows the user to add the word to Word's dictionary
If you right click on a word with a red wavy line under it, Word...
red
If you type a word that is not in Word's dictionary, a ______ wavy underline appears below the word
places a border above a paragraph
If you type three hyphens then press the ENTER key, Word ______
insert
If you want to create a footer, click the footer button on the ______ tab
double quotation marks
If you want to search for an exact word or phrase in Google, you enclose the word or phrase with _______
notifications
Important information about system events or program alerts are called _______, and are commonly displayed in captions above the system tray
true
In Excel, Boolean Logic can be used for comparing cell values, such as finding which cell has the larger value
Redemption is the security's redemption value per $100 face value
In Excel, find the financial formula PRICEDISC. What does Excel Help say about the REDEMPTION parameter?
< >
In Excel, which symbol means "Not Equal To" when comparing two values?
true
Incognito window lets you control whether or not Google Chrome saves your browsing history, cookies, and other data
true
It is a good idea to keep a clean email address for online banking and shopping, and to keep this separate from the email address you use for friends & family and to sign up for websites (like news and product updates)
true
It is a good idea to practice your presentation in the location you will be giving it.
false
It is not important to provide the data that you last accessed a Web source
True
It is possible for a single device to act as both an input and an output device
home
Many of the most commonly used basic formatting options in Microsoft Word are on the ______
.pptx
Microsoft Word uses the ".docx" extension. What extension does Microsoft PowerPoint use?
PowerPoint
Microsoft ____ is a complete presentations graphics program that allows you to produce professional-looking presentations.
False
Outlook does not have a built in spam filter
true
One key benefit to using Sparklines inside Excel is that they will update if the data is changed in the worksheet
system
Operating systems are an example of __________ software
an email scam that attempts to acquire sensitive information
Phishing can be best described as
1: Press the power button 2: POST test is run 3: BIOS 4: Operating system loads kernel 5: Load system utilities 6: User authentication is ran
Put the steps in order for the startup procedure
the questions may distract the presenter and key points may be forgotten.
Question and answer sessions are often held at the end of a presentation because ________.
False
Random Access Memory is used to store information permanently in your computer
1: A database of peer reviewed articles 2: scholar.google.com 3: www.wikipedia.org 4: a personal blog
Rate the following resources from most reliable "1" to least reliable "4"
opening context menus
Right-clicking (pressing the right mouse button once) is commonly used to accomplish which task?
opening context menus
Right-clicking (pressing the right mouse button once) is commonly used to accomplish which tasks?
keyboard, mouse, microphone
Select all the options that are classified as a computer input device
-The Table of Contents has been inserted at the start of the document -The sections of the document have been given the correct Style
Select all the steps that need to be taken for creating a document's Table of Contents
How To Train Your Dog.... -Find the right breed -Choose proper skills -Prepare your reward system -Have fun!!!
Select the powerpoint slide that best presents the information on dog training.
CTRL+'
The keyboard shortcut for displaying all formulas in the spreadsheet is _____________
icons
Small pictures that represent files and programs are called
true
The keyboard shortcut to minimize a window is Windows key + M
false
Sparklines provide a detailed, accurate, and absolute representation of your data
true
Tabbed browsing allows users to navigate between multiple web pages in a quick and orderly manner
All of the above (business cards, resumes, memos)
Templates allow for the quick creation of ______
false
Text in the Notes Pane is seen by the audience while the presentation is running?
clip organizer
The ______ contains a collection of clip art, photographs, sounds, and video
Home Tab, Number Group, $
The Accounting Number format function is contained within the ______
Blind carbon copy
The BCC field in an email stands for
False
The CC Field in an email stands for Creative Commons
False
The CPU is where all of the data on your computer is stored
false
The CPU is where all of the data on your computer is stored
false
The Cell Styles menu on the Insert tab is used to quickly format a cell by choosing from predefined styles
style manuals
The Charles C Sherrod library page has ________ so you can follow correct MLA and APA styles
All of the above (link to various library resources, access your GoldLink account, search for people at ETSU)
The ETSU homepage (www.etsu.edu) allows you to
All of these options (title bar, forward and back buttons, address bar)
The Google Chrome window can contain which of the following?
Works Cited
The MLA style uses the term ______ to refer to the bibliographic list of sources at the end of the paper
100
The Percent style button on the Formatting toolbar is used to display a value determined by multiplying the cell entry by __________, rounding the result to the nearest percent, and adding a percent sign
spin the pie chart
The X-Axis Rotation does what to a pie chart?
false
The Y-Axis rotation will spin the chart around
autoformat
The ____ feature will format a Web or e-mail address that is followed by SPACEBAR or ENTER key as a hyperlink
title slide
The ____ introduces the presentation to the audience.
view
The ____ is the mode in which the presentation appears on the screen. (e.g. normal _____, slide sorter _____, reading _____, slide show _____.
autocorrect
The _____ feature in Word automatically corrects certain spelling, typing, capitalization, or grammar errors
office clipboard
The _____ is a temporary storage area that holds items copied from any Office program
first line indent marker
The _____ is the top triangle on the horizontal ruler
equal sign
The ______ alerts Excel that you are entering a formula or function and not text
count
The ______ command in the AutoCalculate area displays the number of non blank cells in the selected range
cell
The intersection of a row and column is called a _______
Calibri
The default font in Word is usually
tick marks
The default tab stops are indicated at the bottom of the horizontal ruler by small vertical _______
Normal View
The default view for a worksheet is _______
all of these options (viruses, images, text documents)
The different types of files you can attach to an email message include
true
The domain code of a website (.com, .edu, .gov, etc) can help to determine the reliability of a website's information
a small black plus sign
The fill handle looks like _________
=18.5*B4
The formula ________ multiplies the contents of cell B4 by 18.5
true
The navigation pane contains the Quick Access links and the folder list, which allow you to navigate to different folders on your computer
24
The office clipboard can hold up to ______ items
design
The option to change the slide size between standard (4.3) and widescreen (16.9) is on the _______ tab.
100
The percent style button on the Formatting toolbar is used to displayed a value determined by multiplying the cell entry by _______, rounding the result to the nearest percent, and adding a percent sign
-always -ask me -never
The three sharing changes options for document collaboration are
only the characters in the cell
The underline format will underline ________
stops the current page from loading (if it is still loading when you click the button)
The x button on the left side of the address bar
format
To
citation
To avoid plagiarism, you should always provide proper ______ for any material used from another source
CTRL+B
To bold text using shortcut keys, press ________
CTRL+SHIFT+A
To capitalize all selected characters, press
CTRL+E
To center a paragraph using shortcut keys, press ______
Home tab
To center a paragraph, click the Center button on the ______
Center
To center data in a cell, click the _______ button on the Ribbon
tab color
To change the color of a sheet tab, right click on the sheet tab and select ________
home
To change the direction of text you click on the Text Direction control on the ______ tab.
CTRL+2
To change the line spacing to double, press _______
rename
To change the name of a file, we will often right click and select the ______ option
bevel
To change the shape of the edges of a 3-D chart in Excel use the _____ option
close
To close the current Word document but leave Word Open, click the File tab, then click _______
all of the above
To count the number of words in a document, ________
review
To count the words in a document, click the word counter button on the ______tab
CTRL+SHIFT+<
To decrease font size using the shortcuts keys, press
press the DELETE key
To delete a character to the left of the insertion point you use the backspace key. What key do you use to delete a character to the right of the insertion point?
true
To delete an embedded chart, click the chart to select it, and press the DELETE key
insert function box
To determine the average of a range of numbers, click the _______ in the formula bar, then click AVERAGE
MAX
To determine the highest number in a range of numbers, click Insert Function box in the formula bar to display the Insert Function dialog box, then select ________
enter
To display a Web page associate with a URL, type the URL in the Address box, and then press the _______ key
right-click
To display a list of corrections for flagged text (e.g. misspelled word or improper grammar), ______ the flagged text
increase decimal
To display additional decimal places in a cell, click the _____ button on the ribbon
scroll bars
To display different portions of your document in the document window, use the ______
Show/hide P
To display formatting marks in your document, click the ____ button on the Home tab
click the Show/Hide "P" button on the Home tab
To display formatting marks, _________
CTRL+SHIFT+*
To display formatting marks, press ______
left-click the hyperlink, specify the location to which you want to save the file, and click the Save button
To download a file using a hyperlink
cover letter
To elaborate on the positive points in your resumer, you use a ______
format
To emphasize certain entries and make the worksheet easier to read and understand, you _____ the worksheet
four-digit years
To ensure that Excel interprets year values the way you intend, use _______
backups
To ensure the safety of your data and prevent potential loss, you should always make regular __________
page number
To enter a page number in a header, click the ______ button on the insert tab
review
To find a synonym, click the thesaurus on the ______ tab
synonyms
To find a word with similar meaning to the one already in your document, right-click the word and select ______
find and replace
To find and replace text, click the replace button on the home tab to display the ______ dialog box
research tools
To find journals, articles, and other research materials in a given field, you should use the _____ provided by the Charles C Sherrod library
false
To insert a picture into PowerPoint, you click on the Office Button and then Open and browse to where the picture is located.
shake
To minimize all of your open applications except one, grab that one by the title bar and _______ it briskly
firewall & router
To monitor and lock down communication coming into and going out of your computer, you can use a __________
false
To move a window by dragging, you point to the title bar, click and hold the right mouse button, and drag the window to a new location
UP ARROW
To move the insertion point up one line, press the _______ key(s)
right
To open a context menu that gives you more operations on the selected item, you _____ click
CTRL+O
To open a document in Word, press ________, select the file name, press ENTER
CTRL+V
To paste an item from the office clipboard using shortcut keys, place the insertion point in the desired area of the document, and with the clipboard task pane displayed, press _____
more
To print a Web page, click Print on the ___________ drop down menu
CTRL+P
To print a document, press _______
true
To protect your files, and prevent unauthorized access, you should use encryption, ensuring that only someone with the right key can open them
catalog quick search
To quickly search for physical books and E-books that are available through the campus library, you should use the _____________
remove hyperlink
To remove the hyperlink format, right-click the hyperlink, and click ____ on the shortcut menu
site:
To restrict your Google search to a specific domain, you use
CTRL+S
To save a file, press the ______ keys
click to the left of the row
To select an entire row in a table, ____
Voice over internet protocol
VoIP which is used to make standard phone calls over broadband connections stands for
cookies
Websites can store identifying information about you on your computer for future reference by using
true
When protecting a worksheet all cells are locked by default
context
When right-clicking an object, a ____ menu appears, which contains frequently used commands related to the object.
12
When using the function to determine MONTHLY payments for a loan, you multiply the number of years by _________ to determine the total number of MONTHLY payments
copy
When you _______ a file between folders, the file still exists in the source folder
minimize
When you ________ a window, it is hidden from view, but still open and running
0
When you decrease a row height to _______, the row is hidden
deleted permanently
When you delete the files from your USB flash drive, they are __________
true
When you insert a chart inside of PowerPoint an Excel window opens to let you edit the data.
paste options
When you paste items into a document, word automatically displays the ______ button on the screen to allow you to change the format of the pasted item
tab character
When you press the TAB key, a _______ formatting mark appears in the empty space between the tab stops
false
When you received spam, you should reply to it, requesting them to stop emailing you
False
When you save a file to the cloud, you know all the details about the computer where your file is stored
true
When you start Excel, the Ribbon displays eight top-level tabs/views: File, Home, Insert, Page Layout, Formulas, Data, Review, and View
True
When you use a cloud based service, you don't know the details about the computer that services your requests
shortcut keys
When your fingers are already on the keyboard, it is sometimes more efficient to use ____ to format text
chart tools design tab
Where can the button be found to move a chart to a new sheet in an Excel workbook?
pie chart
Which chart type helps to represent portions of a whole?
windows key + an arrow key
Which is the keyboard shortcut for the snap function?
Tab
Which key will demote bullet points in PowerPoint?
F5
Which key will run the current PowerPoint Presentation?
Internet
Which network is larger in size (both in land coverage and number of connected computers): internet or intranet?
HTML, CCCC, Name
Which of the following are NOT appropriate components of an email?
AND, NOT, OR
Which of the following are valid Boolean search operators that will allow you to further refine a search in Google?
192.168.0.1
Which of the following is a valid IP address?
Greater than
Which of the following is a valid conditional formatting operator found in the New Formatting Rule dialog box?
greater than
Which of the following is a valid conditional formatting operator found in the New Formatting Rule dialog box?
adobe acrobat
Which of the following is not Web Browser Software
improves the speed of downloads
Which of the following is not a benefit of tabbed browsing?
Line of pie
Which of the following is not a pie chart type in Excel?
http://facebook.com
Which of the following is not a popular search engine?
heading 5
Which of the following is not a style in the Cell Styles Gallery?
Two Picture
Which of the following is not a type of slide layout?
biographical
Which of the following is not one of the three basic types of presentations?
tera-
Which of the following prefixed indicates the largest number of bytes?
they provide a relative view of your data
Which of the following statements about Sparklines is TRUE?
Click F2 and type the new sheet tab name
Which of the following will not rename the sheet tab in Excel?
www.google.com
Which search engine is least suited to academic research?
Bar graph
Which type of graph best compares the unit sales for the different brands of juice?
Themes help to convey a consistent style.
Why is it a good idea to use slide themes?
any/all
With a 3-D pie chart, you can explode _____ of the slices
remove background
With a picture selected, click the picture tools format tab and click the _______ _______ button to remove the background from the image
soft page breaks
Word automatically inserts page breaks, called ______ when it determines the text has filled one page according to paper size, margin settings, line spacing, and other settings
true
Word automatically numbers notes sequentially by placing a reference mark (either a number or a lowercase roman numeral) in the body of the document and also to the left of the note text
table styles gallery
Word provides a _________, allowing you to change the basic table format to a more visually appealing style
horizontal ruler
Word provides a quick way to indent paragraphs through the ______
increase font size
Word provides a(n) ___ button, which increases the font size of selected text each time you tap or click the button
right-click
You can _______ note text in a footnote to display a shortcut menu related to footnotes
Underline
You can access decorative underlines and change their color through the ______ drop down
conditional
You can apply ______ formatting that appears only when the value in a cell meets conditions that you specify
picture tools, format
You can change the color of a graphic by clicking the color button on the _______ to display the recolor gallery
false
You can enter the Date and Time into PowerPoint by using the formula '=now()', just as we did in Excel.
Web query
You can import data stored on a Web site using a(n) _______
row boundary
You can resize a row in a table by dragging the ______
square
You can resize an entire table by dragging the table resize handle, which is a small _______ that appears when you point to a corner of the table
10
You can see the following formula in cell A3 of an excel spreadsheet =IF(A1 <> A2, 10, 30) With the following values for A1 and A2, what value will be found in cell A3?
true
You can see where others are editing when multiple people are editing the same document when collaborating
true
You can use Google to get help if you have an error message appear
true
You can use a network drive only if you are on the same network as the drive
all of the above
You can use the fill handle to _______
insert tab
You click the clip art button on the ______ to display the clip art task pane
true
You only need to select OneDrive as the storage location for a collaboration document once. The next time you open it and save it it will save to OneDrive automatically
25
You open Microsoft Excel and see in Cell B5 the following formula =IF(H3 >= J2, 15, 25) If H3 = 11 and J2 = 13, what value will the formula set B5 to?
false
You should never bother running a spelling & grammar check because AutoCorrect will catch all of your mistakes
they interfere with other students' access to authorized Wi-Fi service
You should not bring unauthorized Wi-Fi devices into the dorms because _______
they interfere with other students' access to authorized Wi-Fi service
You should not bring unauthorized Wi-Fi devices into the dorms because ________________
false
You should trust all email messages you receive
Myrtle Beach firework policy site:.gov
You're planning a trip to Myrtle Beach this summer and want to know what if there are any laws against using fireworks on the beach. Which of the following searches will give you the most reliable results?
-Google/Web search the link's website to check if anyone has complaints against the website -Contact you friend (email, text, Instant Message, in-person, etc.) to see if he/she actually has posted the link on your facebook page
Your friend on facebook has posted a link to your page to a website you've never visited before. How can you safely verify that the link is actually from your friend and/or a legitimate website?
Layouts
____ are used to position content on a slide.
system software
____ consists of programs to control the operations of computer equipment
document properties
____ includes such information as the project author, title or subject.
AutoFit
_______ means that the width of the column will be increased or decreased so the widest entry will fit in the column
Bold
________ characters display thicker than normal which helps to make them stand out from normal characters
Best fit
________ means that the width of the column will be increased or decreased so the widest entry will fit in the column
sticky
________ notes are a great tool for making quick reminders. They can even be color coded or hold a short voice memo
system software
_________ consists of programs to control the operations of computer equipment
print preview
_________ displays the entire document as it will appear on paper after being printed
CTRL+X
_________ is the keyboard shortcut for cut
Character formatting
_________ is the process of changing the way characters appear on the screen and in print
CTRL+HOME
__________ is a keyboard shortcut that repositions the insertion point at the start of the document
Hard Disk
___________ drivers are used to store data inside the computer
CTRL+C
___________ is the keyboard shortcut for copy
CTRL+V
____________ is the keyboard shortcut for paste
Faulty hardware
generally, what does it mean when the POST fails to load
URL
www.google.com is an example of a _________
