Final exam information systems
What unction would you use to display how many entering are made in Column A above Cell A37?
COUNT
The CSV format saves the cell values and formulas.
False
What accurately matches the type of attire with attribute it projects?
Formal business dress projects authority
A status update is also known as a
Microblog
A common method to delete a column or row in ,ostensibly spreadsheet programs is to ____ on the column or row heading, and then select delete from the menu.
Right-click
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.
An early task to be accomplished when developing a presentation is to
understand the needs of your audience.
User 1.0 is most likely to
use email as the main communication tool.
What does the upper case sigma represent in spreadsheets?
AutoSum
Rafe, the sales manager at a national magazine, wants to complete sales of the magazine's spring issue not eh West Coast to those in the Midwest and on the East Coast. This comparison will be best illustrated through a
Bar chart
Which chart type can be used to compare many types of data and is thus the most versatile?
Bar charts
Which person illustrates a characteristic of an excellent business thinker?
Barras uses a variety of sources such as journal articles and colleagues' expertise.
How can a team ensure that it gives a cohesive presentation?
Be clear with one another about the team's objectives and key messages
Web 2.0 communication tools are primarily read-only
False Web 1.0 are read-only.
While developing slides, you should use bold, italics, and other formatting features to make key phrases or key components in figures stand out
true
To ensure that the bar charts are formatted effectively, the bars should be about ______ the width of the space in between bars.
two times
In an Excel field, 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!
You just had a great lunch at a nice restaurant and decide to leave a 15% tip on your $18 meal. What will be the total charge on your debit card?
$20.70
Select the spreadsheet formula that would correctly calculate the average (mean) of the following values: 25, 50 and 75.
+(25 + 50 + 75)/3
When adjusting the width of a column or the height of a row, which pointer(s) is/are used?
+. +
Providers use SMISs to deliver which of the following kinds of user data to sponsors? More than one answer may be correct.
-content data from user interactions -connection data from user relationships with other sources -data that reveal user behavior and connection patterns
If you type =8 / 2 * 4 + 1 into a cell in a spreadsheet and then press Enter, what will appear in the cell?
17
If you type =3+2^2*6 into a cell in a spreadsheet and then press Enter, what will appear in the cell?
27
Select the spreadsheet formula that would correctly calculate the average (mean) of the following values: 4, 2, 5, and 5.
= (4 + 2 + 5 + 5) / 4
Which social media tool would be best at helping a business professional establish a personal brand?
A blog
a public relations team's first step is to
Clarify the company's brand
Blogs and wikis are
Collaborative tools
Hardware, software, data, and procedure are dour of the five components of social media information systems.
False Hardware and software, data and procedures, and people are the three components of SMIS
Slides that have a lot of white space seem skimpy and give the presentation an unprofessional appeareance
False It provides an uncluttered appearance
If you wish to keep a column visible while you scroll through the rest of a spreadsheet file, you can use the ____ options.
Freeze
Which statement about SOFTEN model of nonverbal communication in presentations is true?
Keeping your arms to your sides or gesturing with palms up is more inviting to the ausience
What are the two most common spreadsheet charts?
Lin graphs and bar charts
In the curse of creating an effective business message, excellent business thinkers are most likely to
Make well-reasoned conclusions and solutions
Which of the NIST Cybersecurity Framework functions involves correcting an organizations cybersecurity plans due to a cybersecurity even?
Recover (RC) function
When displaying financial information, the accepted practice is that ___ indicates negative values.
Red
When displaying financial information, the accepted practice is that ______ indicates negative values
Red
Creating an internal company with a blog with comment features is a good way for managers to increase
Transparency
A business message should show that you have the interests of your audience in mind
True
Which medium is most likely to hold a of the work group's communications, such as updates, progress reports, a discussions?
a team blog
Use the AutoSUM function if you want to quickly ________ a series of values in a spreadsheet.
add
In spreadsheets, all functions and calculations begin with
an equal sign (=)
If you want to find the mean of the values in cells above A37 in the above spreadsheet, what function would you place A37?
average
Hoda is skilled at reading the emotional signals of her audience and making quick, subtle adaptations to her presentation to connect with them. Hoda is good at showing her
caring
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
Charlie has been assigned the task of creating an effective business message aimed at encouraging healthy habits in the workplace. He uses the AIM planning process. What should he do during the information gathering stage?
identify problems that prevent employees from making healthy choices
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 formatting method decreases the effectiveness of pie charts?
locating the smallest pie slice at 12 o'clock
Which of the following acts is an example of social engineering?
manipulating people in order to obtain and misuse their personal information
The traditional role of public relations was to communicate with
media
Bad actors seeking to create computer viruses primarily must know how to
program code
The ______ of data acquired through a secondary research is how well it applies to your specific business problem.
relevance
Because they make it easy to arrange, display, and calculate numerical data, ________ programs are commonly used in nearly every business setting.
spreadsheet
You see ###### in a cell. This means that
this is not an error. The cell needs to be expanded in order to display the entire value.
What is the goal of the NIST Cybersecurity Framework Protect (PR) function?
to help protect an organization's IT infrastructure from security breaches by offering guidelines on IT infrastructure protection
A common method to delete a column or row in most spreadsheet programs is to ____ on the column or row heading, and then select delete from the menu.
to right-click
When you log into most social software systems, you access a front page known as a
Dashboard
To quickly show if the values in a column or row are greater than, less than, or equal to a certain value, use the ________ function.
IF
Which statement about online research is true?
Industry sites list a variety of sources that may be more current than the information in business databases.
Advertised as an annual percentage rate (APR), the amount of money a lender charges for a loan is the loan's ________.
Interest
Select the two spreadsheet programs.
OpenOffice Calc Apple Numbers
Which statement about primary research is true?
Primary research provides feedback directly related to an organization and its needs.
The amount of money borrowed in a loan is often referred to as the loan's balance or the ______ of the loan.
Principal
The amount of money borrowed in a loan is often referred to as the loan's balance or the __________ of the loan.
Principal
________ involves ranking or assigning importance to things, such as projects, goals, and tasks.
Priorities
Which of the following is an example of an event that may occur during the protect stage of the plan-protect-respond cycle?
Provide employees with information regarding the specific types of security threats their realization faces Make sure resources are protected through routine maintenance Limit remote control access to sensitive data.
Which strategy will help make the question and answer portion of presentations as smooth and effective as possible?
Reframe the questions to match your agenda.
In the middle of his presentation, Leroy loses train of thought. What should he do?
Repeat his last statement to regain thought
In a spreadsheet, a horizontal line of cells is called a
Row
A drawback of online database is that they
Take time to navigate
What does the General Data Protection Regulations (GDPR) strive to achieve?
To endure EU companies protect the privacy and personal data of EU citizens
A legend shows which items are being identified by the different colors, lines, bars, or pie segments.
True
The use of social media, even for private use, complicates your relationship with your employer.
True
Typically, tone influences readers over the entire course of a message
True
As you collect , analyze, and present data to others, you should provide all the relevant facts, even if they do not fr into convenient conclusions
True A part of the FAIR test, you should grant access to your data.
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.
You ask your coworker to review your slides for a presentation, and he has trouble recognizing the most important ideas. To fix this, what should you change?
Use bold or italics to highlight key ideas.
Select three true statements regarding labels
Usually a test or text+number combination Can be created by typing an apostrophe in front of a number Remain of the left side of a cell when entered
Repots or guides that are issued by the government and organizations and that generally describe research about solving a particular issue are
White papers
Which action will help you maintain a flexible approach during your presentation
arriving early to deal with surprises regarding equipment, room layout, or attendance
Extensive use of the I-voice in a business message
fails to focus on the interests of the audience.
A meta message is
what people take away from a communication.
Which online action is most likely to damage your professional reputation?
writing a glowing recommendation of a colleague with whom you have never worked
Match the part of the loan with its definition
1. Rate. 2. Period 3. Present value (PV). 4. Term 1. Annual percent rate (APR) of interest 2. Single payment 3. Amount of money (principal) originally borrowed or owed
Every time you go to the gas station you're amazed at how much prices have increased. At this time last year the price was $3.20 per gallon and now the price is $4.25 per gallon. Which of the following spreadsheet formulas correctly calculates the percentage change?
=((4.25-3.20)/3.20) * 100
A corporation's Twitter report card indicates that engagement has dropped off in the past two months. What information from the tweet activity dashboard could they use to determine the cause of this drop off in engagement?
A change in demographics of the people who are engaging with their tweets
Which guideline increases the effectiveness of a bar chart?
A legend should be used only if the chart has two or more data series.
Which type of visual is most effective to display stock prices over time?
A line chart
In the context of workplace attire, which item of clothing distinguishes men's formal business dress from casual dress?
A necktie
Which of the following is an example of data in transit? More than one answer may be correct
A person uses an app on their smartphone to pay a bill A person transfers documents between their laptop and mobile devices
The basic unit of any spreasheet, essentially a box where data an be entered, is called a(n)
Cell
Saving a spreadsheet file in .CSV format only saves the
Cell values
Latecomers to forum discussions are most likely to cause problems by
Challenging the team's hard-earned consensus and damaging morale
In addition to planning, analysis, and mitigation, select two remaining two categories of the respond (RS) function of the MIST Cybersecurity Framework from the list below.
Communication Improvements to cybersecurity response plans
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
To select non adjoining cells in a spreadsheet, hold down the _____ key while selecting a cells.
Control (ctrl)
Mason maintains an exhaustive database on his research sources and findings, which he shares with decision makers at Oriel Pharmaceuticals when presenting his report on the marketing approach for a new drug. This practice will increase the ________ of Mason's report.
Credibility
Which statement about nervousness when developing presentations is true?
Experiencing some nervousness can heighten your ability to deliver forcefully
If you want to draw the audience's attention to you during your presentation, you should
Explain and elaborate on the content in your slides
What does "E" stand for in the SOFTEN model of nonverbal communication in presntations?
Eye contact
Katherine creates a survey that includes the following question: "With traffic accidents on Main Street at an all-time high, do you believe that the city should reduce the speed limit to 35 miles per hour?" This question is non-leading.
False
Organizations can only use Faceook's Audience Insights to learn demographic information about people who have engaged with the organization by "liking" their page or attending an event hosted by an organization
False
The profiles you post on personal social media accounts will no affect your professional reputation, but your work related accounts will
False
Talia is creating a surgery on customer satisfaction. An appropriate question to include would be "Please describe your ideal customer service experience and tell us whether your experience with Sailboat Hospitality lived up to your expectations
False Surveys should contain short questions and short response options.
The process of developing business messages involves the three steps: planning, writing, and distributing.
False it is plan, write, and review
Professionals with green motivational value systems a most attracted to action-oriented and results-oriented language and logic
False red motivational value system (MVSs). Professionals with green MVSs will appreciate your ability to provide and avoid rushing to judgement and conclusion
The total amount of money (principal + interest) that lender receives from a borrower at the end of the loan is referred to as the loan's
Future Value (FV)
The total amount of money (principal +interest) that the lender receives from a borrower at the end of the loan is referred to as the loan's
Future Value (FV)
The active cell in a spreasheet is the cell into which of the user can input data. In most spreasheet programs the active cell can be identified by which three items?
Heavy border Highlighted column and row heading Name box (in the upper left corner of the sheet)
When creating a blog , you should use naming, labeling, indexing, and tagging to
Help other find your information
In the context of the AIM planning process, what tends t be the single most important planning step for many messages?
Identifying reader benefits and constraints
In the context of dealing with business's problems, what should ideally be the first step?
Identifying the business problem
What is typically included i the writing stage of developing an effective business message?
Settling a positive and other-oriented tone
What action is most likely to lower a person's credibility?
Slanting facts
Programs such as Microsoft Excel, iWork's (APple) Numbers, Google Sheets, and OpenOffice Calculator, that allow users to arrange numerical data are called
Spreasheets
A well done preview helps the audience listen to the whole presnstion
True
Coma-separated format (.cvs) files are commonly used by those who are sending data but do not know what spreadsheet the recipient uses.
True
Currently, one of the biggest vectors opportunities for cybercriminals is MitMo
True
Employees should become familiar with their companies acceptable-use policies for social networking websites
True
Excellent business thinkers explore issues deeply to gather information from a variety of sources
True
Hacking into an organization's email servers is a crime that can be prosecuted under the Stored Communications Act.
True
Presentations put a spotlight on speakers, providing them with the opportunity to build credibility
True
When specifically want your presentation to appeal t professionals with a blue motivational value system, you should focus on
Using relationship centered terms. People with blue motivational value system will appreciate your ability to discuss business relationships- such as benefits to work teams and colleagues and loyalty to customers and clients. They will connect through the use of "we" language ad other relationship-centered terms.
Select three true statements regarding labels
Usually a text or text+number combination Can be created by typing an apostrophe in front of a number Remain on the left side of a cell when entered
The beginning of your presentation is critical because
audience members form quick impressions about you and your message during this time.
In content and form, a business message should typically
avoid any form of self-centeredness.
Sadie, the expeditor at RingGro Manufacturing, writes a memo asking her manager to buy her a new computerized system for tracking customer orders. She claims that if she does not get this system, chronically late deliveries will ensue. Her manager turns down her request. Sadie made the mistake of using
either/or logic.
What is typically included in the reviewing stage of writing an effective business message?
ensuring that the communication is fair
Company leaders often use the op-ed style on corperate blogs
true
You can usually better assess the usefulness of _____ than other secondary sources because of the many online review available.
Business books
What is the purpose of using color in spreadsheets?
Color makes data easier to read.
In addition to planning, analysis, and mitigation, select the remaining two categories of the respond (RS) function of the NIST Cybersecurity Framework from the list below.
Communication Improvements to cybersecurity response plans
What has the greatest influence on the impact of social media in the work place?
Cultural norms and values
When using a shared file Alford, it is important to
Discuss protocols for co editing files
The higher the knowledge level of your listeners, the more presentation time you should spend providing details.
False
When developing a business presentation, that last step is the planning process should be to gain. Deeper understanding of the needs of the audience
False. It is one of the FIRST tasks
Due to the many communication tools available to the emerging Social Age, the division between professional ad private lives is becoming increasingly clear
False. The division between professional and private lives becoming increasingly blurred
Select the two spreadsheet programs.*******
Microsoft excel and google sheets *******
In order to make business messages more positive, business writers should focus on actions they can accomplish and demonstrate a realistic optimism. However they should be careful
Not to set unrealistic expectations
Natalie, assistant manager at Bright Gardens restaurant, is preparing a questionnaire to help her evaluate sustainer satisfaction. She wants her survey to only include closed questions. Which type 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.
Because Janet's-manager has a hub of motivational value system, she should focus on on using language that is
Option oriented
Select two methods of selecting range of adjoining cells in Excel.
Select the first cell in the range and drag down to the last cell. Select the first cell in the range then hold down the shift key and select the last cell in the range.
Sports analysts often use ____ to keep track of statistics, times, and scores of nearly every porting event.
Spredsheets
What is the purpose of saving an Excel file as a .cvs (comma-sepperated format) file?
To share data with the other spreadsheet users regardless of which spreadsheet program is being used
Barbara is looking for concise, easy to understand research on ways to motivate employees at her workplace. Which research source is least likely to provide the kinds of information she needs?
scholarly articles
Which term is used to encompass the analysis of data collected by others with no direction from you or members of your organization?
secondary research
Posting about excessive weekend partying on twitter can damage a person's chances at getting a good job.
true
What action makes a chart ineffective?
using a nondescriptive chart title
The costs of borrowing money, quoted as an annual percentage rate (APR), is a loan's
Interest
Which statement accurately describes the need to keep sensitive data, information, and systems confidential?
It is both a major goal and a requirement for cybersecurity.
Which is the best definition of cybersecurity exploit?
It is the means by which a hacker capitalizes on a cybersecurity vulnerability to do harm.
The General Data Protection Regulation (GDPR) regulates how companies collect and protect consumer data
True
The most important stage of creating effective business messages is planing
True
In order to be effective, a consumer survey should contain
exhaustive answer choices for each question.
which statement about online presence is true?
A personal brand built through an online presence can help business professionals gain opportunities.
The bar chart, due to its limited forms, is less versatile than the one chart or the line chart.
False
A question that is designed to gain a preferred response from the surveys designer's perspective
Leading
Anaylizing a business problem typically involves
Making conclusions based on facts
Ariel notices that her team's online discussion forum has become contentious. Which guideline should she following this situation?
Meet in real time
Why are rob able loss calculations important?
Organizations have limited funds to use toward system protectione
Which statement about pie charts is true?
Pie slices should complete a whole, that is, add up to 100% of a data series.
An indirect approach is often effective for delivering bad news.
True
Nate's boss has asked him to present a business report on "Consumer shopping habits" in three days. Due to the time constraint , his boss wants him to use secondary research. In this situation, what should Nathan do?
Use data published in business journals
Wanda, the marketing manager at Royal Theatres, believes that employees should always act ethically and should also report instances of unethical behavior that they encounter. This belief held by Wanda is an example of a
Value
In Apple iWork's Numbers freeze options are located under the Table tab. In Microsoft Excel and Google sheets the freeze call or panes options are found in the _____ menu.
View
Your coworker Kennedy has to give a presentation to a group of managers and he is feeling nervous. Which tip would be the best advice you could give him?
Visualize yourself speaking with confidence and ease
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.
A ransomware attack involves a multi step process of file encryption, making demands of the target untraceable payment, and possible file decryption.
True
According to the National Institute of Standards Technology (NIST), the RS function of the framework includes communications with internal and external stakeholders
True
From the following list, select all the examples of different cybersecurity breaches
Viruses, spyware, impersonation, Distributed Denial of Service (DDOS)
To determine how much a recurring monthly payment would be for a car loan or a mortgage, use the _______ function.
PMT
When money is borrowed, the ______ value of the loan (the principal) is the initial amount of money borrowed
Present
Bankers and other lenders refer to the initial amount of the loan (the principal) as the loan's
Present value (PV)
To insert a column to the left of Column D in an OpenOffice Calculator file, select Column D and then ______ and select Insert.
Right-click
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.
Which technique is most likely to make business messages more positive?
using constructive terms
In Google sheets, what are the two methods that allow a user to move data from one cell to another?
Drag the data to the desired cell when the cursor changes to a drag hand Right-click the ell then cut and paste the date into a desired cell
In financial institutions, the color red represents positive values
False
Readers will respond better to a business message that has an objective , impersonal tone.
False
