Archive for February 2019

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?"

Add Comment

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?"



a. schedule feasibility
b. technical feasibility
c. economic feasibility
d. operational feasibility


Answer: B

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?"

Add Comment

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?"



a. schedule feasibility
b. technical feasibility
c. economic feasibility
d. operational feasibility


Answer: D

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

Add Comment

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



a. least benefit, at the highest cost, in the longest period of time
b. least benefit, at the lowest cost, in the longest period of time
c. greatest benefit, at the highest cost, in the shortest period of time
d. greatest benefit, at the lowest cost, in the shortest period of time


Answer: D

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

Add Comment

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



a. user-friendly system that improves employee job satisfaction
b. sales tracking system that supplies better information for marketing decisions
c. new Web site that enhances the company's image
d. online package tracking system that decreases the need for clerical staff


Answer: D

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

Add Comment

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



a. user-friendly system that improves employee job satisfaction
b. new scheduling system that reduces overtime
c. online package tracking system that decreases the need for clerical staff
d. sophisticated inventory control system that cuts excess inventory


Answer: A

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

Add Comment

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



a. action on requests must wait until the committee meets
b. one person's bias is less likely to affect the decisions
c. members might favor projects requested by their own departments
d. internal political differences could delay important decisions


Answer: B

IT Departments today ____ .

Add Comment

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. are more team-oriented


Answer: D

A systems request form should ____.

Add Comment

A systems request form should ____.



a. have clear instructions
b. be difficult to understand
c. not include enough space for all required information
d. not indicate what supporting documents are needed


Answer: A

Systems development typically starts with a ____.

Add Comment

Systems development typically starts with a ____.



a. feasibility study, followed by a systems request, which includes a preliminary investigation
b. systems request, followed by a preliminary investigation, which includes a feasibility study
c. preliminary investigation, followed by a feasibility study, which includes a systems request
d. feasibility study, followed by a preliminary investigation, which includes a systems request


Answer: B

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

Add Comment

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



a. User support
b. Database administration
c. Systems support and security
d. Network administration


Answer: C

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.

Add Comment

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.



a. systems implementation phase
b. systems planning phase
c. systems analysis phase
d. systems design phase


Answer: D

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.

Add Comment

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.



a. systems design phase
b. systems planning phase
c. systems support and security phase
d. systems analysis phase


Answer: B

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.

Add Comment

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.



a. interactive model
b. requirements model
c. waterfall model
d. object model


Answer: C

In a typical company organizational model, middle managers ____.

Add Comment

In a typical company organizational model, middle managers ____.



a. develop long-range plans, called strategic plans, which define the company's overall mission and goals
b. provide direction, necessary resources, and performance feedback to supervisors and team leaders
c. oversee operation employees and carry out day-to-day functions, coordinating operational tasks and people
d. include users who rely on TP systems to enter and receive the data they need to perform their jobs


Answer: B

In a typical company organizational model, top managers ____.

Add Comment

In a typical company organizational model, top managers ____.



a. develop long-range plans, called strategic plans, which define the company's overall mission and goals
b. provide direction, necessary resources, and performance feedback to supervisors and team leaders
c. oversee operation employees and carry out day-to-day functions, coordinating operational tasks and people
d. include users who rely on TP systems to enter and receive the data they need to perform their jobs


Answer: A

User productivity systems ____.

Add Comment

User productivity systems ____.



a. provide job-related information to users at all levels of a company
b. simulate human reasoning by combining a knowledge base and inference rules that determine how the knowledge is applied
c. process data generated by day-to-day business operations
d. include e-mail, voice mail, fax, video and Web conferencing, word processing, automated calendars, database management, spreadsheets, desktop publishing, presentation graphics, company intranets, and integrated mobile computing systems


Answer: D

Business support systems ____.

Add Comment

Business support systems ____.



a. provide job-related information support to users at all levels of a company
b. simulate human reasoning by combining a knowledge base and inference rules that determine how the knowledge is applied
c. process data generated by day-to-day business operations
d. include e-mail, voice mail, fax, video conferencing, word processing, automated calendars, database management, spreadsheets, and integrated mobile computing systems


Answer: A

Transaction processing (TP) systems ____.

Add Comment

