| A | B |
|---|
| What does to parse data mean? | interpret character by-character |
| What is a character that separates data entries from one another? | delimiter |
| A character that encloses values in your data file is known as a __________________. | text qualifier |
| ____________ file types have characters such as commas or tabs to separate each field. | Delimited |
| What file types are aligned in columns with spaces between each field? | fixed width |
| Common ____________ include Tabs, Semicolons, Commas, and Spaces | delimiters |
| What process ensures that data gets entered correctly? | validation |
| What tab do you select to import information from another file? | data |
| When data is imported to an Excel file, what is the default data format? | General |
| What data format converts numeric values to numbers, date values to dates, and all remaining values to text? | General |
| To ______________ data to worksheets means to import data to existing worksheets. | append |
| _____________ ensures that data gets entered correctly before it gets processed incorrectly | Validation |
| Which of the following validation criteria are allowed? | any value, whole number, list, date, text length, & Custom |
| To what data do validation rules pertain? | new data as you enter it into the workbook |
| What is one method of cleansing your database? | remove duplicate rows |
| ____________ elements are referred to when executing a function | criterion |
| Data cannot be sorted if cells are ____________. | merged |
| Levels can be added, deleted, and _________ when sorting data. | copied |
| When the orientation to sort data is from top to bottom, the levels will list the names of the ________ | columns |
| When data is sorted with an orientation from left to right, the levels will list the names of the __________. | rows |
| When using Sort Order, on what list will you find the days of the week and months as options? | custom list, custom |
| Which of the following are criteria on which you can sort data? | values, cell icon, cell color & font color |
| After data is filtered, what happens to rows that do not pertain? | They are hidden |
| What does Auto Filter use as the filtering criteria? | header row |
| Which of the following can be done to AutoFilter results? | filter by additional criteria, sort A to Z, filter by Top 10, & sort by color |
| Which of the following tasks can AutoFilter perform? | compare a value agains something else, compare ranges above and below an amount, evaluate actual samples & evaluate multiple values |
| ____________ are single-row headings of subdivided data that are collapsed. | Outlines |
| How should grouping and outlining of data in a workbook be done? | with the final report |
| To _________ the group, click the plus box symbol | expand |
| Clicking the minus box symbol will ____________ the group | collapse |
| To remove the outline entirely, on the DATA tab, click the ___________ button, then Clear Outline from the menu | ungroup |
| Which tab contains the Subtotal Command? | Data |
| Subtotal functions include which of the following? | count, maximum, product, sum |
| Subtotals can be added at each change in a criteria and do which of the following? | add subtotals to multiple columns, replace current subtotals, add page break between groups, & change cell color |
| Using the Format as Table dialog box, what you can set on the table besides the headers? | size |
| Format as Table can be found under what tab? | Home |
| Which of the following options do the Table Style Options include? | Banded Rows, Banded Columns, Filter Button & Total Row |
| Which tab appears when a style is applied to a table? | Design |
| To remove a style from a table, select the ___________ tab, expand the ___________ group, and click Clear | Design, Table/Quick Styles |
| The default table style includes banded ___________. | rows |
| A formal table name can be changed on the ____________ tab in the Properties group | Design |
| In the Table Style Options, use _____________ to add a row to the bottom and give each column a drop-down menu to add other subtotals or formulas | Total Row |
| On which tab can you find Insert Cells to insert a row or column? | Home |
| Which character has the exclusive meaning “just the value of the column in the same row as this formula”? | @ |
| When Remove Duplicates compares fields selected in the dialog box, which row does it remove? | the lowermost row without reconciling contents |
| Remove Duplicates will remove all duplicated information in a row if ____________ fields are selected for comparison. | all |
| A ____________ is a recorded series of steps that can be repeated | macro |
| In order to display the necessary tab to record macros, click the File tab, click Options, click Customized Ribbon, check the ____________ box, and click OK | Developer |
| Record Macro dialog box is where you do which of the following? | name a macro, assign a shortcut key, & store the location macro |
| The icon located at the bottom of the Excel window that looks like a worksheet with a dot in the upper left corner will do what? | start recorfing a new macro |
| Excel will only save macros in a workbook using which file type? | xlsm |
| Macro Security will warn you whenever an opened workbook contains macros if the Trust Center setting is set to what? | Disable all macros with notification |
