IS 2200 Final Exam

In an Excel file, if a label (such as the word "panda") is used in a formula, what will appear in the cell when the Enter key is pressed?

#VALUE!

The stylist just did a great job and your hair is going to look good for weeks. The stylist charged $70 and you decide to add a 15% cash tip. How big is the tip?

$10.50

What is an example of a company using social media during the marketing research process?

-Collect data and information -Analyze data and information -

List the reasons why organizations should identify their target markets when creating a social media information system (SMIS).

-Different social media platforms attract and cater to different markets. -Social media marketing is more cost-effective if it targets specific markets.

Information provided by Instagram Insights informed an organization that their sponsored post had 1,000 impressions per day but an unsponsored post written by their new Social Media Director received 15,000 impressions that same day. Why might his information be valuable to the organization?

-If the new Social Media Director is able to recreate that level of engagement with more of her posts, the organization may be able to reduce the amount of sponsored content they place on Instagram. -The organization may be targeting the wrong audience with their sponsored posts; analyzing who's engaging with the Social Media Director's posts can provide the organization valuable information about their target audience.

Which of the following are responsibilities of a CISO? Select all that apply.

-Leadership of the information security team to ensure alignment with the strategic direction of the business. -Identifying, evaluating, and reporting on information security risks. -Ensuring that disaster recovery plans are in place and tested regularly.

Which of these statements best explain why humans are studied as components in a technology-based business system?

-People are valuable potential customers. -Human capital is vital to operating SMISs.

What is the importance of Identity-First Approaches in cybersecurity?

-Protecting against unauthorized access -Managing the identification of individuals with IT system access

Which three arguments will usually be entered when using the PMT function?

-Rate -Nper -Pv

What information does the Facebook tool Audience Insights provide to organizations?

-The geographic location of users who most frequently interact with a corporation's page. -A list of the pages that a defined target audience most frequently interacts with. -The average amount a targeted demographic spends on products when the purchase is initiated from an ad on their timeline.

Which of these statements support the assertion that MitMo is a growing security risk? More than one answer may be correct.

-The world is flooded with smartphones and other mobile devices. -Mobile devices function in many of the same ways that computers do.

Select three benefits gained by incorporating themes and styles when presenting a spreadsheet.

-They provide visually appealing color combinations and fonts. -They allow you to easily incorporate company colors and fonts, reinforcing brand identity. -They provide color combinations that can increase accessibility.

Which of these online functions are most susceptible to MitM attacks? More than one answer may be correct.

-financial applications -e-commerce

What are some types of software that social media providers use?

-software that allows the provider team to log on to the system -any database management system

Because interest rates are advertised as annual percentage rates (APRs), when using the PMT function to determine a monthly payment it is necessary to divide the rate by

12.

The number 27 in the cell depicted above is a value, not a formula. If the user drags the cursor to the right, what will appear in the cell to the right?

27

Select the spreadsheet formula that would correctly calculate the average (mean) of the following values: 25, 50, and 75.

= (25 + 50 + 75) / 3

Select the spreadsheet formula that would correctly calculate the average (mean) of the following values: 3, 2, 6, and 8.

= (3 + 2 + 6 + 8) / 4

To multiply the value in cell B3 times the value in cell E2, you could use the PRODUCT function. Alternatively, you could simply enter

=B3*E2.

If you want to quickly find the mean of the values in cells A1, A2, and A3, what function would you place in A4?

AVERAGE

What advice is useful for conducting business across cultures with those who have limited English ability?

Allow those with limited English ability enough time to process their thoughts into English.

Which situation is an example of how social media can complicate professional relationships?

An employee blogs about an embarrassing incident involving his or her boss, who sees the post.

Which person illustrates a characteristic of an excellent business thinker?

Barras uses a variety of sources such as journal articles and colleagues' expertise.

Why is a denial-of-service attack (DoS attack) a threat to data availability?

By flooding a system with incoming messages, a DoS attack forces the system to shut down, rendering it inaccessible to the users who legitimately have access to it.

What function would you use to display how many entries are made in Column A above Cell A37?

COUNT

Determine which of the following is an example of data that has integrity.

Data that are used to set sales goals for account executives are stored on a secure server; managers are allowed read-only access to the sales data for the reps they directly manage.

Gowan has been hired by Bailey's Automotive to assess whether the company should air television commercials in the local market. He is planning a study of the relationship between local television commercials and the sales of new vehicles. What is the best way for Gowan to establish a research objective that will address his research problem?

