MCIS: Excel Study Guide
Order by
100 terms
Terms | Definitions |
|---|---|
 An Excel ____ allows data easily to be summarized and charted. | worksheet |
| The person or persons requesting the worksheet should supply their requirements in a ____ document. | requirements |
| The first step in creating an effective worksheet is to make sure you ____. | understand what is required |
| To enter data in a cell, you must first select or activate the ____. | cell |
| ____ is/are used to add worksheet, column, and row titles on a worksheet. | Text |
| To cancel an entire entry before entering it into the cell, press the ____ key. | ESC |
| Clicking the ____ box completes an entry. | Enter |
| The ____ is a blinking vertical line that indicates where the next typed character will appear. | insertion point |
| The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry. | AutoCorrect |
| In Excel, a number can contain the characters ____. | 0 1 2 3 4 5 6 7 8 9 + - ( ) , / . $ % E e |
| To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 or you can type ____. | 6E15 |
| A ____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells, as shown in the accompanying figure. | range |
| You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____. | colon (:) |
| The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the ____. | destination area (or paste area) |
| A ____ reference is an adjusted cell reference in a copied and pasted formula. | relative |
| The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting. | Auto Fill Options |
| You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand. | format |
| In general, use no more than ____ font types in a worksheet. | two |
| You can apply the Bold font style by pressing the ____ keyboard shortcut keys. | CTRL + B |
| Combining two or more selected cells into one cell is called ____ cells. | merging |
| What effect does the Accounting Number format have on the selected cells? | Displays cell contents with two decimal places that align vertically |
| What effect does the Comma Style format have on the selected cells? | Displays cell contents with two decimal places and commas as thousands separators |
| How many chart types does Excel offer? | 11 |
| A(n) ____ chart is drawn on the same worksheet as the data. | embedded |
| In the accompanying figure, the ____ identifies the colors assigned to each bar in the chart on a worksheet. | legend |
| ____ properties are associated with all Microsoft Office documents and include author, title, and subject. | Standard |
| The ____ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected numbers in the worksheet. | AutoCalculate |
| Which of the following keys moves the insertion point to the end of data in a cell: HOME, DELETE, END, BACKSPACE? | END |
| The ____ button is located on the Quick Access Toolbar, as shown in the accompanying figure. | Undo |
| Excel remembers the last ____ actions you have completed. | 100 |
| To remove an embedded chart, you should ____ it and press the DELETE key. | click |
| To start a new line in a cell, press the ____ keys. | ALT + ENTER |
| When you enter a two-digit year that is less than 30, Excel changes the year to ____. | 20xx |
| All of the following are valid Excel arithmetic operators except: ^ * % > | > |
| Which of the following calculations multiplies 23 by 0.01: =23%, =23, =23 + .01, =24 - .01 | =23% |
| When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra. | operations |
| When Excel follows the order of operations, the formula, 8 * 3 + @, equals ____. | 26 |
| Point mode allows you to ____, as shown in the accompanying figure below. | select cells for use in a formula using the mouse pointer |
| The adjusted cell references in a copied and pasted formula are called ____ references. | relative |
| Which of the following is the path to the Copy and Paste buttons? | (Home tab | Clipboard group) |
| You can click the ____ button to undo an automatic correction. | AutoCorrect Options |
| Which of the following Option buttons gives options for filling cells following a fill operation: Auto Fill Options, AutoCorrect Options, Insert Options, Paste Options. | Auto Fill Options |
| The ____ Options button lists error-checking options following the assignment of an invalid formula to a cell. | Trace Error |
| The ____ Option button lists formatting options following an insertion of cells, rows, or columns. | Insert |
| A ____ cell in Excel has a numerical value of zero. | blank |
| 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. | AVERAGE |
| Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key. | right parenthesis |
| Which of the following is the path to the Sum button? | (Home tab | Editing group) |
| You should ____ a function name in the Formula AutoComplete list to select the function. | double-click |
| The ____ function displays the highest value in a range. | MAX |
| Clicking the ____ opens the Insert Function dialog box shown in the accompanying figure. | Insert Function box on the formula bar |
| The ____ function determines the lowest number in a range. | MIN |
| To copy cell contents, you can select the cell and then press the ____ keys. | CTRL + C |
| To paste copied cell contents, you can press the ____ keys. | CTRL + V |
| You can use the ____ to check which cells are referenced in the formula assigned to the active cell. | Range Finder |
| A ____ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects. | theme |
| You can open the Format Cells dialog box by pressing the ____ keys. | CTRL + 1 |
| The most popular background color is _____. | blue |
| 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. | Accounting number format |
| In the accompanying figure, the ranges E4:I4 and F13:I13 are formatted with a ____ dollar sign. | fixed |
| Which of the following is the path to the Comma Style button? | (Home tab | Number group) |
| Which of the following is the path to the Conditional Formatting button? | (Home tab | Styles group) |
| If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters. | 8.43 |
| When you decrease the row height to ____, the row is hidden. | 0 |
| Which of the following is the path to the Spelling button? | (Review tab | Proofing group) |
| ____ view allows you to create or modify a worksheet while viewing how it will look in printed format. | Page Layout |
| To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery, as shown in the accompanying figure. | Print Selection |
| When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values. | constant |
| You can ensure correctness in your formulas by carefully checking them using ____. | Range Finder |
| Which of the following is a suggested decision to make when you plan a workbook? | determine the necessary functions and formulas needed |
| With a solid understanding of the requirements document, an understanding of the necessary decisions, and a sketch of the worksheet, the next step is to ____. | use Excel to create the worksheet |
| ____ text often provides a strong visual appeal. | Rotated |
| To open the Format Cells dialog box with the Alignment sheet active, click the Format Cells ____. | Dialog Box Launcher |
| The ____ Auto Fill Options that fills the destination area using the format of the source area; no content is filled. | Fill Formatting Only |
| Which of the following patterns extends the fill series to 575, 550, 525? | 625, 600 |
| In the accompanying figure, the split double arrow mouse pointer ____. | is the result of moving the mouse pointer to the boundary between column heading A and column heading B |
| Which of the following is the path to the Increase or Decrease Indent button? | (Home tab | Alignment group) |
| The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it. | three |
| The Copy button copies the contents and format of the source area to the Office ____, a reserved place in the computer's memory. | Clipboard |
| 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 |
| Which of the following is the path to the Insert button? | (Home tab | Cells group) |
| Which of the following is not a valid format symbol: semi colon (;), percent sign (%), dollar sign ($), comma (,). | semi-colon (;) |
| 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! |
| When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899. | NOW |
| 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"? | < > |
| ____ refers to cells not wide enough to display the entire entry. | # # # # # |
| A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function. | nested |
| A(n) ____ 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 | Clipboard group) |
| ____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges. | Double-click |
| You should use a ____ chart to show the relationship or proportion of parts to a whole. | Pie |
| A(n) ____ is a separate sheet in a workbook that contains only a chart. | chart sheet |
| A Pie chart with one or more slices offset is called a(n) ____. | exploded Pie chart |
| Which of the following is the path to the Zoom button? | (View tab | Zoom group) |
| When working with a large worksheet, you can split the window into ____ panes. | two or four |
| Which of the following is the path to the Goal Seek button? | (Data tab | Data Tools group) |
| ____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell. | Goal |
First Time Here?
Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.