Of the measures of feasibility in the accompanying figure, ____ considers points such as "Does the proposed platform have sufficient capacity for future needs?" and "Will the hardware and software environment be reliable?"

Of the measures of feasibility in the accompanying figure, ____ considers points such as "Does the proposed platform have sufficient capacity for future...

Of the measures of feasibility in the accompanying figure, ____ considers questions such as "Does management support the project?" and "Will the new system require training for users?"

Of the measures of feasibility in the accompanying figure, ____ considers questions such as "Does management support the project?" and "Will the new...

When setting priorities for systems requests, the highest priority goes to projects that provide the ____.

When setting priorities for systems requests, the highest priority goes to projects that provide the ____. a. least benefit, at the highest cost,...

An example of a tangible benefit includes a(n) ____.

An example of a tangible benefit includes a(n) ____. a. user-friendly system that improves employee job satisfaction b. sales tracking system that...

A(n) ____ is an example of an intangible benefit.

A(n) ____ is an example of an intangible benefit. a. user-friendly system that improves employee job satisfaction b. new scheduling system that reduces...

A feasibility study includes tests for ____ feasibility, which means that the projected benefits of the proposed system outweigh the estimated costs.

A feasibility study includes tests for ____ feasibility, which means that the projected benefits of the proposed system outweigh the estimated costs. a....

The estimated costs of a proposed system usually are considered the ____, which includes ongoing support and maintenance costs, as well as acquisition costs.

The estimated costs of a proposed system usually are considered the ____, which includes ongoing support and maintenance costs, as well as acquisition...

A feasibility study includes tests for ____ feasibility, which refers to the practical resources needed to develop, purchase, install, or operate the system.

A feasibility study includes tests for ____ feasibility, which refers to the practical resources needed to develop, purchase, install, or operate the...

A feasibility study includes tests for ____ feasibility, which means that a proposed system will be used effectively after it has been developed.

A feasibility study includes tests for ____ feasibility, which means that a proposed system will be used effectively after it has been developed. a....

When evaluating systems requests, which of the following is an advantage of a systems review committee ____.

When evaluating systems requests, which of the following is an advantage of a systems review committee ____. a. action on requests must wait until...

IT Departments today ____ .

IT Departments today ____ . a. only consult users if they want input b. handle all aspects of systems development c. are not closely linked to management d....

A systems request form should ____.

A systems request form should ____. a. have clear instructions b. be difficult to understand c. not include enough space for all required information d....

Many companies implement ____ systems that integrate all customer-related events and transactions.

Many companies implement ____ systems that integrate all customer-related events and transactions. a. CRM b. TCO c. JIT d. RFID Answer: ...

Electronic data interchange (EDI) enables ____ inventory systems, which rely on computer-to-computer data exchange to minimize unnecessary inventory.

Electronic data interchange (EDI) enables ____ inventory systems, which rely on computer-to-computer data exchange to minimize unnecessary inventory. a....

____ components can provide automated response to sales inquiries, Web-based order processing, and online inventory tracking.

____ components can provide automated response to sales inquiries, Web-based order processing, and online inventory tracking. a. Mission statement b....

Hardware-based security controls include ____.

Hardware-based security controls include ____. a. passwords b. various levels of user access c. coding data d. none of the above Answer: ...

____ limitations result when a system that was designed for a specific hardware configuration becomes obsolete when new hardware is introduced.

____ limitations result when a system that was designed for a specific hardware configuration becomes obsolete when new hardware is introduced. a....

Strategic planning starts with a ____ that reflects the firm's vision, purpose, and values.

Strategic planning starts with a ____ that reflects the firm's vision, purpose, and values. a. Relationship Diagram b. Feasibility Study c. Performance...

During strategic planning, top managers ask a series of questions that is called a ____ analysis because it examines a company's strengths, weaknesses, opportunities, and threats.

