Final Exam Level 2

5 How many Access tables can be imported into Excel at the same time? Choose one answer. a. one b. three c. as many as there are in the active database d. as many as there are in the active database Page: Excel Level 2, page 271

a

9 In the Save As dialog box, click the _____ to open the Publish as Web Page dialog box. Choose one answer. a. Publish button b. Save button c. Save as type box d. Change Title button Page: Excel Level 2, page 302

a

5 By default, Excel saves the macro in Choose one answer. a. the current workbook. b. a special macros workbook. c. a stand-alone Visual Basic file. d. the Excel program file. Page: Excel Level 2, page 227

a. the current workbook.

1 A custom _____ saves the display and print settings for the active worksheet. Choose one answer. a. view b. ribbon c. button d. macro Page: Excel Level 2, page 248

a. view

8 If a range name used in a formula is deleted, cells that used the name will display this error message. Choose one answer. a. #ERROR! b. #REF! c. #NAME? d. #NA Page: Excel Level 2, page 51

c. #NAME?

5 Cell references in range names use ____ references. Choose one answer. a. no b. relative c. absolute d. mixed Page: Excel Level 2, page 106

c. absolute

3 Changing the appearance of a cell based on a condition is called Choose one answer. a. what-if formatting. b. what-if cell analysis. c. conditional formatting. d. conditional analysis. Page: Excel Level 2, page 6

c. conditional formatting.

5 Cells that contain a formula that references other cells are called _____ cells. Choose one answer. a. precedent b. successor c. dependent d. independent Page: Excel Level 2, page 170

c. dependent

1 A shared workbook is usually kept Choose one answer. a. on a CD or DVD that others have access to. b. on a flash drive. c. in a network folder. d. on a local hard drive. Page: Excel Level 2, page 193

c. in a network folder.

1 A ___ file contains only letters, numbers, punctuation symbols, and a few control characters. Choose one answer. a. text b. database c. workbook d. Word Page: Excel Level 2, page 280

a

10 Text file formats usually use _____ to separate data fields. Choose one answer. a. commas or tabs b. apostrophes or quotation marks c. slashes or backslashes d. colons or semicolons Page: Excel Level 2, page 275

a

2 A link to Excel data from a Word document will no longer work if you _____ the source workbook. Choose one answer. a. move or rename b. close c. change any data in d. make any changes to the structure of Page: Excel Level 2, page 280

a

1 A formula that refers to the same cell in a range that includes several worksheets is known as a(n) Choose one answer. a. 3-D reference. b. matrix reference. c. extended reference. d. multi-sheet reference. Page: Excel Level 2, page 106

a. 3-D reference.

7 How can you tell whether a cell contains a comment? Choose one answer. a. A small red triangle appears in the upper right corner of the cell. b. A small green triangle appears in the upper left corner of the cell. c. The cell displays with a wavy red border. d. The cell displays with a wavy blue border. Page: Excel Level 2, page 189

a. A small red triangle appears in the upper right corner of the cell.

8 How do you remove protection from a worksheet? Choose one answer. a. Click the Unprotect Sheet button on the REVIEW tab. b. Unlock the locked cells, then click Unprotect Sheet in the Format drop-down list on the HOME tab. c. Unlock the locked cells, then click Unprotect Sheet on the REVIEW tab. d. Save the workbook with a different name. Page: Excel Level 2, page 207

a. Click the Unprotect Sheet button on the REVIEW tab.

10 In a nested IF formula, how does Excel help you keep track of the brackets that belong to each IF function? Choose one answer. a. It color-codes them. b. It shows them on a different line. c. It uses different font effects. d. It varies the size of the brackets. Page: Excel Level 2, page 58

a. It color-codes them.

2 After copying the source cell, from where do you paste a comment into its new location? Choose one answer. a. Paste Special dialog box b. Clipboard c. Shortcut menu d. HOME tab Page: Excel Level 2, page 190

a. Paste Special dialog box

