CSCI Final Exam Study Guide

Which of the following keys can you press to run a slide show starting with slide 1? a. F5 b. F7 c. F9 d. F11

a. F5

A brownout is a complete power failure. True False

False

A cell reference with only one dollar sign before either the column or the row is called an absolute reference. True False

False

A cyberextortionist uses the Internet or network to destroy or damage computers for political reasons. True False

False

As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations. True False

False

Breakthroughs in surgery, medicine, and treatments seldom result from scientists' use of computers. True False

False

By default, PowerPoint ends a slide show with a black slide. True False

True

As you type, Excel displays the entry in the ____ bar. formula entry text worksheet

formula

A(n) ________ is a computer program stored in Excel™ for specific calculations. enumerator matrix function variable

function

What is the role of the PMT as input in the calculation of Pv from a future value source? Calculating the effect of withdrawing a regular amount from an account. Calculating a mortgage payment. Calculating the effect of irregular withdrawals at unpredictable points in time. Calculating square roots.

Calculating the effect of withdrawing a regular amount from an account.

To remove spyware, users need to obtain a special program that can detect and delete it. True False

True

To select a number format, you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear. True False

True

Press ____ to select the entire worksheet. a. CTRL+A b. F1 c. ALT+A d. F4

a. CTRL+A

Clicking the Create Function box opens the Function Arguments dialog box. True False

False

Clipping is the process of transferring an item from a clipboard to a specific location in a document. True False

False

Every domain name contains a master domain, which identifies the type of organization associated with the domain. True False

False

If you delete a file from removable media, it is stored in the Recycle Bin where you can recover it until you empty the Recycle Bin. True False

False

It is not possible to add a shadow to text. True False

False

Line spacing is the amount of space above and below a paragraph. True False

False

Live preview is available on a touch screen. True False

False

Low saturation produces vivid colors. True False

False

Mobile service providers never charge additional fees for sending text, picture, or video messages. True False

False

One technique to improve Web searches is to use general nouns and put the less specific terms first in the search text. True False

False

Open source software is copyrighted software that is distributed at no cost for a trial period. True False

False

Point-and-shoot cameras are much heavier and larger than SLR cameras. True False

False

Tax preparation software helps companies record and report their financial transactions. True False

False

The range automatically selected by Excel is always correct. True False

False

To reload a picture taken with a digital camera means to copy the digital picture from the camera to your computer. True False

False

If you inadvertently rename a file that is associated with certain apps, the apps may not be able to find the file and may not run properly. True False

True

Information collected and stored about individuals should be limited to what is necessary to carry out the function of the business or government agency collecting the data. True False

True

The Normal view is composed of ____. a. Slides tab b. Notes Pane c. Slide Pane d. Properties Pane

a. Slides tab b. Notes Pane c. Slide Pane

Short text messages sent via a text message service are typically fewer than how many characters? a. 300 b. 445 c. 500 d. 700

a. 300

All of the following are valid Excel arithmetic operators EXCEPT ____. a. > b. * c. % d. ^

a. >

____ are types of changes that occur when text has been omitted from a document and must be inserted later. a. Additions b. Deletions c. Modifications d. All of the above

a. Additions

____ includes special visual and sound effects applied to text or other content. a. Animation b. Playback control c. Visual effects d. Audio control

a. Animation

____ changes picture color into black, white, and shades of gray. a. Grayscale b. Whitescale c. Colorscale d. Blackscale

a. Grayscale

In the construction of the IPMT and PPMT functions in the amortization table, which of the following entries uses the relative addressing feature? Fv Per Pv Nper

Per

Any illegal act involving a computer generally is referred to as a computer crime. True False

True

E-books have no wear and tear. True False

True

PowerPoint allows you to adjust colors to match or add contrast to slide elements by coloring photos. True False

True

The Insert Options button lists formatting options. True False

True

The most common error when entering a formula is to reference the wrong cell in the formula. True False

True

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula. True False

True

You can nest IF functions as deep as you want, but after you get beyond a nest of three IF functions, the logic becomes difficult to follow. True False

True

In the ____ letter style, the date, complimentary close, and signature block are positioned approximately one-half inch to the right of center or at the right margin. a. modified block b. block c. modified semi-block d. all of the above

a. modified block

