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
