Exam (elaborations)
ITE 140 Chapter 7 Multiple Question (1).
- Course
- Institution
ITE 140 Chapter 7 Multiple Question (1).
[Show more]
Seller
Follow
scholartutor
Content preview
ITE 140 Chapter 7 Multiple Question________ cells contain formulas that refer to other cells. - CORRECT
ANSWER-Dependent
________ cells are referred to by a formula in another cell. - CORRECT
ANSWER-Precedent
________ functions search for a value in a defined range of cells located in another
part of the workbook to find a corresponding value. - CORRECT ANSWER-Lookup
________ is a method to find a specific value for a cell by adjusting the value of one
other cell. - CORRECT ANSWER-Goal Seek
________ is the process of examining a worksheet for errors in formulas. -
CORRECT ANSWER-Auditing
A(n) ________ triangle in the upper left corner of a cell indicates that the formula in
the cell is suspect for some reason and could be a potential error. - CORRECT
ANSWER-green
A command that displays arrows to indicate what cells affect the value of the cell that
is selected is the ________ command. - CORRECT ANSWER-Trace Precedents
A data table is useful for all of the following except ________. - CORRECT
ANSWER-determining the Future value (Fv)
A defined name provides a logical reference to ________. - CORRECT
ANSWER-data
A range of cells that shows how changing certain values in your formula affects the
results of those formulas is a(n) ________. - CORRECT ANSWER-data table
A technique to improve accuracy when entering data in a worksheet by controlling
the type of data or the values that can be entered is called ________. - CORRECT
ANSWER-data validation
A word or string of characters in Excel that represents a cell, a range of cells, a
formula, or a constant value is called a ________. - CORRECT ANSWER-defined
name
All of the following are methods to define a name for a cell or group of cells except
________. - CORRECT ANSWER-select the range, click in the Formula Bar, and
then type the name
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 scholartutor. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
53022 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now