MGT 2180 Module 3-Practice Exam Multiple Choice Questions

Which of the following error values indicates that the formula divides by zero (0) or an empty cell? a. #N/A b. #VALUE! c. #REF! d. #DIV/0!

d. #DIV/0!

In a SUMIFS formula, what is the maximum number of criteria_rangeN arguments? a. 2 b. 7 c. 27 d. 127

d. 127

In OR functions and AND functions, how many LogicalN arguments can you use? a. 10 b. 100 c. 155 d. 255

d. 255

What symbol precedes all structured references in Formula AutoComplete lists? a. # b. $ c. & d. @

d. @

What do you call a row in a table that has exactly the same information in one or more columns? a. identical row b. matching row c. equal row d. duplicate row

d. duplicate row

Which of the following is a character such as an exclamation point that marks or signifies a component of an external reference? a. relative reference b. mixed reference c. external reference formula d. identifier

d. identifier

In an Excel table, what is the name assigned to a column with its table called? a. column reference b. filter reference c. ordered reference d. structured reference

d. structured reference

Which of the following is not an example of SmartArt objects? a. organization charts b. matrices c. pyramids d. text effects

d. text effects

Which of the following financial function arguments specifies if the payment will be made at the beginning or the end of the period? a. nper b. rate c. pmt d. type

d. type

Which of the following is true of a SmartArt graphic's position in a worksheet? a. It rests on an invisible, transparent layer in the worksheet. b. It appears with a solid background and border by default. c. It is linked to worksheet data. d. It is always anchored to the top margin of the worksheet.

a. It rests on an invisible, transparent layer in the worksheet.

Which of the following measures how spread out a set of values is from the average? a. Mean Absolute Deviation(MAD) b. Mean Square Error(MSE) c. STDEV.S d. Standard Deviation

a. Mean Absolute Deviation(MAD)

To select part of a window or screen for a screenshot, which of the following options should you select from the illustrations gallery? a. Screen Clipping b. Screen Area c. Screenshot d. Screen Selection

a. Screen Clipping

Which of the following is used to select adjacent sheets? a. Shift b. Ctrl c. Alt d. Fn

a. Shift

Which of the following is an illustration, which often includes text that can be placed in Excel worksheets? a. SmartArt graphic b. Screenshot c. Screen Clipping d. Shape

a. SmartArt graphic

Which of the following text functions combines text strings? a. TEXTJOIN b. CONCAT c. EXACT d. REPLACE

a. TEXTJOIN

Which of the following is not a popular image format used in Excel? a. TXT b. JPEG c. PNG d. TIFF

a. TXT

Which of the following statements is true about the Subtotal command? a. The Subtotal command is in the Outline group on the Data tab. b. The Subtotal command is available for Excel tables. c. The Subtotal command only includes the SUM function. d. Worksheet data does not need to be sorted into order prior to using the Subtotal command.

a. The Subtotal command is in the Outline group on the Data tab.

Which of the following describes a SmartArt graphic bounding frame? a. The bounding frame is a rectangle that surrounds the graphic. b. The bounding frame is circular and surrounds the graphic. c. The bounding frame is adjacent to the SmartArt graphic. d. The bounding frame appears below the SmartArt graphic.

a. The bounding frame is a rectangle that surrounds the graphic.

Which of the following use ranking or averages to format cells? a. Top/Bottom Rules b. Quick Analysis tool c. Highlight Cells Rules d. all of the above

a. Top/Bottom Rules

Which of the following does not occur after a dynamic consolidation is created? a. Worksheets are automatically grouped. b. The data is consolidated in outline format. c. Each item is collapsed. d. The consolidation sheet displays a 3-D reference in each cell above the result cell when the outline is expanded.

a. Worksheets are automatically grouped.

Which of the following statements is not true? a. You can import text from a Word document directly into Excel. b. You can copy and paste data from Word into an Excel worksheet. c. It is possible to import text files directly into Excel. d. It is possible to save a Word document as a text file.

a. You can import text from a Word document directly into Excel.

What must you build to use an Advanced Filter? a. a criteria range b. a data range c. an extract range d. filters

a. a criteria range

In a database function, what does the field argument reference? a. column to be used in the calculation b. row to be used in the calculation c. range of cells to be analyzed d. labels

a. column to be used in the calculation

Which of the following is a separate summary sheet in a workbook? a. consolidation worksheet b. source worksheet c. dependent worksheet d. external reference

a. consolidation worksheet