During strategic planning, top managers ask a series of questions that is called a ____ analysis because it examines a company's strengths, weaknesses,...

____ planning is the process of identifying long-term organizational goals, strategies, and resources.

____ planning is the process of identifying long-term organizational goals, strategies, and resources. a. Opportunity b. Preliminary c. Strategic d....

Systems development typically starts with a ____.

Systems development typically starts with a ____. a. feasibility study, followed by a systems request, which includes a preliminary investigation b....

A(n) ____ investigates, analyzes, designs, develops, installs, evaluates, and maintains a company's information systems.

A(n) ____ investigates, analyzes, designs, develops, installs, evaluates, and maintains a company's information systems. a. application developer b....

____ provides vital protection and maintenance services for system software and hardware, including enterprise computing systems, networks, transaction processing systems, and corporate IT infrastructure.

____ provides vital protection and maintenance services for system software and hardware, including enterprise computing systems, networks, transaction...

The ____ group typically provides leadership and overall guidance, but the systems themselves are developed by teams consisting of users, managers, and IT staff members.

The ____ group typically provides leadership and overall guidance, but the systems themselves are developed by teams consisting of users, managers,...

The newest development techniques are called ____, which attempt to develop systems incrementally.

The newest development techniques are called ____, which attempt to develop systems incrementally. a. structured methods b. object-oriented methods c....

Agile methods typically use a(n) ____model, which represents a series of iterations based on user feedback.

Agile methods typically use a(n) ____model, which represents a series of iterations based on user feedback. a. gradual b. extreme c. spiral d. ev...

In object-oriented design, built-in processes called ____ can change an object's properties.

In object-oriented design, built-in processes called ____ can change an object's properties. a. methods b. functions c. attributes d. features ...

In object-oriented analysis, an object is a member of a(n) ____, which is a collection of similar objects.

In object-oriented analysis, an object is a member of a(n) ____, which is a collection of similar objects. a. property b. class c. message d. ins...

Whereas structured analysis treats processes and data as separate components, ____ combines data and the processes that act on the data into things called objects.

Whereas structured analysis treats processes and data as separate components, ____ combines data and the processes that act on the data into things...

In the model of the SDLC shown in the accompanying figure, during the ____, the IT staff maintains, enhances, and protects the system.

In the model of the SDLC shown in the accompanying figure, during the ____, the IT staff maintains, enhances, and protects the system. a. systems...

In the model of the SDLC shown in the accompanying figure, during the ____, the new system is constructed.

In the model of the SDLC shown in the accompanying figure, during the ____, the new system is constructed. a. systems planning phase b. systems support...

In the model of the SDLC shown in the accompanying figure, the purpose of the ____ is to create a physical model that will satisfy all documented requirements for the system.

In the model of the SDLC shown in the accompanying figure, the purpose of the ____ is to create a physical model that will satisfy all documented requirements...

In the model of the SDLC shown in the accompanying figure, the purpose of the ____ is to build a logical model of the new system.

In the model of the SDLC shown in the accompanying figure, the purpose of the ____ is to build a logical model of the new system. a. systems analysis...

In the model of the SDLC shown in the accompanying figure, the ____ usually begins with a formal request to the IT department, called a systems request, which describes problems or desired changes in an information system or a business process.

In the model of the SDLC shown in the accompanying figure, the ____ usually begins with a formal request to the IT department, called a systems request,...

In the __swirly picture__, like that shown in the accompanying figure, the result of each phase, which is called a deliverable or end product, flows sequentially into the next phase in the SDLC.

In the __swirly picture__, like that shown in the accompanying figure, the result of each phase, which is called a deliverable or end product, flows...

Because it focuses on processes that transform data into useful information, structured analysis is called a(n) ____ technique.

Because it focuses on processes that transform data into useful information, structured analysis is called a(n) ____ technique. a. iterative b. process-centered c....

Structured analysis is a traditional systems development technique that uses a series of phases, called the ____, to plan, analyze, design, implement, and support an information system.

