MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Sample data used in place of actual data to verify formulas in a template.
A)template
B)dummy data
C)XML
D)Excel Template
E)external data
F)fixed width file
G)drag and drop
H)Web query
I)transposed
J)replication

Question

Quizplus · Accepted Answer

Dummy data is used as a substitute for actual data to test the functionality of a template.

Answer: F
 A fixed width file is a type of file format where data is organized into columns of fixed width.

Answer: A
 A template is a pre-designed document or spreadsheet that serves as a starting point for a new file.

Answer: D
 An Excel template is a pre-designed spreadsheet that includes formulas, formatting, and other features.

Answer: H
 A web query is a feature in Excel that allows users to import data from a webpage directly into a spreadsheet.

Answer: I
 Transposing data in Excel means reorganizing it so that its rows become columns and its columns become rows.

Answer: J
 Replication in Excel refers to the process of copying a formula or formatting to multiple cells at once.

Note: XML and external data are not relevant to the given phrase/definition. Drag and drop is a general term that may apply to Excel but is not specific to the given scenario.

MATCHING Identify the Letter of the Choice That Best Matches the the Phrase