front 1 A ____ is a prewritten formula that is built into Microsoft Excel | back 1 Function |
front 2 When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra | back 2 Operations |
front 3 Cell References that automatically adjust in a copied and pasted formula are called ____ references | back 3 Relative |
front 4 One popular metaphor for visualizing a file system is an upside-down _____ | back 4 Tree |
front 5 When using the PMT function to calculate monthly loan payments, the interest rate and the number of payments should be based on the interest rate per month and the total ___ to pay off the loan | back 5 Months |
front 6 The ___ options button lists error-checking options following the assignment of an invalid formula to a cell | back 6 Trace Error |
front 7 The ___ function calculates the interest rate charged or received during each payment period | back 7 RATE |
front 8 The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range | back 8 AVERAGE |
front 9 A table name can include | back 9 Numbers, letters, and underscores |
front 10 The ____ function determines the lowest number in the range | back 10 MIN |
front 11 You can use the ____ to check which cells are referenced in the formula assigned to the active cell | back 11 Range Finder |
front 12 Conditional formats in Excel | back 12 Icon sets, cell highlighting, and data bars |
front 13 The ____ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent | back 13 Accounting number format |
front 14 This part of the Excel screen displays the contents of the active cell | back 14 Forumla Address Bar |
front 15 In Excel, _____ view allows you to create or modify a worksheet while viewing how it will look in printed format | back 15 Page Layout |
front 16 To start a new line in a cell, press the ____ keys | back 16 ALT + ENTER |
front 17 The _____ function calculates the amount paid into an investment or loan during each payment period | back 17 PMT |
front 18 In Excel, a cell reference that remains constant when a formula is copied down a column is referred to as an _____ reference | back 18 Absolute |
front 19 Excel's ____ view allows you to modify a worksheet's print layout, providing a method to quickly adjust the breaks between pages | back 19 Page Break Preview |
front 20 A ______ chart provides a simple way to show trends and variations in a range of data within a single cell | back 20 Sparkline |
front 21 You should use a ____ chart to show the relationship or proportion of parts to a whole | back 21 Pie |
front 22 A ____ is a separate sheet in a workbook that contains only a chart | back 22 Chart Sheet |
front 23 A pie chart with one of more slices offset is called a ___ | back 23 Exploded Pie Chart |
front 24 If the formula in a cell references a range of cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message | back 24 =REF! |
front 25 ____ order arranges labels in alphabetical order, from A to Z | back 25 Ascending |
front 26 Information created in Excel is saved in a file called a _____ | back 26 Workbook |
front 27 To deselect a worksheet group, you can right-click the sheet tab of a sheet in the group and then click ___ on the shortcut menu | back 27 Ungroup Sheets |
front 28 Which of the following formulas contains an absolute cell reference | back 28 =$B$8 |
front 29 The ____ function is useful when you want to assign a value to a cell based on a logical test | back 29 IF |
front 30 ____ refers to cells not wide enough to display the entire numeric entry | back 30 ##### |
front 31 When you set up an Excel worksheet, you should use cell references in formulas whenever possible, rather than ___ values | back 31 Constant |
front 32 _____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell | back 32 Goal |
front 33 The ____ function is a logical function that returns a TRUE value if all of the logical conditions are TRUE and a false value if all the logical conditions are false | back 33 AND |
front 34 When you retrieve a particular value from a lookup table, the ____ value is the value you are trying to find | back 34 Lookup |
front 35 The top level of the file system in PC-nomenclature is known as the _____ | back 35 Root Directory |
front 36 The default cell format in Excel is ____ | back 36 General |
front 37 After you filter a column, the ___ Filter command becomes available so you can remove the filter and redisplay all the records | back 37 Clear |
front 38 When a worksheet group is selected, the ___ includes text to indicate the sheets are in fact grouped | back 38 Title Bar |
front 39 The _____ function is a logical function that returns a TRUE value if any of the logical conditions are true and a FALSE value if all the logical conditions are FALSE | back 39 OR |
front 40 When Excel automatically fills the rest of a table column with a formula entered into an empty table column, this is referred to as a ____ column | back 40 Calculated |
front 41 Microsoft Excel's Goal Seek changes the ____ values to produce the resulting values you seek to determine | back 41 Input |
front 42 One way to display formulas in Excel is by pressing this key combination | back 42 Ctrl + ` |
front 43 The COUNT function _____ | back 43 Counts the number of cells that contain numbers within the selected range |
front 44 When copying or moving cells, if data already exists in the destination cells, Excel ___ | back 44 Replaces the contents |
front 45 This type of excel chart is used to depict trends and change over time intervals | back 45 Line |
front 46 This part of the excel screen displays the cell reference of the active cell | back 46 Name Box |
front 47 By default, files created with Excel 2013 are saved with the ____ extension | back 47 .xlsx |
front 48 A _____ is a group of adjacent cells in an Excel worksheet | back 48 Range |
front 49 Which of the following chart types is characterized as always having one data series? | back 49 Pie |
front 50 There are 3 general types of cell entries that a user can enter into the cells of an Excel worksheet. These include: texts, numbers, and _____ | back 50 Formulas |