1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
marishachu [46]
3 years ago
14

How to compare two columns in excel for matches and differences?

Computers and Technology
1 answer:
vlabodo [156]3 years ago
8 0
If columns A and B has equal length you can use simply formula =A1=B1 for each row. i.e 
=A1=B1  for first row
=A1=B1  for second row etc

Formula returns TRUE if values are equal or FALSE if they are not equal 
You might be interested in
The _____ option will allow a user to remove text from one location and keep it for use later on the clipboard.
ValentinkaMS [17]

I believe the answer is the "cut" option?

8 0
3 years ago
David is working in a database that organizes student exam grade information. He needs to find all students who have scored 100
kobusy [5.1K]

Answer:

David can apply filter to the data in order to show only records that meet the criteria.

Explanation:

  • Filter is a very helpful option that displays the records that you want to view, hiding rest of the unwanted records.
  • Sometimes you want to extract and view only the records that match a specific criteria instead of viewing all the records.
  • For example in the CUSTOMERS table which contains names, addresses, countries of customers. There are several customers from different countries but you only want to view the customers from Spain. So you can use filter feature to view all the customers from country Spain.
  • In MS Access you can apply filters using Sort & Filter group in the Home tab by selecting the desired column. In SQL, WHERE clause can be used along with SELECT to for filtering and extracting certain records. SELECT will select the records from the table and WHERE clause will specify the criteria to select the certain records.
7 0
3 years ago
List the seven steps used by a laser printer to print a page
Schach [20]
T<span>he seven steps used by a laser printer to print a page are :
</span>1)  Processing, this is where he computer sends the data to the printer.
2)  Charging, where <span>the wire (primary corona) negatively charges the
     photoconductive drum.</span>
3)  Exposing, where <span>the laser scans the image to the drum. Anywhere the
     laser touches the drum causes the electrical charge to drain off.</span>
4)  Developing, where <span>negatively charged toner particles are allowed to
     attach to the painted area of the drum; since the negative charge has
     been drained off these areas</span>
5) Transferring, where the transfer corona wire charges the paper with a
     positive charge from behind. The negatively charged toner jumps to the
     positive paper, according to the image on the drum. <span>A Static Charge
     eliminator then removes any residual charge.
</span>6) Fusing, where t<span>he toner particles attached to the paper are fused or
     melted to the paper, because of the heated drum.</span>
7) Cleaning, where t<span>he drum is cleaned of excessive toner and electrical
    charges.</span>
7 0
3 years ago
Read 2 more answers
What are those jackets called the ones with lots of straps inside, like in movies where they store there ammo etc?
sesenic [268]

Answer:

Tactical Vest | Tactical Ammo Vest.

Explanation:

6 0
3 years ago
Government expenditures classify as a characteristic of which of the following?
LenKa [72]
Your answer shall be c
5 0
3 years ago
Other questions:
  • ​A(n) ____ statement can include rules for site visitors, a statement of copyright in the site design and content, and can restr
    12·1 answer
  • What is requirement analysis
    8·1 answer
  • Although the original BBS system was simple, it increased people's ability to communicate
    14·1 answer
  • Which tab is used to edit objects on the slide master and layouts
    10·1 answer
  • Spoken word and written word are different because what
    9·1 answer
  • When including multiple images in a report, it may help to create a _____ on each image so you can cross reference them througho
    11·1 answer
  • Novice drivers lack the experience necessary to reliably categorize and appropriately respond to ___________ hazards.
    11·1 answer
  • What does ctto mean?
    11·2 answers
  • What is the difference between a network intrusion detection system (NIDS) and a network intrusion prevention system (NIPS)?
    12·1 answer
  • PLEASE HURRY!!!
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!