7 How are numbers displayed when the format code is [Red];[Blue]? Choose one answer. a. Positive numbers are displayed in red; negative numbers in blue. b. Positive numbers are displayed in blue; negative numbers in red. c. Numbers to the left of the decimal point are displayed in red; numbers to the right in blue. d. Numbers to the left of the decimal point are displayed in blue; numbers to the right in red. Page: Excel Level 2, page 20

a. Positive numbers are displayed in red; negative numbers in blue.

7 Create a PivotChart with the active cell anywhere in a PivotTable by clicking the PivotChart button in the Choose one answer. a. Tools group on the PIVOTTABLE TOOLS ANALYZE tab. b. PivotTable group on the PIVOTTABLE TOOLS ANALYZE tab. c. Layout group on the PIVOTTABLE TOOLS DESIGN tab. d. Charts group on the DATA tab. Page: Excel Level 2, page 127

a. Tools group on the PIVOTTABLE TOOLS ANALYZE tab.

3 Add a Total row to a table by clicking the Choose one answer. a. Total Row check box on the TABLE TOOLS DESIGN tab. b. Total Row check box in the Table Styles group. c. Totals button on the TABLE TOOLS TABLE STYLES tab. d. Sum Rows check box on the FORMULAS tab. Page: Excel Level 2, page 76

a. Total Row check box on the TABLE TOOLS DESIGN tab.

9 If a password was entered when a workbook was protected, clicking the Protect Workbook button will cause the Choose one answer. a. Unprotect Workbook dialog box to display. b. password to be removed from the workbook. c. Save As dialog box to display. d. Confirm Password dialog box to display. Page: Excel Level 2, page 208

a. Unprotect Workbook dialog box to display.

8 How can you format a cell based on the value in a different cell? Choose one answer. a. Use a formula. b. Apply two conditional formatting rules. c. Apply conditional formatting rules to both cells. d. You cannot format a cell in this way. Page: Excel Level 2, page 15

a. Use a formula.

9 Custom views cannot be created for any worksheet that contains Choose one answer. a. a table. b. formulas. c. macros. d. a style. Page: Excel Level 2, page 250

a. a table.

3 Begin creating a custom view by Choose one answer. a. applying the desired settings to the active worksheet. b. displaying the Excel Options dialog box. c. clicking the VIEW tab. d. clicking the Custom Views button. Page: Excel Level 2, page 248

a. applying the desired settings to the active worksheet.

2 A function includes two parts: the name of the function and the Choose one answer. a. argument. b. format. c. size. d. location. Page: Excel Level 2, page 39

a. argument.

8 How do you delete a scenario? Choose one answer. a. at the Scenario Manager dialog box b. from the What-If Analysis button c. from the current worksheet d. from the Connections group on the DATA tab Page: Excel Level 2, page 164

a. at the Scenario Manager dialog box

10 In a _____, Excel automatically copies a formula from the first cell to the remaining cells in the column. Choose one answer. a. calculated column b. table range c. currency-formatted column d. header row Page: Excel Level 2, page 75

a. calculated column

9 Icon sets allow you to Choose one answer. a. classify data into three to five categories. b. create your own symbols. c. modify the shapes of threshold symbols. d. change the images that appear on Excel buttons. Page: Excel Level 2, pages 12 and 13

a. classify data into three to five categories.

9 Excel's ____ feature summarizes data from multiple worksheets or another workbook into a master worksheets. Choose one answer. a. consolidate b. group c. connections d. table Page: Excel Level 2, page 114

a. consolidate

6 Excel's data validation feature allows you to Choose one answer. a. control the type of data that can be entered into a cell. b. spell check your data. c. check your formulas for errors. d. specify which users can enter data into your worksheet. Page: Excel Level 2, page 84

a. control the type of data that can be entered into a cell.

6 Excel provides special number formats that are specific to which of the following? Choose one answer. a. country and language b. language and dialect c. region and language d. country and alphabet Page: Excel Level 2, page 18

a. country and language

