Extract information with the CELL and INFO functions

- [Instructor] Excel has a number … of different information functions. … Tow of the are called Cell and Info. … That's the name of the worksheet we're looking at … in our chapter 10 exercise file. … If you go to the Formulas tab in the ribbon, … off to the right you'll see More Functions, Information. … And we'll be covering some of these in follow-up movies. … Here's the function, Cell, the we're about to look at. … It turns information about the formatting location … or contents of the first cell, and on and on and on. … Also, Info, returns information … about the current operating environment. … These two functions are probably not widely used. … On the other hand, they could be valuable … in providing certain kinds of documentation … or possibly of use when auditing Excel. … Let's take a look at, first, Cell. … Left parenthesis, we've got lots of choices here. … And by the way, these are also displayed over in column B. … If we were to choose here, we don't see a description … of what's going on. …