Structured analysis is a traditional systems development technique that uses a series of phases, called the ____, to plan, analyze, design, implement,...

The ____ method of developing systems stresses team interaction and reflects a set of community-based values.

The ____ method of developing systems stresses team interaction and reflects a set of community-based values. a. object-oriented analysis b. agile/adaptive c....

The ____ method of developing systems produces code that is modular and reusable.

The ____ method of developing systems produces code that is modular and reusable. a. object-oriented analysis b. adaptive c. structured analysis d....

The ____ method of developing systems is well-suited to project management tools and techniques.

The ____ method of developing systems is well-suited to project management tools and techniques. a. object-oriented analysis b. adaptive c. structured...

____ methods include the latest trends in software development.

____ methods include the latest trends in software development. a. Object-oriented analysis b. Agile/Adaptive c. Structured analysis d. Rapid application...

____ is a systems development technique that tests system concepts and provides an opportunity to examine input, output, and user interfaces before final decisions are made.

____ is a systems development technique that tests system concepts and provides an opportunity to examine input, output, and user interfaces before...

____ is a systems development technique that produces a graphical representation of a concept or process that systems developers can analyze, test, and modify.

____ is a systems development technique that produces a graphical representation of a concept or process that systems developers can analyze, test,...

A(n) ____ shows the data that flows in and out of system processes.

A(n) ____ shows the data that flows in and out of system processes. a. process model b. object model c. business model d. network model Answer:...

A ____, or requirements model, describes the information that a system must provide.

A ____, or requirements model, describes the information that a system must provide. a. process model b. data model c. business model d. network ...

In a typical company organizational model, middle managers ____.

In a typical company organizational model, middle managers ____. a. develop long-range plans, called strategic plans, which define the company's overall...

In a typical company organizational model, top managers ____.

In a typical company organizational model, top managers ____. a. develop long-range plans, called strategic plans, which define the company's overall...

User productivity systems ____.

User productivity systems ____. a. provide job-related information to users at all levels of a company b. simulate human reasoning by combining a...

Knowledge management systems use a large database called a(n) ____ that allows users to find information by entering keywords or questions in normal English phrases.

Knowledge management systems use a large database called a(n) ____ that allows users to find information by entering keywords or questions in normal...

Business support systems ____.

Business support systems ____. a. provide job-related information support to users at all levels of a company b. simulate human reasoning by combining...

Transaction processing (TP) systems ____.

Transaction processing (TP) systems ____. a. provide job-related information to users at all levels of a company b. simulate human reasoning by combining...

___ enabled computer-to-computer transfer of data between companies, usually over private telecommunications networks.

___ enabled computer-to-computer transfer of data between companies, usually over private telecommunications networks. a. EDI b. ACH c. TCH d. O-...

Which of the following is one of the main sectors of e-commerce?

Which of the following is one of the main sectors of e-commerce? a. C2C b. B2C c. C2B d. BBC Answer: ...

A business ____ is an overview that describes a company's overall functions, processes, organization, products, services, customers, suppliers, competitors, constraints, and future direction.

A business ____ is an overview that describes a company's overall functions, processes, organization, products, services, customers, suppliers, competitors,...

Systems analysts use a ____ to graphically represent company operations and information needs.

Systems analysts use a ____ to graphically represent company operations and information needs. a. JAD b. Scrum c. RAD d. business process model ...

For complex operations, analysts apply computer-based modeling tools that use a standard language called ____.

For complex operations, analysts apply computer-based modeling tools that use a standard language called ____. a. electronic data interchange (EDI) b....

When planning an information system, a company must consider how a new system will interface with older systems, which are called ____.

When planning an information system, a company must consider how a new system will interface with older systems, which are called ____. a. enterprise...

Over 40 years ago, a concept called Moore's Law accurately predicted that computer processing power would double about every ____.

