Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Excel Lesson 1-4
| Question | Answer |
|---|---|
| The name of each worksheet appears in the ____ at the bottom of the worksheet window. | sheet tab |
| ____ of the worksheet appear vertically and are identified by letters at the top of the worksheet window. | columns |
| ____ appear horizontally and are identified by numbers on the left side of the worksheet window. | rows |
| Numbers that extend beyond a cell’s width appear as ____ in the cell. | ##### |
| Excel ____ all numbers. | right align |
| By default, the ____ theme is applied to each workbook. | office |
| You can remove the borders from a selected cell by clicking ____ in the border style menu. | no border |
| On the Home tab of the Ribbon, the ____ group includes buttons for inserting and deleting rows, columns, and cells. | cells |
| Worksheets printed in ____ orientation are wider than they are long. | landscape |
| A ____ is text that prints in the top margin of each page. | header |
| A ____ is text that prints in the bottom margin of each page. | footer |
| The formula = E6/4 is an example of a(n) ____ operation. | division |
| The sequence used to calculate the value of a formula is called the ____. | order of evaluation |
| You can press the ____ key to cycle a selected cell reference from a relative reference to an absolute reference. | F4 |
| Three types of cell references are used in formulas that do NOT include ____. | relational |
| If you were using relative cell references, the formula =A3+A4 would change to ____ when copied from cell A5 to cell B5. | =B3+B4 |
| A grid of rows and columns in which you enter text, numbers, and the results of calculations. | spreadsheet |
| he worksheet that is displayed in the work area. | active worksheet |
| A computerized spreadsheet. | worksheet |
| Identifies the cell, and is formed by combining the cell’s column letter and row number. | cell reference |
| The file used to store worksheets. | workbook |
| A symbol that indicates the type of calculation to perform. | operator |
| A constant (text or number) or cell reference used in a formula. | operand |
| Adjusts to its new location when copied or moved. | relative cell reference |
| Does not change when copied or moved to a new cell. | absolute cell reference |
| Cell reference that contain both relative and absolute references. | mixed cell reference |
| a group of selected cells is called a(n) _____________ | range |
| ____________ copies a cell’s contents and/or formatting into an adjacent cell or range | filling |
| When you __________ panes, you select which rows and/or columns of the worksheet remain visible on the screen as the rest of the worksheet scrolls. | freeze |
| Ctrl +C key | copy |
| Ctrl + V key | paste |
| Ctrl + X key | cut |
| consist of the cells and ranges designated for printing. | print area |
| =4*D5 is an example of a _____________ operation. | multiplication |
| If adding long columns or rows of numbers, the _________ button makes this operation simple. | sum |
| A ______________ is the equation used to calculate values in a cell. | formula |
| Each formula begins with a(n) _________ | equal sign |
| when formulas with mixed cell references are copied, the row or column references preceded by a ______________ do not change. | dollar sign |
| =B3^3 is an example of a(n) ___________ operation. | exponentation |
Created by:
rweynand