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 CGS2518
Mod 1 (30q) Mod 2 (30q) Mod3 (30q)
| Question | Answer |
|---|---|
| Excel displays a _______ to help you resolve errors. | Smart Tag |
| Formula AutoComplete is a shortcut for entering _______. | Formula AutoComplete is a shortcut for entering functions. |
| The _______ argument of the PMT function is the present value of the loan or how much is owed now. | PV |
| t cell A1 contains the location of employee, and cell B1 contains employee's current salary, which formula could be used to calculate a 5% increase for employees working from ny or sf with all other employees receiving no salary increase? | =IF( OR( A1="NY", A1="SF"), B1*5%, 0 ) |
| For which values is the formula =AND( A1>5, OR( A2>5, A3<5 ) )true? | A1 = 6, A2 = 6, A3 = 6 |
| A logical function is a function that works with values that are either ____. | true or false |
| =IF(G22="x", SUM(H22:J22)," ") will display ______ if G22 is not equal to "x". | a blank cell |
| _______ allows you to manipulate where page breaks occur when the worksheet is printed. | Page Break Preview view |
| If your worksheet has both a header row and a column of labels in the first column use the _______ option to freeze the worksheet at the selected cell, so the rows above the cell and the columns to the left of the cell are always visible. | Freeze Panes |
| When an Excel worksheet is split, the panes _______ independently of the other(s), allowing you to see different areas of the worksheet at the same time. | scroll |
| The _______ lists all the named ranges used in your workbook. | Name Manager |
| The IF function can return either a _______ value or display a text string. | numerical |
| Cells that include potential errors are marked with a green _______. | triangle |
| Cell A1 contains the cost of a concert ticket. purchasing adds a 20% convenience fee to the cost, plus a flat $5 service fee. ex) a $100 face value ticket would cost a total of $125 with fees. Which formula would be used to compute the total cost? | A1 * 20% + 5 + A1 |
| To access the option to hide a worksheet, first select the worksheet, then click the format button in the _______ group of the Home tab, and point to Hide & Unhide. | Cells |
| To remove all the manual page breaks at once, on the Page Layout tab, in the Page Setup group, click the Breaks button, and click _______. | Reset All Page Breaks |
| To return the worksheet to a single view from a split view, click the _______ button a second time. | Split |
| A named range refers to a _______ in your formula. | range of cells |
| The _______ argument is the text string or value in the IF function that will be displayed or the formula that will be calculated if the Logical_test argument is true. | Value_if_true |
| The _______ argument of the PMT function is the future value of the loan. Excel assumes a value of 0 unless you include the argument and specify a different value. | FV |
| By default, all the worksheet tabs in Excel are the color _______. | white |
| In Excel you can split the worksheet view into _______ or _______ panes. | two; four |
| To move or copy more than one non-consecutive worksheet, press _______ on the keyboard and click the worksheets you want to copy or move. | Ctrl |
| When you select a cell that contains a formula, the formula bar displays the _______. | formula |
| The easiest way to use AutoFill is to use the _______ tool. | Fill Handle |
| A cell's address, its position in the workbook, is referred to as a _______ when it is used in a formula. | cell reference |
| A(n) _______ reference is a cell reference that adjusts to the new location in the worksheet when the formula is copied. | relative |
| When you select a cell that contains a formula, the cell displays the _______. | result |
| _______ display a graphic in the cell representing the cell value in relation to other cell values. | Icon sets |
| The Undo command allows you to _______ the last action you performed. | reverse |
| To remove the contents of a cell without removing the cell from the structure of your workbook, use one of the _______ commands. | Clear |
| Splitting a cell back into the original cells uses a method called _______. | Unmerge Cells |
| _______ lets you merge cells together without centering the data. | Merge Cells |
| A _______ is any sequence of cells with a recognizable pattern. | data series |
| The General number format _______ numbers in the cells but does not maintain a consistent number of decimal places or commas. | right-aligns |
| The _______ is the data entry area directly below the Ribbon and above the worksheet grid. | Formula bar |
| In Excel, the Find and Replace commands not only find text but also _______ in values and formulas in a single worksheet or across an entire workbook. | numbers |
| _______ clears all cell contents and formatting and deletes any comments or hyperlinks attached to the cell. | Clear All |
| Use the _______ and Input styles to highlight cells used in formulas. | Calculation |
| You can right-click a cell with formatting you want to copy and then select the Format Painter to activate it from the _______ toolbar. | Mini |
| Use the _______ paste option to paste the content, including formulas, but none of the formatting into a worksheet. | Formulas |
| By default, the Percent Style button on the Ribbon displays _______ places to the right of the decimal point. | zero |
| When you enter a formula with more than one mathematical operation, the formula is not necessarily calculated left to right because Excel calculations follow the mathematical rules called the _______. | order of operations |
| _______ are preprogrammed shortcuts for calculating complex equations, such as the monthly payment amount for a loan. | Functions |
| The content of a cell or range of cells that is _______ is removed from the selected cell. | cut |
| A _______ refers to a set of characters of a certain design. | font |
| The Fill Color button is also available from the _______ when you right-click a cell. | Mini toolbar |
| The _______ paste option pastes only the values, not the underlying formula or cell formatting. | Values |
| You can sort _______ by text, by date, or by values. | alphabetically |
| Pie chart values are a visual "_______" of the pie. | slice |
| In a column chart, values in the cell range which are plotted along the vertical (y) axis are known as _______. | data points |
| In a PivotTable, Excel will place fields with numeric data in the Values section and text or date fields in the _______ section. | Rows |
| A _______ is a special report view that summarizes data and calculates the intersecting totals. | PivotTable |
| The chart _______ provides a key so you know which data point or data series is represented by each color in the chart. | legend |
| Certain data analysis tools, including creating subtotals and grouping outlines, are not available if data are formatted as an Excel __________. | table |
| When selecting chart data to filter, use the _______ to determine how the chart will look with each selection you make. | Live Preview |
| To hide elements in a chart, click the Chart Elements button and _______ each element you wish to hide. | uncheck |
| Use the check boxes in the _______ group to customize the table formatting by adding or removing banding for rows or columns. | Table Style Options |
| A method used to sort is to _______ any cell in the column you want to sort by, point to Sort, and then select the option you want. | right-click |
| If you use the Move Chart dialog to move a chart to a new sheet, Excel creates a _______. | chart sheet |
| A _______ is a special report view that summarizes data and calculates the intersecting totals. | PivotTable |
| _______ represent a series of data values as an individual graphic within a single cell. | sparklines |
| In a(n) "_______" pie chart, each slice is slightly separated from the whole. | exploded |
| To change the calculation type for the current field in a PivotTable, make the selection in the _______ dialog. | Value Field Settings |
| _______ display data values for each data marker. | Data labels |
| If you want to convert a table to a range, you can _______ anywhere in the table, point to Table, and select Convert to Range. | right-click |
| One method of changing a chart type is to _______ in the chart area and select Change Chart Type…. | right-click |
| To hide or show chart elements and control their appearance and position, use the _______ tab. | Chart Tools Design |
| _______ charts are like column charts turned on their side. | Bar |
| To remove duplicate data that are not formatted as an Excel table, use the _______ command from the Data tab, Data Tools group. | Remove Duplicates |
| _______ charts show the movement of values over time. They work best when data trends over time are important. | Line |
| In the Create Sparkline dialog, the _______ box refers to the cell range where you want the Sparklines to appear. | Location Range |
| To remove filtering, click the _______ button. | Clear Filter |
| Quick Styles and color schemes are available from the _______ button that appears near the upper right corner of the chart when it is selected. | Chart Styles |
| If you have data formatted as a table, you can add a _______ to quickly calculate an aggregate function such as the sum or average of all the values in the column. | Total row |
| If your data are formatted as a _______, you can click the arrow at the top of the column and select the sort order you want. | table |
Created by:
Avi0