Over 40 years ago, a concept called Moore's Law accurately predicted that computer processing power would double about every ____. a. 2 months b....

Examples of company-wide applications, called ____, include order processing systems, payroll systems, and company communications networks.

Examples of company-wide applications, called ____, include order processing systems, payroll systems, and company communications networks. a. enterprise...

____ software controls the flow of data, provides data security, and manages network operations.

____ software controls the flow of data, provides data security, and manages network operations. a. Enterprise b. System c. Application d. Legacy...

____ refers to the combination of hardware, software, and services that people use to manage, communicate, and share information.

____ refers to the combination of hardware, software, and services that people use to manage, communicate, and share information. a. Information systems b....

Having finished your project, what if anything do you consider to be a gap in your team's research that, if addressed, would make you feel more confident about your conclusion?

Having finished your project, what if anything do you consider to be a gap in your team's research that, if addressed, would make you feel more confident...

What was the strongest counter-argument to the solution or conclusion your team identified and why?

What was the strongest counter-argument to the solution or conclusion your team identified and why? Answer: robots would take over the workforce...

What is an example of a compelling argument from one of your peer's individual reports that you decided to exclude from your team presentation and why?

What is an example of a compelling argument from one of your peer's individual reports that you decided to exclude from your team presentation and why? Answer: (ONLY...

What is an example of a compelling argument from one of your peer's individual reports that you decided to exclude from your team presentation and why?

What is an example of a compelling argument from one of your peer's individual reports that you decided to exclude from your team presentation and why? Answer: (DOESNT...

In what way did you improve your ability to work with a group as a result of this project?

In what way did you improve your ability to work with a group as a result of this project? Answer: learn to accept diversity of opinions respectful...

Reflecting on your colleagues' work, which one had the greatest impact on your overall understanding of the problem your group identified?

Reflecting on your colleagues' work, which one had the greatest impact on your overall understanding of the problem your group identified? Answer: (ONLY...

Reflecting on your colleagues' work, which one had the greatest impact on your overall understanding of the problem your group identified?

Reflecting on your colleagues' work, which one had the greatest impact on your overall understanding of the problem your group identified? Answer: Brianna's...

In the future, what change would you make to your group norms, and how would you expect that to improve the team presentation?

In the future, what change would you make to your group norms, and how would you expect that to improve the team presentation? Answer: met up...

How did the group decide to include Kayla's perspective/lens/conclusions into the overall presentation?

How did the group decide to include Kayla's perspective/lens/conclusions into the overall presentation? Answer: We didn't include because we...

How did the group decide to include Ariel's perspective/lens/conclusions into the overall presentation?

How did the group decide to include Ariel's perspective/lens/conclusions into the overall presentation? Answer: -Robots are far more attractive to...

How did the group decide to include Brianna's perspective/lens/conclusions into the overall presentation?

How did the group decide to include Brianna's perspective/lens/conclusions into the overall presentation? Answer: -How AI will be used in the military....

How did the group decide to include Jack's perspective/lens/conclusions into the overall presentation?

How did the group decide to include Jack's perspective/lens/conclusions into the overall presentation? Answer: Decrease Danger risk in jobs because...

How did the group decide to include Aaliya's perspective/lens/conclusions into the overall presentation?

How did the group decide to include Aaliya's perspective/lens/conclusions into the overall presentation? Answer: Mental instability in labor-intensive...

Describe how the content of the team presentation was changed as a result of group discussion.

Describe how the content of the team presentation was changed as a result of group discussion. Answer: daily lives -> too broad -> used why...

Which is NOT true?

Which is NOT true? A) Frank is an artificial intelligence marketing platform that requires little human input. B) Tools like Hunch check analytics...

Which is NOT True?

Which is NOT True? A) AI can build new websites from the ground up B) AI algorithms can help companies to find new channels that competitors may not...

What is the name of an artificial intelligence application for marketing in use today?

