Excel Appendix A

What would be the result if you use custom format of mmm yyy? EX A19

Jan 2018

compatibility checker

a dialog box that alerts you to any features that are not supported by earlier versions of excel when you save a workbook in an earlier format

custom formats

a format you create to accommodate specific requirements

format codes

a series of symbols used to describe exactly how excel should display a number, date, time, or text string

palceholders

a special character used to represent an individual digit

UPPER function

a text function that converts all letters of each word in a text string to uppercase

PROPER function

a text function that converts the first letter of each word to uppercase, capitalizes any letter that does not follow another letter, and changes all other letters to lowercase

CONCATENATE function

a text function that joins, or concatenates, two or more text values

SUBSTITUTE Function

a text function that replaces existing text with a new text

LEFT function

a text function that returns a specified number of characters from the beginning of a specified text string

LEN function

a text function that returns the number of characters (length) of a specified text string

insignificant zeros

a zero whose omission from a number does not change the number's value

compatibility mode

the mode that keeps a workbook in the older file format, which has the .xls file extension, making the workbook accessible for users who do not have the current version of excel installed

Can you read this function: =IF(LEN([zip])=10,LEFT([zip]),5),[zip]) ? EX A5

this is a IF logical function with the area of true and area of false IF the field of zip has 10 characters, then go to zip and count from the left 5 places, if the field of zip does NOT have 10 characters, then just bring back whatever is in zip field

delimits

to separate; for example, data with a character such as a tab, a semicolon, a column, or a space