hardmultiple choiceObjective-mapped

A user reports that a specific Microsoft Office add-in causes Excel to crash when opening any spreadsheet. The technician disables the add-in and Excel works fine. However, the user needs the add-in. The technician checks the add-in's compatibility and finds it is designed for 32-bit Office but the user has 64-bit Office installed. What is the best solution?

Question 1hardmultiple choice
Full question →

A user reports that a specific Microsoft Office add-in causes Excel to crash when opening any spreadsheet. The technician disables the add-in and Excel works fine. However, the user needs the add-in. The technician checks the add-in's compatibility and finds it is designed for 32-bit Office but the user has 64-bit Office installed. What is the best solution?

Answer choices

Why each option matters

Good practice is not just finding the correct option. The wrong answers often show the exact trap the exam wants you to fall into.

A

Best answer

Install the 64-bit version of the add-in if available

This directly resolves the bitness mismatch. Most add-in vendors provide both 32-bit and 64-bit versions.

B

Distractor review

Reinstall Office in 32-bit mode

While this would allow the 32-bit add-in to work, it is a more disruptive change and not necessary if a 64-bit version of the add-in exists.

C

Distractor review

Run Excel in compatibility mode for an earlier version

Compatibility mode affects how documents are handled, not the bitness of the application. It will not allow a 32-bit add-in to load in 64-bit Excel.

D

Distractor review

Use a Windows compatibility troubleshooter on the add-in

The compatibility troubleshooter adjusts compatibility settings for legacy applications, but it cannot change the bitness of the add-in.

Common exam trap

Common exam trap: NAT rules depend on direction and matching traffic

NAT is not only about the public address. The inside/outside interface roles and the ACL or rule that matches traffic are just as important.

Technical deep dive

How to think about this question

NAT questions usually test address translation, overload/PAT behaviour, static mappings and whether the right traffic is being translated. Read the interface direction and address terms carefully.

KKey Concepts to Remember

  • Static NAT maps one inside address to one outside address.
  • PAT allows many inside hosts to share one public address using ports.
  • Inside local and inside global describe the private and translated addresses.
  • NAT ACLs identify traffic for translation, not always security filtering.

TExam Day Tips

  • Identify inside and outside interfaces first.
  • Check whether the scenario needs static NAT, dynamic NAT or PAT.
  • Do not confuse NAT matching ACLs with normal packet-filtering intent.

Related practice questions

Related 220-1101 practice-question pages

Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.

More questions from this exam

Keep practising from the same exam bank, or move into a focused topic page if this question exposed a weak area.

Question 1

A user reports intermittent network connectivity on a desktop computer. The technician observes that the Ethernet link light on the NIC turns off for a few seconds and then turns back on. The cable passes a wiremap test, the switch port is verified good with another device, and the NIC driver is updated. The issue occurs more frequently when the computer's case fan runs at high speed. Which of the following is the MOST likely cause?

Question 2

A workstation is unable to connect to the internet. The technician runs the 'ipconfig' command and sees the IPv4 address is 169.254.15.200 with a subnet mask of 255.255.0.0. The workstation can ping other devices on the local subnet but cannot ping the default gateway or any external addresses. Which TWO actions should the technician take to resolve this issue? (Select two.)

Question 3

A workstation is connected to a managed switch. It obtains a valid IP address (192.168.10.50) from the DHCP server, but it cannot ping the default gateway (192.168.10.1). The link light on both the workstation NIC and the switch port are solid green. Other workstations on the same switch CAN ping the default gateway successfully. The technician accesses the switch management interface and finds that the workstation's port is configured as an access port on VLAN 10. The default gateway is located on VLAN 20. An inter-VLAN router is configured but not explicitly allowing VLAN 10 access to VLAN 20. Which of the following is the MOST likely cause of the problem?

Question 4

A company develops a web application that relies on a custom library available only for a specific Linux distribution. They want to deploy the application in the cloud with minimal administrative overhead, but they need full control over the software stack, including the ability to install the custom library and configure the web server. Which cloud service model BEST meets these requirements?

Question 5

A company has a legacy virtual machine running on a deprecated hypervisor (Hyper-V). They want to migrate this VM to a new hypervisor (VMware vSphere) hosted in a private cloud while preserving the VM's configuration, installed applications, and data. The migration must be performed with minimal downtime. Which of the following methods is MOST appropriate?

Question 6

A company hosts a critical database on a virtual machine in a public cloud. The database requires persistent storage that must be retained even if the VM is terminated. The storage must also be accessible from multiple VMs simultaneously for a future high-availability configuration. Which type of cloud storage BEST meets these requirements?

FAQ

Questions learners often ask

What does this 220-1101 question test?

Static NAT maps one inside address to one outside address.

What is the correct answer to this question?

The correct answer is: Install the 64-bit version of the add-in if available — A 32-bit add-in cannot run in a 64-bit Office application due to bitness incompatibility. The best solution is to obtain a 64-bit version of the add-in from the vendor, if available. Reinstalling Office as 32-bit would work but is a more drastic change and not optimal if a 64-bit add-in exists. Compatibility mode and Windows compatibility troubleshooter do not resolve bitness conflicts.

What should I do if I get this 220-1101 question wrong?

Then try more questions from the same exam bank and focus on understanding why the wrong options are tempting.

Discussion

Loading comments…

Sign in to join the discussion.