CIS120 Final Study Guide
The _____ feature saves versions of your work at a specified time interval.
a. AutoSave b. AutoArchive c. AutoRecover ****** d. AutoBackup
In Word 2016, you can search for an image on the web at the Insert Pictures dialog box, which provides image search results from the _____ search engine.
a. Bing ****** b. Yahoo! c. Google d. Dogpile
To move a PivotChart to a new sheet, use the _____ button in the Actions group on the PivotChart Tools Analyze tab.
a. Chart Styles b. Chart Elements c. Move Chart ****** d. Edit Data
To remove conditional formatting, select the range, click the Conditional Formatting button, point to Clear Rules, and then choose
a. Clear Conditional Formatting. b. Clear Rules from Selected Cells. ****** c. Clear Rules from Selected Range. d. Clear Rules from Workbook.
What is the first step in creating a PivotTable?
a. Click Insert tab. b. Select source range. ****** c. Click PivotTable button. d. Add fields as needed using PivotTable Fields task pane.
Which of the following is the final quick step when using a customized template?
a. Click PERSONAL. b. Click File tab. c. Click OK. d. Double-click the template. ******
Which of these steps comes first when you create a table?
a. Click the Table button. b. Select the range. ****** c. Print the worksheet structure. d. Format the data range.
The letter entered into the Shortcut key section of the Record Macro dialog box is used in conjunction with the _____ key.
a. Ctrl ****** b. Esc c. Alt d. Home
The Data Tools group on the Data tab contains each of the following buttons except
a. Data Validation. b. Sort & Filter. ****** c. Remove Duplicates. d. Text to Columns.
The AND and OR functions use this type of logic to construct a condition test in a formula.
a. Deductive b. Inductive c. Modal d. Boolean ******
You can clear cell trace marks by clicking the _____ button.
a. Delete Marks b. Remove Arrows ****** c. Delete Traces d. Remove Traces
When setting up a range for filtering, what step must you take just before you click the filter arrow button?
a. Deselect the range. ****** b. Point to Filter by Icon Set. c. Point to Filter by Color. d. Click the Sort & Filter button.
Once a table has been inserted into a document, use buttons in the Table Tools _____ tab and the Table Tools _____ tab to format and modify it.
a. Design; Layout ****** b. Layout; Format c. Format; Edit d. Edit; Design
Which Excel feature can be used to test data that was entered before validation rules were set up?
a. Evaluate Formula b. Trace Dependents c. Error Checking d. Circle Invalid Data ******
Create a table by clicking a square from the Table drop-down grid, or by opening the _____ dialog box.
a. Format Table b. Insert Table ****** c. Edit Table d. Create Table
By default, all charts copied from Excel to PowerPoint are
a. embedded. ****** b. pasted as static objects. c. hyper-linked objects. d. linked.
Which of these is not an Excel error flag mentioned in Chapter 5?
a. #NAME? b. a green diagonal triangle c. #VALUE! d. a red diagonal triangle ******
If a range name used in a formula is deleted, cells that used the name will display this error message.
a. #REF! b. #ERROR! c. #NA d. #NAME? ******
Which number is represented by the format 2.60E+05?
a. 2,600,000.00 b. 2.65 c. 260,000.00 ****** d. 0.00026
Which of these custom number format codes will round values to fit the number of decimals and fill in leading zeros?
a. ???.?? b. "Number"### c. ###.## d. 000.00 ******
What function would you use with an IF function to test multiple conditions?
a. AND ****** b. NOT c. ABS d. BUT
Who developed the PDF standard?
a. Apple b. IBM c. Adobe ****** d. Microsoft
Who developed the XPS standard?
a. Apple b. Microsoft ****** c. Adobe d. IBM
How can you tell that a selected cell is locked?
a. In the Format button drop-down list, the Lock Cell icon is highlighted. ****** b. In the Format button drop-down list, the Lock icon displays as "unlocked." c. In the Format button drop-down list, the text Lock Cell reads Unlock Cell. d. A pop-up box displays Locked when you hover the mouse pointer over the cell.
When a table is automatically expanded, the _____ is displayed.
a. Insert Function dialog box b. Format Cells dialog box c. AutoCorrect Options button ****** d. Format as Table gallery
By default, what happens when the VLOOKUP function does not find an exact match in the first column of the VLOOKUP table?
a. It looks in the second column of the table for a value that matches the lookup_value. b. It looks in the first column of the table for the largest value that is less than the lookup_value. ****** c. An error occurs. d. It looks in the first column of the table for the next closest value (higher or lower).
Macros in Excel are recorded in the _____ programming language.
a. Java b. Cobol c. VBA ****** d. C++
A range of cells containing a series of input values is called a
a. PivotTable. b. precedent c. data table. ****** d. scenario.
How do you start creating a macro?
a. Press Alt + M. b. Click the Insert tab, then click the Record Macro button. c. Perform the actions that will be recorded in the macro. d. Click the View tab, click the down-pointing arrow on the Macros button, then click Record Macro. ******
Workbook properties can be viewed and edited in the
a. Protect Workbook dialog box. b. Track Changes dialog box. c. Info backstage area. ****** d. Data Tools group on the Data tab.
By default, non-numeric fields are added to the _____ box of the PivotTable Field task pane, and numeric fields are added to the _____ box.
a. Report Filter; Row Labels b. Column Labels; Values c. Rows; Values ****** d. Values; Column Labels
If you want comments to print, use options in the Sheet tab at the _____ dialog box.
a. Save As b. Page Setup ****** c. Print d. Share Workbook
In the Save As dialog box, click the _____ to open the Publish as Web Page dialog box.
a. Save button b. Save as type box c. Publish button ****** d. Change Title button
Which button do you click to remove protection from a worksheet?
a. Share Workbook b. Protect Sheet c. Unprotect Sheet ****** d. Protect and Share Workbook
Add a border around the edges of a page using the _____ button.
a. SmartArt b. Page Background c. Page Borders ****** d. Text Box
When viewing the results of a scenario in Scenario Manager, clicking the _____ button will result in replacing the current values.
a. Summary b. Add c. OK d. Show ******
The Stop Automatically Expanding Tables option appears when you click the _____ button.
a. Table b. Format as Table c. PivotTable d. AutoCorrect Options ******
How can you tell that a filter has been defined for a column?
a. The Sort & Filter button flashes when you select that column. b. The word Filtered appears when you hover the mouse pointer over the column. c. A down-pointing filter arrow appears in the column heading. ****** d. The column heading appears as bold text.
The Scenario Manager is available in the drop-down box on the _____ button.
a. Trace Dependents b. What-If Analysis ****** c. Data Validation d. Solver
How do you remove protection from a worksheet?
a. Unlock the locked cells, then click Unprotect Sheet in the Format drop-down list on the Home tab. b. Unlock the locked cells, then click Unprotect Sheet on the Review tab. c. Click the Unprotect Sheet button on the Review tab. ****** d. Save the workbook with a different name.
Which of these options is not found in the Paste section in the Paste Special dialog box?
a. Values and number formats b. All except borders c. Comments d. As hyperlink ******
A _____ file contains only letters, numbers, punctuation symbols, and a few control characters.
a. Word b. workbook c. database d. text ******
When you send a worksheet as a PDF document, what does the recipient need to have in order to use the file?
a. XPS viewer b. Adobe Reader ****** c. a Windows Live account d. a browser
Can you create your own conditional formatting rules? If so, how?
a. Yes; use the New Formatting Rule dialog box. ****** b. Yes; edit a predefined rule. c. No; you must use Excel's predefined rules. d. Yes; create a macro.
A Reply button is available inside a comment box. What does the button look like?
a. a blue shaded box b. a green plus symbol inside a comment balloon c. a left-pointing arrow inside a white box ****** d. a right-pointing arrow next to the account picture or icon
What do you enter in the Changing cells textbox in the Add Scenario dialog box?
a. a name for the scenario b. values for each of the changing cells c. a description of the scenario d. the range cells that will change when the scenario is applied ******
As changes are made to the PivotChart,
a. a new PivotChart is created and placed in its own worksheet. b. the PivotChart remains static until it is manually refreshed. c. the PivotChart is removed and must be rebuilt. d. the PivotTable associated with it also updates. ******
When you create a PivotTable, you can choose to place it in either the existing worksheet or in
a. a new worksheet. ****** b. a Word document. c. a PowerPoint presentation. d. a separate workbook.
In Excel, an argument can include any of the following except
a. a single cell. b. a specified format. ****** c. multiple ranges. d. a range of cells.
The Header Row check box in the Table Styles Options group is used to
a. add totals to that row. b. band that row. c. freeze that row on the screen. d. show or hide the column headings row in the table. ******
A change made to a document after the document has been typed is referred to as
a. editing. ****** b. redlining. c. proofreading. d. spellchecking.
All of the following banding options are available in Excel except
a. adding random bands to columns. ****** b. adding banding to columns. c. removing banding from rows. d. removing banding from columns.
What does the Slicer pane contain?
a. all of the unique values for the specified field ****** b. a query form that can be used to filter the PivotTable c. filter arrows for all fields in the PivotTable d. properties for the specified field
By default, the Macro dialog box displays all macros within
a. all open workbooks. ****** b. all workbooks on all available drives. c. the active workbook. d. the active worksheet.
In the PPMT function, the argument fv refers to the
a. amount of money borrowed. b. period for which you want to find the principal portion of the payment. c. balance at the end of the loan. ****** d. interest rate per period.
If the data you are copying from Excel to Word is not likely to need editing or updating, copy it to the Clipboard in Excel, open Word, place the insertion point in the desired location,
a. and then click the Paste button. ****** b. click the Paste button arrow, click Paste Special, and then click Microsoft Office Excel Worksheet Object. c. click the Paste button arrow, and then click Paste Values. d. click the Paste button arrow, click Paste Special, click Microsoft Office Excel Worksheet Object,and then click Paste link.
You can only apply a custom view to the worksheet that
a. appears in the Sheet1 position. b. was active when the view was created. ****** c. contains an applied style. d. contains no headers or footers.
Begin creating a custom view by
a. applying the desired settings to the active worksheet. ****** b. clicking the View tab. c. displaying the Excel Options dialog box. d. clicking the Custom Views button.
When you create a new tab in the ribbon, where is the new tab placed?
a. at the left side of the ribbon b. at the right side of the ribbon c. after the tab name you have clicked in the Main Tabs list ****** d. before the tab name you have clicked in the Main Tabs list
Macros are used to increase productivity by
a. automatically formatting worksheets. b. automatically spell-checking data as it is entered. c. automating tasks that are performed repeatedly. ****** d. automatically checking formulas for errors as they are entered.
A Works Cited page is organized
a. by date the source was published. b. alphabetically by title of resource. c. alphabetically by author's first name. d. alphabetically by author's last name. ******
In a _____, Excel automatically copies a formula from the first cell to the remaining cells in the column.
a. calculated column ****** b. currency-formatted column c. table range d. header row
You _____ create your own conditional formatting rules.
a. cannot b. can, but should not c. can ****** d. must
While other users are editing a shared workbook, you should not
a. change a workbook's status from shared to exclusive. ****** b. close the file. c. make changes. d. save changes you have made.
Adjust the width of a column by
a. clicking anywhere in the column and pressing Shift + Tab. b. dragging the border line between columns left or right. ****** c. clicking anywhere in the column and pressing the left or right arrow key. d. double-clicking on the border line between columns.
Changing the style set changes _____ and _____ formatting options.
a. color; font b. paragraph; page layout c. font; theme d. font; paragraph ******
When displayed in the Visual Basic for Applications window, the first few lines of a macro are preceded by apostrophes ('). These lines are
a. commands. b. statements. c. comment lines. ****** d. declarations.
You can filter values by more than one criterion at a time by using
a. comparison operators. ****** b. conditional formatting. c. wildcards. d. dual filters.
Changing the appearance of a cell based on a condition is called
a. conditional formatting. ****** b. what-if formatting. c. what-if cell analysis. d. conditional analysis.
The syntax of the COUNTIF and COUNTIFS arguments requires that the criteria
a. contain only text. b. be enclosed in quotation marks. ****** c. be enclosed in square brackets. d. contain only numerical values.
The Paste Special feature allows you to perform each of the following except
a. copy only the cell format. b. copy the values, not the formulas. c. Standard Deviation. d. copy the active cell, plus all others with the same value. ******
Excel provides special number formats that are specific to which of the following?
a. country and alphabet b. region and language c. country and language ****** d. language and dialect
The Table Tools Design tab contains options for _____ the table.
a. creating b. formatting ****** c. protecting d. adding a chart to
Pressing the Tab key creates a _____ indent.
a. dangling b. first line ****** c. hanging d. special
A PivotChart can be created directly from a PivotTable or from
a. data in a worksheet. ****** b. a chart created in Word. c. a standard Excel chart. d. a PowerPoint slide.
What method described in Chapter 6 allows users to collaborate?
a. data tables b. What-If analysis c. workbook sharing ****** d. Sparklines
Conditional formats can be based on any of the following except
a. dates. b. values in a range. c. duplicated values. d. formatting. ******
A header is text that appears
a. directly under the document's title. b. next to the page number on the title page. c. at the top of each page. ****** d. above a picture or figure.
A _____ indent is where the first line of the paragraph remains at the left margin but subsequent lines are indented.
a. drop b. floating c. hanging ****** d. reverse
You should test the accuracy of key values in a worksheet by entering _____ outside the main worksheet area.
a. error checks b. proof formulas ****** c. trend lines d. trace precedents
The Show/Hide button turns on or off the display of
a. file extensions. b. hidden formatting symbols. ****** c. hidden folders. d. hyperlinks.
A _____ is used to organize and present data in columns and rows.
a. flowchart b. table ****** c. theme d. style set
A function includes two parts: the name of the function and the
a. format. b. size. c. argument. ****** d. location.
The process of changing the appearance of the text in a document is referred to as
a. formatting. ****** b. kerning. c. editing. d. blacklining.
A _____ is a built-in formula.
a. function ****** b. template c. style d. format
The document information panel found in previous versions of Excel
a. has been expanded for Excel 2016. b. no longer exists in Excel 2016. ****** c. has been upgraded for 2016. d. is larger than for Excel 2016.
You can rename a tab by _____ the tab name, clicking Rename at the shortcut menu, and then typing a new name at the Rename dialog box.
a. hovering the mouse pointer over b. clicking c. right-clicking ****** d. double-clicking
What is the name for the scrambled text Excel uses to encrypt passwords?
a. hypertext b. invisitext c. ciphertext ****** d. secretext
Where will you find the Insert Slicer button?
a. in the Tools group on the PivotTable Tools tab b. in the Active Field group on the PivotTable Analyze tab c. in the Timeline group on the PivotTable Tools Design tab d. in the Filter group on the PivotTable Tools Analyze tab ******
A page break that you insert manually is referred to as a _____ page break.
a. layout b. manual c. soft d. hard ******
You can navigate between comments by using the
a. left and right mouse buttons. b. up and down arrow keys. c. Next and Previous buttons. ****** d. Shift and Shift + Tab keys.
By default, new documents in Word are set up for a _____ page in _____ orientation with _____ inch margins at the left, right, top, and bottom.
a. legal-sized; landscape; one- b. legal-sized; portrait; two- c. letter-sized; landscape; one- d. letter-sized; portrait; one- ******
In a table, the box that is the intersection of a row and a column is called a table
a. marker. b. cell. ****** c. coordinate. d. matrix.
How many functions does Excel include?
a. more than 300 ****** b. 50 c. 100 d. more than 1,000
How many Access tables can be imported into Excel at the same time?
a. one ****** b. five c. as many as there are in the active database d. three
If you have linked an Excel object to a Word document and decide you want to keep the data but do not want to maintain the link,
a. open the Word document, click the linked object, and then press the Delete key. b. open the Excel workbook, right-click the linked object, click Linked Worksheet Object, click Links, and then click the Break Link button. c. open the Word document, right-click the linked object, point to Linked Worksheet Object, click Links, and then click the Break Link button. ****** d. open the Excel workbook, click the Connections button on the Data tab, highlight the link, and then click Remove.
When filtering a PivotTable using Timelines, which of the following time levels is not available?
a. quarters b. months c. days d. weeks ******
The COUNTIF function requires two arguments: range and
a. rate. b. cell reference. c. syntax. d. criteria. ******
A PivotTable is a(n) _____ table that organizes and summarizes data based on category labels you designate.
a. regressive b. static c. modal d. interactive ******
Which types of data tables does Excel offer?
a. relative and absolute b. one-variable and two-variable ****** c. static and dynamic d. horizontal and vertical
At the dialog box that allows you to protect a workbook's structure, you can also prevent the user from
a. resizing or changing the position of the windows in the workbook. ****** b. sending the workbook as an email attachment. c. moving the workbook to a new location. d. saving the workbook under a new name.
The Reset button below the Main Tabs list box in the Excel Options dialog box with Customize Ribbon selected can be used to
a. restore a previous version of the workbook. b. reset the selected ribbon tab. ****** c. reset all styles and themes to the defaults. d. restore the last customized ribbon.
Find a template that suits your needs by browsing previews grouped by category or by typing a keyword in the _____ text box at the New backstage area.
a. search ****** b. document c. locate d. navigate
The first step in creating a custom number format is to
a. select the desired range. ****** b. click the Number group dialog box launcher. c. click Custom in the Category list box. d. right-click the Number Format option box.
Adding color behind text is called
a. shading. ****** b. bordering. c. saturating. d. filling.
Clicking the left part of the Bullets button indents and inserts a _____ bullet.
a. solid round ****** b. solid square c. hollow round d. hollow square
By default, comments _____ print.
a. sometimes b. always c. do d. do not ******
The functions ABS, RAND, SQRT and SUMIF can be found in the _____ category.
a. statistical b. financial c. math and trigonometry ****** d. logical
The method of formatting even rows in a table differently from odd rows is called
a. striping. b. odd/even formatting. c. banding. ****** d. alternating formats.
In Excel, a range that can be managed separately from other rows and columns in the worksheet is called a
a. table. ****** b. PivotChart. c. chart. d. named range.
The VLOOKUP argument that would identify a range of cells rather than a value, a single cell, or a column number is
a. table_array. ****** b. lookup_value. c. col_index_num. d. range_lookup.
A _____ is a workbook with standard text, formulas, and formatting.
a. template ****** b. macro c. customized workbook d. model
A _____ is a document that has been created with formatting options already applied.
a. template ****** b. theme c. typeface d. style set
Values in rows that do not meet the criteria in the Custom AutoFilter feature are
a. temporarily hidden from view. ****** b. formatted with a bold font. c. dimmed. d. deleted from the worksheet.
Excel's built-in auditing features help you make sure
a. that there are no formatting errors. b. that your use of financial functions meets standard accounting practices. c. that there are no spelling errors in your data. d. that your worksheet is functioning accurately. ******
To share a workbook, open it, click _____, and then click Allow changes by more than one user at the same time.
a. the Data tab, click the Group button b. the Review tab, click the Share Workbook button ****** c. the Data tab, click the From Other Sources button d. the File tab, click Save As
In the VLOOKUP function, what does the col_index_num argument indicate?
a. the address range for the lookup table that you want Excel to search b. the value you want Excel to search for in the lookup table c. the column number from the lookup table that contains the data you want placed in the formula cell ****** d. the first column in the lookup table
When you create a new comment, what is inside the comment box?
a. the file name b. the user's name ****** c. nothing d. the date
The lookup_value argument in the VLOOKUP function specifies
a. the range of cells to be searched. b. whether to find an exact match or just the nearest match in the range of cells to be searched. c. the value that Excel searches for in the reference table. ****** d. the value that will be returned by the function.
As a visual guide to see the variation of values in a range, Excel provides each of the following except
a. three-color scales. b. data bars. c. two-color scales. d. animated graphics. ******
To calculate a value, the Goal Seek feature requires that cells have a(n) _____ relationship.
a. two-way b. static c. dependent ****** d. absolute
A font is also referred to as a
a. typeface. ****** b. theme. c. character set. d. style.
Footnotes differ from endnotes in the
a. way in which they are formatted. b. type of information they contain. c. location in which they appear. ****** d. length of the note.
Inserting a new citation involves associating the source for the content and then editing the citation to add the
a. web address. b. ISBN. c. author's last name. d. page or paragraph number. ******
The Edit the Rule Description section of the New Rule dialog box varies depending on
a. whether any other cells in the worksheet have conditional formatting applied. b. the formatting of the selected cells. c. the active option in the Select a Rule Type section. ****** d. the type of formula in the selected cells.