Which of the following is not a component of a SmartArt graphic? a. external reference formula b. text pane c. sizing handles d. bounding frame

a. external reference formula

Which of the following is criteria that determines which data is shown and which is hidden? a. filter b. AutoFilter c. criterion range d. all of the above

a. filter

Which of the following commands can you apply to grouped sheets that are not identical? a. header or footer command b. conditional formatting c. insert graphics d. enter functions

a. header or footer command

In an Excel table, which of the following contains descriptive titles or labels? a. header row b. record c. field d. table

a. header row

Which of the following refers to the task of obtaining data from another software program or another file format? a. importing data b. exporting data c. flash fill d. data connecting

a. importing data

Which of the following financial function arguments specifies the total number of payments? a. nper b. rate c. pmt d. type

a. nper

Which of the following is a document that includes basic data, no formatting, and commas or other characters to separate the data into fields? a. text file b. field c. Text Import Wizard d. delimiter

a. text file

Which of the following error values indicates that the formula uses unrecognized text such as a misspelled function, sheet, or range name? a. #NUM! b. #NAME" c. #NULL! d. #DIV/0!

b. #NAME"

Which of the following error values indicates that an incorrect data type is used? a. #N/A b. #VALUE! c. #REF! d. #DIV/0!

b. #VALUE!

In the MATCH function, which of the following match_type arguments finds the first value that exactly matches the lookup_value? a. 1 or omitted b. 0 c. -1 d. -2

b. 0

Which of the following calculates the average deviation of the absolute values in a range? a. STDEV.P b. AVEDEV c. STDEV.S d. RANK.AVG

b. AVEDEV

Which of the following functions would enable you to calculate the average number of on-site visits made by a particular sales representative? a. REPLACEIFS function b. AVERAGEIFS function c. COUNTIFS function d. SUMIFS function

b. AVERAGEIFS function

Which of the following creates groups based on formulas that are located in a consistent pattern in data list? a. Subtotal command b. Auto Outline command c. Group button d. Conditional Formatting

b. Auto Outline command

Which of the following is the first step to insert a screenshot clipping in a worksheet? a. Open the workbook, document, or web site that contains the content to be captured. b. Click the sheet tab where the screenshot will be inserted. c. Click the Take a Screenshot button. d. Draw a rectangle around the content to be captured with the cross hair pointer.

b. Click the sheet tab where the screenshot will be inserted.

If values are edited in source worksheets used in a static consolidation, which of the following commands will update the results? a. Update command b. Consolidate command c. Summary command d. Reference command

b. Consolidate command

Which consolidation method is used when data in multiple worksheets is arranged differently but has the same row and column labels? a. Consolidation by position b. Consolidation by category c. Consolidation by summary d. Consolidation by worksheet

b. Consolidation by category

Which of the following is used to select nonadjacent sheets? a. Shift b. Ctrl c. Alt d. Fn

b. Ctrl

Which of the following database functions counts cells in the field that are not empty that meet the criteria? a. DCOUNT b. DCOUNTA c. DAVERAGE d. DMAX

b. DCOUNTA

Which of the following functions compares two text strings, values, or characters to determine if they are identical? a. CONCAT function b. EXACT function c. REPLACE function d. MATCH function

b. EXACT function

Which of the following functions determines the future value of a series of payments at the same interest rate for a specified period of time? a. PV function b. FV function c. NPV function d. NPER function

b. FV function

Which of the following is the process of referring to data in another workbook? a. Data connection b. Linking c. Trace Dependents d. Consolidating

b. Linking

Which of the following functions looks for data that matches your specifications and displays the location of the data within a list? a. INDEX function b. MATCH function c. IFERROR functionS d. SUMIFS function

b. MATCH function

Which of the following commands sets a read-only file property? a. Manage Workbook b. Mark as Final c. Inspect Workbook d. Protect Workbook Structure

b. Mark as Final

How does Excel treat criteria entered on different rows? a. AND condition b. OR condition c. FILTER condition d. BOTH condition

b. OR condition

Which of the following is not a function listed in the Consolidate dialog box? a. Count b. PMT c. Product d. SUM

b. PMT

Which of the following error values indicates that the formula refers to an intersection of two cell ranges that do not intersect? a. #NUM! b. #NAME" c. #NULL! d. #DIV/0!

c. #NULL!

Which of the following error values indicates that a cell reference is empty? a. #N/A b. #VALUE! c. #REF! d. #DIV/0!

