MIS 111 LAB FINAL

What does Excel display when you enter the formula =DATE(2014,13,1)? "1/1/2015" "1/1/2014" "1/31/2014" "1/31/2015"

"1/1/2015"

For VLOOKUP() and HLOOKUP(), the lookup_value argument can include wildcard characters if the lookup_value argument is ______ and the range_lookup argument is ________ "numeric, true" "numeric, false" "text, false" "text, true"

"text, false"

Which of the following error codes indicates that a problem with a value exists? For example, a negative number was specified by the user where a positive number was expected. #REF! #NUM! #N/A #NAME?

#NUM!

Which of the following is a VALID format for a URL query string in Excel? ---URL---?<Val>=<Name> ---URL---?<Name>=<Val> ---URL---<Name>=<Val>? ---URL---?name?value

---URL---?<Name>=<Val>

By default, what is the extension used when you save a workbook in Excel 2016? .xlsx .xslx .xls .xsl

.xlsx

What are the minimum and maximum zoom ranges that can be displayed in an open Excel worksheet (respectively)? 10%, 400% 10%, 500% 10%, 300% 25%, 200%

10%, 400%

With a single IF() function, how many actions can you ask Excel to carry out? 1 (i.e., an action if the criteria is true) Correct Response 2 (i.e., an action if the criteria is true, or an an action if the criteria is false) 3 (i.e., an action if the criteria is any one of true, false, unknown) As many as you want, this is why IF() functions are so difficult to understand

2 (i.e., an action if the criteria is true, or an an action if the criteria is false)

How many sort options/commands do we have in Excel under the 'Data' tab? 1 2 3 4

3

The formula =COUNTIF(range, "???") returns the number of cells in the range containing exactly ______ characters of text 3 5 4 2

3

What is the result of the following expressions (formulas), respectively? = (10 - 6) * 10 and = 10 - 6 * 10 40 and -50 -50 and 40 40 and 50 50 and 40

40 and -50

What will be the result of this formula =IF(A1<100000,A1*5%,A1*7.5%) , if the cell A1 has a value of 90000? 6750 4750 4500 500000

4500

What does the following formula return? =FIND("m","Big Mama Thornton",1) 8 6 5 7

7

To display today's date in the format like "Today is Friday April 4, 2014", which formula should you use? ="Today is "&TEXT(TODAY(),"dddd, mmmm, yy") ="Today is "&TEXT(TODAY(),"dddd, mmmm d, yy") ="Today is "&TEXT(TODAY(),"dddd, mmmm, yyyy") ="Today is "&TEXT(TODAY(),"dddd, mmmm d, yyyy")

="Today is "&TEXT(TODAY(),"dddd, mmmm d, yyyy")

Use the attached spreadsheet to answer the following question. Which formula can be used to find: How many songs were sung by singers whose last names contain exactly six letters? =COUNTIF(B2:B23,"6*?") =COUNTIF(B2:B23,"{6?}") =COUNTIF(B2:B23,"??") =COUNTIF(B2:B23,"??????")

=COUNTIF(B2:B23,"??????")

Use the attached spreadsheet to answer the following question. Which formula can be used to find: How many songs were sung by singers whose names begin with S? =COUNTIF(B2:B23,"S*") =COUNTIF(B2:B23,"*S") =COUNTIF(B2:B23,"S") =COUNTIF(B2:B23,"S?")

=COUNTIF(B2:B23,"S*")

To generate a series of dates 1 year apart in Excel, which of the following formulas is correct? (assuming the first date is entered in cell A1, and you are trying to compute the next year in the series) =DATE(YEAR(A1), MONTH(A1) + 1, DAY(A1)) =A1 + 7 =DATE(YEAR(A1) + 1, MONTH(A1), DAY(A1)) =DATE(YEAR(A1), MONTH(A1), DAY(A1) + 1)

=DATE(YEAR(A1) + 1, MONTH(A1), DAY(A1))

What formula displays the value of B5 stored in a file named "example.xslx" in a different directory called "TEST" in the "C:\" drive? =HYPERLINK("C:\TEST\example.xslx"B5) =HYPERLINK("C:\TEST\example",B5) =HYPERLINK("C:\TEST\example.xslx",B5) =HYPERLINK("C:\example.xslx",B5)

=HYPERLINK("C:\TEST\example.xslx",B5)

Which of the following options, when used as a formula in the Custom Data Validation criteria for cell A1, will ensure that the entry in cell A1 is an odd number? =ISODD(A1) =ISNOTEVEN(A1) =ODD(A1) All the other options are correct

