Question: In a spreadsheet that I'm working on, there is a row that contains text describing someone's salary. The only values I want are low, medium,

In a spreadsheet that I'm working on, there is a row that contains text describing someone's salary. The only values I want are "low", "medium", and "high".

Some of the values are something other than those such as "very high", "I don't know", etc.

How can I select the rows that have these incorrect values and delete them?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Choose machine F and create tables for Sales Budget, Production Budget, Direct Materials Budget, Overhead Budget, SGA Budget, Income Statement, Cash Budget, and Balance Sheet For the six months ended...

Can anyone help me with this or already have the solution this whole Finance Workbook for Madura Personal Finance, Third Edition by Jeff Madura BUILDING YOUR OWN FINANCIAL PLAN WORKBOOK INDEX Chapter...

Week 1 Lecture 1 Class Approach to Statistics Statistics is basically a set of tools that allow us to get information out of data sets (we will get to the more formal definition below). As such, it...

I have to do an accounting assignment. I have attached the instructions, the questions, and pdf's containing the information requested for the questions. Company Estimates & Opinions Sanmina Corp...

I got this big assignmnet for Quantitative methods for business i really need help Azimi, Hamida - azihy004 AH Share Comments Delete this page before submission Q-Constructions - building your future...

Read Chapter 6 of the book "How to measure anything". Now, write a letter to Mr. Williams, starting with the following statement: "Mr. Williams, currently you work with categorical risk metrics...

BACKGROUND You are an information analyst working for NEE. The company president has asked you to prepare a Quantitative analysis of financial, sales, and operations data to help determine which...

I'm doing a project for cost /benefits /risk analysis for information system. My case analysis is tesla motors and i could not find a resources of how much their website application cost, maintain...

I need to see the SPSS output. You need to have all z-scores, all charts, all descriptives data from SPSS, everything you used to answer the questions. I am sending you what the previous tutor sent...

Your Lab Report must be divided into sections in the following order; title, abstract, introduction, methods, results, discussion, conclusions references, appendix. The appendix section is optional....

A melting point test of n = 10 samples of a binder used in manufacturing a rocket propellant resulted in Assume that melting point is normally distributed with . (a) Test H0: = 155 versus H0:...

Let S = (a, b, c, d, e, fy with P(b) = 0.17, P(c) = 0.11, P(d) = 0.21, P(e) = 0.18, and P() = 0.15. Let E (a, b, d) and F = (a, b, d, e). Find P(a), P(E), and P(F). P(a) = P(E) = P(F) =

Which type of financing consist of small amounts of capital given to help prove a concept

What is an example of constructive feedback? provide reference