You are the manager for a real estate agency. Your assistant created a list of houses that were put on the market in April. However, the list contains several issues and errors that you will fix. Open e11d1Houses and save it as e11d1Houses_LastFirst. First, the CONCAT function in the Code-Num column concatenates the Code and Num data in columns A and B. However, the concatenated result should have a hyphen, such as CH-1. Cor-rect the function in cell C5 and copy the corrected function down the column. Next, your assistant combined the street address with the cities. Luckily, a comma separates the data. Convert the text to columns to separate the addresses from the cities. Your assistant created criteria and output ranges. However, the conditions in the criteria range are not correctly entered. You want to identify houses in American Fork that were represented by Goodrich or Carey. Correct the criteria range and run the advanced filter to copy the records to the output range. Six records should be copied. The database function in cell E2 does not correctly identify the number of records for houses in American Fork. Correct the function name and the field argument. The INDEX function in cell H2 is incorrect. It should use the position in cell I1 as the row number and the correct column for the selling price. Correct the function’s arguments and format the result with Accounting Number Format with zero decimal places. Change the number in cell H1 to CH-1 to see if the results update correctly. Create a footer with your name on the left side, the sheet name in the center, and the file name code on the right side on all sheets. Save and close the file. Exit Excel. Based on your instructor’s directions, submit e11d1Houses_LastFirst.

You are the manager for a real estate agency. Your assistant created a list of houses that were put on the market in April. However, the list contains several issues and errors that you will fix. Open e11d1Houses and save it as e11d1Houses_LastFirst. First, the CONCAT function in the Code-Num column concatenates the Code and Num data in columns A and B. However, the concatenated result should have a hyphen, such as CH-1. Cor-rect the function in cell C5 and copy the corrected function down the column. Next, your assistant combined the street address with the cities. Luckily, a comma separates the data. Convert the text to columns to separate the addresses from the cities. Your assistant created criteria and output ranges. However, the conditions in the criteria range are not correctly entered. You want to identify houses in American Fork that were represented by Goodrich or Carey. Correct the criteria range and run the advanced filter to copy the records to the output range. Six records should be copied. The database function in cell E2 does not correctly identify the number of records for houses in American Fork. Correct the function name and the field argument. The INDEX function in cell H2 is incorrect. It should use the position in cell I1 as the row number and the correct column for the selling price. Correct the function’s arguments and format the result with Accounting Number Format with zero decimal places. Change the number in cell H1 to CH-1 to see if the results update correctly. Create a footer with your name on the left side, the sheet name in the center, and the file name code on the right side on all sheets. Save and close the file. Exit Excel. Based on your instructor’s directions, submit e11d1Houses_LastFirst.

You are the manager for a real estate agency. Your assistant created a list of houses that were put on the market in April. However, the list contains several issues and errors that you will fix. Open e11d1Houses and save it as e11d1Houses_LastFirst. First, the CONCAT function in the Code-Num column concatenates the Code and Num data in columns A and B. However, the concatenated result should have a hyphen, such as CH-1. Cor-rect the function in cell C5 and copy the corrected function down the column. Next, your assistant combined the street address with the cities. Luckily, a comma separates the data. Convert the text to columns to separate the addresses from the cities. Your assistant created criteria and output ranges. However, the conditions in the criteria range are not correctly entered. You want to identify houses in American Fork that were represented by Goodrich or Carey. Correct the criteria range and run the advanced filter to copy the records to the output range. Six records should be copied. The database function in cell E2 does not correctly identify the number of records for houses in American Fork. Correct the function name and the field argument. The INDEX function in cell H2 is incorrect. It should use the position in cell I1 as the row number and the correct column for the selling price. Correct the function’s arguments and format the result with Accounting Number Format with zero decimal places. Change the number in cell H1 to CH-1 to see if the results update correctly. Create a footer with your name on the left side, the sheet name in the center, and the file name code on the right side on all sheets. Save and close the file. Exit Excel. Based on your instructor’s directions, submit e11d1Houses_LastFirst.