=ISODD(A1)

Which of the following formulas calculates the number of payment periods for a $5,000 loan that has a monthly payment amount of $117.43. The loan has a 6 percent annual interest rate. =NPER(6%/12,117.43,-5000) =NPER(8%/12,117.43,-5000) =NPER(6%,117.43,-5000) =NPER(6%/12,117.43,50000)

=NPER(6%/12,117.43,-5000)

If cell "A1" contains JOHN F. SMITH and you want this value to be changed into a proper case like John F. Smith, what Excel function would you use? =CASE(A1) =PROPER(A1) =PROPERCASE(A1) =LOWER(A1)

=PROPER(A1)

Which of the following statements is true? A workbook can have at most 3 worksheets. A worksheet can have many workbooks. A workbook can have many worksheets. A worksheet can have at most 3 workbooks.

A workbook can have many worksheets.

How do you group Pivot Table items manually? After creating the pivot table, select the items to be grouped and then choose Analyze (tab) under PivotTable Tools and select Group (group) -> Group Selection After creating the pivot table, select the items to be grouped and then choose Design (tab) under PivotTable Tools and select Group (group) -> Group Selection Select columns in the pivot table and right click on them and choose the option to "Cluster Group" None of the answers provided is valid

After creating the pivot table, select the items to be grouped and then choose Analyze (tab) under PivotTable Tools and select Group (group) -> Group Selection

Which of the following is TRUE about a Watermark in Excel? A watermark is an image (or text) that appears on each printed page. A watermark can be a faint company logo, or a word such as DRAFT. Excel doesn t have an official command to print a watermark, but you can add a watermark by inserting a picture in the page header or footer. All of the above statements are TRUE.

All of the above statements are TRUE

Data validation on a cell or range can do which of the following? Calculate what is allowed based on the content of another cell Use a formula to calculate what is allowed Restrict entry of time values (to be within a specified time frame) All of the options provided are valid

All of the options provided are valid

Assume you have a shape (e.g., a rectangle) on your worksheet. Then, you can use the: "Drawing Tools -> Format -> WordArt Styles group" for which of the following? Convert the shape into a chart Change the shape from a rectangle to a circle Alter text formatting within the shape Insert a Sparkline graphic within a shape

Alter text formatting within the shape

There are two options if you want to save an Excel workbook, so that it can be viewed on the World Wide Web. What are the two options? An HTML file and a single-file web page An HTML file and a JPEG file A Text file and a JPEG file A .ZIP archive file and a Text file

An HTML file and a single-file web page

There are a few commands that could be used to customize sparklines to highlight parts of data. One of them is Negative Points. What is its purpose? Apply a different color to the highest data point in the Sparkline Apply a different color to negative values in the Sparkline Apply a different color to the lowest data point in the Sparkline Apply a different color to the first data point in the Sparkline

Apply a different color to negative values in the Sparkline

In the Top Salespersons list, which feature can be used to populate the numbers "3," "4," and "5" in cells "A17," "A18," and "A19," respectively? Format Cells Quick Access toolbar Autofill =SUM() formula

Autofill

Which of the following is the default font type and font size in Excel 2016? Calibri, 11 point Arial, 12 point Times New Roman, 10 point Cambria, 14 point

Calibri, 11 point

What command would you use to import a CSV file? Choose Data --> Get External Data --> From Text Choose Data --> Get External Data --> From CSV Choose Data --> Import Data --> External None of the provided options is correct

Choose Data --> Get External Data --> From Text

Which of the following is a way of accessing the "Evaluate Formula" dialog box that helps debug a formula? Choose Formula ->Formula Auditing ->Evaluate Formula Choose Formula ->Formula Auditing ->Watch Window Choose Formula ->Formula Auditing ->Trace Precedents Choose Formula ->Formula Auditing ->Show Formulas

Choose Formula ->Formula Auditing ->Evaluate Formula

Which of the following is the keyboard shortcut that creates a new blank workbook in Excel? Correct Response Ctrl + N Ctrl + E Ctrl + W Ctrl + B

Ctrl + N

Which of the following keyboard shortcuts will add the current time to a cell in an Excel worksheet? Ctrl + Shift + : Ctrl + ; Ctrl + ' Ctrl + T

Ctrl + Shift + :

