Term
|
Definition
|
|
Term
| Move one column to the left. |
|
Definition
|
|
Term
| Move to previous or next sheet in current workbook. |
|
Definition
Ctrl+Page Up
&
Ctrl+Page Down
|
|
|
Term
| Returns to the first cell in the worksheet. |
|
Definition
|
|
Term
|
Definition
| Ctrl+G or the button on the editing group. |
|
|
Term
| Excel allows a maximum of _______ columns in a worksheet. |
|
Definition
|
|
Term
| By default, text is ___-aligned in cells whereas numbers, dates, and times are ___-aligned. |
|
Definition
|
|
Term
|
Definition
| A collection of text ad numbers laid out in a rectangular grid. |
|
|
Term
|
Definition
| Contains an excel chart that provides a visual representation of worksheet data. |
|
|
Term
| What is a cell reference? |
|
Definition
| A number and letter that indicate the row and column location. |
|
|
Term
|
Definition
| Any combination of letters, numbers, and symbols that form words and sentences. |
|
|
Term
|
Definition
| Any numerical value that can be used in a mathematical calculation. |
|
|
Term
|
Definition
| When the rest fo an entry is hidden from view. |
|
|
Term
|
Definition
| Excel tries to anticipate what you may be tryping to amke repetitive typing easier. |
|
|
Term
|
Definition
| Forces tect that extends beyond the border to fit within a cell. |
|
|
Term
| If a number exceeds it cell size you see? |
|
Definition
|
|
Term
| Difference between clearing and deleting. |
|
Definition
| Clearing only removes data, deleting removes the cells as well. |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
| What are the two types of sheets in a workbook? |
|
Definition
| Worksheets and chartsheets. |
|
|
Term
| A group of cells is called a? |
|
Definition
|
|
Term
| A _____ is an expression that returns a value. |
|
Definition
|
|
Term
|
Definition
|
|
Term
| A group fo cells in a single rectangular block of cells. |
|
Definition
|
|
Term
|
Definition
|
|
Term
| Hold this down to select cells in different areas of the worksheet. |
|
Definition
|
|
Term
| A formula is written using _________that combine different values resulting in a single value that si displayed in the cell. |
|
Definition
|
|
Term
|
Definition
|
|
Term
| Where is the page break preview button? |
|
Definition
|
|
Term
| To toggle between formula view and normal view. |
|
Definition
|
|
Term
| What are the two types of ranges in excel? |
|
Definition
| Adjacent and Non-Adjacent Ranges |
|
|
Term
| How do you rename a worksheet? |
|
Definition
| Double click the sheet tab and type the new name. |
|
|
Term
| How are page-breaks indicated in page break preview? |
|
Definition
| A dotted blue border sepearates one page from another. |
|
|
Term
|
Definition
| The specific design of a set of characters, including letters, numbers, punctuation marks, and symbols. |
|
|
Term
|
Definition
| A collection of of formats for text, colors, images, and graphical effects applied throughout a workbook. |
|
|
Term
|
Definition
| The process of changing a workbook's appearance by defining the fonts, styles, colors, and decorative features. |
|
|
Term
| How many standard colors are there? |
|
Definition
|
|
Term
| What is the difference between the serif and the sans serif fonts? |
|
Definition
| Serif includes delicate strokes, whereas sans serif does not include them. |
|
|
Term
| ______ colors are the ___ colors that belong to a workbook's ______. |
|
Definition
|
|
Term
| Why are dates right aligned in a worksheet by default? |
|
Definition
| Excel treats dates and time as numbers. |
|
|
Term
| What is the general number format? |
|
Definition
Displays values exactly as they are typed by the user.
|
|
|
Term
| What three tools can you use to copy formats? |
|
Definition
| Format painter, paste special and the paste options buttons. |
|
|
Term
| What is a conditional format? |
|
Definition
|
|
Term
|
Definition
|
|
Term
| Six table style options you can turn on and off? |
|
Definition
|
|
Term
| Difference between an cell style and a table style? |
|
Definition
|
|
Term
| Two methods of applying the same format t different ranges. |
|
Definition
|
|
Term
| Where can you define the page margins? |
|
Definition
| GO to the page layout tab and then press the margns button. |
|
|
Term
|
Definition
|
|
Term
| A/an ______ reference is interpreted in relation to the location of the cell containing the formula. |
|
Definition
|
|
Term
| A/an absolute reference fixed when the cell formula is copied to a new location and has an $ in front of the column letter and the row number. |
|
Definition
|
|
Term
| ______________ argumentsfs (in bold)are needed to return a value. |
|
Definition
|
|
Term
| The _______ function return s the sum of the values in the range. |
|
Definition
|
|
Term
| The _______ function returns the minimum value in the range. |
|
Definition
|
|
Term
| The _______ function returns the average value of the range. |
|
Definition
|
|
Term
| The _______ function returns the maximum value in the range. |
|
Definition
|
|
Term
| The __________ are not required for the function to return a value. |
|
Definition
|
|
Term
| Each chart has a ____ ____, which is the range that contain the data to display in the chart. |
|
Definition
|
|
Term
| What does the TODAY function do? |
|
Definition
|
|
Term
| An ______ is a logical function that tests a condition and then returns one value if the condition is true and another value if the condition is false. |
|
Definition
|
|
Term
| What does the fill handle do? |
|
Definition
| Copies the formating and content into another selected range. |
|
|
Term
| A ____ function inserts or calculates dates and times. |
|
Definition
|
|
Term
| An Excel ________ is a spreadsheet written or tailored to meet specific needs. |
|
Definition
|
|
Term
| Defined names can include as many as ____ characters |
|
Definition
|
|
Term
| A ______ _______ indicates that the cell contains a comment. |
|
Definition
|
|
Term
| The Defined Names group can be found in the _______ tab |
|
Definition
|
|
Term
| The data validation button can be found in the _____ tab |
|
Definition
|
|
Term
| To protect a worksheet, go to the _____ group of the _______ tab |
|
Definition
|
|
Term
(Keyboard short cut)
Current Date |
|
Definition
|
|
Term
|
Definition
|
|
Term
| Header row contains ______ names |
|
Definition
|
|
Term
| Values within () are called ________ |
|
Definition
|
|
Term
|
Definition
|
|
Term
(Keyboard short cut)
Auto fill selected cells |
|
Definition
|
|
Term
| The fields that you use to order data are called ______ fields |
|
Definition
|
|
Term
| Each row represents a _______ |
|
Definition
| Record of data entered by the user. |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
| A quicker and easier way to filter a PivotTable or PivotChart is by using a |
|
Definition
|
|
Term
| Freeze Pane is located in the _____ tab |
|
Definition
|
|
Term
| _______ and left click to select a range of worksheets. |
|
Definition
|
|
Term
| ______ click the fill handle to auto fill |
|
Definition
|
|
Term
| When you select any cell, it becomes the |
|
Definition
|
|
Term
| The split button is in the _____ tab |
|
Definition
|
|
Term
| To rename a table, go to table name located in the ________ group of the Design tab |
|
Definition
|
|
Term
| A worksheet _____ is a collection of two or more selected worksheets |
|
Definition
|
|
Term
| What is the PMT function used for? |
|
Definition
Calculates the payment for a loan based on constant payments and a constant interest rate. |
|
|
Term
True or False?
Subtotals can be done in a table? |
|
Definition
|
|
Term
| An _____________ is an object in a worksheet. |
|
Definition
|
|
Term
| A data source is a collection of ____ _____which is a range of values that is plotted as a single unit on a chart. |
|
Definition
|
|
Term
| A _________________ is a rectangular area that indicates the data and markers associated with the data series. |
|
Definition
|
|
Term
| _____ marks identify the units t regular intervals on the chart axis. |
|
Definition
|
|
Term
| The _____ area contains the chart and all other chart elements inside of it. |
|
Definition
|
|
Term
| Every function has to follow a set of rules or _____ in order to function and return a value. |
|
Definition
|
|
