Delimited Data
This file extension is commonly used for comma-separated data.
What is .csv?
This setting changes a page from portrait to landscape.
What is orientation?
This keyboard shortcut inserts a hyperlink.
What is Ctrl + K
This is the standard default row height in Excel.
What is 15 points?
Removing columns in Power Query is an example of this type of action.
What is transforming (or modifying) data?
This character separates columns in a CSV file.
What is a comma?
These control the blank spaces around the printed worksheet.
What are margins?
This option shows descriptive text when hovering over a hyperlink.
What is screen tip?
Double-clicking the right border of a column heading performs this action.
What is AutoFit column width?
This button opens Power Query instead of loading data immediately.
What is Transform Data?
This tool allows you to clean or transform data before loading it into Excel.
What is the Power Query Editor?
True or False: Images can be inserted into headers and footers.
What is true?
This ribbon tab contains the “Find & Select” option.
What is the Home Tab?
This is the maximum number of rows in an Excel worksheet.
What is 1,048,576?
This happens to the original file when you edit data in Power Query.
What is nothing (it remains unchanged)?
Delimited files are saved in this format type.
What is plain text?
This feature allows different headers on odd and even pages.
What is Different Odd & Even Pages?
This dialog box allows you to jump directly to a named range or cell reference.
What is the Go To dialog box?
Cells and cell ranges are examples of these.
What are name elements?
This feature allows you to sort or filter data before loading it.
What is Power Query Editor?
Name two examples of delimiters used in text files.
What are comma, tab, colon, or space?
This view is required to properly see and edit headers and footers.
What is page layout view?
This tool lets you sample formatting from a cell during a search.
What is the eyedropper?
This toolbar can be customized for frequently used commands.
What is the Quick Access Toolbar?
This type of file commonly works with Power Query imports.
What is a .csv or .txt file?