Spreadsheet Computing Final Exam

The ____ arrangement option layers the open workbooks on the screen. A. Cascade B. Horizontal C. Tiled D. Lateral

Cascade

To calculate multiple cell values, select the range and type the array formula, then press the _______ keys to enter the formula. A. Alt+Enter B. Ctrl+Shift+Enter C. Alt+Shift+Enter D. Ctrl+Enter

Ctrl+Shift+Enter

Which of the following shows the correct order of steps for adding a data series to a chart? A. Select the chart, Click the Add button, Click the Select Data button, Select the range B. Select the chart, Click the Select Data button, Click the Add button, Select the range C. Select the range, Click the Select Data button, Click the Add button, Select the chart D. Select the range, Select the chart, Click the Select Data button, Click the Add button

Select the chart, Click the Select Data button, Click the Add button, Select the range

If an optional argument is not included, Excel assumes a(n) ____ value for it. A. default B. generic C. static D. absolute

default

When you reference a cell or range in a different worksheet, the ____ separates the sheet reference from the cell reference. A. ? B. ! C. " D. ;

!

Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas? A. A5 B. $A$5 C. $A5 D. A$5

$A$5

What is the file extension of macro-enabled workbook? A. .xls B. .xlx C. .xlsx D. .xlsm

.xlsm

All template files have a(n) ____ extension. A. .xlsx B. .xltx C. .xldx D. .xtpl

.xltx

Binding constraints always show a slack of _______. A. -0.01 B. 0 C. 0.01 D. 1

0

To project a trend that decreases rather than increases, use a step value of less than _______ for a linear trend. A. -1 B. 0 C. 1 D. 2

0

With the PMT function, the type argument is _______ when the payments are made at the end of each period. A. 0 B. 1 C. a D. -1

0

How many items in a Pivot table can you drill down at a time? A. 1 B. 2 C. 5 D. 8

1

A jewelry designer creates an excel sheet to list different items he sold on the previous day. Cells A1, B1, C1, and D1 contain headings—Order ID, Unit price, and Quantity, respectively. Cells A2 to A6 list the order ID for items sold—10001,10002,10003,10004, and 10005, respectively. Cells B2 to B6 list their respective unit price—$15, $18.5, $12, $9.5, and $6. Cells C2 to C6 list their respective quantities—20, 32, 16, 15, and 10. If he enters the formula in cell D1 as: =VLOOKUP (10005, A1: H3, 3, FALSE), what will the formula return? A. 10 B. $6 C. $12 D. 10003

10

Excel functions are organized into ____ categories. A. 8 B. 10 C. 11 D. 13

13

To move or copy a range of cells, select the correct order: 1. Move the pointer over the border of the selection until the pointer changes shape. 2. Select the cell or range you want to move or copy. 3. To move the range, click the border and drag the selection to a new location, or to copy the range, hold down the Ctrl key and drag the selection to a new location. A. 1,2,3 B. 3,2,1 C. 1,3,2 D. 2,1,3

2,1,3

Range names can be up to _____ characters. A. 15 B. 27 C. 56 D. 255

255

Which of the following is not a comparison operator? ____ A. = B. <= C. << D. <>

<<

The formula used to multiply cell A1 by cell C1 is ____. A. =A1*C1 B. C1*A1 C. =A1/C1 D. A1*C1

=A1*C1

The score of a student inserted in the B2 cell is 65 and in the C2 cell is 75. Which of the following functions will you insert in the D2 cell so that it returns FALSE if any of the conditions are false for the values in the B2 and C2 cells? A. =IF(B2>=70, C2>=80) B. =OR(B2>=70, C2>=80) C. =AND(B2>=70, C2>=80) D. =NOT(OR(B2>=70, C2>=80))

=AND(B2>=70, C2>=80)

What is the correct formula to insert the date January 12, 1998 into a cell? A. =DATE(1998,1,12) B. =DATE(1998,12,1) C. =DATE(12-1-1998) D. =DATE(1/12/1998)

=DATE(1998,1,12)

The DB function used to calculate the declining balance depreciation has the following syntax: _______. A. =DB(salvage, life, period [month]) B. =DB(cost, salvage, period [month]) C. =DB(salvage, cost, life, period [month]) D. =DB(cost, salvage, life, period [month])

=DB(cost, salvage, life, period [month])

Warren creates a table listing the height and weight of students in his class. He enters the heading "Name" in cell A3 and the names of students in cells A4 to A9, the heading "Height" in cell B3 and the height of students in cells B4 to B9, the heading "Weight" in cell C3 and the weight of students in cells C4 to C9. What formula can he use to look up the height of one of the students, Sari, whose name, height, and weight are mentioned in cells A7, B7, and C7, respectively? A. =INDEX(A3:C9,4,2) B. =INDEX(A7:C7,4,2) C. =INDEX(A7:B7,2,4) D. =INDEX(A3:B9,2,4)

=INDEX(A3:C9,4,2)

Barry creates a table showing ranks and percentage his students obtained in their final exams. He enters the heading "Name" in cell A3 and the names of students in cells A4 to A9, the heading "Rank" in cell B3 and the height of students in cells B4 to B9, the heading "Percentage" in cell C3 and the weight of students in cells C4 to C9. One of the students, Cara's name, rank, and percentage are mentioned in cells A7, B7, and C7, respectively. He types Cara's rank in cell A14. What formula can he use in cell B14 to find the column in which Cara's rank is? A. =MATCH (A14,A3:C9,1) B. =MATCH (A14,A3:C3,0) C. =MATCH (B14,A3:C3,0) D. =MATCH (B14,A4:C9,1)

=MATCH (A14,A3:C3,0)

Which of the following shows the syntax of the NPER function? A. =NPER(pmt, pv, [fv=0], [type=0]) B. =NPER(rate, pmt, [fv=0], [type=0]) C. =NPER(rate, pmt, pv [, fv=0] [, type=0]) D. =NPER(pmt, rate, pv, [fv=0], [type=0])

=NPER(rate, pmt, pv [, fv=0] [, type=0])

The score of a student in two subjects are inserted in the B2 and C2 cells and the passing score for each subject is 60. Which of these functions will you insert in the D2 cell so that it returns TRUE if at least one score is greater than or equal to 60, or else it returns FALSE? A. =IF(B2>=60, C2>=60) B. =OR(B2>=60, C2>=60) C. =AND(B2>=60, C2>=60) D. =NOT(OR(B2>=60, C2>=60))

=OR(B2>=60, C2>=60)

What is the syntax for a SUM formula adding the values of cell F6 to F9? A. =SUM(F6+F9) B. =SUM(F6,F9) C. =SUM(F6*F9) D. =SUM(F6:F9)

=SUM(F6:F9)