Transaction processing (TP) systems ____.



a. provide job-related information to users at all levels of a company
b. simulate human reasoning by combining a knowledge base and inference rules that determine how the knowledge is applied
c. process data generated by day-to-day business operations
d. include e-mail, voice mail, fax, video conferencing, word processing, automated calendars, database management, spreadsheets, and integrated mobile computing systems


Answer: C

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?

Add Comment

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?



Answer:

AI developing so rapidly
may learn human emotions + feel pain
corrupts argument of reducing mental instability
if we address the increase in complexity of AI in the future, it's strengthen our argument

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

Add Comment

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



Answer:

robots would take over the workforce completely over time
machine will pay for itself because of no pay, no sick, no need for benefits, more efficient
eliminate humans completely from the workforce which is negative for the workforce because of unemployment

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?

Add Comment

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 APPLIES TO KAYLA)
- excluded jack's research about education
-effective because AI can connect with every student, better teachers, can teach better

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?

Add Comment

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 APPLY TO KAYLA)
Kayla's research
AI will not replace doctors, but it will aid them
Good argument -> shows why it is beneficial

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

Add Comment

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



Answer:

(ONLY APPLIES TO BRIANNA)
Aaliya's research
increased regulation on AI
would limit major cons such as mass unemployment + depression
If we can control AI, it'd be highly beneficial
Example: AI can replace jobs in labor-intensive workforce but if they replace everything, it's negative for society

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

Add Comment

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



Answer:

Brianna's research
increased efficiency in workforce
two stakeholders -> legal + military
proved how AI is beneficial
Example: Legal system decreases bias -> help innocent people

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

Add Comment

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 sooner so our schedules worked, progress checks -> improve because we'd be more prepared -> we would be more concise in our argument -> more practice which would improve quality of work

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

Add Comment

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



Answer: We didn't include because we could not use this as a strong claim. It was a potential counterclaim but we decided it was not strong enough as it was too specific of an example

-how AI is used in the medical field,

-for example, the PET CT scanning is not advanced enough to detect cancer early enough to possibly cure cancer.


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

Add Comment

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



Answer:

-Robots are far more attractive to Employers
-Ex: The transition of decreasing danger jobs ->unemployment b/c of the increased skill of AI

-Massive job loss but create high skilled jobs
-Ex: AI = higher understanding/educated jobs but mass unemployment in certain classes

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

Add Comment

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. Ex: The Aegis Combat system and that would increase the efficiency and accuracy of weapons used in the military.
- How AI will be used in the legal system. Ex: The ability of AI to decrease the bias of the judges and the jury in court.

Which is NOT true?

Add Comment

Which is NOT true?



A) Frank is an artificial intelligence marketing platform that requires little human input.
B) Tools like Hunch check analytics to know what's happening every second and detect when unexpected traffic is visiting a site.
C) Frank uses machine learning to find the best paid channels for a specified target audience.
D) Albert is an artificial intelligence marketing platform that provides an autonomous media buying service.


Answer: A, Frank is an artificial intelligence marketing platform that requires little human input.

Which is NOT True?

Add Comment

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 have yet discovered
C) AI algorithms can optimize the targeting of key audiences
D) AI algorithms can improve marketing performance by testing ad platforms


Answer: A, AI can build new websites from the ground up

What is the difference between machine learning and deep learning?

Add Comment

What is the difference between machine learning and deep learning?



A) Deep learning is the same as machine learning
B) Deep learning utilizes statistical data and machine learning does not
C) Machine learning uses neural networks and deep learning does not
D) None of the above


Answer: D, none of the above

What does the following code do?

Add Comment

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. Exchanges two values
D. Swaps values.
E. Performs an atomic exchange.
F. Clears memory
G. Nothing

Answer:


C. Exchanges two values
D. Swaps values.

What is the input to the Java Virtual Machine

Add Comment

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 libraries
F. Virtual code.
G. MSIL


Answer:

A. .class files.0
E. Dynamically linked libraries

What is the output of a Java compiler

Add Comment

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 instructions
G. machine instructions

Answer:


A. A .class file.
C. Java bytecode

Dynamically Linked Libraries (DLLs)