c. #REF!

In the MATCH function, which of the following match_type arguments finds the smallest value that is greater than or equal to the lookup_value? a. 1 or omitted b. 0 c. -1 d. -2

c. -1

Using the PV function, if the interest rate is an annual rate and the payments are quarterly, what should you type after the cell address? a. /12 b. /6 c. /4 d. /2

c. /4

Which of the following represents the short date format? a. October 14, 2019 b. Monday, October 14, 2019 c. 10/14/2019 d. 14-October-19

c. 10/14/2019

Which of the following functions would enable you to count the number of on-site visits made by a particular sales representative? a. REPLACEIFS function b. AVERAGEIFS function c. COUNTIFS function d. SUMIFS function

c. COUNTIFS function

When using the NPV function, which of the following statements is not true? a. For a year with neither a positive or negative cash flow, type a zero (0) for the ValueN argument. b. Cash flow amounts can be negative or positive. c. Cash flows are present payments or receipts. d. The NPV function has two required arguments.

c. Cash flows are present payments or receipts.

Which of the following error values indicates that a value or an argument is missing? a. #N/A b. #VALUE! c. #REF! d. #DIV/0!

a. #N/A

Which of the following error values indicates that the formula uses an invalid numeric entry? a. #NUM! b. #NAME" c. #NULL! d. #DIV/0!

a. #NUM!

Which of the following is an example of an external reference with all of its identifiers? a. ='[WorkbookName]WorksheetName'!CellRange b. =WorksheetName c. =!CellRange d. =!CellRange'WorksheetName'[WorkbookName]

a. ='[WorkbookName]WorksheetName'!CellRange

Which of the following shows the correct syntax for the AND function? a. =AND(LogicalN) b. =AND(database, field) c. =AND(database LogicalN, field) d. =AND(database, field, LogicalN)

a. =AND(LogicalN)

Which of the following shows the correct syntax for the NPV function? a. =NPV(rate,value1,value2,...) b. NPV(rate,value1,value2,...) c. =NPV(value1,value2,...) d. =NPV(value1,value2,rate)

a. =NPV(rate,value1,value2,...)

Which of the following shows the correct syntax for the OR function? a. =OR(LogicalN) b. =OR(database, field) c. =OR(database LogicalN, field) d. =OR(database, field, LogicalN)

a. =OR(LogicalN)

Which of the following functions joins or combines data strings? a. CONCAT function b. EXACT function c. REPLACE function d. TEXT function

a. CONCAT function

Which of the following database functions counts cells with values in the field that meet the criteria? a. DCOUNT b. DCOUNTA c. DAVERAGE d. DMAX

a. DCOUNT

Which function category analyzes money transactions such as loans, bond purchases, depreciation, and mortgage amoritization? a. Financial b. Statistical c. Text d. Logical

a. Financial

Where is the Take a Screenshot command located? a. Insert tab, Illustrations group b. Data tab, Get External Data group c. Page Layout tab, Insert group d. Home tab, Insert group

a. Insert tab, Illustrations group

Which of the following is true about table styles? a. It is possible to remove a style once you've applied it. b. You must save your Excel file before you apply a table style. c. You can not apply a table style until you've used the Quick Analysis tool. d. By default, table styles only apply red, green, and blue shading.

a. It is possible to remove a style once you've applied it.

Which of the following is true about table styles? a. It is possible to remove a style once you've applied it. b. You must save your Excel file before you apply a table style. c. You cannot apply a table style until you've used the Quick Analysis tool. d. By default, table styles only apply red, green, and blue shading.

a. It is possible to remove a style once you've applied it.

Which of the following is not true of PivotTables? a. A PivotTable is a separate worksheet in which you can sort, filter, and calculate large amounts of data. b. PivotTables are not interactive because you cannot rearrange parts of the report for analysis by clicking or dragging. c. The list of data in a PivotTable is dynamic. d. PivotTables provide great flexibility when it comes to analyzing your data.

b. PivotTables are not interactive because you cannot rearrange parts of the report for analysis by clicking or dragging.

Which of the following should you use to perform a multiple column sort? a. Multiple Column command b. Sort dialog box c. Table Tools group d. Subtotal command

b. Sort dialog box

Which function displays columnar data in rows and vice versa? a. MATCH b. TRANSPOSE c. INDEX d. LOOKUP

b. TRANSPOSE