The components of a structured reference are as follows: Table 1 is Table Name, [Net Amount] and [Commission Amount] are column specifiers and [#Totals] and [#Increase] are item specifiers. Which of these can be the formula for the structured reference? A. =SUM(#Totals[[Table1],[Net Amount]],#Increase[[Table1],[Commission Amount]]) B. =SUM(Net Amount[[#Totals],[able1]], Commission Amount[[#Increase],[Table1]]) C. =SUM(Table1[[#Totals],[Net Amount]],Table1[[#Increase],[Commission Amount]]) D. =SUM(Table1[[#Totals],[Net Amount]],Table1[[#Increase],[Commission Amount]])

=SUM(Table1[[#Totals],[Net Amount]],Table1[[#Increase],[Commission Amount]])

table

A collection of data stored in rows and columns

In the formula =IF(A1=B1, C1, C2), the result will be C2 if ____. A. A is equal to B B. A does not equal B C. A1+B1 is equal to C1 D. A1>B1 is equal to C2

A does not equal B

DAX

A formula language used to write a calculation called an explicit measure.

DSUM

A function that calculates a total in a database range.

DAVERAGE

A function that calculates an average in a database range.

DCOUNT

A function that counts the number of occurrences that meet the specified condition in a database range.

DGET

A function that retrieves the first cell in a database range that meets the specified criteria.location of the first occurrence alculates an average in a database range.

query

A question you ask about the data in a database

Which of the following is a Statistical function? _____ A. INT B. RAND C. ROUND D. AVERAGE

AVERAGE

In the formula =B6*$B$2, which of the following describes $B$2? A. Relative cell reference B. Absolute cell reference C. Function D. Average

Absolute cell reference

_______ is a database program. A. Word B. Access C. PowerPoint D. Outlook

Access

To align currency symbols and decimal points in a column of numbers, you can apply the ____ number format. A. Currency B. Accounting C. Percentage D. General

Accounting

To add a sort field in the Sort dialog box, click the ____ button. A. Add Level B. Add Field C. New Sort Field D. New Level

Add Level

Johan wants to create a PivotTable using Power Pivot. During the procedure, to add a Table to PowerPivot, he selects a cell in a Table and clicks Power Pivot tab > Tables group > X. What is X in the procedure? A. Add to Data Model B. Update All C. Measures D. KPIs

Add to Data Model

Which of the following is not an Excel function category? ____ A. Math & Trig B. Algebra C. Statistical D. Text

Algebra

The Query Editor also includes tools to:​ ​A. create new columns B. group data values ​C. calculate summary statistics D. All of the above

All of the above

Which of the following combinations of keys will you press to open the VBA window and run a macro code? A. Alt + F9 B. Alt + F11 C. Alt + F4 D. Alt + Tab

Alt + F11

Esperanza wants to record a macro to automate a repetitive task. Which of the following combinations of keys should she press to open the Macro name box? A. Ctrl + Z B. Alt + F8 C. Ctrl + Shift D. Alt + T + M + R

Alt + T + M + R

Marcos wants to refresh the data in a Pivot table manually. He clicks on the PivotTable to show the PivotTable Tools on the ribbon. Which combination of keys should he press next to complete the procedure? A. Alt + F9 B. Alt +F5 C. Ctrl + K D. Shift +Tab

Alt +F5

Xavier wants to use a solver to find optimal solutions for a decision problem. What should he select as X in the series of clicks for this purpose: Data tab > X > Solver > Enter Solver parameters (read on) > Check "Make Unconstrained Variables Non-Negative" > Select "Simplex LP" > Solve? A. Outline B. Analyze C. Forecast D. Connections

Analyze

You select the ____ option button in the Custom AutoFilter dialog box if you want to display rows that meet both of two criteria. A. Or B. Both C. And D. Either

And

Which of the following will you click on the Reports list box in Solver Results dialog box to produce an Answer Report? A. Limits B. Answer C. Sensitivity D. Outline Reports

Answer

With the Last Quarter criteria filter, quarters are defined as, for example, ____. A. April, May, June B. March, April, May C. May, June, July D. March, April, May, June

April, May, June

Arlo creates a rectangular shape and inserts the text 'Color Box' in it. Then, he right clicks on the shape and selects a button to assign a macro to it. Which of the following can his selection be? A. Assign Macro... B. Format Shape... C. Set as Default Shape D. Size and Properties...

Assign Macro...

Which of the following lets you fill a cell with only specific elements of a copied cell? A. relative cell reference B. Auto Fill Options button C. argument D. mode indicator

Auto Fill Options button

What feature inserts a function that totals the cells above or to the left of the selected cell? A. AutoSum button B. absolute reference C. reference operator D. mode indicator

AutoSum button

The ____ criteria filter requires the records displayed to start with the specified text string. A. Origin B. Begins With C. Initial D. Start

Begins With

If you receive a destination workbook but the source files are not included, click the ____ Link button in the Edit Links dialog box to replace the external references with the existing values. A. Fix B. Break C. Update D. Check

Break

To add and remove chart elements, you can use the Add Chart Element button in the Charts Layout group on the ____ tab. A. CHART TOOLS LAYOUT B. CHART TOOLS DESIGN C. INSERT D. HOME

CHART TOOLS DESIGN

Which function counts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references? A. SUM B. COUNT C. COUNTA D. AUTOSUM

COUNT

_______ analysis expresses the relationship between a company's expenses, its volume of business, and the resulting profit. A. MVP B. ABC C. CVP D. CBP

CVP

To remove workbook protection, click the Unprotect Workbook button in the _____ group on the Review tab. A. Format B. Changes C. Sheet D. Options

Changes

To reposition the legend to the left-hand side of a chart, click the _________ button, point to Legend, click the right arrow icon, and click Left. A. Legend B. Chart Elements C. Formatting D. Layout

Chart Elements

After you filter a column, the ____ Filter command becomes available so you can remove the filter and redisplay all the records. A. Remove B. Clear C. Delete D. Archive

Clear

Luca wants to insert a pivot table. He clicks on a single cell inside the data set, then proceeds to step X, and finally clicks OK in the dialog box that appears after step 2. What can step 2 be? A. Select a pivot table under Pivot Chart & Pivot Tables in the Charts group on the Charts tab. B. Click PivotTable on the Insert tab, in the Tables group. C. Click Recommended PivotTables on the Insert tab, in the Tables group. D. Select a pivot table under Pivot Chart in the Charts group on the Charts tab.

Click PivotTable on the Insert tab, in the Tables group.

Jin wants to insert a recommended pivot table. He clicks a single cell inside the data set, then proceeds to step X and finally clicks OK in the dialog box that appears after step 2. What can step 2 be? A. Select a pivot table under Pivot Chart & Pivot Tables in the Charts group on the Charts tab. B. Click PivotTable on the Insert tab, in the Tables group. C. Click Recommended PivotTables on the Insert tab, in the Tables group. D. Select a pivot table under Pivot Chart in the Charts group on the Charts tab.

Click Recommended PivotTables on the Insert tab, in the Tables group.

Horatio wants to hide field headers in a Pivot table to increase the display of the screen. He clicks on a cell in the pivot table, then clicks on ANALYZE in the ribbon. What should he do next to complete the procedure? A. Click on Clear in the Actions group. B. Click on +/- Buttons in the Show group. C. Click on Field Headers in the Show group. D. Click on Fields, Items & Sets in the Calculations group.

Click on Field Headers in the Show group.

How can one filter a PivotTable using a report filter? A. Click on the drop down arrow for a Report Filter in the pivot table and Click (All). B. Click the Report Filter's drop-down arrow, then click on an item to select an item in the list and click OK. C. Right-click a cell in the pivot table, and click Pivot Table Options, then set the 'Display Fields in Report Filter Area' to 'Down, Then Over' On the Layout & Format tab. D. Right-click a cell in the pivot table, and click Pivot Table Options, then set the 'Display Fields in Report Filter Area' to Over, Then Down' On the Layout & Format tab.

Click the Report Filter's drop-down arrow, then click on an item to select an item in the list and click OK.

How can you remove Split panes in a worksheet you are working on? A. Click the View tab in the Ribbon, then click the Split button in the Window group. B. Click the Page Layout tab in the Ribbon, then click the Bring Forward button in the Arrange group. C. Click the View tab in the Ribbon, then click the Split button and then the Hide button in the Window group. D. Click the Page layout tab in the Ribbon, then click the Insert Breaks button and choose from the drop down menu in the Page Setup group.

Click the View tab in the Ribbon, then click the Split button in the Window group.

To select a single worksheet cell so you can work with it, which of the following would you do? A. Click the cell. B. Move the cell pointer over the cell. C. Click the status bar D. Click the Name box.

Click the cell.

database

Collection of data organized to be easily retrieved and used by the end user

Alejandro wants to change the color of a Pivot Chart he has created to make it a little more impactful. To do so, he clicks the chart he wants to change, then clicks Chart Styles in the upper right corner next to chart, clicks X and selects the color scheme he wants. What can X be in the series of clicks? A. Style B. Color C. Fonts D. Effects

Color

Which of the following should you select as X in the following series of clicks to change the chart type to a clustered column chart: Chart > Chart Tools > Design tab > Type group > Change Chart Type > All Charts > X > Clustered Column > OK? A. Pie B. Bar C. Line D. Column

Column

Which of these is the default report layout for a newly created Pivot table? A. Compact Form B. Outline Form C. Tabular Form D. Chart Form

Compact Form

Which of the following will you select as X in the series to insert a button (form control) into a worksheet: Developer tab > X > Insert > Form Controls > Button Form Control > Worksheet location where you want the upper-left corner of the button to appear > Type OK in the Assign Macro popup window? A. XML group B. Modify group C. Controls group D. Add-ins group

Controls group

To calculate subtotal for a table, the first step is to use the ____ button on the Table Tools Design tab. A. Expand for Calculation B. Convert to Range C. Summary D. Function

Convert to Range

Which of the following would you use to create a duplicate of the selected cell when the CTRL key is pressed? A. Normal pointer B. I-beam pointer C. Move pointer D. Copy pointer

Copy pointer

Adele wants to extract a list of unique items in a database. Which of the following will she select in the series of clicks to do so: Select cell > Data tab > Advanced > Select option under Action (X) > Specify List range > Select a starting cell for copying to location > Check box beside Unique records only > OK? A. Filter the list, in place B. Copy to another location C. Filter unique records D. Copy unique records

Copy to another location

Which dialog box opens after selecting a cell in the list of prepared data, clicking the Insert tab on Ribbon and then clicking the Table command in the Tables group? A. New Table B. Insert Table C. Create Table D. Include Table

Create Table

Which of these keys will you hold to select more than one item while inserting a slicer into a PivotTable? A. Tab B. Alt C. Ctrl D. Shift

Ctrl

Grace wants to insert a Form control button into a worksheet. Which of the following will she select as X in the following series of clicks/entries/selections to display the Developer tab: File menu > Options from drop down menu > X in Excel Options Window > Developer checkbox under the list of Main Tabs > OK? A. Advance B. Language C. Customize Ribbon D. Quick Access Toolbar

Customize Ribbon

The ____ CHART TOOLS contextual tabs appear on the Ribbon when you select a chart. A. INSERT and DESIGN B. DESIGN and FORMAT C. INSERT and FORMAT D. FORMAT and PRINT

DESIGN and FORMAT

Which of the following is NOT a database function provided in Excel? A. DAVERAGE B. DTOTAL C. DCOUNTA D. DGET

DTOTAL

You can display or hide filter arrows for an Excel table by using the Filter button in the Sort & Filter group on the ____ tab. A. Category B. View C. Data D. Home

Data

_____ are an example of conditional formats in Excel. A. Data bars B. Quick Analysis tools C. Font sets D. Percentages

Data bars

____provide descriptive text for the individual data markers, such as pie slices A. Asset labels B. Legend values C. Data labels D. Leader lines

Data labels

The Power Pivot add-in provides access to the _________.​ A. ​Data model ​B. Diagram ​C. Database ​D. None of the above

Data model

A ________ is a highly structured collection of data values organized into separate tables.​ ​A. Data model ​B. Diagram C. Database D. None of the above​

Database

____ order arranges labels in reverse alphabetical order, from Z to A. Reverse B. Major C. Ascending D. Descending

Descending

Ricki wants to apply a particular chart style to a PivotChart she has created. Which of these tabs will help her apply it? A. Layout tab B. Format tab C. Design tab D. Analyze tab

Design tab

You can turn off the macro recorder by clicking the Stop Recording button in the Code group on the _____ tab. A. Insert B. Developer C. Layout D. Macro

Developer

record

Displays the collection of characteristics of a particular person, place, or thing

Amelia wants to insert a hyperlink to an e-mail address. Which of these can be X in the following series of clicks she can use: Select text or picture to display as hyperlink > Insert tab > Hyperlink > Link To > X > Subject box (Type subject ) > OK? A. E-mail Address B. Create New Document C. Place in This Document D. Existing File or Webpage

E-mail Address

To change a range's conditional formatting from data bars to icon sets, which of the following can you do? A. Delete the conditional formatting rule. B. Edit the conditional formatting rule. C. Format the range in the Font dialog box. D. Format the range as a table.

Edit the conditional formatting rule.

You can access the Sort buttons in the ____ group on the Home tab by clicking the Sort & Filter button and clicking a sort option. A. Filtering B. Formatting C. Editing D. Text

Editing

Loralie wants to protect her Excel spreadsheet using a password to prevent others from accessing data in it. What should she select in the Protect Workbook box under Options in the File tab to do this? A. Mark as Final B. Encrypt with Password C. Protect Current Sheet D. Protect Workbook Structure

Encrypt with Password

What will you do in step X in the following series of clicks to change the font size of chart title: (Right-click) Chart Title > Font > Font tab > X> OK? A. Select a color in Color box. B. Enter +Heading in Latin text font box. C. Select Normal Spacing in Spacing box. D. Enter the desired size of the chart title in the Size box.

Enter the desired size of the chart title in the Size box.

To evaluate a formula, you select the cell and then click the _______ button from the Formula Auditing group on the Formulas tab. A. Define Formula B. Select Formula C. Check Function D. Evaluate Formula

Evaluate Formula

Using AutoFill, what would be the extended series of the initial entry Jan? ___ A. uary B. Feb, Mar, Apr C. Kan, Lan, Man, Nan D, Jan1, Jan2, Jan3

Feb, Mar, Apr

In which of these boxes will you list all the possible fields that can be included in your formula in a PivotTable? A. Name text box B. Fields lists box C. Formula text box D. Calculated Field dialog box

Fields lists box

Which of the following tabs lets you set worksheet print options? A. File B. Home C. Page Layout D. View

File

On which tab and button are document properties located for editing? A. File tab, Info Button B. View tab, Show button C. Review tab, Changes button D. Home tab, Alignment button

File tab, Info Button

Which of the following will you select as X in the following series of clicks to change the change the color of a data series: (double-click) Data Series > Format Data Series > Series Options > X > Color > Color of your choice? A. Effects B. Fill & Line C. Shadow Effects D. Series Options

Fill & Line

You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell? A. mode indicator B. Page Break Preview C. scroll bar D. Fill handle

Fill handle

Leigh-Ann wants to filter data in a PIvotChart using a slicer. She clicks on the table and then selects Slicer in a particular group on the insert tab. She then ticks the check boxes for the columns that she wants to filter in the Insert Slicers dialog box and clicks OK. What tab did click during the procedure? A. Links B. Filters C. Symbols D. Sparklines

Filters

You want to change all worksheet occurrences of "Radio" to "TV"; to do this, you can use the _____ feature. A. Find and Replace B. Locate and Replace C. Edit and Find D. Find and Edit

Find and Replace

____ enters text based on patterns it finds in the data. A. AutoComplete B. Flash Fill C. AutoFit DFill

Flash Fill

To change the color of cell content, you use the ________ color list arrow. A. Cell B. Text C. Pattern D. Font

Font

Which of these tabs will you select to alter the font as desired while changing the slicer style? A. Font tab B. Analyze tab C. Border tab D. Slicer Contextual tool tab

Font tab

Jacob wants to import a table from an Access database and put it into a workbook to organize it for a presentation. To do so, he opens a new workbook in Excel, clicks on the Data tab, then clicks on X under Get External Data. He then browses to the location of the database he wants to import and selects the table. He then selects the appearance of the data in the workbook, chooses the cell where he wants it to start, and finally clicks OK. What can X in the series of clicks be? A. From Text B. From Web C. Form Access D. From Other Sources

Form Access

You can open the Format Cells dialog box by right-clicking a cell or selected range, and then clicking _____ on the shortcut menu. A. Format B. Cells C. Format Cells D. Cells Style

Format Cells

You can choose Center, Inside End, Outside End, or Best Fit for the data label positions in the in the ____ pane. A. Format Data Labels B. Format Legend C. Format Chart Area D. Format Axis

Format Data Labels

To copy a cell's formatting to another cell, which of the following can you use? A. Format Cells dialog box B. Format Painter C. Quick Analysis Tool D. Format as Table

Format Painter

Which of the following will you select as X in the following series of clicks to format a range as a table: Home tab > Styles group > X > Table Styles? A. Cell Style B. Cell Effects C. Format as Table D. Conditional Formatting

Format as Table

In a workbook's theme, _____ colors are designated for text and background, _____ colors are used for accents and highlights, and _____ colors are used for hyperlinks. A. Four, two, six B. Two, four, six C. Four, six, two D. Six, four, two

Four, six, two

____ rows and columns lets you keep headings on the screen as you work with the data in a large worksheet. A. Hiding B. Freezing C. Showing D. Sealing

Freezing

To view a worksheet without gridlines showing on the screen, which of the following would you uncheck? A. Gridlines View B. Gridlines Print C. Headings View D. Headings Print

Gridlines View

Che wants to change the chart type of the whole chart to give it a different look. To do this, he follows the following steps: 1. X 2. He clicks Change Chart Type On the Design tab in the Type group. 3. Che clicks the chart type that he wants to use in the Change Chart Type dialog box. What was step 1 in his procedure? A. He clicks the chart area of the chart. B. He selects all the labels of the chart. C. He clicks one data series among the ones she wants to change the chart type for. D. He selects all the data series of the chart.

He clicks the chart area of the chart.

Helen wants to resize slicer buttons to exact dimensions. She selects the slicer, then clicks the Slicer Tools under Options tab. What should she select next to reset the slicer buttons to exact dimensions? A. Height and Width under Size group B. Height and Width under Buttons group C. Format cells under Format in Cells group D. Filter under Sort & Filter in Editing group

Height and Width under Buttons group

A ________ is an organization of fields that start with the most general and go down to the most specific.​ A. Hierarchy ​B. Trendline ​C. Data Cube ​D. Timeline slicer

Hierarchy

To apply a cell style, you would use the Cell Styles command on the _____ tab. A. Layout B. Insert C. View D. Home

Home

To delete records that are incorrect, out of date, or no longer needed, select a cell in each record you want to delete, click the Delete button arrow in the Cells group on the ____ tab, and then click Delete Table Rows. A. Home B. Insert C. View D. Data

Home

What will you select as X in the following series of clicks/entries/selections to apply a table style: Select cell to format as table > X > Format as table > Desired table style? A. Data tab B. Insert tab C. Home tab D. Review tab

Home tab

Which of the following series of clicks will you select to remove banded columns from a table? A. Home tab > Format as Table > Clear B. Home tab > Format as Table > Custom > Clear C. Page layout tab > Format as Table > Click on cell > Clear D. Home tab > Format as Table > New Table Style > New Table Style dialog box > Table Element box > Format > Clear

Home tab > Format as Table > Clear

Which of the following is not a type of trendline?​ ​A. Exponential ​B. Linear C. Horizontal ​D. Power

Horizontal

____ are usually represented by words with colored letters and underlines or images A. Indices B. Hyperlinks C. Templates D. Icons

Hyperlinks

Which of the following is a Math & Trig function? ____ A. INT B. COUNT C. MIN D. AVERAGE

INT

The _______ function returns the amount of a particular payment that is used to pay the interest on the loan. A. PMT B. IPMT C. INPMT D. NPMT

IPMT

To calculate the internal rate of return, use the _______ function with the cost of the initial investment as the first cash flow value in a series. A. IRR B. XNPV C. NPV D. XIRR

IRR

The _____ alert accepts the invalid data but still allows you to cancel the data entry. A. Information B. Stop C. Security D. Warning

Information

_____ messages appear as ScreenTips next to the active cell. A. Value B. Input C. Key D. User

Input

To create a table, click the ____ tab on the Ribbon and then, in the Tables group, click the Table button. A. Design B. Home C. Insert D. View

Insert

Which of the following should be selected as X in the series to assign a macro to a button: Developer tab > Controls group > X > Form Controls > Button Form Control > Worksheet location where you want the upper-left corner of the button to appear > Type in the Assign Macro popup window? A. Insert B. View Code C. Run Dialog D. Design Mode

Insert

What will you select as X in the following series of clicks to insert a Recommended chart: Range of cells > X > Charts group > Recommended Charts > Clustered Column > OK? A. Data tab B. View tab C. Insert tab D. Page Layout tab

Insert tab

Which of the following panes in the Power Map window defines where and how data will be used in the map? A. Layer Pane B. Editor Pane C. Center Pane D. Tour Editor Pane

Layer Pane

Which of the following will you select as X in the following series of clicks to add a data table to a chart: Data Chart > Chart Tools > X > Data table > (Select check box) Show Data table? A. Layout B. Design C. Format D. Kutools

Layout

The ____ category of Excel functions returns (true-false) values. A. Information B. Statistical C. Logical D. Math & Trig

Logical

To have Excel enter the lowest price from a range of prices, which of the following would you use? A. MAX function B. COUNT function C. MIN function D. COUNTA function

MIN function

Kahir wants to delete a macro. To do this, he selects Tools > Macro > X > Select Macro > - sign > Yes on confirmation message dialog box. Which of the following will he select as X in this series of selections? A. Macros B. Excel Add-ins C. Stop Recording D. Visual Basic Editor

Macros

Nathan wants to run a macro from the developer tab. He enables the developer tab by clicking File > Options > Customize Ribbon > Developer tab > Code > X > Macro name box > Run. What should he click as X in this procedure? A. Macros B. Visual Basic C. Record Macro D. Macro Security

Macros

If content is blocked, the _____ located under the Ribbon appears, notifying you that some content was disabled. A. Mini toolbar B. Quick Launch toolbar C. Message Bar D. Status Bar

Message Bar

The _______ function calculates the number of payment periods in an investment or loan. A. RATE B. PV C. NPER D. FV

NPER

To calculate the number of montly payments required to pay off a loan or meet an investment goal, use the _______ function. A. PMT B. FV C. PPMT D. NPER

NPER

The _____ dialog box displays all of the names in the workbook. A. Name Manager B. Ranges C. Definition D. Terms

Name Manager

Izzy wants to move a pivot table to a new worksheet. Which of these should she select after the following clicks to do so: PivotTable > Analyze tab > PivotTable tools > Move PIvotTable > Move PivotTable dialog box > Choose where you want the PivotTable to be placed? A. New Worksheet B. Blank Worksheet C. Fresh Worksheet D. Create Worksheet

New Worksheet

To print your worksheet at its actual size, which of the following would you select? A. Fit to B. No scaling C. Fit sheet to one page D. Scale to fit

No scaling

In the Format Cells dialog box, the _____ tab allows you to format currency by choosing decimal places, comma separators, and regular number displays. A. Number B. Font C. Alignment D. Fill

Number

____ arguments may provide more control over the returned value. A. Relative B. Required C. Optional D. Absolute

Optional

You select the ____ option button in the Custom AutoFilter dialog box if you want to display rows that meet one of the criteria. A. Or B. Both C. And D. Either

Or

The _______ function calculates the amount paid into an investment or loan during each payment period. A. NPER B. RATE C. PMT D. INT

PMT

The _______ function calculates the present value of an investment or loan. A. PRES B. PV C. NPER D. FV

PV

Your worksheet appears with a reduced view of each page and blue dividers where new pages begin. What view are you in? Normal view A. Page Layout view B. Page Break Preview C. Print Preview

Page Break Preview

You can edit a worksheet footer in _____. A. Page Layout view B. Normal view C. Page Break Preview D. Print Preview

Page Layout view

One way to ensure that you are using consistent formats is to copy and paste your formats using the Format _____. A. Master B. Gallery C. Palette D. Painter

Painter

The _____ Macro workbook is a hidden workbook opened whenever you start Excel, making its macros available anytime you use Excel. A. Universal B. Personal C. Microsoft D. XP

Personal

To which of the following chart types can you not add axis titles? A. Pie chart B. Line chart C. Area chart D. Column chart

Pie chart

A ________can retrieve data from multiple fields in different tables in the Data Model​ A. Diagram ​B. Record C. PivotTable ​D. Timeline slicer

PivotTable

Ingrid wants to change the name associated with a Pivot Chart in Excel. To do so, she right-clicks on the pivot table and then selects X from the popup menu. She then enters the new name for the Pivot Chart in the Name field in the window that appears and clicks the OK button. What can X be in this procedure? A. Hide Field List B. Number Format C. PivotTable Options D. Value Field Settings

PivotTable Options

A data structure that stores the information used to create a PivotTable is called the ________________. A. PivotTable cache B. PivotTable format C. PivotTable outline D. PivotTable background

PivotTable cache

Lola wants to install an add-in in Excel. She has to unblock the add-in to allow Excel to open the add-in file automatically. To do this, she right clicks on the add-in file and selects an option from the menu. What could the option be? A. Copy B. Delete C. Rename D. Properties

Properties

You can create conditional cell formats using either the Home tab or the _____. A. Quick Analysis tool B. Cell Styles dialog box C. Font formatting buttons on the Home tab D. Number formatting buttons on the Home tab

Quick Analysis tool

Grace wants to connect a slicer to two PivotCharts. In which of these dialog boxes can she select the pivot tables she wants to link to the slicer and click OK? A. Insert Slicers B. Remove "Product" C. Report Connections D. Multi-select "Product"

Report Connections

Josh teaches sixth grade math. He created a table showing marks that his students scored on an assessment—the last column on the right displays this information. He now wants to add another column to the right showing percentage of marks that each students scored. What should he do after selecting the current last column on the right? A. Right click on it and select Insert from the drop-down menu. B. Right click on it, select Format Cells from the drop-down menu and select Add New Column. C. Click on it, then click the arrow next to Insert in the drop-down menu. D. Double click on it, select Format cells from the drop-down menu and click on Insert.

Right click on it and select Insert from the drop-down menu.

Which of these steps will you choose to refresh data in a Pivot Chart? A. Right-click on the Pivot Chart and select Refresh B. Click on the Pivot Chart > PivotTable Tools > Analyze > Refresh arrow > Refresh Status C. Click on the Pivot Chart > PivotTable Tools > Analyze > Refresh arrow > Cancel Refresh D. Click Analyze > Options > Layout & Format tab > Check Autofit column widths on update and Preserve cell formatting on update boxes

Right-click on the Pivot Chart and select Refresh

Nolan wants to group data in a Pivot table to analyze a subset of data. Which of these series of clicks/ selections/ entries should he follow to do so? A. Ctrl + values > Group B. Group > Analyze > Field Settings > Change Custom Name > OK C. Right-click an item in the group > Ungroup D. Right-click value > Group > Grouping box > Edit values in Starting at and Ending at checkboxes > Under By, select a time period > OK

Right-click value > Group > Grouping box > Edit values in Starting at and Ending at checkboxes > Under By, select a time period > OK

One way to interact with a database is with a query language. A popular query language is _______. A. ODC B. UDC C. OLE D. SQL

SQL

The _______ function returns the sum-of-years' digit depreciation that results in a more accelerated depreciation than straight-line depreciation but less than declining balance depreciation. A. DB B. SLN C. SYD D. VDB

SYD

Where do you rename a workbook and adjust its save location? A. Save As dialog box B. Home tab C. Name box D. Active cell

Save As dialog box

The default ____ for a hyperlink is the folder location and the name of the file to which you will link. A. title B. alt text C. description D. ScreenTip

ScreenTip

Edwin wants to insert a Pivot Chart to summarize raw data. Which of the following combination of clicks/selections/entries should he use to do this? A. Select Cell > Insert > PivotChart > OK B. Select Cell > Insert > Recommended PIvotTables > OK C. Select Cell > PivotTable Tools > Analyze > PivotChart > Select a chart > OK D. Select Cell > Insert > Table > Create Table dialog box > Fill data in Where is the data for your table? box > OK

Select Cell > Insert > PivotChart > OK

Michelle finished a 5 kilometer run in 180th position. The organizers shared an Excel spreadsheet with names of all the participants and the time they took to complete the race. The top 15 finishers are listed in rows 2 to 16. Michelle wants to compare her time against theirs. How can she do so? A. Select row 17 and click View tab > Window group > Split. B. Select rows 2 to 16 and click View tab > Window group > Split. C. Select rows 2 to 16 and click View tab > Window group > New Window > Split. D. Select row 16 and click View tab > Window group > Split > Arrange All.

Select row 17 and click View tab > Window group > Split.

Which of these will you do in step X in the series of clicks/ selections to delete a vertical page break: View tab > Workbook View > Page Break Preview > X > Page layout tab > Page Setup > Breaks > Remove Page Break? A. Select the column to the left of the page break you want to delete. B. Select the column to the right of the page break you want to delete. C. Select the row above the page break you want to delete. D. Select the row below the page break you want to delete.

Select the column to the right of the page break you want to delete.

Which of the following tabs in the Data Validation dialog box allows you to set validation criteria? A. Criteria B. Input Message C. Error Alert D. Settings

Settings

You use the _____ tab in the Data Validation dialog box to enter the validation rules for the active cell. A. Active Cell B. Criteria C. Settings D. Input Message

Settings

Anne has created a chart and wants to apply a different fill color to a chart element. Which of these will she choose after selecting the chart element and clicking on Chart Tools under Format tab? A. Shape Fill B. Shape Styles C. Shape Effects D. Shape Outline

Shape Fill

Which of the following will you select as X in the following series of clicks to apply a shape fill to a chart element: Chart > Chart Tools > Format > Shape Styles > X? A. Shape Fill B. Shape Outline C. Shape Effects D. Shape Borders

Shape Fill

The worksheet range ____ references the worksheets, "Sheet1," "Sheet2," "Sheet3," and "Sheet4." A. Sheet1_Sheet4 B. Sheet1-Sheet4 C. Sheet1:Sheet4 D. Sheet1/Sheet4

Sheet1:Sheet4

You can switch from one scenario to another by clicking the _______ button in the Scenario Manager dialog box. A. Display B. View C. Show D. Effect

Show

Mila wants to digitally sign a workbook to communicate that no further modifications should be made in the workbook. She clicks Insert tab > Text group > X > Microsoft Office Signature Line > Signature Setup Dialog box > Type Information for each box in the dialog box > Show sign date in signature line OK. What can X be in this series of clicks? A. Create New B. Create from File C. Signature line List D. Add Signature Services

Signature line List

_______ is a program that searches for the optimal solution of a problem involving several variables. A. Trial and error B. Solver C. Goal Seek D. Scenario Manager

Solver

In which of the following dialog boxes will you click "Add" under "Subject to the Constraints" to add constraints to a model? A. Options B. Solver Results C. Solver Parameters D. Show Trial Solution

Solver Parameters

In which of the following dialog boxes will you click Load/Save to save a problem model? A. Options B. Solver Results C. Solver Parameters D. Show Trial Solution

Solver Parameters

In which of the following dialog boxes, under Subject to the Constraints, will you click the constraint that you want to change and then click Change? A. Options B. Solver Results C. Solver Parameters D. Show Trial Solution

Solver Parameters

When you extrapolate a series, the _______ value represents the amount that each value is increased or multiplied as the series is extended. A. Increase B. Step C. Extension D. Advance

Step

After drilling down, Esteban wants to drill up to analyze summary data. To do so, he follows the following steps: 1. Select the item to drill up on in the PivotTable hierarchy you have drilled into. 2. Click the Quick Explore button that appears in the lower-right corner of the selection. 3. Use the Quick Explore button to reach the data you want. Which step did he miss while following this procedure? A. Step 3: Select the item you want to explore in the Explore box and then click Drill Down. B. Step 3: Select the item you want to explore in the Explore box and then click Drill Up. C. Step 2: Select the item you want to drill up on and then click Drill Up. D. Step 4: Click OK to complete the procedure.

Step 3: Select the item you want to explore in the Explore box and then click Drill Up.

The following are Excel-supported error alert types: _____. A. Stop, Warning, and Alert B. Alert, Warning, and Information C. Security, Warning, and Alert D. Correct Answer Stop, Warning, and Information

Stop, Warning, and Information

Kathy wants to add the numbers entered in a range of selected cells. To do this, which tab will she click on the menu that appears after clicking on Totals in the Quick Analysis option? A. Sum B. Count C. Average D. %Total

Sum

A chart that compares three set of values in a three-dimensional chart is _____. A. Stock B. Radar C. Surface D. Scatter

Surface

Which of the following keys will you press when the cell cursor is in the last cell of the last record (row) to add new data for the next record? A. Esc B. Ctrl C. Tab D. Shift

Tab

Excel assigns the name ____ to the first Excel table created in a workbook. A. 1 B. 1Table C. NewTable D. Table1

Table1

The ____ report layout displays one column for each field and leaves space for column headers. A. Outline B. Design C. Tabular D. Headers

Tabular

In the Allow list box in the Data Validation dialog box, the _____ option means that the cell will accept only text of a specified number of characters. A. Custom B. Text Length C. Any Value D. Specified Text

Text Length

Which of the following options will you select to restrict access to a shared workbook to only co-workers in your company who are logged into Microsoft Office? A. The Specific People B. The People with Existing Access C. The Co-workers in <name of your organization>. D. The People in <name of your organization>.

The People in <name of your organization>.

If you discover an error immediately after you have confirmed a cell entry, what of the following would you use next? A. The Undo button on the Quick Access toolbar B. The Cancel button on the Formula bar C. The Enter button on the Formula bar D. The Save button on the Quick Access toolbar

The Undo button on the Quick Access toolbar

In the following formula: =IF(A1="YES", "DONE", "RESTART"), what happens if A1= "NO"? _____ A. The formula returns the text "RESTART". B. The formula returns the text "DONE". C. The formula returns the text "NO". D. The formula returns the text "NO, RESTART".

The formula returns the text "RESTART".

OR operator

The use of two or more criteria on different rows.

AND operator

The use of two or more criteria on the same row.

A __________ is a slicer that is applied to date fields. Using the timeline, you can summarize the data for ranges of time intervals from years down to minutes and seconds.​ A. Trendline B. Timeline ​C. Scatter line ​D. PivotTable

Timeline

Which of the following will you select as X in the series of clicks to highlight the top 10 items in a range of cells: (Select) Range of cells > Home tab > Styles group > Conditional formatting > X > Top 10 items > Change value and highlight option in dialog box if required > OK? A. Icon Sets B. Color Scales C. Top/Bottom Rules D. Highlight Cells Rules

Top/Bottom Rules

Which of the following boxes will you check after clicking on a table and then selecting Table Tools > Design, to add a total row to a table? A. Total Row B. Header Row C. Footer Row D. Banded Rows

Total Row

Which option will you click after selecting a chart and clicking on + at its top to add a trendline to a chart? A. Axes B. Legend C. Gridlines D. Trendline

Trendline

You need at least ____ complete years of data to project a seasonal trend for the next year.​ ​A. One B. Two ​C. Three ​D, Four

Two

Shelley creates a table containing the marks of Language Arts students in her class with these columns: Names of Students and Marks. She now wants to see the names of students who scored exactly 60 marks. What will Shelley do after selecting the column header arrow for the column with heading Marks? A. Check the box beside Select All and the number 60 and click OK. B. Uncheck (Select All), select the box beside the number 60 and click OK. C. Select Number Filters > Between > (Enter value 0 in dialog box on top) > (Enter value 60 in dialog box below it) > OK. D. Select Number Filters > Less Than or Equal To > (Enter value 0 in dialog box on top) > (Enter value 60 in dialog box below it) > OK.

Uncheck (Select All), select the box beside the number 60 and click OK.

To remove a worksheet group, you can right-click the sheet tab of a sheet in the group and then click ____ on the shortcut menu. A. Remove Group B. No Group C. Exit Group D. Ungroup Sheets

Ungroup Sheets

Which of the following would you select on the Developer group to record a relative reference macro? A. Macros B. Visual Basic C. Record Macro D. Use Relative References

Use Relative References

To create a macro, you can enter a series of commands in the _____ programming language. A. HTML B. Java C. VBA D. Perl

VBA

PivotTables support all of the following statistical functions to summarize data within each PivotTable field EXCEPT A. CountNumbers B. Product C. Varp D. VSum

VSum

Which of the following should you select as X after selecting the cell to which the validation rule applies, pressing Ctrl + C, then selecting the cell you want to validate, right clicking it, clicking Paste Special, and then selecting X from the context menu and then clicking OK? A. All B. Formats C. Formulas D. Validation

Validation

Which of these functions will you use to find the variance of a population of all of the values to be summarized? A. Var B. Varp C. StDev D. StDevp

Varp

Carol wants to unhide a workbook window she had hidden earlier. Which of these series of clicks can she press to do so? A. View tab > Window group > Unhide B. View tab > Window group > Uncheck box beside Hide > Check box beside Unhide C. File > Options > Display > Check Show all windows in the Taskbar box D. Home > Format > Visibility > Hide & Unhide > Hide Sheet

View tab > Window group > Unhide

In the Allow list box in the Data Validation dialog box, the _____ option means that the cell will accept only integers. A. Integer B. Decimal C. Numerical D. Whole Number

Whole Number

Mila wants to restrict a cell to accept only whole numbers between 1 and 100. What should she select as X in the following clicks/entries/selections: Select cell. Data > Data Validation > Settings tab > Validation Criteria > Allow > X > Data > (select) between > Minimum > (select) 1 > Maximum > (select) 10 > OK > Enter number between 1 and 100 in cell? A. Decimal B. List C. Text length D. Whole number

Whole number

Kathy wants to rename a table she created to list the chapters from a textbook, and the topics they cover. She selects a cell in the table, then clicks on a Tab X on the Ribbon under the Table Tools tab, clicks on the Table Name box to select the existing name, and then types the new name "Book A" and presses the Y key. What can X and Y be in this series of clicks/selections/entries? A. X-Insert tab, Y-Shift key B. X-Home tab, Y-PgDn key C. X-Design tab, Y-Enter key D. X-Page Layout tab, Y-Esc key

X-Design tab, Y-Enter key

Kylie is a corporate trainer. She creates a table with three columns, with column headings as: Skill Number, Skill Name and Learning Objective. She wants to display numbers in the first column in the range of 400 to 500. What can Kylie select as X and Y in the following series of clicks or entries to do so: Click filter icon on the column heading > X > Y > (Enter value 400 in dialog box on top) > (Enter value 500 in dialog box below it) > OK? A. X-Text Filters, Y-Ends with B. X-Text Filters, Y-Begins with C. X-Number Filters, Y-Between D. X-Number Filters, Y-Does not equal

X-Number Filters, Y-Between

The ____ criteria filter requires the records displayed to be since January 1 of the current year to the current date. A. Year to Date B. Today C. Current D. none of the above

Year to Date

Which of the following is true about moving cell contents? A. You can move cells using the Copy command. B. You cannot move cells from one worksheet to another. C. When you move cell contents, they remain in their original location. D. You can move cells using the drag-and-drop feature.

You can move cells using the drag-and-drop feature.

Which of the following is a valid table name? A. %_table B. $Table2 C. _Newtable D. 2Table

_Newtable

When you underline cell content, you are using _____. A. a font style B. an orientation setting C. an indent setting D. a centering style

a font style

Range names must begin with _____. A. a letter or an underscore B. a number C. a hash tag D. an asterisk

a letter or an underscore

Aside from Solver, other Excel _______ provide the ability to perform statistical analyses, generate business reports, and retrieve financial data from the Internet. A. parameters B. add-ins C. helper applications D. constraint applications

add-ins

Solver can create the following three different reports: _______. A. sensitivity, answer, analysis B. constraint, sensitivity, analysis C. analysis, answer, limits D. answer, limits, sensitivity

answer, limits, sensitivity

In the formula =SUM(A6:A9), which of the following best describes A6? A. argument B. function C. label D. active cell

argument

The numbers, text, or cell references used by the function to return a value are called ____. A. expressions B. arguments C. data D. values

arguments

{=SUM(B1:B10*C1:C10)} is an example of a(n) _______. A. array formula B. TABLE function C. scenario D. input value

array formula

Use the XNPV and XIRR functions for cash flows that appear _______. A. with a regular pattern B. at unevenly spaced intervals C. at evenly spaced intervals D. to be cyclical

at unevenly spaced intervals

After the comments, in VBA code the next item is the _____ of the macro. A. module B. body C. procedure D. command

body

In "SUM(number1 [, number2, number3, ...])", number 1, number 2, and number 3 may be numbers or ____. A. letters B. cell references C. symbols D. operators

cell references

Placing a chart in a ____ displays only the chart and no worksheet cells. A. new worksheet B. tabbed view C. graph display D. chart sheet

chart sheet

The _______ displays the data series in separate columns side-by-side so that you can compare the relative heights of the columns in the three series. A. clustered column chart B. stacked column chart C. 100% stacked column chart D. column chart

clustered column chart

Each range is identified with a range reference that includes the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a ____. A. semi-colon B. period C. colon D. comma

colon

"AZ" is an example of a ____. A. column heading B. row heading C. cell reference D. Name box

column heading

You relate tables to one another by using _______ fields. A. key B. common C. indexed D. date

common

To format a range so that all values greater than $500 appear in red, which of the following can you use? A. conditional formatting B. cell formatting C. cell styles D. Quick Access toolbar

conditional formatting

A(n) _______ is a limit that is placed on a Solver problem's solution. A. max B. target C. constraint D. adjustment

constraint

The fill handle copies ____. A. content only B. formats only C. content and formats D. formats and cell references

content and formats

To perform a what-if analysis with more than two input cells, you _______. A. hide all references B. use only exchange values C. apply additional constraints D. create scenarios

create scenarios

If you see a cells with blue fills of varying lengths representing the values, the cells most likely have ________ applied to them. A. themes B. icon sets C. data bars D. cell styles

data bars

A ________ contains the actual values that are plotted on the chart. A. data source B. data series C. category values D. legend

data series

Audra is a manager in the Sales Department for Creative Pastry Gadgets. She needs access to up-to-date financial data and sales reports. Some of this information comes from Excel workbooks, but other information is stored in other software programs. In addition, Creative Pastry Gadgets maintains a database with detailed financial information and sales figures. Audra uses Excel to analyze data from external data sources. ​ Audra decides to import data so it will be stored in an external data range. She learns that Excel automatically assigns the data range a defined name based on the filename of the _______. A. open source B. destination file C. data source D. file source

data source

The process of allocating the original cost of an investment over the years of use is known as _______. A. interest B. balance C. depreciation D. amortization

depreciation

When you save a workbook that contains external reference formulas Excel stores the most recent results of those formulas in the ____ file. A. source B. destination C. both a. and b. D. neither a. nor b.

destination

Most Excel financial functions require a particular _______ to the cash flow to return the correct value. A. index B. valence C. orientation D. direction

direction

When you copy a formula that contains an absolute reference to a new location, the reference ____. A. is updated automatically B. does not change C. becomes bold D. has a dotted outline in its cell

does not change

When combination charts have data series with vastly different values, you can create ____ charts. A. dual axis B. secondary C. multivalued D. multiple axis

dual axis

Category values are usually located in the ____ of the data source. A. first row B. first column C. either a or b D. neither a nor b

either a or b

To move one slice of a pie chart away from the pie creates a(n) ____. A. spontaneous pie chart B. perfect pie chart C. exploded pie chart D. exponential pie chart

exploded pie chart

A formula can include a reference to another workbook (called an ____ reference), which creates a set of linked workbooks. A. internal B. external C. import D. export

external

To add a _____ to a sheet tab, right-click a sheet tab, point to Tab Color on the shortcut menu, and then click a color. A. fill color B. tab setting C. format color D. formatting style

fill color

To set a page break in Excel, select the _____. A. first cell below the row where you want to insert a page break B. first cell above the row where you want to insert a page break C. row above where you want to insert a page break D. row below where you want to insert a page break

first cell below the row where you want to insert a page break

A business must pay insurance and rent; these are examples of _______ expenses. A. fixed B. variable C. mixed D. transitional

fixed

Which of the following is a built-in formula that helps you perform complex calculations? A. clipboard B. mode indicator C. named range D. function

function

The FV function stands for ____. A. function value B. future value C. financial value D. formulated value

future value

When you click a(n) ____, the computer switches to the file or portion of the file that it references. A. index B. hyperlink C. template D. icon

hyperlink

Sometimes when you build a worksheet for other users, you may decide to add a(n) _____ message to a cell even if you do not validate the data in that cell. A. value B. input C. key D. user

input

While deleting a constraint, which of the following relationships will you click for integer to appear in the Constraint box? A. bin B. int C. >= D. <=

int

To _______ a series, the cells between the first and last cells in the series must be blank. A. extrapolate B. concatenate C. integrate D. interpolate

interpolate

A(n) _______ process means that Solver starts with an initial solution and uses that as a basis to calculate a series of solutions. A. reciprocal B. iterative C. secondary D. convergent

iterative

Edward Tufte was concerned with what he termed as "chart ____," in which a proliferation of chart elements—chosen because they look "nice"—confuse and distract the reader. A. espionage B. clutter C. confusion D. junk

junk

Which of the following is NOT an option for arranging your workbooks? A. tiled B. cascade C. horizontal D. lateral

lateral

The ____ identifies which data markers are associated with each data series. A. x-axis B. y-axis C. chart area D. legend

legend

One of the benefits of Live Preview is that it _____. A. lets you see and evaluate different formats as you develop your workbook B. shows you what a document will look like when printed C. applies thematic styles to your document D. allows you to track changes in your document

lets you see and evaluate different formats as you develop your workbook

Every cell in a workbook has a(n) _____ property that determines whether or not changes can be made to that cell. A. ensured B. locked C. security D. changeable

locked

A _____ can be destructive and can modify or delete files that may not be recoverable. A. digital signature B. macro virus C. comment virus D. micro virus

macro virus

A _____ is the space between the page content and the edges of the page. A. margin B. border C. frame D. ruler

margin

You can create a(n) ____ reference by deleting the $ from the row reference in the cell reference $B$6. A. mixed B. absolute C. relative D. indexed

mixed

To calculate the annual rate, you must _______ the value returned by the RATE function by the number of payments per year. A. add B. subtract C. multiply D. divide

multiply

Before using Scenario Manager, you should assign _______ to all the input and result cells you intend to use in your scenarios. A. cells B. names C. ranges D. ranks

names

=ROUND(AVERAGE(A1:A100),2) is an example of a(n) ____ function. A. complex B. logical C. absolute D. nested

nested

Because Excel stores dates and times as _____, you can apply different formats without affecting the date and time value. A. numbers B. text C. universal numbers D. Greenwich Mean Time

numbers

In addition to displaying subtotals, the Subtotal feature "____" your worksheet so you can control the level of detail that is displayed. A. headers B. outlines C. shadows D. defines

outlines

Each sub procedure in VBA begins with the keyword "Sub" followed by the name of the sub procedure and a set of _____. A. brackets B. braces C. parentheses D. asterisks

parentheses

To change the order of operations, enclose part of the formula in ____. A. brackets B. italics C. parentheses D. quotation marks

parentheses

When you borrow money, the money you receive represents a _______ cash flow. A. positive B. negative C. fixed D. neutral

positive

If active cell D12 contains the formula =D10+D11, cells D10 and D11 are _______ cells for D12. A. feeder B. dependent C. precedent D. formula

precedent

PMT(rate, nper, pv [, fv=0] [, type=0]) In the figure above, pv stands for the ____. A. payments verified B. principal value of the loan C. present value of the loan D. primary interest rate of the loan

present value of the loan

When you _____ a workbook, you control the ability users have to make changes to the file. A. ensure B. protect C. secure D. seal

protect

A(n) _______ might ask something like, "What are the names of all the stocks in the portfolio, and what are their corresponding ticker symbols?" A. index B. matrix C. register D. query

query

Like cell ____, a worksheet group can contain adjacent or nonadjacent sheets. A. controls B. groups C. tabs D. ranges

ranges

When creating an Excel document, you should avoid using _____ text and background together, since this is the most common form of color blindness. A. red and green B. yellow and blue C. black and white D. red and yellow

red and green

Databases in which tables can be joined through the use of common fields are known as _______ databases. A. structured B. relational C. linked D. trusted

relational

Formulas created using the point-and-click method contain ____ references. A. absolute B. mixed C. relative D. relational

relative

With Goal Seek, you specify the _______ values you want. A. result B. constraint C. exchange D. index

result

The default template places the formula results aligned to the ____ of a cell. A. right side B. left side C. top D. bottom

right side

If a _____ error appears when you run a macro that has worked in the past, some part of the macro code no longer makes sense to Excel. A. syntax B. run-time C. logic D. baseline

run-time

Which of the following will not change the location of the active cell? A. drag and drop B. scrolling C. clicking another cell D. clicking a column heading

scrolling

The Insert Function dialog box has a(n) ____ option. A. search B. formatting C. find and replace D. expand/collapse

search

To resize an embedded chart, ____. A. select the chart and drag the corner sizing handle of the selection box B. right click the chart and then click Resize on the shortcut menu C. select the chart and press Tab D. both a and b

select the chart and drag the corner sizing handle of the selection box

Keyboard ____ can help you work faster and more efficiently because you can keep your hands on the keyboard. A. KeyTips B. ScreenTips C. ShortTips D. shortcuts

shortcuts

When you reference cells and ranges in other worksheets, if the worksheet name contains spaces, you must enclose the sheet name in ____. A. braces B. brackets C. parentheses D. single quotation marks

single quotation marks

The answer report is divided into _______ sections. A. two B. three C. six D. five

six

A _____________________ can be used to filter a PivotTable or PivotChart to a selected group of records. A. template B. calculated field C. named range D. slicer

slicer

Every ____ consists of an object that contains a button for each unique value in that field. A. piece B. slicer C. section D. part

slicer

A _____ indicates a manual page break. A. dashed blue line B. solid blue line C. dashed red line D. solid red line

solid blue line

A data _______ is any file that contains the data you want to retrieve. A. roster B. link C. dialog D. source

source

A table name cannot include ____. A. numbers B. spaces C. underscores D. letters

spaces

The advantage of an electronic ____ is that the content can be easily edited and updated to reflect changing financial conditions. A. database B. spreadsheet C. expression D. formula

spreadsheet

Protecting the _____ prohibits users from renaming, deleting, hiding, or inserting worksheets. A. skeleton B. structure C. format D. location

structure

In VBA, macros are called _____ procedures. A. body B. sub C. commented D. modular

sub

The following is an example of a delimiter: _______. A. # B. $ C. tab D. period

tab

To move a worksheet or worksheet group to another location in the same workbook, select the worksheets and then drag and drop them by the selected sheet ____. A. tabs B. indices C. keys D. icons

tabs

A ____ is a workbook that you can open with the text, formats, and formulas already built into it. A. boiler B. summary sheet C. template D. range master

template

To create a workbook containing text, formulas, macros, and formatting that you use repeatedly, you create a _____. A. master B. model C. template D. standard

template

After you delete a worksheet column, _____. A. the columns to its right shift left B. the columns to its left shift right C. the row remains but its contents are deleted D. only its formats are deleted

the columns to its right shift left

Which of the following is not a way to move cell contents? A. the Cut and Paste buttons on the Home tab B. the fill handle in the lower-right corner of an active cell or range C. the CTRL key + the Move pointer D. drag-and-drop

the fill handle in the lower-right corner of an active cell or range

FUNCTION(argument1, argument2, ...) is ____. A. the syntax of writing optional arguments B. an example of a formula C. the general syntax of all functions D. the general syntax of all formulas

the general syntax of all functions

PMT(rate, nper, pv [, fv=0] [, type=0]) In the figure above, nper stands for the ____. A. total number of payment periods B. total number of payments that have already been made C. number of payments per year D. number of interest payments per year

total number of payment periods

A(n) _______ arrow provides a visual clue to the relationship between two cells by pointing from the precedent cell to the dependent cell. A. tracer B. outline C. index D. key

tracer

You can split the worksheet window into ____ separate panes. A. two or four B. four or six C. six or eight D. between two and eight

two or four

An input message appears when the cell becomes active, and can be used to specify the _____ of data the user should enter in that cell. A. aspect B. type C. format D. cast

type

In the function =CUMIPMT(rate, nper, pv, start, end, type), it is _______ that defines whether the payments are made at the beginning or end of each period. A. rate B. nper C. end D. type

type

Any blanks or parentheses in a row or column label will be changed to _____ in defined names. A. ampersands B. underscore characters C. hyphens D. dashes

underscore characters

Usually, you will want to protect a worksheet but leave some cells _____. A. open B. empty C. lear D. unlocked

unlocked

In two-variable tables, you must always place a reference to the result cell in the _______ corner of the table at the intersection of the row values and the column values. A. upper-right B. upper-left C. lower-right D. lower-left

upper-left

One way to ensure that correct data is entered into a cell or range is to use the Excel data _____ feature. A. validation B. concatenation C. security D. index

validation

One way to ensure that correct data is entered into a cell or range is to use the Excel data _____ feature. A. validation B. concatenation C. security D.index

validation

In Solver, changing cells are sometimes referred to as _______ cells. A. self-adjusting B. variable C. key D. constraint

variable

Which of the following expense types can be used in a CVP analysis? A. static B. variable C. dynamic D. declining

variable

The three items that you must specify when using Solver are _______. A. target cell, input value, and results B. target cell, variable cell, and parameters C. variable cell, parameters, and constraints D. variable cell, objective cell, and constraints

variable cell, objective cell, and constraints

All three expense types can be classified as _______. A. mixed, fixed, and CVP B. variable, fixed, and mixed C. asset-based, fixed, and mixed D. variable, fixed, and cost-based

variable, fixed, and mixed

To save a workbook with macros, the default Excel Workbook format needs to change to a macro-enabled workbook, which has the _____ file extension. A. xlsm B. xlst C. xlsx D. xls

xlsm