update car_sales_data
set car_model=
case
        when car_model = 'Altima' THEN 'Nissan'
        when car_model = 'F-150' THEN 'Ford'
        when car_model = 'Civic' THEN 'Honda'
        when car_model = 'Silverado' THEN 'Chevrolet'
        else car_model
    END

WHERE car_model IN ('Altima','F-150','Civic','Silverado')

Base Data

create table car_sales_data(car_model varchar(100))
insert into car_sales_data values('Altima')
insert into car_sales_data values('F-150')
insert into car_sales_data values('Civic')
insert into car_sales_data values('Civic')

The script below will check if your results table exists, and drop it if so (to allow multiple runs). It then selects the required data into dbo.test from your current table, and select the results. I've set it to put the results into a table called dbo.test ; make sure this name isn't in use already for something else.

/* DELETE OUTPUT TABLE IF IT EXISTS */

if exists
(
    select name from sys.tables 
    where 
        name = 'test' 
        and OBJECT_SCHEMA_NAME(object_ID) = 'dbo'
)
begin 
    drop table dbo.test 
end

select *,
    case
        when car_model = 'Altima' THEN 'Nissan'
        when car_model = 'F-150' THEN 'Ford'
        when car_model = 'Civic' THEN 'Honda'
        when car_model = 'Silverado' THEN 'Chevrolet'
    END

/*  NEW table NAME HERE */

into dbo.test

FROM car_sales_data
WHERE car_model IN ('Altima','F-150','Civic','Silverado')

select * from dbo.test