| Question | Answer |
| A spreadsheet software program allows you to ____.
A. produce worksheets
B. organize data
C. Calculate data
D. both A and C
E. A, B & C | E. A, B & C |
| The active cell is identified ____. | Cell Pointer |
| The intersection of a column and row is called a ____. | cell |
| The Full Screen option ____.
a. hides the toolbar and Formula bar
b. is found on the Options menu
c. expands the worksheet to fill the screen
d. both A and C
e. A, B, and C | d. both A and C |
| ______ shows options for the task at hand | task pane |
| The ______ bar displays the insert function button, an area that displays the contents of the active cell and the the name box | Formula |
| To move to the first cell in the current row, press ____. | Home |
| To correct data after it is entered, ____.
A. Edit information on the formula bar
B. Delete cell, re-enter text
C. F2
D. All the above | D. All the Above |
| The formula =E6+(F6-G6) directs the worksheet to | subtract two numbers first, then add the total to the first number |
| To quickly enter sequential numbers, times, or dates in a column or row, you would use the following feature: | fill handle |
| You can change column width easiest by ____ the column heading. | double-clicking |
| The ____ feature is used to funnel out the information that you don't want temporarily | AutoFilter |
| ________ happens when text has been removed and put on the clipboard. | Cut |
| _______ is duplicating the information to be placed into another document. | Copy |
| Placing text that has been duplicated or copied from another area is known as | Paste |
| Which button do I use to show more decimals | Increase decimal button |
| What type of cell reference does not change when it is copied? | Absolute |
| A button used to add a column of numbers | Autosum |
| The fx button on the formula toolbar is used for ____ | Accessing other Excel functions |
| A panel that appears on the right side of your screen that can be used for many purposes | Task bar |
| How many items will the clipboard hold? | 24 |
| T or F: I can delete any item from the clipboard? | True |
| What is the order of operations | Parenthesis, Exponets, Multiplication/Division, Addition/Subtraction |
| How can you add before you multiply or divide? | Use Parenthesis |
| Resizing a column happens how? | Double-Click; Format, Column, Width; Drag it wider |
| How can I insert a row? | Edit, insert, row; right-click, insert |