What is the name of an artificial intelligence application for marketing in use today? A) Fred B) Alice C) Albert D) Francis Answer: C, al...

Which algorithm does not used supervised learning?

Which algorithm does not used supervised learning? A) Classification B) Regression C) Decision tree D) Cluster analysis Answer: D, cluster...

Which of these refers to systems that are designated to work on specific tasks?

Which of these refers to systems that are designated to work on specific tasks? A) Assisted intelligence B) Applied intelligence C) General intelligence D)...

Which of these does swarm intelligence do?

Which of these does swarm intelligence do? A) Surveys B) Polls C) A and B D) None of the above Answer: D, none of the abov...

Which application of artificial intelligence allows systems to automatically learn and improve without being programmed to do so?

Which application of artificial intelligence allows systems to automatically learn and improve without being programmed to do so? A) Adaptive learning B)...

What are the two categories of Artificial Intelligence?

What are the two categories of Artificial Intelligence? A) Assisted and general B) Assisted and narrow C) Applied and general D) Applied and narrow Answer: C,...

What is the most used form of artificial intelligence?

What is the most used form of artificial intelligence? A) General AI B) Prototypical AI C) Applied AI D) Neurological AI Answer: C, applied...

What is the difference between machine learning and deep learning?

What is the difference between machine learning and deep learning? A) Deep learning is the same as machine learning B) Deep learning utilizes statistical...

Which of the following is a pseudoinstruction?

Which of the following is a pseudoinstruction? A. move B. add C. add D. lgb E. j F. blt G. addi Answer: A. move E....

What kind of sort involves successive exchanges of values in an array until they are in order?

What kind of sort involves successive exchanges of values in an array until they are in order?  A. Card sort B. Short sort C. Bucket sort D....

What does the following code do?

What does the following code do? lw $t0, 0($s0) lw $t1, 4($s0) sw $t0, 4($s0) sw $t1, 0($s0) A. Ensures proper order. B. Sorts a list of numbers C....

What is the input to the Java Virtual Machine

What is the input to the Java Virtual Machine A. .class files.0 B. assembly instructions C. Java source code D. Java bytecode E. Dynamically linked...

What is the output of a Java compiler

What is the output of a Java compiler A. A .class file. B. A .exe file. C. Java bytecode D. A .jar file.0 E. Dynamically linked libraries F. assembly...

Dynamically Linked Libraries (DLLs)

Dynamically Linked Libraries (DLLs) A. Are not linked until runtime. B. Were invented by IBM in the 1960s. C. Are assembled by the loader and loaded...

Which is not an advantage to using compiled libraries of commonly used code (e.g., a math library)?

Which is not an advantage to using compiled libraries of commonly used code (e.g., a math library)? A. It keeps the user from having to write complicated...

Which describes a symbol table?

Which describes a symbol table?  A. A table of all the special characters in the ASCII character set used in the source code. B. A table that...

An assembly instruction which is not executed in hardware but rather decomposed into a more verbose assembly-language construct by the assembler is called a

An assembly instruction which is not executed in hardware but rather decomposed into a more verbose assembly-language construct by the assembler is...

In the traditional scheme of compiling and running a program, what is the sequence of actions?

In the traditional scheme of compiling and running a program, what is the sequence of actions? A. Compile, assemble, link. B. Load, Link, Compile. C....

What best describes what a linker does?

What best describes what a linker does? A. Ensures instructions are on 4-byte boundaries. B. Checks the assembly code against the manufacturer's specification. C....

The MIPS instruction set does not include a "branch on less than" Why not?

The MIPS instruction set does not include a "branch on less than" Why not? A. It was originally designed into the circuitry, but a wiring error forced...

The branch instructions can jump plus or minus 32k instructions. What if we need to branch farther than that?

The branch instructions can jump plus or minus 32k instructions. What if we need to branch farther than that? A. Multiple branch instructions can...

The MIPS J instruction uses ______ addressing.

