Information systems final

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

If you type =2 + 3 * 6 into a cell in a spreadsheet and then press Enter, what will appear in the cell?

20

Stories in presentations should typically last for

30 seconds to one minute

A friend asks if you want to go see the new Avengers movie but you say it's too expensive. "No it's not, tickets have only gone up $2.00 since last year," says your friend. You reply, "tickets went from $8 to $10 for a matinee. That is a large percentage increase. What formula would provide the percentage increase?

=(10-8)/8*100

Which statement about online presence is true?

A personal brand built through an online presence can help business professionals gain opportunities.

Peyton wants to make his team's discussion forum more effective. Which strategy would best help him accomplish that?

Acknowledge teammates' ideas.

According to the CIA triad, in which of the following examples is an organization ensuring data integrity? More than one answer may be correct.

An organization has a formal policy for alerting the IT department when employees leave the company.

Σ What does the above symbol (upper-case Sigma) represent in spreadsheets?

AutoSUM

Which statement about charts is true?

Charts should not require much mental effort for the reader.

What is the purpose of using color in spreadsheets?

Color makes data easier to read.

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.

Stanley, a sales analyst for G&B Toys, is preparing a report for board members on the company's market share for action figures. Although G&B has retained its spot as the market leader, several competitors have captured a larger share of the market over the preceding year and appear likely to overtake G&B within the next three years. How should Stanley present his findings to the board?

Disclose the data fully to foster transparency in the organization.

In the context of writing business messages, which statement is true?

Emphasizing what products and services are, rather than what they are not, makes business messages more positive.

As you review your presentation, what should you ask yourself to determine how factual you've been?

Have I carefully considered various interpretations of my data?

Ebony, the owner of One Hour Gym, wants to know how customers feel about the new strength and conditioning classes that she is offering. Which question should Ebony incorporate into her survey questionnaire?

How do you feel about the new strength and conditioning classes compared to the old ones?

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

A digital music streaming company is promoting its service in a new country with a special discount for residents. How can the company use authentication to help prevent people from exploiting or abusing the deal? More than one answer may be correct.

It can verify that the customer lives in the correct country. & It can verify that the customer is new to the company or service.

Which of the following statements best illustrates why a rootkit is described as creating a back door?

Like an intruder coming through a back door, a rootkit allows an unknown user into an operating system.

What distinguishes Multi-Factor Authentication (MFA) from Two-Factor Authentication (2FA)?

MFA can include biometrics, security tokens, or SMS codes & MFA uses only two verification factors

Breanna, IS manager at a mid-size service firm, picks up some evidence that a Trojan horse engineered to steal passwords has accessed the system. All members of project teams are trained in online safety, and their network is protected by a firewall. But the worse-case scenario has happened: a competitor has received protected information, possibly directly from a member's computer. What first steps should Breanna and the security team take to solve the problem? More than one answer may be correct

They should review everyone's activity log, looking for any downloaded files or programs. & The security group should sift through emails for a message with clickable links.

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.

Data at rest or storage can be found in which of the following places? More than one answer may be correct.

a database in a datacenter & on a memory card

James begins his presentation on supplemental insurance by telling a dramatic story about an employee who was able to keep his home because of having such insurance. What type of attention-getter is this?

a vivid example

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

What are the three categories of the detect (DE) function of the NIST Cybersecurity Framework?

analysis, observation, detection

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

audience analysis

Facts are statements that

can be relied on with a fair amount of certainty

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

cell

When Baruch joined his company, his manager encouraged him to use the company's digital platform to network with those who have shared professional interests and to join their groups. These groups are called

communities of practice.

Generally, bar charts are best suited for

comparing amounts or quantities

To select nonadjoining cells in a spreadsheet, hold down the ________ key while selecting cells.

control

Who is the primary audience for the most business reports?

decision makers within the company

According to the Coca-Cola social media guidelines, when employees promote the brand online, they should

disclose that they work for the company.

When using a shared file platform, it is important to

discuss protocols for co-editing files.

Aria wants to gather information on the sales potential for a new women's dietary supplement, and decides to purchase a report compiled by a research firm that is highly respected for its understanding of women's health issues. In this case, she is primarily evaluating data quality in terms of its

expertise

The majority of your presentation should be devoted to

expressing and supporting your views

In the context of the AIM planning process, what tends to be the single most important planning step for many messages?

identifying read benefits and constraints

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

The main aim of your presentation is to draw support from your audience and to

influence key decision makers in your audience

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

inverted pyramid

Sadiki included the question on a customer survey: "Do you prefer healthy, nutritious food, or food that is bad for you and will ruin your health?" The problem with that question is that it

is leading

Which element is a typical Web 1.0 communication?

photos of a restaurant menu posted online

Which type of reputation is affected by material a person posts to an online discussion forum that is accessed only by people in his or her company?

professional and private.

What part of the plan-protect-respond cycle is occurring when an organization limits access to sensitive documents on a server to only those with the required security clearance?

protect

What is the key action called for in the detect (DE) function of the NIST Cybersecurity Framework?

quick identification of a cybersecurity threat

When displaying financial information, the accepted practice is that ________ indicates negative values.

red

A cybersecurity exploit allows a hacker or intruder to

remotely access a network, gain privileges, and make unauthorized changes.

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

setting a positive and other-oriented tone

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

In a business message, the function of a call to action is to

state explicitly what you want the audience to do.

What is the first step of the PREP method of justifying your views in a presentation?

stating your position

A drawback of online databases is that they

take time to navigate

What is the goal of the most public relations messages?

to create a distinctive brand for a company or organization

What is the purpose of saving an Excel file as a .cvs (comma-separated format) file?

to share data with other spreadsheet users regardless of which spreadsheet program is being used

User 1.0 is most likely to

use email as the main communication tool

When you specifically want your presentation to appeal to professionals with a blue motivational value system, you should focus on

using relationship-centered terms

Chavez, a human resources manager of K8 Fabrics believes that the company can improve employee retention rates by improving employee benefits. In outlining his argument to the company's leadership team, he points out that a large technology firm had success with such a strategy. Chavez' message fails to convince K8's leadership team. What is the likely cause of their reaction?

weak analogy

Reports or guides that are issued by the government and organizations and that generally describe research about solving a particular issue are

white papers