MIS 2201 Final Exam Review/ Updated Exam Questions with
Correct Verified Answers – Latest 2024.
Using MS Word, the easiest way to format paragraphs with similar fonts, line spacing and justification is
to use: - ANSWER - styles
Assuming that the "Body Text" style is one of the styles available in MS Word. What happens if you
modify this style in a MS Word document? - ANSWER - only those paragraphs formatted with the Body
Text style will be changed
In MS Word, to format selected parts of the document in different formats (e.g. different margins, page
numbering, headers and footers) you need to use: - ANSWER - Section Breaks
The placement of paragraph text relative to the left and right margins is referred to as: - ANSWER -
alignment
The space between the text and the top, bottom, left and right edges of the paper are referred to as: -
ANSWER - margins
Which of these is WRONG about word processing? - ANSWER - Only character-level formatting is
possible. Whole paragraphs cannot be formatted
The easiest way to create a new document that has a specific style, text, graphics or any other elements
you wish to recreate from a previous document is to use a(n): - ANSWER - template
When starting up a new blank document, MS Word applies the _______ template which contains the
default Office theme, default body font, headings and line spacing. You can modify this template to
match your preferences. - ANSWER - normal
Managing a very long document can be cumbersome especially when several people are working on
different parts and the formatting and page numbering need to be consistent. In MS Word the
pg. 1
,________________ feature allows different people to work on separate files simultaneously which can
be quickly organized into a single, complete document. - ANSWER - master and subdocument
When working on a long document, the _______ view enables paragraphs to be organized into levels so
more content can be viewed and manipulated in a single screen without scrolling or searching through
the whole document. - ANSWER - outline
What value will display if the following formula (note the missing equal sign) was entered into a cell in
MS Excel?
$55.00 + 5 - ANSWER - $55.00 + 5
What happens when dollar signs ($) are entered into a cell address? (not into the cell itself)
(e.g. $B$2:$B$10) - ANSWER - An absolute cell address is created
Given the following spreadsheet
Cell A3 has the formula =SUM(A1:A2). Copying the contents of cell A3 to cell B3 gives the following result
in B3: - ANSWER - 5
Given the following spreadsheet
Cell A3 has the formula =$A1+A$2. Copying the contents of cell A3 to cell B3 gives the following result in
B3: - ANSWER - 10
When working with charts in Excel, and the selected range of values is taller than it is wide, Excel
assumes that the category values and data are laid out in - ANSWER - columns
When working in charts in Excel, and you wish to change the title, legend and data labels, what part of
the chart needs to be changed? - ANSWER - chart elements
Which of these is NOT a reason why you would use tables in an Excel spreadsheet? - ANSWER - To use
different formulas in different rows in the worksheet
pg. 2
, Which of these functions in Excel allows you to display selected rows based on some criteria and hide
other rows? - ANSWER - filters
Which of these functions in Excel allows you to summarize certain statistics about the data and view
different outlines with the summaries - ANSWER - subtotals
Which of these functions in Excel allows you to summarize data from selected fields, view data from
different perspectives and compare one item to another item (slicing and dicing the data) - ANSWER -
pivot table
Which of the following is a valid statement on digital security? - ANSWER - Digital security is everybody's
responsibility
Based on the case studies in the textbook, the costs of a digital security breach to a business like Target,
TJX (TJ Maxx, Marshalls), Home Depot, etc., are not only in the ________ in terms of loss, reissuing of
credit cards, payouts to court-imposed restitution, legal fees and more, but also damage to the firm's
reputation and long-term profitability. - ANSWER - billions of dollars
__________ attacks via the Internet refer to cyber criminals using "zombie" computers or botnets to
repeatedly hit on a victim's website with a crushing load of seemingly legitimate requests sent
simultaneously by thousands of machines. - ANSWER - Distributed denial of service (DDoS)
A bank customer receives a message, what appears to be from the bank's website, asking her to provide
her login information. Assuming the message is intended to defraud the customer, what type of
infiltration technique is being used here? - ANSWER - phishing
Which of the following types of infiltration techniques does one open up to by posting sensitive personal
information and details about one's workplace on social networking sites? - ANSWER - social engineering
Some of the most common guidelines for designing a secure password include: - ANSWER - The
password should be at least eight characters long and include at least one number, upper and lower case
and other special (non-alphabet) characters
pg. 3
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller ASSIGNMENT7. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.