The MIPS J instruction uses ______ addressing. A. Shift right two bits B. Replace bottom 28 bits of PC C. Register D. PC-relative E. Add bottom 26...

The 16-bit immediate field of a conditional branch instruction can jump through what address range?

The 16-bit immediate field of a conditional branch instruction can jump through what address range? A. 0 to 256K bytes B. +-128K bytes C. +- 128K...

An addressing scheme where the target address is the sum of the program counter and a number specified in an instruction is

An addressing scheme where the target address is the sum of the program counter and a number specified in an instruction is A. Memory-relative addressing B....

How is immediate data handled in branch instructions

How is immediate data handled in branch instructions A. It is shifted left 2 after being sign extended and added to the program counter B. It replaces...

Which is not a type of MIPS instruction?

Which is not a type of MIPS instruction? A. J-type B. R-type C. I-type D. B-Type E. S-type Answer: D. B-Type E. S-ty...

The J instruction immediate field is _____ bits.

The J instruction immediate field is _____ bits. A. 15 B. 28 C. 26 D. 16 Answer: C. ...

The J-type instruction has an immediate field which is ____ bits long.

The J-type instruction has an immediate field which is ____ bits long. A. 25 plus a sign B. 26 C. 15 plus a sign D. 5 E. 16 F. 26 unsigned G. 6 Answer: B....

A branch instruction is a(n) ____ instruction.

A branch instruction is a(n) ____ instruction. A. I-type B. J-type C. B-Type D. P-Type E. R-type F. K-Type Answer: A. I-ty...

Loading a 32-bit value from immediate data into a MIPS register can be done with which instructions

Loading a 32-bit value from immediate data into a MIPS register can be done with which instructions A. lui, ori B. lui, slt C. mfhi, mflo D. l32 E....

The original mortgage loan was for $300,000 with a 5% APR for 30 years. You want to calculate the interest on the last monthly payment at the end of the 15th year. What value should be referenced for the per argument in the IPMT function? Hint: Number of payment periods in a year is 12.

The original mortgage loan was for $300,000 with a 5% APR for 30 years. You want to calculate the interest on the last monthly payment at the end of...

You workbook contains a list of artwork. Column B lists Sold Out if the piece is sold out, Available if it is still readily available, or Limited if only a few pieces are available. In the third column, you want to display TRUE if the art is not sold out. What function would produce the same results as =OR(B1="Available", B1="Limited")?

You workbook contains a list of artwork. Column B lists Sold Out if the piece is sold out, Available if it is still readily available, or Limited if...

The date 5/12/2018 is stored (in format MONTH/DAY/YEAR) in cell C1. What function should you use to extract just 12?

The date 5/12/2018 is stored (in format MONTH/DAY/YEAR) in cell C1. What function should you use to extract just 12? a. =YEAR(C1) b. =MONTH(C1) c....

Today's date (February 12, 2018) is stored in cell B1. The last day of the semester (May 4, 2018) is stored in cell B2. You want to know how many days until the end of the semester. Which function should you use?

Today's date (February 12, 2018) is stored in cell B1. The last day of the semester (May 4, 2018) is stored in cell B2. You want to know how many days...

When you are performing an advanced filter, where do you enter the rage for the dataset?

When you are performing an advanced filter, where do you enter the rage for the dataset?  A. Output range B. List range C. Criteria range D. Copy...

A local police office wants to create a rule that if an officer pulls over a person for exceeding the speed limit by at least five miles per hour or if that person has two or more speeding violations on record, the officer will fine the speeder the higher of $200 or $50 for each mile over the speed limit. Otherwise, the fine is $45. The speed limit is entered in cell B5, the person's speed is entered in cell B10, and the person's number of previous tickets is entered in cell B11. What function derives the correct answer?

A local police office wants to create a rule that if an officer pulls over a person for exceeding the speed limit by at least five miles per hour or...

What function would you use to calculate the total (i.e., cumulative) interest paid for the first year of a mortgage?