Which of the following statements is not true? a. The Subtotal command is available for a normal range of cells. b. The Subtotal command is available when the range is formatted as an Excel table. c. The Subtotal command automatically inserts summary rows for data that are arranged in related groups. d. If you apply a filter to data with subtotals, you can hide the subtotal rows.

b. The Subtotal command is available when the range is formatted as an Excel table.

Which of the following statements is true about data bars? a. A default data bar style and color is applied after you choose Data Bars. b. The length of the data bars compares the value in each cell to the other values in the selected cell range. c. Icon sets insert icons that represent the upper, middle, or lower values of the cell range. d. all of the above

b. The length of the data bars compares the value in each cell to the other values in the selected cell range.

Which of the following is not true when creating object hyperlinks? a. An object hyperlink is a shortcut to a SmartArt graphic, a chart, or a picture. b. Underlined text displays below the hyperlink. c. Use the Insert Hyperlink dialog box. d. Use the hyperlink ScreenTip to provide information.

b. Underlined text displays below the hyperlink.

Which of the following provides a convenient way to monitor changes in formulas when you work in large worksheets or with multiple sheets? a. Insert Formulas dialog box b. Watch Window c. Formula AutoComplete d. Data Validation

b. Watch Window

When linking workbooks using a formula, what type of link is created? a. a link to the destination workbook b. a link to the source workbook c. a link to the worksheet d. a link to the cell range

b. a link to the source workbook

When linking workbooks using a formula, what type of link is created? a. a link to the destination workbook b. a link to the source workbook c. a link to the worksheet d. a link to the cell range

b. a link to the source workbook

Consider the function =INDEX(array,row_number,column_num). Which of the arguments is a cell range to be searched? a. INDEX b. array c. row_num d. column_num

b. array

How does the Subtotal command format the list data? a. It doesn't format the list data. b. as an outline c. as a table d. as a PivotTable

b. as an outline

How does Excel treat dates? a. as text b. as values c. as filters d. as criterion

b. as values

How many rows must the criteria range of an Advanced Filter have? a. at least 1 b. at least 2 c. 3 or more d. no more than 5

b. at least 2

What is another name for rows that alternate shading on the rows? a. striped rows b. banded rows c. lined rows d. ruled rows

b. banded rows

Which of the following refers to a range of cells that includes a header row and rows of data? a. field b. database c. record d. criteria range

b. database

Which of the following words best describes a Z to A sort? a. ascending b. descending c. rising d. sliding

b. descending

Which of the following should you use when data on source worksheets might be edited after you have created the consolidation worksheet? a. static consolidation b. dynamic consolidation c. constant consolidation d. permanent consolidation

b. dynamic consolidation

Which of the following can you do immediately after you create a dynamic consolidation? a. collapse each outline item b. expand each outline item c. convert outline items to plain text d. delete outline items

b. expand each outline item

Which of the following represents an individual column in a text file? a. text file b. field c. Text Import Wizard d. delimiter

b. field

Which of the following financial function arguments refers to the interest rate for a time period? a. nper b. rate c. pmt d. type

b. rate

In an Excel table, which of the following represents a row of data? a. header row b. record c. field d. table

b. record

Which of the following includes data that is referenced in a dependent workbook? a. dependent workbook b. source workbook c. external reference d. formula identifiers

b. source workbook

How many arguments do all database functions have? a. two b. three c. four d. five

b. three

When using the NPV function, which of the following statements is not true? a. For a year with neither a positive or negative cash flow, type a zero (0) for the ValueN argument. b. Cash flow amounts can be negative or positive. c. Cash flows are present payments or receipts. d. TheNPV function has two required arguments.

c. Cash flows are present payments or receipts.

Which of the following is not true when building date and time calculations? a. Excel uses serial numbers for dates. b. For years between 1900 and 1929, you must key "19." c. Excel uses a 12-hour day in time calculations. d. Use the Format Cells dialog box to select date and time formats.

c. Excel uses a 12-hour day in time calculations.

Which of the following is used for recognizing a pattern in the first cell and suggesting data for the remaining rows in a column? a. AutoFilter b. Advanced Filter c. Flash Fill d. PivotTable

c. Flash Fill

Which function has one or more logical tests with corresponding results for each test? a. MATCH b. IFERROR c. IFS d. INDEX

c. IFS

Which of the following cannot be performed when worksheets are grouped? a. Change fonts b. Change alignment c. Insert a graphic d. Apply a fill color

c. Insert a graphic

