Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Assign the word to each blank which best completes the statement. Each word is u

ID: 3553609 • Letter: A

Question

Assign the word to each blank which best completes the statement. Each word is used ONLY once. Not all words are

used.

A) Changes B) Placeholders C) Data

D) Refreshable E) ASCII F) Comma-delimited

G) Resolve Conflicts H) Format Painter I) Merging

J) Convert Text to Columns K) Track Changes L) Replace

______ 1. _________________________ can guide users of a template regarding what type of data to

enter in cells.

______ 2. _________________________ allows users to bring together copies of workbooks that others

have worked on independently.

______ 3. Importing data into Excel can create a(n) _________________________ link that can be used to

update data whenever the original file changes.

______ 4. _________________________ stands for the American Standard Code for Information

Interchange.

_____ 5. If both you and another user change the same cell in a shared workbook, Excel displays

a(n) ________________________ dialog box when the workbook is saved.

______ 6. A text file in which data fields are separated by commas is called a(n) ___________________

text file.

______ 7. To copy formatting to text, you can select text, right-click the selection, and then click the

_________________________ button on the Mini toolbar.

______ 8. Data in a single column can be separated using Excel

Explanation / Answer

1)placeholders

2)merging

3)refreshable

4)ASCII

5)Resolve Conflicts

6) Comma-delimited

7)Format Painter

8)Convert Text to Columns

9)changes

10)Data