What function would you use to calculate the total (i.e., cumulative) interest paid for the first year of a mortgage? a. CUMIPMT b. IPMT c. CUMPRINC d....

A worksheet contains the times in which runners completed a race, with the times organized from fastest to slowest. You will use the MATCH function to identify what place a runner came in given a time of 4:05 (four minutes and five seconds). Which argument should contain the specific runner's time?

A worksheet contains the times in which runners completed a race, with the times organized from fastest to slowest. You will use the MATCH function...

What function would you use to calculate the total number of periods in a loan or investment?

What function would you use to calculate the total number of periods in a loan or investment? A. FV B. PV C. NPER D. RATE Answer: C. NPE...

A workbook contains a list of members in the Computer Club. You want to identify the number of students who are freshmen who are Information Systems majors. Without filtering the dataset, what function should you use?

A workbook contains a list of members in the Computer Club. You want to identify the number of students who are freshmen who are Information Systems...

Calculates the number of periods for an investment or loan given a fixed rate, period payment, and present value.

Calculates the number of periods for an investment or loan given a fixed rate, period payment, and present value. Answer: NPER functio...

What is the function that returns the RELATIVE position of a value? Index, Match, HLOOKUP or VLOOKUP ?

What is the function that returns the RELATIVE position of a value?Index, Match, HLOOKUP or VLOOKUP ? Answer: It's MATCH fa...

Why would you nest MATCH in an INDEX function?

Why would you nest MATCH in an INDEX function? Answer: To use the position that was returned from the MATCH function as an argument in the INDEX...

Which of the following is not an argument in a Database function?

Which of the following is not an argument in a Database function?  A. Database B. Criteria C. Filter D. Field Answer: C. Filte...

What's the purpose of an Excel What-if scenario?

What's the purpose of an Excel What-if scenario? Answer: It's a detailed set of values that represent different possible situation...

Why would you put a negative sign in many financial functions?