Which of the following shortcuts allows you to enter the same data into multiple selected cells?Example: In a new Excel worksheet select cells A1:B4 and type "MIS111". The text is initially entered into cell A1. What could you do to replicate the same text "MIS111" in all the selected cells? Ctrl+Enter Ctrl+Shift Ctrl+Backspace Ctrl+Insert

Ctrl+Enter

Which key combination can a user press to toggle between formula view and normal view within Excel? Shift-Tab Shift+` Ctrl+` Ctrl-Tab

Ctrl+`

If you are trying to display trends with a Sparkline, you may have to work with irregular time periods in the underlying data. To properly do so, you can click on the Group (command group), then click on "Axis", and choose _________ to format the shape of the chart. Date Axis Type Date Value Type Character Axis Type Find and Replace

Date Axis Type

What command (within Conditional Formatting) is used to delete a specific rule from a worksheet? Delete Rule Clear Rule Alter Rule New Rule

Delete Rule

What is metadata? Descriptive information about a workbook Corrupted data in a workbook The file extension of the workbook Comments and cell annotations in a workbook

Descriptive information about a workbook

Please refer to the figure. Which of the following Excel tabs is NOT visible in a worksheet by default? Developer Review Home Insert

Developer

Which older version of Excel file can Excel 2016 NO LONGER open? Excel can open all of these files. Excel 4 Excel 97 Excel 2000

Excel can open all of these files.

What are the #REF! and #NUM! that may appear in a cell? Excel error codes NA functions range functions a hyperlink reference to a Word document with numbers

Excel error codes

Excel uses column headers to create labels for each _____ on data entry form. Record Data Form Row Field

Field

You can create Sparklines for rows of data that you add later by using the _________ on an adjacent cell that contains a sparkline. Format Painter Fill handle Spray Can Smart Art

Fill handle

How do you change the calculation mode while dealing with a calculation intensive data table? Formulas (tab) -> Calculation (group) -> Calculation Options -> Automatic Except For Data Tables Formulas (tab) -> Calculation (group) -> Calculation Options -> Automatic Formulas (tab) -> Calculation (group) -> Calculation Options -> Manual Press Ctrl+C, followed by: Alt+P

Formulas (tab) -> Calculation (group) -> Calculation Options -> Automatic Except For Data Tables

Please use the attached workbook as an external data source. The workbook has a table called 'Employee'. When you import data, after selecting all the columns from the table using the query wizard (Data (tab) -> Get External Data (command group) -> From Other Sources -> From Microsoft Query), how will you filter the records to retrieve those that has a value 'Tucson' for 'City' column. From the Column to Filter list, select Name. In the right panel, select 'ends with' from the first drop-down list and then type 'm' in the second drop-down list box From the Column to Filter list, select City. In the right panel, select 'equals' from the first drop-down list and then select 'Tucson' from the second drop-down list From the Column to Filter list, select City. In the right panel, select 'ends with' from the first drop-down list and then type 'T' in the second drop-down list box From the Column to Filter list, select Age. In the right panel, select 'equals' from the first drop-down list and then select 'Tucson' from the second drop-down list

From the Column to Filter list, select City. In the right panel, select 'equals' from the first drop-down list and then select 'Tucson' from the second drop-down list

The easiest way to enter a function into a formula is to use Formula AutoComplete (the drop-down list that Excel displays while you type a formula). Another way to insert a function is to use the ______ on the _________ tab. Function Library group (on the) Formulas Formulas group (on the) Functions Functions group (on the) Insert Calculations group (on the) Formulas

Function Library group (on the) Formulas

After pressing "Alt + H" while in an open Excel worksheet, a number of Key Tips are displayed. Which ribbon tab do these Key Tips relate to? Correct Response Home Review Insert Formulas

Home

Which of the following is NOT one of the Excel functions to determine whether a cell contains an error value? ISERROR ISNA ISLOGICAL ISERR

ISLOGICAL

To add one or more Slicers to a worksheet, start by selecting any cell in a pivot table and then choose ______________. Insert (tab) -> Filters (group) -> Slicer. The Insert Slicers dialog box appears. Insert (tab) -> Slicer (group) -> Filters. The Insert Slicers dialog box appears. Right Click on it. The Insert Slicers menu option can be selected. All of the answers provided are correct

Insert (tab) -> Filters (group) -> Slicer. The Insert Slicers dialog box appears.

If you need to display lots of text in a worksheet, you can consider using a text box. How will you insert a textbox? Insert (tab) -> Links (command group) -> Text Box Insert (tab) -> Symbols (command group) -> Text Box Home (tab) -> Text(command group) -> Text Box Insert (tab) -> Text (command group) -> Text Box

Insert (tab) -> Text (command group) -> Text Box

After you have selected the data to create a chart, which of the following is the correct sequence of options needed to create a clustered column chart? Insert --> Charts --> Column --> Clustered Column Insert --> Charts --> Bar --> Clustered Column Insert --> Charts --> Clustered Column Insert --> Charts --> Other Charts

Insert --> Charts --> Column --> Clustered Column

Which of the following is TRUE about the color scale formatting option? It varies the background color of a cell based on the cell's value relative to other cells in the range. Color scale conditional formatting does not use a gradient. This formatting option will cause high value and low value cells to have the same color. The color scale cannot be customized.

It varies the background color of a cell based on the cell's value relative to other cells in the range.

Which of these dates will Excel store as a text string rather than a serial number? June 23, 2014 23-June-14 June 23 2014 05/05/14

June 23 2014

The __________ function can be used to find the count of characters in a word or text string. COUNTCHARS() NUMLETTERS() LEN() NUMCHARS()

LEN()

Which of the following options provides correct syntax for the LOOKUP function? LOOKUP(lookup_value,lookup_vector,[result_vector]) LOOKUP(lookup_vector,result_vector) LOOKUP(lookup_value,answers_range) LOOKUP(lookup_value)

LOOKUP(lookup_value,lookup_vector,[result_vector])

The HYPERLINK function syntax has two arguments. Which argument has the path and file name to the document to be opened? Link_location Friendly_name Name File

Link_location

To apply specific formatting to a sparkline, use the Sparkline Color or the ___________ commands. Sparkline Editor Sparkline Style Marker Color Sparkline Developer

Marker Color

To display the Total Row in a Table: choose Table Tools / Design -> Table Style Options (command group) and put a check mark next to Total Row. Selecting a cell in the Total Row and clicking on the drop-down arrow that appears in that cell will NOT allow you to select which of the following summary formulas? Average Count Sum Mode

Mode

Which function is used to calculate depreciation in Excel using the straight line method? DB() DDB() SYD() None of the above

None of the above

When you use the HLOOKUP() function, which of the following parameters represents the row number from which the matching value will be returned? range lookup lookup_value row_care_param None of the options provided is correct

None of the options provided is correct

What is the correct syntax for the PMT function, if we are only considering the required parameters/arguments for the function? (Note: "nper" means Number of Payments) PMT(rate,nper) PMT(rate,nper,pv) PPMT(rate,per,nper,pv,fv) PMT(required)

PMT(rate,nper,pv)

Which of the following options would you choose if you want to insert a page break in the worksheet? Page Layout (tab) -> Page Setup (group) -> Breaks -> Insert Page Break Page Layout (tab) -> Page Setup (group) -> Breaks -> Reset All Page Breaks Page Layout (tab) -> Page Setup (group) -> Breaks -> Remove Page Break Page Layout (tab) -> Sheet Options (group) -> Breaks -> Insert Page Break

Page Layout (tab) -> Page Setup (group) -> Breaks -> Insert Page Break

By default, Excel prints worksheets in ___________ orientation Landscape Portrait Angular Glossy

Portrait

For this question, please download the attached Excel workbook. Convert the data on Sheet1 into a table. Next answer the following question: What keys do you need to press to select the newly created table so that it can be copied or moved to a different worksheet? Press Crtl+X Press Ctrl+Z Press Crtl+V Press Crtl+A

Press Crtl+A

________ can be used to check whether all of the columns fit on one page before printing an Excel worksheet. Quick Print Print Preview Page Layout A Pivot Table

Print Preview

What is the syntax for the RATE() function? RATE(nper,[fv],[type],[guess]) RATE(nper,pmt,pv,[fv],[type],[guess]) RATE(rate,nper,pmt,pv,[fv],[type]) RATE(nper,pmt,pv,[guess])

RATE(nper,pmt,pv,[fv],[type],[guess])

Adding comments to a cell is available through which tab of the Excel ribbon? Home Formulas Data Review

Review

The first field you add to a PivotTable report that does not contain numbers will automatically be added in the _______ part of the report. Column Labels Report filter Row Labels Slicer Group

Row Labels

The last step in the Query Wizard, "Finish", lets you do which of the following? Save a query so that you can reuse it Determine the order of sorting the output Choose hyperlinks that will appear for the query Decide whether the query will use relative or absolute cell references

Save a query so that you can reuse it

When you have several drawings on a worksheet, you may want to align or evenly space these objects. What is the best way to do it? Drag the objects and adjust spacing with your mouse and with the aid of a ruler Use Navigation arrow keys to move the selected object, one pixel at a time Select the appropriate command from: Drawing tools -> Format (tab) -> Arrange (command group) -> Align (drop-down list) This is not possible in Excel, instead you must use Photoshop to achieve such effects

Select the appropriate command from: Drawing tools -> Format (tab) -> Arrange (command group) -> Align (drop-down list)

Please see the attached workbook image. What sequence of steps will allow you to format the data into a table? Select data, then click "Ctrl + 1" and choose the "Table Creation"option Select the data, then click "Table" under the "Insert" tab of the Excel Ribbon Select data, then click on conditional formatting command in Excel Select data, then click the "Convert to Table" option under the Table Tools / Design tab

Select the data, then click "Table" under the "Insert" tab of the Excel Ribbon

What does selecting the option "Current region" within the: Go To Special Dialog Box (Home (tab) -> Editing (command group) -> Find & Select) do? Selects the entire array Selects all graphic objects on the worksheet Selects a rectangular range of cells around the active cell Selects all empty cells

Selects a rectangular range of cells around the active cell

Which of the following is NOT one of the types of Sparkline graphics? Line Column Win/Loss Slicer

Slicer

Which icon (in data validation error alerts) is used to prevent users from entering invalid data into a cell? Stop Warning Information Prevent

Stop

In Excel 2016, in order to change the date's default format, one needs to change ___________ settings. System-wide (i.e., all of Windows) Excel optional Pivot Table Text formatting

System-wide (i.e., all of Windows)

Excel formatting tools are available at the following locations: The Format Cells dialog box and the Home Tab of the Ribbon On the Home Tab of the Ribbon only On the Mini toolbar that appears when you right-click a range or a cell, and the Home Tab of the Excel Ribbon The Format Cells dialog box, the Home Tab of the Ribbon, the Mini toolbar

The Format Cells dialog box, the Home Tab of the Ribbon, the Mini toolbar

What part(s) of a table can be selected? An entire column, but not an entire table An entire row, but not an entire column The entire table or an entire row only The entire table, an entire row, or an entire column from a table can be selected

The entire table, an entire row, or an entire column from a table can be selected

Please see the attached workbook. To round off B11 cell to four decimal places what formula would you use? The formula: =AVERAGE(4,B11) The formula: =ROUND(B11,4) The formula: =FLOOR(B11,2,2) The formula: =DECIMAL(B11,4)

The formula: =ROUND(B11,4)

The "Go to Special" dialog box in Excel allows a user to select all of the following EXCEPT: Cells that contain comments Blank cells All cells that differ from the active cell in a selected column The second to last cell in a selected column that contains data or formatting

The second to last cell in a selected column that contains data or formatting

The formula =COUNTIF(range, "*budget*") will count the number of cells in the specified range containing the word "budget" in certain positions within the text. Which of the following best describes the cells counted? The word "budget" must appear in the cells surrounded by asterisks (i.e., the * character). The word "budget" can appear anywhere within the cell. It looks specifically for cells containing budget multiplied by some number. For example, a cell containing the formula: "=budget*0.25". Only cells with the text "budget" at the beginning or the end of the cell, are counted. Thus a cell with "budget constraint" is counted, but a cell with "Previous budget estimates" is not counted.

The word "budget" can appear anywhere within the cell.

What is the output of the following command sequence: click the Analyze tab under PivotTable tools -> Actions (group) -> Clear -> Clear Filters? This removes all the filters at once This removes only filters on the selected column (or row) This does not remove any filters This is not a valid command sequence for any pivot table

This removes all the filters at once

To find a working date that falls after a number of days (e.g., 12 business days after some date), you typically use this function: WEEKDAY() TODAY() WORKDAY() NETWORKDAY()

WORKDAY()

In Excel, a/an ________ is created or run to retrieve text or data from a Web Page. Web Query SQL command Table of formulas Database design

Web Query

When a row of data is very ____ and requires repeated horizontal scrolling, consider using a data form to add, edit, find, and delete rows Wide Narrow Transformed Empty

Wide

Is it possible to get the data back after deleting it using keyboard ? May be Yes No None of the (other) options provided is correct

Yes

Would you be able to apply the "watch window" option in multiple sheets at the same time ? Yes, but only if there are no more than 3 sheets in the workbook This option was available in Excel 2013 but not in Excel 2016 no Yes

Yes

In Excel, can you insert a Shape into a chart? Yes, select the chart and then click inside the chart to insert the Shape. No, this feature in not available in Excel 2016. Yes, click on the Shape in your worksheet, then Insert a chart; Excel infers that you want the shape copied into the chart. None of the options provided is correct.

Yes, select the chart and then click inside the chart to insert the Shape.

What characters are NOT allowed in sheet names ? [] , All options are correct !

[]

Which of the following characters is VALID for use in an Excel workbook file name? Correct Response _ : " \

_

How can you insert a header or footer into the workbook? a) Click File > Print > Page Setup and edit the header and footer. b) Click Insert (tab) --> Header and Footer (group) --> Edit c) In the Page Layout view, click on the placeholder for the header or footer, and add the information. a and c

a and c

To find an asterisk (i.e., the symbol: * ) within a cell, you enter which of the following in an Excel form search criteria? a tilde followed by a question mark a tilde followed by an asterisk a tilde by itself this is a type of search you cannot do with Excel Forms

a tilde followed by an asterisk

Which of the following types (chart types) is a VALID option in the Charts ribbon group on the Insert ribbon tab? all of the options provided are valid area scatter column

all of the options provided are valid

When a range of cells is selected, which of the following occurs? the selected cells are all highlighted in the same color none of the cells is highlighted in any color a box marks the boundary of the selected cells, but none of the cells are highlighted all selected cells are bounded by a selection box, and all but the active cell in the range are highlighted/shaded

all selected cells are bounded by a selection box, and all but the active cell in the range are highlighted/shaded

A pivot table and a pivot chart are joined in a two-way link, if you make structural or filtering changes to one, the other _______. also changes remains unchanged shows a sparkline graphic to highlight the change can be eliminated to avoid duplicates

also changes

Consider the HLOOKUP function in Excel. If the "range_lookup" argument is set to TRUE, we need to sort the first column of the range in ____________ order descending ascending color coded ranged

ascending

After you create a chart, which of the following actions can you perform on it? change the chart type, but not the data series change the chart formatting and colors, but not the data series modify the data series, but not change the formatting change the chart type, formatting, and data series

change the chart type, formatting, and data series

Please refer to the figure. The address of the active cell consists of which of the following? column letter, row number column height, row width column letter row number

column letter, row number

Which of the following does the function =NOW() return? current date current time current date and time nothing, it is not a valid Excel function

current date and time

Consider a Column Sparkline with three columns. A wide area of blank space between two columns in a sparkline corresponds to which of the following? boolean data missing data a right aligned cell a value formatted as currency (not supported by sparklines)

missing data

Which of the following types of data may NOT be contained in a cell in an Excel worksheet? objects formulas text numeric

objects

You select a cell with data "120" in an Excel worksheet and press the "Delete" key on your keyboard. Which of the following holds TRUE? only the contents of the cell are removed the contents and formatting of the cell are removed only the formatting of the cell is removed no changes occur

only the contents of the cell are removed

_________ is a graphical data representation of data displayed in a pivot table. pivot chart reverse pivot pie chart slicer sparkline

pivot chart

Which of the following methods will NOT move or copy a worksheet? click the worksheet and drag it to the desired location click the worksheet tab and press "Ctrl" while dragging it to the desired location right-click the sheet tab and choose Move or Copy from the dialog box press keyboard shortcuts Ctrl + C and Ctrl + V in order

press keyboard shortcuts Ctrl + C and Ctrl + V in order

When do you use the following sequence of commands: PivotTable Tools -> Analyze -> PivotTable -> Options -> Generate GetPivot Data? prevent Excel from using GETPIVOTDATA function make use of GETPIVOTDATA function add GETPIVOTDATA function to the pivot table enable GETPIVOTDATA function for the pivot table

prevent Excel from using GETPIVOTDATA function

Step 3 of the Query Wizard lets you specify how you want the ______. records to be filtered record selection criteria named records to be sorted query to be saved

records to be sorted

What does it mean when excel displays the following error? ##### a number is divided by a very large number that is #'d out for privacy the column is not wide enough to display contained data or a negative date or time is used unrecognized text not matching a data validation rule none of the options provided is valid

the column is not wide enough to display contained data or a negative date or time is used

Which of the following is NOT a tool in Analysis ToolPak for Excel? y-Test t-Test z-Test F-test

y-Test