In this video, staff author Jess Stratton shows users how to work with individual cells, such as formatting text and data type, and using preset styles.
- [Instructor] Let's go over some basic cell techniques…that you'll be using on a day to day basis.…The first thing that you might want to do is…format your cells.…I'll click and drag to highlight them all.…On the home ribbon tab, here's where you…can change the data type.…Right now it's set to number…but you can use the dropdown list…and change to anything, such as currency,…short date, long dates, times,…percentages, fractions.…You can also change what type of currency,…where you want the decimal point to go,…and if you want the zeroes at the end…of the dollar signs, or not.…
If you prefer to work with a dialog box…you can click the down arrow to the right…of the number format pane…and it's going to bring up a dialog box…where you can work with more settings.…For example, in the currency area…you can quickly set the amount of decimal places…you want, what kind of currency symbol you're using,…and how you want negative numbers portrayed.…You'll find that you get different options…for each data type that you choose.…
- Identify which option allows you to download all of your Google files at once.
- Explain what happens when you double-click the border on the right side of a column.
- List the formula that will copy the contents of one cell into the current cell.
- Identify the location where an excel file needs to be stored to work on it simultaneously with another user.