click below
click below
Normal Size Small Size show me how
Excel Unit A
| Question | Answer |
|---|---|
| An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data. | spreadsheet |
| In Excel, the electronic spreadsheet you work in is called a | worksheet |
| In Excel, a worksheet is contained in a file called a ____. | workbook |
| You can use predesigned, formatted files called ____ to create new worksheets quickly | templates |
| You can use a spreadsheet to ____ by using variable values to investigate and sample different outcomes. | create what-if data scenarios |
| ____ below the worksheet grid let you switch from sheet to sheet in a workbook. | sheet tabs |
| You can use ____ to move around in a document that is too large to fit on the screen at once. | scroll bars |
| All Excel formulas begin with the ____. | equal sign (=) |
| The Excel operator for exponent is ____. | carat (^) |
| The Excel operator for division is ____. | front slash (/) |
| A(n) ____ is an entry in a cell that contain text such as “2011 Sales” or “Travel Expenses.” | label |
| A(n) ____ is a built-in formula that uses arguments to calculate information. | function |
| Excel recognizes an entry as a value if it is a number or it begins with ____. | +, $, = |
| You can use the ____ key(s) on the keyboard to navigate a worksheet. | arrow |
| To quickly jump to the first cell in a worksheet press ____. | CTRL Home |
| To move one screen to the left press ____. | Alt Page Up |
| To quickly jump to the last cell in a worksheet press _____. | CTRL END |
| In a worksheet, the ____ is called the formula prefix | equal sign (=) |
| ____ operators perform mathematical calculations such as adding and subtracting. | Arithmetic |
| Possible paper orientations for printing a worksheet are landscape and ____. | portrait |
| The ____ option helps fit the data on a single page without making changes to individual margins | Scale to Fit |
| You can use the ______________ slider on the status bar to enlarge your view of specific areas of your worksheet. | Zoom |
| The Undo button allows you to reverse up to _________ previous actions, one at a time. | 100 |
| Any time you use a worksheet to ask the question “what if?” you are performing ____________________ analysis. | What if |
| The cell in which you are working is called the ____________________ cell. | active |
| A(n) ____________________ is an equation in a worksheet. | formula |
| Clicking the ____________________ button sums the adjacent range above or to the left. | sum |
| A dark rectangle that outlines the cell in which you are working | cell pointer |
| Provides a brief description of the active command or task in progress | status bar |
| Identified by the coordinates of the intersecting column and row | cell address |
| Displays the active cell address | Name box |
| Work done in a virtual environment | cloud computing |