Excel - Chapter 10 Latest Update 2023 Rated A+

Document Content and Description Below

Excel - Chapter 10 Latest Update 2023 Rated A+ Comma separated values (CSV) file ✔✔A file that uses commas to separate text into columns CONCATENATE function ✔✔A function that joins two or ... more text strings into one text string Delimiter ✔✔A character used to separate data in a text tfile Element ✔✔An XML component, including the start tag. an end tag, and associated data End tag ✔✔An XML code indicating an element's ending point and name eXtensible Markup Language (XML) ✔✔A data-structuring standard for sharing data across applications, operating systems, and hardware Fixed-width text file ✔✔A file that stores data in columns that have a specific number of characters designated for each column Flash Fill ✔✔A feature that fills in data or values automatically based on one or two examples you enter Importing ✔✔The process of inserting data from one application or file into another LOWER function ✔✔A function that converts all uppercase letters to lowercase PROPER function ✔✔A function that capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter Refresh ✔✔The process of updating data in Excel to match current data in the external data source Start tag ✔✔An XML code indicating an element's starting point and element's name SUBSTITUTE function ✔✔A function that substitutes new text for old text in a text string Tab-delimited file ✔✔A file that uses tabs to separate text into columns Tag ✔✔A user-defined marker that identifies the beginning or ending of a piece of XML data Text file ✔✔A file that contains letters, numbers, and symbols only; it does not contain formatting, sound, or video UPPER function ✔✔A function that converts text to uppercase letters Web query ✔✔A data connection that links an Excel worksheet to a particular data table on a Web page [Show More]

Last updated: 1 year ago

Preview 1 out of 3 pages