Cell references in a formula are called ____. a. assumptions b. content c. numbers d. comments

a. assumptions

The text in a flyer is organized into the following areas: ____. a. body copy b. footer c. headline d. signature line

a. body copy c. headline d. signature line

Which of the following kinds of malware is a malicious mobile app that uses a variety of fraudulent schemes to charge unsuspecting users for premium messaging services? a. toll fraud b. worm c. trojan horse d. rootkit

a. toll fraud

In a business letter, the inside address usually contains the addressee's ____. a. full geographical address b. business affiliation c. complimentary close d. courtesy title

a. full geographical address b. business affiliation d. courtesy title

The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it. a. two b. three c. four d. five

a. two

The ____ function is useful when you want to assign a value to a cell based on a logical test. a. OR b. IF c. AND d. NOW

b. IF

The Undo button is located on the ____. a. HOME tab on the ribbon b. Quick Access Toolbar c. status bar d. vertical scroll bar

b. Quick Access Toolbar

____ properties are associated with all Microsoft Office files and include author, title, and subject. a. Replacement b. Standard c. Hidden d. Automatic

b. Standard

____ allows you to see through the background, so that any text on the slide is visible. a. Transversely b. Transparency c. Ambiguity d. Opaqueness

b. Transparency

Which of the following is the use of computers to simulate a real or imagined environment that appears as three-dimensional (3-D) space? a. TCP b. VR c. IrDA d. POP

b. VR

Which of the following oversees research for the Internet? a. NSFnet b. World Wide Web Consortium (W3C) c. ARPANET d. NASA

b. World Wide Web Consortium (W3C)

Which of the following is the path to the Zoom button? a. (INSERT tab | Zoom group) b. (ZOOM tab | View group) c. (VIEW tab | Zoom group) d. (HOME tab | Zoom group)

c. (VIEW tab | Zoom group)

What is the term for the picture/video message service available on smartphones and other mobile devices? a. MCS b. SCM c. MMS d. CMS

c. MMS

Which of the following is NOT a media player? a. iTunes b. Windows Media Player c. Safari d. RealPlayer

c. Safari

What consist(s) of a series of related instructions that tells the computer what tasks to perform and how to perform them? a. Storage utilities b. GUIs c. Software d. Sharing communities

c. Software

Which of the following terms refers to someone who uses the Internet or network to destroy or damage computers for political reasons? a. cyberextortionist b. cracker c. cyberterrorist d. script kiddie

c. cyberterrorist

Files containing ____ are available from a variety of sources. a. search terms b. colors c. graphics d. task panes

c. graphics

The small squares and circles around a selected graphic are called ____ handles. a. dimension b. shape c. sizing d. base

c. sizing

To print a mailing label, click the Labels button on the MAILINGS tab in the ____ group. a. Building Block b. AutoText c. Template d. Create

d. Create

Clicking the ____ box completes an entry. a. Cancel b. Tab c. Formula d. Enter

d. Enter

Pressing the ____ key to complete an entry activates the adjacent cell to the right. a. DOWN ARROW b. UP ARROW c. LEFT ARROW d. RIGHT ARROW

d. RIGHT ARROW

The range of cells receiving copied content is called the ____ area. a. range b. location c. fill d. paste

d. paste

What is the electronic component that interprets and carries out the basic instructions that operate the computer? a. motherboard b. control unit c. arithmetic unit d. processor

d. processor

Which of the following occurs when the electrical supply or voltage drops, often defined as more than five percent below the normal volts? a. overvoltage b. online surge c. power surge d. undervoltage

d. undervoltage

A large amount of e-waste ends up polluting developing countries, who accept the materials for profit. True False

True

A mobile console is a device that combines features of a smartphone with a tablet, like the one shown in the accompanying figure. True False

False

The Theme Fonts group of formatting choices for a document theme contain a set of lines and fill effects. True False

False

The application system provides a means for users to communicate with the computer or mobile device and other software. True False

False

The cost of accounting software for a small business can be several hundred thousand dollars. True False

False

The distinction among categories of computers is always very clear. True False

False

When you insert an object in a document, Word always inserts it as a floating object. True False

False

When you run a slide show, empty shapes do not display. True False

False

Word inserts text to the right of the insertion point. True False

False