1 A range of cells containing a series of input values is called a Choose one answer. a. data table. b. PivotTable. c. precedent d. scenario. Page: Excel Level 2, page 166

a. data table.

4 By default, comments _____ print. Choose one answer. a. do not b. sometimes c. do d. always Page: Excel Level 2, page 190

a. do not

6 Chapter 4 suggests that when using 3-D reference, you should set up data in each worksheet in Choose one answer. a. identical cells. b. adjacent cells. c. named ranges. d. columns. Page: Excel Level 2, page 108

a. identical cells.

3 A PivotTable is a(n) _____ table that organizes and summarizes data based on category labels you designate. Choose one answer. a. interactive b. static c. regressive d. modal Page: Excel Level 2, page 116

a. interactive

6 Ctrl + Alt + V is the keyboard shortcut for Choose one answer. a. pasting a copied comment. b. adding a comment. c. deleting a comment. d. protecting a workbook. Page: Excel Level 2, page 217

a. pasting a copied comment.

6 Cells that provide data to a formula cell are called _____ cells. Choose one answer. a. precedent b. dependent c. independent d. related Page: Excel Level 2, page 170term-45

a. prededent

3 At the dialog box that allows you to protect a workbook's structure, you can also prevent the user from Choose one answer. a. resizing or changing the position of the windows in the workbook. b. saving the workbook under a new name. c. sending the workbook as an email attachment. d. moving the workbook to a new location. Page: Excel Level 2, page 207

a. resizing or changing the position of the windows in the workbook.

7 Excel's built-in auditing features help you make sure Choose one answer. a. that your worksheet is functioning accurately. b. that your use of financial functions meets standard accounting practices. c. that there are no spelling errors in your data. d. that there are no formatting errors. Page: Excel Level 2, page 169

a. that your worksheet is functioning accurately.

10 How does Chapter 4 suggest that you use Sparklines? Choose one answer. a. to show high or low values within a range b. to interactively filter data c. to reverse the axes of a chart d. to summarize an entire worksheet of data Page: Excel Level 2, page 130

a. to show high or low values within a range

8 How are the subtotals displayed when you subtotal a range of data with the Subtotal dialog box? Choose one answer. a. using the Outline feature b. in Print Preview mode c. in comments inserted in cells d. as new rows at the end of the data list Page: Excel Level 2, page 89

a. using the Outline feature

4 By default, Excel adds the folder created upon installation that contains the templates provided by Microsoft to the Trusted _____ list in the Trust Center settings. Choose one answer. a. Publishers b. Locations c. Documents d. App Catalogs Page: Excel Level 2, page 297

b

6 If an Access database does not have an existing table in which to receive data exported from Excel, Choose one answer. a. you must create one. b. start Access, click the EXTERNAL DATA tab, and then click the Import Excel spreadsheet button. c. use the Copy and Paste method to transfer the data. d. use Excel's Export feature to transfer the data. Page: Excel Level 2, page 278

b

4 By default, AutoRecover automatically saves information every Choose one answer. a. 5 minutes. b. 10 minutes. c. 30 minutes. d. hour. Page: Excel Level 2, page 253

b. 10 minutes.

2 After data has been copied to the Clipboard, which command allows you to perform a mathematical operation on the data before it is copied into the destination cell? Choose one answer. a. Paste b. Paste Special c. Paste Link d. Paste Values Page: Excel Level 2, page 155

b. Paste Special

10 If two users change the same cell in a shared workbook, Excel prompts the second user by displaying the _____ dialog box. Choose one answer. a. Share Workbook b. Resolve Conflicts c. Track Changes d. Comments Page: Excel Level 2, page 196

b. Resolve Conflicts

7 By default, the Macro dialog box displays all macros within Choose one answer. a. the active workbook. b. all open workbooks. c. all workbooks on all available drives. d. the active worksheet. Page: Excel Level 2, page 230

b. all open workbooks.