Which of the following is not a TEXT function? a. TEXTJOIN b. CONCAT c. MATCH d. EXACT

c. MATCH

Which of the following lets you create your own conditional formatting rule as well as edit existing rules? a. Data Bar command b. Conditional Formatting command c. Manage Rules command d. Rules command

c. Manage Rules command

Which of the following functions assumes that cash flows occur at the end of each period? a. PV function b. FV function c. NPV function d. NPER function

c. NPV function

Which of the following functions calculates the net present value of an investment using a discount rate and a series of future payments and receipts? a. PV function b. FV function c. NPV function d. NPERF function

c. NPV function

When you place a screenshot in a worksheet, what type of object is it? a. SmartArt graphic b. Linked c. Picture d. Shape

c. Picture

Which of the following is a cross tabulation report based on list-type data? a. Pivot b. Table c. PivotTable d. all of the above

c. PivotTable

Which of the following functions allows you to substitute characters for a specified number of characters in existing data? a. CONCAT function b. EXACT function c. REPLACE function d. SUBSTITUTE function

c. REPLACE function

Which of the following ungroups all sheets in a workbook? a. Press Ctrl+Z b. Press Shift+U c. Right-click any sheet tab and choose Ungroup Sheets d. Click the Split command on the Home tab

c. Right-click any sheet tab and choose Ungroup Sheets

Which of the following should you use to calculate the standard deviation for an entire population instead of a sample? a. Mean Absolute Deviation (MAD) b. Mean Square Error (MSE) c. STDEV.P d. Standard Deviation

c. STDEV.P

Which of the following is a picture of a full or partial computer screen inserted as an object in a worksheet? a. SmartArt graphic b. Shape c. Screenshot d. Illustration

c. Screenshot

When you first create an Excel table, what name does Excel give it initially? a. TableA, where A is a letter b. TableC, where C is a character c. TableN, where N is a number d. TableS, where S is a symbol

c. TableN, where N is a number

Which function category splits, joins, or converts labels and values in a worksheet? a. Financial b. Statistical c. Text d. Logical

c. Text

Which of the following displays after the file name in the title bar when worksheets are grouped? a. [Worksheets] b. [Consolidate] c. [Group] d. [Sheets]

c. [Group]

Which of the following refers to a series of equal payments made at the same time of the month or year for a specified period of time? a. depreciation b. amoritization c. annuity d. bond purchase

c. annuity

Which of the following makes it easier to take screenshots? a. maximizing the current window b. minimizing the current window c. arranging open windows side by side d. show the desktop

c. arranging open windows side by side

How does Excel display a sheet that is being used in a dynamic consolidation? a. with hyperlinks b. with text formatting c. as an outline d. as a table

c. as an outline

What do AutoFilter arrows replace when you scroll down in a table with many records? a. fields b. records c. column headings d. none of the above

c. column headings

When created a consolidation worksheet, what must you do to the range of cells to be consolidated? a. copy the contents b. move the contents c. delete the contents d. format the contents

c. delete the contents

In an Excel table, which of the following represents a column of data? a. header row b. record c. field d. table

c. field

Which of the following financial function arguments specifies the amount paid each period? a. nper b. rate c. pmt d. type

c. pmt

Which of the following must you do for the Subtotal command to work? a. sort the rows in ascending order by the first column b. sort the rows in either ascending or descending order by the first column c. sort the rows by the field to be totaled d. none of the above

c. sort the rows by the field to be totaled

Which of the following is a predesigned set of built-in format options? a. Table Tools b. Conditional Formatting c. table style d. table format

c. table style

Which of the following is a predesigned set of built-in format options? a. TableTools b. Conditional Formatting c. table style d. table format

c. table style

Which of the following statements about SmartArt graphics is not true? a. You can customize the text in a SmartArt graphic. b. A SmartArt graphic includes a text pane for entering text. c. As you type in a SmartArt graphic, the text and its shape are sized to fit the contents. d. A SmartArt graphic is linked to worksheet data.

d. A SmartArt graphic is linked to worksheet data.

Which of the following must you do before you can create a group? a. Format the range of cells to be grouped. b. Insert a summary row either above or below the group. c. Sort the data. d. Both insert a summary row either above or below the group and sort the data.

d. Both insert a summary row either above or below the group and sort the data.

Which of the following applies specified formats to cells only when the cells meet some criteria? a. Subtotal command b. Auto Outline command c. Group button d. Conditional Formatting

d. Conditional Formatting