Determine how often television commercials result in purchases of new vehicles.

Which guideline should be followed while reviewing a presentation for effectiveness?

Double-check every aspect of your supplementary materials.

Which person demonstrates high self-management during interpersonal communication?

Haruki controls emotional impulses that are not aligned with work and relationship goals.

A colorful style can make important data stand out on your worksheet. The Cell Styles button is located in the Styles group on the ___ tab.

Home

To quickly add a series of values, use the AutoSUM function. The AutoSUM icon is an upper case sigma, located in the Editing group, on the ___ tab.

Home

Seong finds that a geographic restructuring would have a positive effect on his insurance company's sales department and increase its efficiency. He draws up a report for the board of directors in which he suggests that separate departments should be set up for each of the company's 10 sales territories. Which statement is most likely to increase the positivity of his proposition?

I look forward to putting together a detailed plan to restructure the company geographically.

Pivot tables provide a quick way to organize information. In most spreadsheet programs, click the ________ tab to create a pivot table.

Insert

What is a disadvantage of conducting primary research into a business problem?

It is more time consuming than secondary research.

Natalie, assistant manager at Bright Gardens Restaurant, is preparing a questionnaire to help her evaluate customer satisfaction. She wants her survey to only include closed questions. Which question should Natalie use?

On a scale of 1 to 5, how would you rate your level of satisfaction with your most recent meal at Green Gardens?

When optimizing your spreadsheet for printing, you can select which data is shown at the top of each page by using

Page breaks.

Which statement about pie charts is true?

Pie slices should complete a whole, that is, add up to 100% of a data series.

What is the role of social media information systems (SMIS) in consumer behavior?

SMIS provide user data and analytics tools that help inform consumer behavior researchers.

During a budget meeting, Fanny concludes her part of the talk and points to her presentation partner. What does this gesture most likely mean in context?

She is indicating that it is his turn to speak.

Which statement is true about auditory learners?

They believe emotion is best conveyed through voice.

Which statement accurately describes microblogs?

They contain just a few sentences per entry.

Which statement is true about visual learners?

They enjoy gestures and metaphors.

What is a primary responsibility of a CISO in relation to the information security team?

To lead the information security team ensuring alignment with the business's strategic direction.

Shanda has created a presentation to convince the executives at Doggy Daycare, a regional chain of full-service dog boutiques, to include behavioral training in employee interactions with canine clients. It hits every mark but one: it is difficult to visually distinguish key points from the rest of the slides. What should she do to improve her presentation for ease of processing?

Use at least 28-point fonts for titles and 18-point fonts for body text.

Which formatting guideline increases the effectiveness of all types of charts?

Use darker colors to represent the most important data series.

Which element is a typical Web 2.0 communication?

a discussion forum that allows users to post questions and answers

The Stored Communications Act prohibits which activity?

accessing the communications of an organization without authorization

When you evaluate how well secondary research can be revised to address your specific business problem, you are considering its

adaptability.

Arturo opens his presentation with his two takeaway messages and a statement that frames them both in appealing terms. What did he forget to include in the preview of his presentation?

an attention-getter

In the PR story, what does the first paragraph do?

answer basic questions

During which step in the AIM planning process should you consider the constraints your readers face?

audience analysis

The beginning of your presentation is critical because

audience members form quick impressions about you and your message during this time.

Which speech pattern is more common among women than men?

avoiding verbal opposition

Most business arguments employ a deductive approach. When employing this approach, you are most likely to

begin by stating the primary message, which is typically a recommendation.

Rhonda used data from a liberal political organization in her report on voting trends in the U.S. In terms of data quality, what is a potential problem with this source?

bias

The basic unit of any spreadsheet, essentially a box where data can be entered, is called a(n)

cell.

Which action is a deceptive research practice?

cherry-picking data and adjusting information in your favor

Arla, an executive at American Hustle, Inc., wants to introduce a profit-sharing program. She needs to convince the other executives that it is a good idea for their company. She has considered her audience and gathered information. Next, she should

decide how to frame her primary message.

When using a shared file platform, it is important to

discuss protocols for co-editing files.

Which quality is characteristic of people who are hubs?

flexible

Which of these is least important when analyzing data related to a business problem?

focusing on tangential issues

The Rule of 72 states that dividing 72 by the interest rate approximates the time for the investment to double. This calculates the ________ of the investment.

