Chp 10

10 September 2022
4.7 (114 reviews)
6 test answers

Unlock all answers in this set

Unlock answers (2)
question
A text file separates data by a special character called a: (ch. 10)
answer
Delimiter
question
which of the following file formats can be imported using power query
answer
CSV
question
Vhich of the following Power Add-ins is best suited for editing data before import?
answer
Power Query
question
Your coworker created a workbook with a list of names and addresses. The state abbreviation and zip code are stored in once cell per customer, such as NC27215. You need to be able to sort these data by postal code to use bulk-rate mailing. The appropriate excel action is to
answer
Type 27215 in the cell to the right of NC27215 and use Flash Fill
question
A workbook contains addresses in column C. the addresses use commas after the street, city, and state such as 129 Elm Street. Column D contains the phone number. You instruct excel to divide the data into multiple columns. You successfully divide the column into four columns. What happens to the phone numbers in column D?
answer
The phone numbers are overwritten by the cities
question
You have client last names stored in column A and the date of their first purchase in column B. You would like to create a custom account number by combining the client's last name and date. What function would you use to complete the task?
answer
CONCATENATE