IS 2200 Final
Unfortunately, Excel does not offer a division function or shortcut. To divide two cell values, use the ___ symbol.
/
If you type = 3 + 12 * 6 into a cell in a spreadsheet and then press Enter, what will appear in the cell?
75
You are tired of paying rent but the cost of a house keeps increasing. At this time last year the average price was $280,000 and now it is $325,000. Which of the following spreadsheet formulas correctly calculates the percentage change?
= ((325,000 - 280,000) / 280,000) * 100
A friend asks if you want to go see the new Marvel movie but you say it is too expensive. "No it is 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
= (10 - 8) / 8 * 100
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.
Which of the following entries would subtract the value in cell F3 from the value in cell D6?
=SUM(D6,-F3)
When entering data into a cell in Excel, to add a line break within a cell, type
ALT + ENTER.
What does the formula =SUM(C4,D5) mean in plain language?
Add the values in cell C4 and cell D5.
Which statement describes how writers should address the priorities of their targeted audience during the AIM planning process?
Assign importance to things, such as projects, goals, and tasks.
Which person illustrates a characteristic of an excellent business thinker?
Barras uses a variety of sources such as journal articles and colleagues' expertise.
To remove and replace unwanted characters from an Excel spreadsheet, you will probably want to open the Find & Select menu. This is found in the Editing group on the ___ tab.
Home
Use the AutoSUM function if you want to quickly __ a series of values in a spreadsheet.
add
If you want to make a numerical entry in Excel that will not interact with another cell, you can make it a label rather than a value. One way to turn a number into a label is to place ___ in front of the number when you enter it into the spreadsheet.
an apostrophe (')
Clicking ENTER moves the active cell to the one ___ the cell in which the data was entered.
below
The basic unit of any spreadsheet, essentially a box where data can be entered, is called a(n)
cell.
A vertical line of cells in Excel is referred to as a
column.
To remove the content from one cell and move the content to another cell, one way is to right click on the origination cell (to open the context menu) and click
cut
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.
If you wish to view or manipulate your Excel spreadsheet when you are offline you will need to load it onto your computer. Taking a file from the Internet and saving onto your computer's hard drive is called
downloading.
Taking a file from the cloud and saving it to your hard drive is called
downloading.
What is typically included in the reviewing stage of writing an effective business message?
ensuring that the communication is fair
Anything placed into an Excel spreadsheet falls into one of four categories. These four data types are Numbers, Text, Logic functions, and
error announcements.
Extensive use of the I-voice in a business message
fails to focus on the interests of the audience.
To remove and replace characters in Excel, one option is to use Find & Select menu. This menu is indicated by a(n) ___ icon.
magnifying glass
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.
To select an entire row in Excel, click on the corresponding
number.
By default, in Excel a cell reference is a(n) ___ reference.
relative
What is a goal of the AIM planning process?
to unleash good ideas
Howard, a manager at ABN, has to prepare a report about the advantages of introducing a counseling program for employees in his company. In his report, he makes the claim that introducing a counseling program would reduce voluntary turnover because employees would be happier with their pay packages, but he offers no evidence linking counseling with pay. This report failed to effectively deliver the message that Howard had intended. What is the most likely reason for its failure?
unsupported generalization
Which technique is most likely to make business messages more positive?
using constructive terms
By default, when you enter a number into a cell in Excel it jumps to the right of the cell. This tells you that Excel recognizes the entry as a(n)
value.
Enduring beliefs and ideals that individuals hold are called
values.
Entries that Excel recognizes as being able to interact with other cells are referred to as
values.
A meta message is
what people take away from a communication.
If you send a Google Sheets file to another user and you're not sure which spreadsheet program they use, it's often best to choose the ___ format.
.csv
If the number 6 is in cell C4, and the number 5 is in cell D5, then the formula: =SUM(C4,D5) would result in
11
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.
When cleaning your data it is often handy to remove any duplicates. One way to do this is to use the Remove Duplicates dialogue box. Remove Duplicates can be found in the Data Tools group in the ___ tab.
Data
CTRL + Minus (+) is the shortcut for deleting a row or column in Excel. Using the menu, to delete a row, select the row below where you want to add a row, the click Home>Cells>___.
Delete.
Because it indicates the beginning of a function or a formula, you can argue that the most important symbol in Excel is the ___ sign.
Equal (=)
For any formula or function in Excel, there should first be a(n) ___ sign in the cell.
Equal (=)
In Excel, as with all Office products, Print options are found under the ___ tab.
File
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
Most users then use the shortcut, CTRL + F to open the Find and Replace dialog box. Alternatively, you could click Find in the dialog box in the editing group, that is located on the ___ tab.
Home
The MIN function displays the largest value in a selected range. A shortcut to the MIN function is located in the AutoSUM dropdown menu found in the Editing group of 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
Ali is the marketing manager at QLM. In his market survey, he finds that customers are not happy with QLM's inefficient customer service. How will Ali structure his message if he wants to use the inductive, or indirect, approach?
Lay out the supporting reasons in careful order; state the primary message.
To display the highest value in a range quickly, use the __ function.
MAX
To display the smallest value in a selected range quickly, you could use the ___ function.
MIN
Choosing an appropriate theme for your spreadsheet can help to highlight the data. To find a good theme, click on the Themes group that is found in the __ tab.
Page Layout
When optimizing your spreadsheet for printing, you can select which data is shown at the top of each page by using
Page breaks.
When printing a large spreadsheet, you probably will want to show the column and row headings on each sheet of paper. This is done by adding
Print Titles.
___ clicking the row or column heading and then selecting Hide will hide the row or column.
Right
When removing and replacing unwanted characters from an Excel spreadsheet, you might use the Find & ___ menu, found in the Editing group on the Home tab.
Select
To enter data into a cell and then immediately go to the cell to the right, press the ___ key.
TAB
What do the deductive approach and inductive approach to structuring business messages have in common?
The arrangement of supporting ideas is important.
________ is the overall evaluation that a reader perceives the writer to have toward the reader and the message content.
Tone
In Excel, the freeze cells or panes option is located in Windows group of the __ tab.
View
If the computer you are using does not have Excel and you do not have a access to Microsoft 365, then you can download Microsoft's Excel ___ program.
Viewer
Rafi's company is having trouble recruiting employees with the right skills. He needs to choose someone to analyze the problem and suggest potential solutions. Which employee should he choose?
Wade has a knack for explaining complex issues in a clear, understandable way.
Placing your cursor between row headings so that you see the double-arrow row-adjusting pointer and then dragging allows you to adjust the height of the row ___ your pointer.
above
In Excel, the cell that a user has selected is referred to as the ___ cell.
active
In Microsoft Excel, a name box (located to the left of the formula bar) shows the ___ cell.
active
In content and form, a business message should typically
avoid any form of self-centeredness.
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.
Facts are statements that
can be relied on with a fair amount of certainty.
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
In the context of the AIM planning process, what tends to be the single most important planning step for many messages?
identifying reader benefits and constraints
In the context of dealing with business problems, what should ideally be the first step?
identifying the business problem
One way to move data from one cell to another in Excel is to ___ to open the context menu and then select cut, and then move to the desired cell and select paste.
right-click on the cell
A ___ is a horizontal line of cells in Excel (or any other spreadsheet program).
row
What is typically included in the writing stage of developing an effective business message?
setting a positive and other-oriented tone
What is something an excellent business writer would do?
spend more time planning than writing
In a business message, the function of a call to action is to
state explicitly what you want the audience to do.
If you enter a formula, and Excel returns an error value of #VALUE!, this means that
the operation or function is not possible.
If you enter a formula in a cell and Excel returns a series of hashmark symbols (####), this means that
this is not an error value. It simply indicates that the cell's visible width cannot display the result.
To save an iCloud Numbers file as an Excel file, you will need to click the View Numbers Tools icon at the top right of the screen. This icon is a circle with
three dots.
What should be one of the primary goals of a business communicator?
to express the message in ways that inspire others
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 = 2 + 3 * 6 into a cell in a spreadsheet and then press Enter, what will appear in the cell?
20
Every time you go to the gas station you are amazed by 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
= ((4.25 - 3.20) / 3.20) * 100
When downloading an Apple iCloud Numbers file, some Excel users prefer to download the file in the ___ format to avoid formatting issues.
CSV
In addition to opening Excel (.xlsx) files, Microsoft Excel Viewer can open ___ files.
Comma Separated Values (.csv)
To avoid potential formatting issues, many Excel users choose to save or send spreadsheet files in the ___ format.
Comma-Separated Values (.csv)
In the formula =IF(C1>5,"Yes","No"), what does it mean in plain language?
If the number in cell C1 is greater than 5, then type "Yes," if not type "No."
To break out of the reputation of an inexperienced newcomer, a person should
attend a lot of meetings to get to know as many colleagues as possible.
To select nonadjoining cells in a spreadsheet, hold down the __ key while selecting cells.
control (Ctrl)
Jaeger, the shipping manager at Durable Wear, writes a memo proposing that that they stop using RoadDog Trucking Company and ship everything by L.B. Haines. The reason he gives is that two of the accounts that have been shipping by L.B. Haines during the last year increased their orders by more than 10%, so he is certain that switching trucking firms will cause other accounts to grow too. The executives of the company do not accept Jaeger's suggestion. Why was his memo unconvincing?
faulty cause/effect argument
What is typically included in the planning stage of writing an effective business message?
identifying the primary message and key points
The difference between the deductive approach and the inductive approach is
in the inductive approach, the supporting reasons are placed before the primary message.
By default, when a number is entered into a cell, it becomes a value that interacts with formulas or values. To keep the number from interacting, type an apostrophe in front so that it becomes a(n)
label.
Placing your cursor between column headings so that you see the double-arrow column-adjusting pointer and then dragging allows you to adjust the width of the column to the ___ of your pointer.
left
Cell references can be relative, absolute or mixed. Imagine that you have a cell with a date in it. If when you copy the cell using the fill handle, the date changes, then you know that the cell is a ___ reference.
relative
Naming a range of cells is useful when creating a VLookup. To name a range of cells in Excel, select the range by dragging, then __-click and select Define Name... from the menu.
right
One way to adjust the width of a column quickly in Excel is to place your cursor to the ___ of the column heading and just drag.
right side
One way to name a range of cells is to ___ the range and select the naming option.
right-click
To delete a row in Excel, click on any cell in the row and SHIFT + Spacebar to select the row, then CTRL + Minus (−) to delete it. Alternatively, simply ___ on the row heading and select Delete from the context menu.
right-click
To move a column or row in Excel, you can simply access the context menu. In Excel, as in most Office products, just __ on the header.
right-click
When you're using Excel, to hide column D, first click on the column heading to select the column, and then ___ to open the menu and select Hide.
right-click
