click below
click below
Normal Size Small Size show me how
Excel 1-4
Chapter 1-4 Excel
| 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 |