Excel Module 7-Creating Templates, Importing Data

A file with a theme applied and that may contain formatted placeholder text, headers and footers, and graphics that you replace with your own information for hundreds of purposes, including budgets, flyers, and resumes; template files have slightly different file extensions than standard application files, such as .xltx, .pptx., or .dotx.

• template

• theme

• layout

A process that lets you copy the data from an external source, without having to open the source file, and add it to the current file, such as an Access database, a worksheet, or a publication.

• import

• export

• transpose

A file that you can open and access but cannot make permanent changes to.

• non-edit file

• file

• read-only file

An open source markup language mainly used to identify and share data across a wide range of applications.

• XML

• .docx

• .xslx

A logical function that returns the word TRUE if both arguments are true.

• Or

• AND

• Azure

A file that contains data with little or no formatting.

• rich text file

• text file

• Word document

A file in which each record is on a separate line and the fields are separated by a special character, called the delimiter.

• delimited file

• comma file

• spacer file

A separator such as a space, comma, or semicolon between elements in imported data.

• space

• comma

• delimiter

A file that contains data fields separated by a comma.

• period-delimited text file

• comma-delimited text file

• space-delimited text file

A file in which the width of any field is the same on every record.

• fixed-width file

• space-width file

• comma file