CSCI Final

Ace your homework & exams now with Quizwiz!

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 _________


Related study sets

AWS Solutions Architect Associate

View Set

Orion Series 65 - Exam 3 Quick Quizzes

View Set

Ch 5: NJ laws, rules, regulations

View Set

RE Course Section 4: Agency in Michigan

View Set

MFT Clinical questions to review

View Set

Concepts 2 Perfusion Practice Assessment

View Set

PMK-EE Professional Conduct (E4)

View Set

Real Estate Brokerage: Practice Exam

View Set

LATITUDE AND LONGITUDE STUDY GUIDE

View Set