Line chart - ️️Chart type that shows trends over time in which the value axis
indicates quantities and the horizontal axis indicates quantities and the horizontal axis
indicates time.
Increase the left and right margins. - ️️Assume that the data on a worksheet
consume a whole printed pa...
ISM 110 FINAL EXAM UNCG
Line chart - ✔️✔️Chart type that shows trends over time in which the value axis
indicates quantities and the horizontal axis indicates quantities and the horizontal axis
indicates time.
Increase the left and right margins. - ✔️✔️Assume that the data on a worksheet
consume a whole printed page and a couple of columns on a second page. You can do
all of the following except what to force the data to print all on one page?
Worksheet - ✔️✔️A spreadsheet that contains formulas, functions, values, text and
visual aids.
Workbook - ✔️✔️A file containing related worksheets.
Input area - ✔️✔️A range of cells containing values for variables used in formulas.
Output area - ✔️✔️A range of cells containing results based on manipulating the
variables.
Name box - ✔️✔️Identifies the address of the current cell.
Formula bar - ✔️✔️Displays the content (text, value, date, or formula) in the active cell.
Cell - ✔️✔️The intersection of a column and row.
Text - ✔️✔️Includes letters, numbers, symbols and spaces.
Value - ✔️✔️A number that represents a quantity or an amount.
Order of precedence - ✔️✔️Rules that control the sequence in which Excel performs
arithmetic operations.
Autofill - ✔️✔️Enables you to copy the contents of a cell or cell range or to continue a
sequence by dragging the fill handle over an adjacent cell or range of cells.
Fill handle - ✔️✔️A small green square at the bottom-right corner of a cell.
Column width - ✔️✔️The horizontal measurement of a column.
Row height - ✔️✔️The vertical measurement of a row.
Range - ✔️✔️A rectangular group of cells.
, Alignment - ✔️✔️The position of data between the cell margins.
Wrap Text - ✔️✔️Formatting that enables a label to appear on multiple lines within the
current cell.
Fill - ✔️✔️The background color appearing behind data in a cell.
Formula - ✔️✔️A combination of cell references, operators, values, and/or functions
used to perform a calculation.
State the purpose of the worksheet. - ✔️✔️What is the first step in planning an effective
worksheet?
Name box - ✔️✔️What Excel interface item displays the address of the current cell?
14 - ✔️✔️Given the formula =B1*B2+B3/B4^2 where B1 contains 3, B2 contains 4, B3
contains 32, and B4 contains 4, what is the result?
To display cell formulas - ✔️✔️Why would you press Ctrl+` in Excel?
A1:A10, D1:D10 - ✔️✔️Which of the following is a nonadjacent range?
Merge and center the data over all columns. - ✔️✔️If you want to balance a title over
several columns, what do you do?
Dollar sign immediately on the left side of the value. - ✔️✔️Which of the following
characteristics is not applicable to the Accounting Number Format?
Click the Paste arrow in the Clipboard group and select Values & Source Formatting. -
✔️✔️You selected and copied worksheet data containing formulas. However, you want
the pasted copy to contain the current formula results rather than formulas. What do you
do?
Increase column width. - ✔️✔️What should you do if you see a column of pound signs
(###) instead of values or results of formulas?
Syntax - ✔️✔️A set of rules that governs the structure and components for properly
entering a function.
TODAY function - ✔️✔️Displays the current date.
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 PatrickKaylian. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $8.39. You're not tied to anything after your purchase.