Why would you put a negative sign in many financial functions? Answer: Excel interprets these calculations as a negative cash flow (money leaving...

T or F: The INDEX function results the position of a value.

T or F: The INDEX function results the position of a value. Answer: Fals...

T or F: The arguments of an INDEX function are array, row_num, and column_num.

T or F: The arguments of an INDEX function are array, row_num, and column_num. Answer: Tru...

T or F: Advanced filtering will not copy results to a new location.

T or F: Advanced filtering will not copy results to a new location. Answer: Fals...

True or False: The RATE function returns periodic rate for an investment or loan.

True or False: The RATE function returns periodic rate for an investment or loan. Answer: Tru...

True or False: The MONTH function would return 25 when used on a cell containing August 25, 2018.

True or False: The MONTH function would return 25 when used on a cell containing August 25, 2018. Answer: Fals...

True or False: You need the same number of logical tests as outcomes in a nested IF function.

True or False: You need the same number of logical tests as outcomes in a nested IF function. Answer: Fals...

Where would you setup the two substitution values in a two-variable data table?

Where would you setup the two substitution values in a two-variable data table? a. In the first row and first column in the table b. In the Series...

What is a benefit of using a range name in Excel?

What is a benefit of using a range name in Excel? a. Range names are easier for people to remember than cell references b. Range names make the data...

Which tool is most effective when comparing the impact of various combinations of interest rates and down payments on a mortgage?

Which tool is most effective when comparing the impact of various combinations of interest rates and down payments on a mortgage? a. Solver b. Scenario...

Which tool is most effective when comparing the impact of various combinations of interest rates and down payments on a mortgage?

Which tool is most effective when comparing the impact of various combinations of interest rates and down payments on a mortgage? a. Apr b. Payment c....

Which of the following tools can incorporate constraints?

Which of the following tools can incorporate constraints? a. Solver b. Data Tables c. Goal Seek d. Scenario Manager Answer: A. Solve...

Which what-if analysis tool is the best option for complex calculations requiring constrained optimization? (two answers)

Which what-if analysis tool is the best option for complex calculations requiring constrained optimization? (two answers) a. Name Manager b. Scenario...

This analysis tool has the ability to handle multiple adjustable cells while minimizing, maximizing, or meeting goals.

This analysis tool has the ability to handle multiple adjustable cells while minimizing, maximizing, or meeting goals. a. Scenario Manager b. Goal...

How can you determine if the Solver add-in is active?

How can you determine if the Solver add-in is active? a. Solver is available via right-click b. Solver is an option on the Home tab c. Solver appears...

Which is an effective way to change a SUM of Price field in the VALUES area to an AVERAGE function?

Which is an effective way to change a SUM of Price field in the VALUES area to an AVERAGE function? a. Right click the appropriate cell and select...

Which is not true about Slicers?

Which is not true about Slicers? a. You can filter data by a single value b. Aggregate values do not respond to slicers c. You can move a slicer so...

Using the % of Grand Total Calculation Option will display the value as

Using the % of Grand Total Calculation Option will display the value as ..................... a. a percentage of the row total b. a percentage of...

Which PivotTable calculated field is correctly constructed to calculate a 20% tip on a meal at a restaurant?

Which PivotTable calculated field is correctly constructed to calculate a 20% tip on a meal at a restaurant? a. =B5*1.2 b. =Meal Cost * 20% c. ="Meal...

You have just created a slicer for the State field in a PivotTable. Which of the following does not characterize the initial slicer?

You have just created a slicer for the State field in a PivotTable. Which of the following does not characterize the initial slicer? a. The slicer...

You have created a PivotChart showing sales by quarter by sales rep. Before presenting it to management, you notice the name of a rep who has since been fired. How do you remove this rep from the chart without deleting the data?

You have created a PivotChart showing sales by quarter by sales rep. Before presenting it to management, you notice the name of a rep who has since...

You have created a PivotTable and made some changes to values in the original dataset from which the PivotTable was created. How does this affect the PivotTable?

You have created a PivotTable and made some changes to values in the original dataset from which the PivotTable was created. How does this affect the...

You created an outline within a worksheet. What does the below button indicate to the left of a row heading?

You created an outline within a worksheet. What does the below button indicate to the left of a row heading? [ - ] A. You can add a new row at that...

A worksheet contains a list of graduates at your university. The worksheet contains these columns in this sequence: Student Last Name, Student First Name, College, Major, and GPA. Data are sorted by College, then by Major, and then by Student Last Name. What is the default At a change in setting within the Subtotal dialog box, and what would be a more appropriate setting?

A worksheet contains a list of graduates at your university. The worksheet contains these columns in this sequence: Student Last Name, Student First...

What settings should you select for a PivotTable if you want to apply a different color scheme and display different fill colors for main category rows and horizontal lines within the PivotTable?

What settings should you select for a PivotTable if you want to apply a different color scheme and display different fill colors for main category rows...

Currently, the House Types field is in the ROWS area, the Real Estate Agent field is in the COLUMNS area, and Sum of List Prices is in the VALUES area. How can you modify the PivotTable to display the agent names as subcategories within the house types in the first column?

Currently, the House Types field is in the ROWS area, the Real Estate Agent field is in the COLUMNS area, and Sum of List Prices is in the VALUES area....

A worksheet contains a PivotTable placeholder and the PivotTable Fields List. No fields have been added to the PivotTable yet. If you click the College Major field check box in the PivotTable Fields List, where does Excel place this field?

A worksheet contains a PivotTable placeholder and the PivotTable Fields List. No fields have been added to the PivotTable yet. If you click the College...

You created a PivotTable to summarize commissions earned by employees in each department. What is the default summary statistic for the commissions field when you add it to the PivotTable?

You created a PivotTable to summarize commissions earned by employees in each department. What is the default summary statistic for the commissions...