Word never moves or adjusts automatic page breaks; however, Word adjusts manual page breaks that follow an automatic page break. True False

False

In a constant payment loan, the _____ will begin as a large part of the payment and at the end of the loan, it will diminish to a smaller part of the loan. Per PPMT IPMT PMT

IPMT

If you are doing a what if? procedure on a NPV calculation and you want to change the order of the returns to be in order of size, what feature of Excel™ should you use? Prioritize Increase Sort Prevent

Sort

____ indicates the number of pixels that a computer uses to display the letters, numbers, graphics, and background on a screen. Pixel resolution Screen view ribbon resolution Screen resolution

Screen resolution

The path to the Format Painter button is ____. a. (HOME tab | Clipboard group) b. (HOME tab | Number group) c. (HOME tab | Font group) d. (HOME tab | Painting group)

a. (HOME tab | Clipboard group)

What is an AUP intended to do? a. outline computer activities for which the computer and network may or may not be used b. establish a network of computers, such as a homegroup c. contract with an outside organization to provide security and recovery services for a network d. license software for individual use

a. outline computer activities for which the computer and network may or may not be used

Business documents can include all of the following EXCEPT ____. a. personal letters b. newsletters c. proposals d. resumes

a. personal letters

When a placeholder is selected, the ____ are displayed. a. selection handles b. placeholder handles c. justification handles d. alignment handles

a. selection handles

With which of the following do users choose which folders and files to include in a backup? a. selective backup b. differential backup c. incremental backup d. full backup

a. selective backup

By default, the Normal style inserts a vertical space equal to ____ line(s) between each line of text. a. 1 b. 1.08 c. 2 d. 2.15

b. 1.08

The term, botnet, means _____________. a. a computer whose owner is unaware that the computer is being controlled remotely by an outsider b. a group of compromised computers connected to a network that attacks other networks c. a program that performs a repetitive task on a network d. spam sent via email to spread viruses or commit a distributed denial of service attack

b. a group of compromised computers connected to a network that attacks other networks

Which kind of desktop uses the same case to house the screen and processing circuitry? a. tower b. all-in-one c. convertible d. slate

b. all-in-one

What kind of software consists of programs designed to make users more productive and/or assist them with personal tasks? a. utility b. application c. operating d. system

b. application

With ____ editing, Word automatically displays a Paste Options button near the pasted or moved text. a. inline b. drag-and-drop c. cut-and-paste d. copy-and-carry

b. drag-and-drop

Which of the following are valid steps toward virus protection? a. stay informed about viruses, never visit web sites unless they are approved by the Virus Protection Agency (VPA) b. purchase a reputable antivirus program, update antivirus definitions regularly c. open e-mail attachments and then scan them for viruses, install operating system updates d. delete a personal firewall, scan your computer for malware

b. purchase a reputable antivirus program, update antivirus definitions regularly

When you drag a graphic's ____ handle, the graphic moves in either a clockwise or counterclockwise direction. a. selection b. rotate c. turn d. revolution

b. rotate

You are looking for a computer to provide a central location for online game play. What kind of computer do you need? a. supercomputer b. server c. mainframe d. minicomputer

b. server

One helpful use of an amortization schedule is to check off each payment as you make it and therefore always be aware of the current ____________ _______. inflation rate principal balance gasoline price exchange rate

principal balance

The Fv function would be very useful for Calculating how much you could accumulate in a savings account with regular deposits. Predicting the stock market increases. Calculating cube roots. Targeting the rate of inflation.

Calculating how much you could accumulate in a savings account with regular deposits.

Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column. True False

True

____ view allows you to create or modify a worksheet while viewing how it will look in printed format. a. Page Layout b. Full Screen c. Normal d. Page Break Preview

a. Page Layout

Inflation is a risk to the success of a new project requiring an investment because inflation can cause the cost of borrowing to increase substantially. inflation can cause the purchasing power of money to be reduced. inflation cannot be controlled by one business. all of the above answers are correct.

all of the above answers are correct.

You should use a ____ chart to compare values side by side, broken down by category. a. Line b. Clustered Column c. Bar d. Column

b. Clustered Column