2 A macro name _____ space(s) and _____ letter(s). Choose one answer. a. can contain; cannot contain b. cannot contain; must begin with a c. cannot contain; can contain d. cannot contain; must end with a Page: Excel Level 2, page 227

b. cannot contain; must begin with a

2 A PivotChart can be created directly from a PivotTable or from Choose one answer. a. a chart created in Word. b. data in a worksheet. c. a standard Excel chart. d. a PowerPoint slide. Page: Excel Level 2, page 127

b. data in a worksheet.

1 A table in Excel is similar in structure to a Choose one answer. a. chart. b. database. c. named range. d. workbook. Page: Excel Level 2, page 74

b. database.

9 If you divide the interest rate by 12 for a monthly rate with the PMT or PPMT functions, what might you have to multiply by 12? Choose one answer. a. present value b. number of payment periods c. future value d. rate Page: Excel Level 2, page 56

b. number of payment periods

3 By default, all charts copied from Excel to PowerPoint are Choose one answer. a. pasted as static objects. b. hyper-linked objects. c. embedded. d. linked. Page: Excel Level 2, page 284

c

7 If you have a workbook that must be used by users with an Excel version earlier than Excel 2007, you Choose one answer. a. cannot share it with them. b. should save it as a text file. c. should save it in Excel 97-2003 format. d. should rename it with the extension .xls. Page: Excel Level 2, page 294

c

6 By default, how many files are displayed in the Recent Workbooks section of the Open backstage area? Choose one answer. a. 7 b. 15 c. 25 d. 35 Page: Excel Level 2, page 236

c. 25

5 Excel can add text such as GX- to the values you type in cells if the cells have been formatted using the _____ category. Choose one answer. a. Special b. Text c. Custom d. General Page: Excel Level 2, page 20

c. Custom

4 By default, non-numeric fields are added to the _____ box of the PivotTable Field task pane, and numeric fields are added to the _____ box. Choose one answer. a. Column Labels; Values b. Values; Column Labels c. Rows; Values d. Report Filter; Row Labels Page: Excel Level 2, page 118

c. Rows; Values

2 Can you create your own conditional formatting rules? If so, how? Choose one answer. a. No; you must use Excel's predefined rules. b. Yes; edit a predefined rule. c. Yes; use the New Formatting Rule dialog box. d. Yes; create a macro. Page: Excel Level 2, page 8

c. Yes; use the New Formatting Rule dialog box.

2 A table should not contain Choose one answer. a. column labels. b. text data. c. blank rows. d. more than five columns. Page: Excel Level 2, page 74

c. blank rows.

9 If you type a formula in the first row of a new table column, Excel will create a(n) Choose one answer. a. preformatted column. b. error message. c. calculated column. d. calculated row. Page: Excel Level 2, page 75

c. calculated column.

5 By default, when a worksheet is protected, you Choose one answer. a. can insert new content in the cells that remain unlocked. b. can change data that was entered before the sheet was protected. c. cannot delete any content. d. can delete, but not modify, content. Page: Excel Level 2, page 204

c. cannot delete any content.

7 Flash fill can be used to Choose one answer. a. copy formatting from one cell to the next. b. convert data from text to numbers. c. join parts of the contents of cells. d. combine formulas. Page: Excel Level 2, page 81

c. join parts of the contents of cells.

7 How many functions does Excel include? Choose one answer. a. 50 b. 100 c. more than 300 d. more than 1,000 Page: Excel Level 2, page 61

c. more than 300

5 By default, where does Excel display filter arrows in a table? Choose one answer. a. in the first and last columns b. only on columns containing text c. next to each label in the header row d. only on columns containing numbers Page: Excel Level 2, page 78

c. next to each label in the header row

10 If you hear a beep while tracing cell relationships, it means that Choose one answer. a. you have reached the next level of indirect relationships. b. the formula is too complex to trace. c. no more relationships exist. d. Excel has detected an error. Page: Excel Level 2, page 170

c. no more relationships exist.

