click below
click below
Normal Size Small Size show me how
Data
Entering and Editing Data in Excel for Microsoft Office 2016
Term | Definition |
---|---|
Planning Your Worksheet | which data belongs in rows and which will be better in columns |
Why should you decide beforehand which data belongs in rows and which will be better in columns. | To avoid needing to make changes later. |
What are labels used for? | They identify the purpose of the worksheet, columns, and rows |
Are labels used in calculations? | No |
What ARE labels? | text used for descriptions |
Is a value text or numeric? | numeric |
Why is it important to use labels? | labeling rows and columns will help others make sense of your data you might forget which values were which over time |
To enter information into a cell..... | Click a cell to make it the active cell, and then type your label or data. |
When typing, what appears in the Formula bar? | the contents |
What happens when you are typing, the contents in the Formula bar? | The Cancel and Enter buttons are active. |
To change the cell contents to the typed data............ | click Enter |
To leave the cell as it was when you're typing what do you do? | click Cancel |
The cell displays #####, what happened? | A numeric value that’s too large for a cell was typed. |
Why/How will data extend in to the next cell? | information that was typed is longer than the cell width |
How can the data display entirely? | by changing the column width for the cell |
By dragging a column boundary at the top of the sheet, what is being done? | the column width is being changed |
Boundary is defined as........ | the line between columns or rows |
The pointer changes to a double-headed arrow, what has happened to cause this? | pointing to a column boundary |