Which of the following are formatting symbols? a. Pound sign (#) b. Comma (,) c. Dollar sign ($) d. Percent sign (%)

b. Comma (,) c. Dollar sign ($) d. Percent sign (%)

Each time you press the ____ key, Word carries forward custom tab stops to the next paragraph. a. CTRL b. ENTER c. SHIFT d. F2

b. ENTER

The term back door, as it refers to computer crime, is _____________. a. a weakness in a computer or network's security system that enables criminals to gain unauthorized access b. a program or set of instructions that allows users to bypass security controls when accessing a program, computer, or network c. the area of memory where information about a virus or attempted attack is sent by the antivirus software in order to prevent similar attacks in the future d. the vulnerabilities of a computer criminal or criminal network that enable them to be tracked and caught

b. a program or set of instructions that allows users to bypass security controls when accessing a program, computer, or network

Which of the following kinds of file utilities shrink the size of a file(s)? a. conversion b. file compression c. matrix d. unit

b. file compression

Which of the following best describes the term, cybercrime? a. using the Internet to apprehend and prosecute criminals b. online or Internet-based illegal acts c. any illegal act involving a computer d. a type of gaming software that simulates criminal acts

b. online or Internet-based illegal acts

____ help clarify and emphasize details, so they appeal to audience members with differing backgrounds, reading levels, attention spans, and motivations. a. Outlines b. Typefaces c. Graphics d. Icons

c. Graphics

The _______ _________ icon is located just to the left of the Formula Bar. heading separator interest payment underline cell insert function

insert function

Cell addresses in Excel™ consist of a column identifier placed in alphabetical order and a row identifier expressed as a(n) _______ in sequential order. symbol financing factor decimal fraction integer

integer

A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet. True False

True

The basis of most real business valuations includes Where the manager got his/her college degree. An estimate of the net present value of the cash flows that have a high probability of occurring in the future years. The political influence the owner has with the city where the business is located. The golf score of the owner.

An estimate of the net present value of the cash flows that have a high probability of occurring in the future years.

To create automatically a column of sequential integers beginning with "1" and ending with the number of payments of the loan, enter correct values (for example, 1, 2) in each of the first and second cells at the top of the column. Then select both cells and _____________. Just type in the values manually Drag using the fill handle in the lower cell to the value of the maximum number of payments. Use the PMT function and copy it to the next lower cell. Drag the top cell to the right.

Drag using the fill handle in the lower cell to the value of the maximum number of payments.

Increasing the number of compounding periods per year in a Fv calculation has the effect of: Reducing the annual percentage rate. Increasing the present value. Increasing the interest paid assuming equal annual percentage rates are used each time. Decreasing the interest paid assuming equal annual percentage rates.

Increasing the interest paid assuming equal annual percentage rates are used each time.

The reason the investment amount is presented as a negative number in the calculation of NPV in Excel™ is which of the following? The investment is in foreign currency. Investment is distinguished from returns by presenting it as a negative number that is expended by the investor or company. Investment is a morally bad way to try to improve a company's procedures. Interest charges are added to the investment in the number recorded as investment.

Investment is distinguished from returns by presenting it as a negative number that is expended by the investor or company.

The Discount Rate used in the implementation of NPV performs what valuable function? It makes the analysis look complicated. It provides the user a way to apply measurable challenges and expenses to the analysis of a new investment in order to provide net returns. It should not be used because you can never predict the success of a new investment. It is a needless bureaucratic process.

It provides the user a way to apply measurable challenges and expenses to the analysis of a new investment in order to provide net returns.

If you are using the IPMT function, how can you confirm you have the right function and how can you know what Per is used for? Use a slide rule. Call your banker and ask him/her how to do it. Just read the notations in the dialog boxes that explain what each function does and the purpose of each of the arguments or input amounts. If you do not remember, you just have to look it up in a reference book or this tutorial.

Just read the notations in the dialog boxes that explain what each function does and the purpose of each of the arguments or input amounts.

If you are using the IPMT function, how can you confirm you have the right function and how can you know what Per is used for? Use a slide rule. If you do not remember, you just have to look it up in a reference book or this tutorial. Call your banker and ask him/her how to do it. Just read the notations in the dialog boxes that explain what each function does and the purpose of each of the arguments or input amounts.

Just read the notations in the dialog boxes that explain what each function does and the purpose of each of the arguments or input amounts.

When confronted with a negative number in a loan calculation that is the result of an Excel™ and not a mathematical negative, the correction can be achieved by the following procedure: Multiply times the quantity -1. Add $.02 to the payment amount. Multiply by a value of 10. Divide by a quantity of 3.14159 (Pi).

Multiply times the quantity -1.

The solution in a Fv function from a procedure using a present value source is most often a negative number. Why? This is most often an Excel™ convention, not a mathematical negative. The number is mathematically negative. There is a bug in the program. You should probably try Pv

This is most often an Excel™ convention, not a mathematical negative.

Organizing files in folders is part of a process known as file management. True False

True

Some users of e-books prefer the electronic paper black-and-white screen over the models with color screens because the electronic paper resembles a paper page from a book. True False

True

The MLA style requires that the works cited be listed in alphabetical order by the author's last name or, if the work has no author, by the work's title. True False

True

The group of adjacent cells beginning with B4 and ending with B8, written as B4:B8, is called a(n) range. True False

True

To protect yourself from social engineering scams, shred all sensitive or confidential documents. True False

True

You can advance slides during a slide show by pressing the PAGE DOWN key. True False

True

You can resize images by dragging the sizing handles to a desired location. True False

True

Which of the following (with examples such as Cambria and Calibri shown in the accompanying figure) is a name assigned to a specific design of characters? a. font b. iconography c. text set d. point

a. font

Which kind of license is a legal agreement that permits users to install the software on multiple computers, usually at a volume discount? a. site b. network c. multipurpose d. distributed

a. site

You can format slide text by changing the ____. a. style b. point size c. font d. color

a. style b. point size c. font d. color

Which of the following are types of placeholders? a. slide b. title c. subtitle d. content

b. title c. subtitle d. content

If someone feels distressed when deprived of computers and mobile devices, that person is said to suffer from what condition? a. Technological interference b. Technological neurosis c. Technology overload d. Technology use syndrome

c. Technology overload

____ a slide can help you see slide elements more clearly so that you can position them precisely where desired. a. Formatting b. Coloring c. Zooming d. Styling

c. Zooming

If someone displays a webpage in a browser and the page indicates Flash Player is needed, what is Flash Player? a. a media compensator b. a different browser than the one being used c. a plug-in d. a streamer

c. a plug-in

PowerPoint assumes every new slide, except for a blank slide, has ____. a. clip art b. large font sizes c. a title d. transitions

c. a title

To enter data in a cell, you must first select the ____. a. worksheet b. column c. cell d. row

c. cell

The box on a slide that has a dotted or hatch-marked border and that contains the insertion point is a text ____. a. layout b. recorder c. placeholder d. pane

c. placeholder

When your friend is using a website that offers a variety of Internet services from a single convenient location, what type of website is she using? a. wiki b. informational c. portal d. content aggregator

c. portal

Which of the following consists of images displayed in motion? a. vodcasting b. digeo c. video d. audio

c. video

A database management system is software that allows you to use a computer to _____. create a workbook create queries add, change, or delete data create forms and reports

create queries add, change, or delete data create forms and reports

The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell. a. Comma style format b. Percent style format c. Currency style format d. Accounting number format

d. Accounting number format

To move up one paragraph, press the ____ key(s). a. ALT+UP ARROW b. F1 c. UP ARROW d. CTRL+UP ARROW

d. CTRL+UP ARROW

What effect does the Accounting Number Format have on the selected cells? a. Copies the numbers of one cell to another b. Performs tax calculations c. Converts alphabetic characters to numbers d. Displays cell contents with two decimal places that align vertically

d. Displays cell contents with two decimal places that align vertically

Which of the following refers to unique and original works such as ideas, inventions, writings, art, processes, company and product names, and logos? a. PGP b. DoS c. TCP d. IP

d. IP

Which of the following enables users to speak to other users over the Internet? a. FTP b. HTTPS c. IM d. VoIP

d. VoIP

Which of the following does a new federal laboratory use in its high security areas? a. digital forensics system b. signature verification system c. hand geometry system d. iris recognition system

d. iris recognition system

A slide ____ is a special effect used to progress from one slide to the next slide in a slide show. a. layout b. theme c. animation d. transition

d. transition

To use an app, you must instruct the operating system to ____ the app. run interface with quit restart

run