4 Excel stops evaluation of an IF formula Choose one answer. a. once the logical_test has been answered as false. b. once the value_if_true has been answered as false. c. once the logical_test has been answered as true. d. once the value_if_true has been answered as true. Page: Excel Level 2, page 58

c. once the logical_test has been answered as true.

5 Excel will add the required syntax automatically when you create a COUNTIF formula if you Choose one answer. a. use copy and paste. b. create the formula manually. c. use the Insert Function dialog box. d. press F1 before typing the function. Page: Excel Level 2, page 43

c. use the Insert Function dialog box.

8 If you want to know in advance what areas of your worksheet might cause problems for users with earlier versions of Excel, Choose one answer. a. run the Mark as Final report. b. run the Document Inspector. c. click the Check Version button on the REVIEW tab. d. run the Compatibility Checker. Page: Excel Level 2, page 294

d

9 How many models can you create using the Scenario Manager dialog box? Choose one answer. a. up to three b. no more than five c. between five and ten, depending on the complexity of the scenarios d. as many as you want Page: Excel Level 2, page 162

d. As many as you want

3 By default, what happens when the VLOOKUP function does not find an exact match in the first column of the VLOOKUP table? Choose one answer. a. It looks in the second column of the table for a value that matches the lookup_value. b. An error occurs. c. It looks in the first column of the table for the next closest value (higher or lower). d. It looks in the first column of the table for the largest value that is less than the lookup_value. Page: Excel Level 2, page 53

d. It looks in the first column of the table for the largest value that is less than the lookup_value.

3 All of the following buttons can be found in the Scenario Manager dialog box except Choose one answer. a. Add. b. Edit. c. Delete. d. OK. Page: Excel Level 2, page 162

d. OK.

4 All of the following banding options are available in Excel except Choose one answer. a. removing banding from rows. b. adding banding to columns. c. removing banding from columns. d. adding random bands to columns. Page: Excel Level 2, page 76

d. adding random bands to columns.

1 As a visual guide to see the variation of values in a range, Excel provides each of the following except Choose one answer. a. two-color scales. b. three-color scales. c. data bars. d. animated graphics. Page: Excel Level 2, page 14

d. animated graphics.

10 From the Macro dialog box, you can do all of the following except _____ a macro. Choose one answer. a. run b. edit c. delete d. copy Page: Excel Level 2, page 230

d. copy

8 Creating a PivotTable allows you to do all of the following except Choose one answer. a. filter data. b. total data. c. summarize data. d. delete data. Page: Excel Level 2, page 114

d. delete data.

6 Excel's Lookup and Reference functions provide a way to Choose one answer. a. format cells. b. export data to another program. c. import data from another program. d. extract certain information from a list of data. Page: Excel Level 2, page 52

d. extract certain information from a list of data.

10 If the appropriate formatting has been applied, data can be filtered by all of the following except Choose one answer. a. cell color. b. cell icon. c. font color. d. font type. Page: Excel Level 2, page 29

d. font type.

4 Conditional formats can be based on any of the following except Choose one answer. a. dates. b. values in a range. c. duplicated values. d. formatting. Page: Excel Level 2, page 6

d. formatting.

1 A _____ is a built-in formula. Choose one answer. a. style b. template c. format d. function Page: Excel Level 2, page 39

d. function

8 By default, when a workbook containing a macro is opened Choose one answer. a. macros are enabled and the worksheet is ready to use. b. macros are disabled and you must click the Macros button on the VIEW tab to enable them. c. macros are enabled but a security notification warns you to disable them. d. macros are disabled and a security warning appears. Page: Excel Level 2, page 231

d. macros are disabled and a security warning appears.

4 Because worksheets provide critical information to decision-makers, Chapter 5 suggests that you do all of the following except Choose one answer. a. examine them carefully. b. look for data entry mistakes. c. check values that do not appear to be realistic. d. place a disclaimer in the Footer of every workbook. Page: Excel Level 2, page 176

d. place a disclaimer in the Footer of every workbook.