Upgrade to remove ads
Terms in this set (28)
What does parse data mean?
What is a character that separates data entries from one another?
A character that encloses values in your data file is known as a ____________.
________________ file types have characters such as commas or tabs to separate each field.
What file types are aligned in columns with spaces between each field?
Common ____________ include Tabs, Semicolons, Commas, and Spaces
What process ensures that data gets entered correctly?
What tab do you select to import information from another file?
When data is imported to an Excel file, what is the default data format?
What data format converts numeric values to numbers, date values to dates, and all remaining values to text?
To _______ data to worksheets means to import data to existing worksheets.
___________ ensures that data gets entered correctly before it gets processed incorrectly.
_____________ elements are referred to when executing a function.
Data cannot be sorted if cells are ____________.
Levels can be added, deleted, and _________ when sorting data
When the orientation to sort data is from top to bottom, the levels will list the names of the ________
When data is sorted with an orientation from left to right, the levels will list the names of the __________.
When using Sort Order, on what list will you find the days of the week and months as options?
custom list, custom
___________ are single-row headings of subdivided data that are collapsed.
To ________ the group, click the plus box symbol.
Clicking the minus box symbol will ____________ the group
To remove the outline entirely, on the DATA tab, click the _________ button, then Clear Outline from the menu.
The default table style includes banded ___________________.
A formal table name can be changed on the ________________ tab in the priorities group.
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.
A ___________ is a recorded series of steps that can be repeated.
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
Excel will only save macros in a workbook using which file type?
You might also like...
Excel Chapter 4: Formatting, Organizing, and Getti…
Excel Chapter 4 Test
MGSC Chapter 4 vocab
CPSC chapter 5
Other sets by this creator
Access 13 & 14
Access 11 & 12
Access 9 & 10
Other Quizlet sets
Fshn 120 - Exam 3
Medieval Period (1066-1485)
Media Analysis Final Exam
bio: unit 1