Which of the following applies specified formats to cells only when the cells meet some criteria? a. Subtotal command b. Auto Outline command c. Group button d. ConditionalFormatting

d. Conditional Formatting

Which command links workbooks? a. Scenario Manager b. Data Table c. Share Workbook d. Consolidate

d. Consolidate

Which of the following database functions displays the largest value in the field that meets the criteria? a. DCOUNT b. DCOUNTA c. DAVERAGE d. DMAX

d. DMAX

Which of the following is not a procedure to prepare a consolidation worksheet? a. Arrange worksheet data in the same rows and columns on each sheet. b. Copy one of the source worksheets to create a consolidation worksheet. c. Delete the contents of the cells to be consolidated. d. Delete formulas that will be used on the consolidated worksheet.

d. Delete formulas that will be used on the consolidated worksheet.

Which of the following statements becomes true after your data is formatted as a table? a. Totals automatically display beneath fields that contain values. b. Each label in the header row displays in a larger font. c. Every cell in the table displays an AutoFilter button. d. Each label in the header row displays an AutoFilter button.

d. Each label in the header row displays an AutoFilter button.

Which of the following is not true after inserting a SmartArt graphic? a. A default object is placed in the worksheet. b. The name box displays Diagram followed by a number. c. The text pane displays at the left or right edge of the graphic frame. d. Each shape must be sized to fit the content.

d. Each shape must be sized to fit the content.

Which of the following can be built from a PivotTable? a. PivotFormats b. PivotFills c. PivotFilters d. PivotCharts

d. PivotCharts

Which of the following calculates where a particular value appears in the dataset? a. MeanAbsoluteDeviation(MAD) b. MeanSquareError(MSE) c. STDEV.S d. RANK.EQ

d. RANK.EQ

Which of the following measures how broadly values deviate from the mean or average value in a range of numbers? a. Mean Absolute Deviation (MAD) b. Mean Square Error (MSE) c. STDEV.S d. Standard Deviation

d. Standard Deviation

Which of the following statements is not true about using the SmartArt Tools tabs? a. The Smart Art Tools tabs display when a SmartArt object is selected. b. You can use the tabs to choose a style. c. You can use the tabs to add a shape. d. You cannot change to a different image.

d. You cannot change to a different image.

Which of the following statements is not true about using the SmartArt Tools tabs? a. The SmartArt Tools tabs display when a SmartArt object is selected. b. You can use the tabs to choose a style. c. You can use the tabs to add a shape. d. You cannot change to a different image.

d. You cannot change to a different image.

Which of the following statements is not true about using the SmartArt Tools tabs? a. TheSmartArtTools tabs display when a SmartArt object is selected. b. You can use the tabs to choose a style. c. You can use the tabs to add a shape. d. You cannot change to a different image.

d. You cannot change to a different image.

Using the Text Import Wizard to set the type of delimiter used in a text file, which of the following delimiters is commonly used? a. tab b. comma c. space d. all of the above

d. all of the above

Which of the following can you sort Excel data by? a. cell icon b. font color c. cell fill color d. all of the above

d. all of the above

Which of the following functions can be inserted by the Subtotal command? a. SUM b. AVERAGE c. MIN and MAX d. all of the above

d. all of the above

Which of the following is a task you can perform using the Table Style Options group of commands? a. show or hide various parts of a table b. hide the header row or display a total row c. hide the AutoFilter arrows d. all of the above

d. all of the above

Which of the following is an example of a data visualization command? a. Data Bars b. Color Scales c. Icon Sets d. all of the above

d. all of the above

Which of the following statements is true about Highlight Cells Rules? a. Highlight Cells Rules formatting uses relational operators. b. Highlight Cells Rules formatting uses comparison operators. c. You can create your own rule using other operators or a formula. d. all of the above

d. all of the above

When you sort a cell range using A to Z or Z to A, what is rearranged? a. numeric values b. cells within a selected row c. cells within a selected column d. complete rows of data

d. complete rows of data

Which of the following summarizes data from multiple worksheets using a mathematical or statistical function? a. external reference formula b. source worksheet c. dependent workbook d. consolidated worksheet

d. consolidated worksheet

Which of the following is a type of conditional formatting that displays cells with a fill color, a horizontal bar, or an icon? a. advanced filter b. PivotTable c. Microsoft Access database d. data visualization

d. data visualization

Which of the following is used to separate data? a. text file b. field c. Text Import Wizard d. delimiter

d. delimiter