Add Comment

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 as a complete unit when the program runs
D. Use "Lazy Linking"
E. Tend to make programs take more space in memory
F. Are rarely used today because main memory is cheap.
G. Contain bare-bones machine instruction information in executable form

Answer:


A. Are not linked until runtime.
D. Use "Lazy Linking"

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

Add Comment

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 routines (e.g., matrix inversion)
B. It makes the executable run faster.
C. It makes it easier to update the program when libraries have been updated.
D. The library code does not have to be compiled each time it's referenced in a program.



Answer: B. It makes the executable run faster.

Which describes a symbol table?

Add Comment

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 matches names of labels to the addresses of the memory words that instructions occupy.
C. A list of needed and supplied program locations.
D. A list of all globally declared data in the program.
E. A table that contains no information.
F. A table containing the operations codes of all the assembly language instructions.
G. The list of ASCII characters used in the program code.

Answer:


B. A table that matches names of labels to the addresses of the memory words that instructions occupy.
C. A list of needed and supplied program locations.

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

Add Comment

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



A. Macro
B. Pseudocode
C. Artificial instruction
D. Simulated instruction
E. Pseudoinstruction
F. Hardware instruction
G. pseudo instruction

Answer:


E. Pseudoinstruction
G. pseudo instruction

What best describes what a linker does?

Add Comment

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. Compresses executable code size.
D. Calculates load parameters for the program.
E. Combines separately compiled code and data modules into a single executable file.
F. Resolves references among separate code modules.
G. Notifies the programmer of errors in the source code.

Answer:

E. Combines separately compiled code and data modules into a single executable file.
F. Resolves references among separate code modules.

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

Add Comment

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 it to be disabled.
B. There was not enough room on the chip to implement the circuits needed for the logic.
C. It can be done by a combination of simple instructions.
D. The need for the branch on less than instruction wasn't discovered until after foundational decisions had been made.
E. BLT is a pseudo instruction.
F. The Assembler can do that.
G. It would take too long as a single instruction and stretch the clock cycle for all other instructions

Answer:

C. It can be done by a combination of simple instructions.
G. It would take too long as a single instruction and stretch the clock cycle for all other instructions

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

Add Comment

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



A. Multiple branch instructions can be used to jump farther.
B. The immediate field can be extended.
C. A jr instruction can be used if the target is fixed.
D. Branch logic can be combine with the jump instruction to do a longer branch.
E. Write directly to the $pc register.
F. It cannot be done if there is a condition attached to the jump.
G. Put the target address into $ra and execute jr $ra.

Answer:

C. A jr instruction can be used if the target is fixed.
D. Branch logic can be combine with the jump instruction to do a longer branch.

The MIPS J instruction uses ______ addressing.

Add Comment

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 bits to PC
F. Immediate
G. Pseudodirect

Answer:

B. Replace bottom 28 bits of PC
G.Pseudodirect

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

Add Comment

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. Program Counter relative addressing
C. Memory Indirect addressing.
D. Absolute addressing
E. Register addressing
F. PC-relative addressing
G. Immediate addressing.

Answer:

B. Program Counter relative addressing
F. PC-relative addressing

How is immediate data handled in branch instructions

Add Comment

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 the program counter
C. It is used to decide whether or not to branch
D. It is sign extended and added to the program counter
E. It is added to the program counter
F. It is sign-extended and subtracted from the program counter
G. It is sign extended, shifted left 2 and added to the program counter


Answer:


A. It is shifted left 2 after being sign extended and added to the program counter
G. It is sign extended, shifted left 2 and added to the program counter

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.

Add Comment

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.


a. 180
b. 15
c. 30
d. 0.05/12


Answer: A. 180

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")?

Add Comment

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")?


a. =AND(B1="Available", B1="Limited")
b. =TRUE(B1<>"Sold Out")
c. =IF(B1="Sold Out", "TRUE", "FALSE")
d. =NOT(B1="Sold Out")


Answer: d. =NOT(B1="Sold Out")

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?

Add Comment

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?


a. =YEARFRAC(B1, B2)
b. =DAY(B1)
c. =DAYS(B2, B1)
d. =DAYS(B1, B2)


Answer: c. =DAYS(B2, B1)

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?

