• Shuffle
Toggle On
Toggle Off
• Alphabetize
Toggle On
Toggle Off
• Front First
Toggle On
Toggle Off
• Both Sides
Toggle On
Toggle Off
Toggle On
Toggle Off
Front

### How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

Play button

Play button

Progress

1/36

Click to flip

### 36 Cards in this Set

• Front
• Back
 The process of summarizing data included on multiple worksheets on one worksheet is called _____. consolidation _____ format codes allow you to specify how a cell entry assigned a format will appear. Custom You document a workbook by adding _____ to cells that contain complex formulas. comments Excel allows you to work with separate workbooks in a _____ and then link the workbooks to provide a consolidated view of the data in the workbooks. workspace _____ often are used when creating an initial consolidated worksheet to guide users of the worksheet regarding what type of data to enter in cells. Placeholders In consolidated worksheets with more complex formulas, you may want to use _____ that test the extreme boundaries of valid data. numbers Which of the following keyboard shortcuts allows you to select a range of cells with entries surrounded by blank cells? CTRL+SHIFT+ASTERISK You can enter _____ in a cell to display tomorrow's date. =NOW()+1 You can use the _____ function to change a year, month, and day to a serial number. DATE You should create good _____ to ensure your workbooks are free of errors. test data The following sequence, Jan, Feb, Mar, etc., is an example of a _____ series. date The following sequence, 1, 1, 1, etc., is an example of a _____ series. fill The following sequence, 2, 4, 6, etc., is an example of a _____ series. linear The following sequence, 1, 2, 3, etc., is an example of a _____ series. linear Which of the following is the path to the Fill button? (Home tab | Editing group) To fill a linear series using the fill handle, hold down the _____ key as you drag through the range. CTRL It is recommended that you use the _____ function on formulas that potentially can result in more decimal places than the applied format displays. ROUND The path to the Sum button is _____. (Home tab | Editing group) You can change from Enter mode or Edit mode to Point mode by typing the _____ sign or symbol followed by clicking a cell. = To copy the contents of a cell to the cell directly below it, click the target cell and press _____. CTRL+D The path to the Accounting Number Format button is _____. (Home tab | Number group) Which of the following format codes insures that Excel will display a decimal point in the number? . (period) Which of the following format symbols displays text along with numbers entered in a cell? " " (quotation marks) You should click _____ in the Category list on the Number tab in the Format Cells dialog box to select or create a format code. Custom Which of the following format codes shows percent values with two decimal places and shows negative percent values in blue with parentheses? 0.00%;[Blue](0.00%) You can open a workbook each time you start your computer by copying the workbook file to the _____ folder located in the All Programs list. Startup A workbook contains _____ worksheets by default. three Which of the following is the path to the Insert Cells button? (Home tab | Cells group) Which of the following can you drill through a workbook? All of the above A range that spans two or more sheets in a workbook is called a _____ range. 3-D To select noncontiguous sheets, hold down the _____ key as you select the sheets. CTRL A(n) _____ reference is a formula that depends on its own value. circular Headers, footers, and margins are all _____ options. page setup Pressing the _____ keyboard shortcut keys pastes an image of the source area as a picture. CTRL+U You can switch to Page Layout view by clicking the Page Layout button _____. on the status bar When you print a worksheet or use the Page Setup dialog box, Excel inserts_____ breaks that show the boundaries of what will print on each page. page