future value (FV)

What is one of the purposes of the preview in a presentation?

generate interest among the audience members

Which business trend is valued across the world?

high priority on performance orientation

Which of the NIST Cybersecurity Framework functions investigates an organization's cybersecurity management in the context of their business needs and resources?

identify (ID) function

Sandra is preparing for a business meeting in a foreign country. What is most important for her to do to ensure proper etiquette?

identify acceptable conversation topics

In the context of dealing with business problems, what should ideally be the first step?

identifying the business problem

What is typically included in the planning stage of writing an effective business message?

identifying the primary message and key points

Frank is typically only interested in people who share his interests in sports and work. Whenever he finds himself having less in common with a friend, he leaves the relationship. What cultural dimension does Frank display?

individualism

Which term best describes the process of sending and receiving verbal and nonverbal messages between two or more people?

interpersonal communication process

In a press-release style message, the "story" is written in third person in a style often referred to as ________ style.

inverted pyramid

The difference between a company's fundamental value and its total value is that

its fundamental value is what customers and stakeholder's value about its product or service, while its total value includes the value added by other aspects of the business.

Gerry lives in a society where people are expected to solve their own problems. During business meetings, leaders do not waste time offering welcome or making social talk. Unfair treatment on the job is considered just the way life is. Which term best describes the type of culture Gerry lives in?

low humane orientation

One potential drawback of using social media in the workplace is that social media

may lower productivity.

Overall and underlying messages that others decode from your online communications are referred to as ________ messages.

meta

Setting social media metrics is the second step in creating a social media information system (SMIS) because

metrics are needed to quantify the organization's progress toward achieving its social media goals.

Natasha is Russian, and she thinks that all Americans are the same: hard-working, dishonest, and greedy. What concept is Natasha demonstrating?

outgroup homogeneity effect

What is the second step in the six-step process of creating an SMIS?

outline measurements of success

A unique set of professional skills and attributes that others associate with you is called your

personal brand.

In a weekly project update meeting, Lisa asks the following questions of one of her employees: "Why were you late meeting your last deadline? Were there external factors that delayed your work? Did other coworkers get their part of the assignment to you on time? Do you need more help from me?" What type of questions are these?

probing

When Kian listens to a customer, he paraphrases the customer's request or complaint to make sure he understands it. Which active listening skill is he using?

reflecting

Overall, women tend to be more ________, while men tend to be more ________.

relationship oriented; competitive

What is most likely to show that the writer of a business message has concern for the audience?

respecting the autonomy of the reader

One way to name a range of cells is to ___ the range and select the naming option.

right-click

Which of these is a domain of emotional intelligence?

self-management

Which action during a speech is most likely to result in your audience judging you as caring?

showing that you are interested in the needs of your audience

What is something an excellent business writer would do?

spend more time planning than writing

Programs such as Microsoft Excel, iWork's (Apple) Numbers, Google Sheets, and OpenOffice Calc, that allow users to arrange numerical data are called

spreadsheets.

One major threat to productive discussions is inconsistency. Firstcomers to a forum discussion are most likely to cause problems by

stating their opinion but failing to take part as the conversation evolves.

A drawback of online databases is that they

take time to navigate.

What is the meaning of the term "social engineering" in the area of cybersecurity?

the act of manipulating or tricking people into sharing confidential, personal information

Piers is using the story line approach in his presentation. He says that the coffee shop chain he works for faces the challenge of improving its customer service orientation. After telling the story of a sandwich chain that trained its workers in a particular customer service approach, he says, "Within six months, their complaints dropped by half, and their customer satisfaction increased by 18 percent." What aspect of a business story does that statement represent?

the moral or lesson

If you enter a formula, and Excel returns an error value of #VALUE!, this means that

the operation or function is not possible.

Which component in a presentation is analogous to the body portion of written documents?

the view

Which quality is more characteristic of introverts?

thoughtful

Vince always drops hand-written reports on his administrative assistant's desk and says, "Type this right away." What common type of incivility is Vince committing?

treating others without courtesy

Martha was once mugged on the subway, so now every time she enters the subway she starts to shake and feel afraid. For Martha, the subway is a

trigger.

When you notice someone is using a different speech pattern than yours, you should

try to overcome biases.

Enduring beliefs and ideals that individuals hold are called

values.

Ethnocentrism is the belief that

your own culture is superior to others.