Add Comment

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. =IF(OR(B10-B5>=5, B11>=2), MAX(200, (B10-B5)*50), 45)
b. =IF(OR(B10>B5, B11>=2), MAX(200, 50), 45)
c. =IF(AND(B10-B5>=5, B11<2), MAX(200, (B10-B5)*50), 45)
d. =IF(AND(B10>B5, B11>=2), 200, 45)


Answer: a. =IF(OR(B10-B5>=5, B11>=2), MAX(200, (B10-B5)*50), 45)

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?

Add Comment

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.
Lookup_value
b.
Row_num
c.
Match_type
d.
Lookup_array


Answer: a. Lookup_value

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?

Add Comment

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. DCOUNT
b. DSUM
c. COUNT
d. COUNT


Answer: A. DCOUNT

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

Add Comment

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 more portable to other applications
c. Range names are required when using financial functions
d. Range names inherently make calculations more accurate


Answer: A. Range names are easier for people to remember than cell references

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

Add Comment

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 on the Data tab
d.
Solver appears in the Goal Seek dialog box to make it appear as a label


Answer: c.
Solver appears on the Data tab

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

Add Comment

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 AVERAGE from the mini-tool bar
b.
Select the appropriate cell in the PivotTable and type =AVERAGE(Price)
c.
Click the field's arrow in the VALUES area and select Value Field Settings
d.
Click the AVERAGE button on the Analyze tab


Answer: c.
Click the field's arrow in the VALUES area and select Value Field Settings

Which is not true about Slicers?

Add Comment

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 it does not cover a PivotTable
d.
You can filter data by multiple value


Answer: b.
Aggregate values do not respond to slicers

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

Add Comment

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 caption is State.
b.
The slicer may display on top of the PivotTable data.
c.
The slicer contains one column of state names or abbreviations.
d.
The slicer buttons are set to filter out all records.


Answer: d.
The slicer buttons are set to filter out all records.

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?

Add Comment

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?


a.
Make the employee's data points and axis titles invisible.
b.
Hide that rep's row(s) in the underlying list, which automatically removes that rep from the chart.
c.
Filter the Sales Rep field in the PivotChart and deselect the employee's check box.
d.
You cannot delete the rep from the chart without first deleting the data.


Answer: c.
Filter the Sales Rep field in the PivotChart and deselect the employee's check box.

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?

Add Comment

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?


a.
The PivotTable is deleted from the workbook because it is not up to date.
b.
You must create a new PivotTable if you want updated results in a PivotTable.
c.
The PivotTable is updated automatically when you make changes to the dataset.
d.
Changes in the dataset do not affect the PivotTable until you refresh the PivotTable.


Answer: d.
Changes in the dataset do not affect the PivotTable until you refresh the PivotTable.

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

Add Comment

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 location only.
B. You can click it to collapse the details of that category.
C. One or more columns are hidden.
D. You can click it to expand the details of that category.


Answer: B. You can click it to collapse the details of that category.

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?

Add Comment

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. College (default field), Student Last Name (correct field)
B. Student First Name (default field), Student Last Name (correct field)
C. Student Last Name (default field), College (correct field)
D. Student Last Name (default field), GPA (correct field)


Answer: C. Student Last Name (default field), College (correct field)

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?

Add Comment

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?



A. Banded Rows check box and a different PivotTable style.
B. Banded Columns check box and a different PivotTable style.
C. Banded Rows and Banded Columns check boxes.
D. A different PivotTable style only.


Answer: A. Banded Rows check box and a different PivotTable style

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?

Add Comment

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?


A. Drag the House Types field from the ROWS area and drop it below the Real Estate Agent field in the COLUMNS area.

B. Drag the Real Estate Agent field from the COLUMNS area and drop it below the House Types field in the ROWS area.

C. Drag the Real Estate Agent field from the COLUMNS area and drop it above the House Types field in the ROWS area.

D. Drag the House Types field from the ROWS area to the FILTERS area and drag the Real Estate Agent field from the COLUMNS area to the ROWS area.


Answer: B. Drag the Real Estate Agent field from the COLUMNS area and drop it below the House Types field in the ROWS 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?

Add Comment

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. FILTERS area
B. COLUMNS area
C. VALUES area
D. ROWS area


Answer: D. ROWS area

Subscribe to: Posts (Atom)