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 Module 3
| Question | Answer |
|---|---|
| Cell references in a formula are called | Assumptions |
| When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values | Constant |
| The __ Auto Fill Option that fills the destination area using the format of the source area; no content is filled. | Fill Formatting Only |
| Which of following Auto Fill Options menu options is the same as the Fill Series Option? | Fill Months |
| Which of the following cell contents is extended to Qtr 3, Qtr 4, and Qtr 1 by dragging the fill handle ? | Qtr 2 |
| Which of the following is an extension of the fill pattern Sunday, Tuesday ? | Thursday, Saturday, Monday |
| The Increase Indent Button indents the contents of a cell to the right by __ spaces each time you click it. | two |
| The Copy Button copies the content and format of the source area to the Office____, temporary storage area in the computer's memory. | Clipboard |
| In the context of copying a range of cells to a nonadjacent location, an alternative to clicking the Paste Button is to press the ___ key. | ENTER |
| Using the mouse to move or copy cells is called ____. | drag and drop |
| If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ___ error message | #REF! |
| Which of the following is not a valid format symbol ? | semi-colon (;) |
| When assigned to a cell, the ___ function returns a number that corresponds to the system date and time beginning with December 31, 1899 | NOW |
| Which of the following formulas contains an absolute cell reference? | =$B$4 |
| The ___ function is useful when you want to assign a value to a cell based on a logical test. | IF |
| Which comparison operator means "not equal to" ? | |
| A ___ IF function is one in which the action to be taken for the true or false case includes yet another IF function | nested |
| A ___ chart provides a simple way to show trends and variations in a range of data within a single cell | sparkline |
| You can press the ___ keys to open the Format Cells dialog box. | CTRL+1 |
| The path to the Format Painter button is____. | (HOME tab l Clipboard group) |
| You should use a __ chart to compare values side by side, broken down by category. | Clustered Column |
| Charts can either be embedded in a worksheet or placed in a separate ____. | chart sheet |
| Which of the following is the path to the Zoom button? | (VIEW tab l Zoom group) |
| When working with a large worksheet, you can split the window into ____ panes | two or four |
| ____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell. | Goal |
| Text in a cell can be rotated counterclockwise by entering a number in the Alignment sheet in the Format Cells dialog box. Which of the following are valid values for that number? | 15, 90 |
| If the contents of a cell copied using the fill handle is Sunday and Thursday, what are the next three values of the extended series ? | Thursday, Saturday, Monday |
| Following the insertion of a row, the Insert Options button lets you select from which of the following options? | Format Same As Above, Format Same As Below, and Clear Formatting |
| Which of the following are formatting symbols? | Dollar Sign ($), Comma (,), and Percent Sign (%) |
| The arguments in an IF function are ___. | logical_ test, value_if_true, and value_if_false |
| Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees. | False |
| The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it. | False |
| The Linked Pictures option in the Paste Options gallery copies an image of the source area as a picture so that a change to the cells in the source updates the picture in the destination area | True |
| A date stamp shows the date a workbook, report or other document was created or the time period it represents. | True |
| A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area. | True |
| A cell reference with only one dollar sign before either the column or the row is called an absolute reference | False |
| The <= comparison operator means less than or equal to | True |
| The path to the Logical button is (FORMULAS Tab l Function Library group). | True |
| A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function. | True |
| You can nest IF functions as deep as you want, but after you get yet beyond a nest of three IF functions, the logic becomes difficult to follow. | True |
| Excel includes four types of sparkline charts: line, column, win/loss, and stock. | False |
| You can select nonadjacent ranges using the SHIFT key. | False |
| The underline format underlines the entire cell, not just the characters in the cell. | False |
| The range of entries that identifies the major groups for a clustered column chart are called the category names. | True |
| When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns | False |
| You can click the Logical button (FORMULAS tab l Function Library group) and click IFERROR to insert the IF function. | False-IF |
| You can press the CTRL+ACCENTMARK(`) keys to display the formulas in a worksheet. | True |
| Panes created using the vertical split bar scroll together HORIZONTALLY | False- Vertically |
| EXPLODING worksheet columns and rows is a useful technique for viewing large worksheets that extend beyond the window. | False- Freezing |
| _____________________ are values in cells that can be changed to determine new values for formulas. | Assumptions |
| The ___________ option on the Auto Fill Options menu fills the destination area with contents using the format of the source area and does not create a series | Copy Cells |
| The __________ option on the Auto Fill Options menu fills the destination area with a series that uses the format of the source area. | Fill Series |
| The _______________ option on the Auto Fill Options menu fills the destination area using the format of the source area; no content is copied unless the fill is a series. | Fill Formatting Only |
| The _______________ option on the Auto Fill Options menu fills the destination area with the contents but without the formatting of the source area. | Fill Without Formatting |
| The _______________________ option on the Auto Fill Options menu fills the destination area with a series of months using the format of the source area. | Fill Months |
| ___________________ is the default option that Excel uses to fill an area with the Auto Fill Options menu. | Fill Series |
| When the Paste Options button is visible, you can use _________________________ to access the paste commands available in the Paste Options gallery. | Keyboard Shortcuts |
| You know Excel is in copy mode when a small plus sign appears next to the block arrow mouse pointer during a ____________ operation. | drag and drop |
| Excel displays the error message _______ in cells to indicate a cell reference error in a formula. | #REF! |
| An _______ cell reference instructs a paste operation to keep the same cell reference as it copies a formula from one cell to another. | absolute |
| The _______________ function is useful when you want to assign a value to a cell based on a logical test. | IF |
| You can specify the style and color for the parts of a sparkline chart by selecting a style in the Styles group on the _____________________. | SPARKLINE TOOLS DESIGN tab |
| Excel allows you to ______________________ the titles so that the titles remain on the screen no matter how far down or to the right you scroll. | freeze |
| A sensitivity analysis is another name for a ____________ analysis. | what-if |
Created by:
TaylorJG