Combo with "Chapter 11 myitlab Isaac Toivonen" and 5 others

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

What is the maximum number of IF statements in a formula?

64

Which of the following functions does not contain a syntax error?

=AVERAGE(B1:B9)

Which of the following is a nested function?

=IF(AND(B7>5,"Yes","No"

Which of the following functions does not contain a logic error?

=IF(B6>C6,"Yes","No")

Which of the following functions requires all arguments to be true in order to return the value if true?

AND

Which of the following functions should be used to evaluate multiple conditions with only two possible outcomes?

AND

Which of the following logical functions will return a value if false if one of the arguments is false?

AND

What is the default reference type when recording a macro?

Absolute

Which of the following tools is best suited to review your files for potential issues that could hinder the ability of users who access your public files?

Accessibility Checker

Which Excel Options category contains Editing options?

Advanced

Which of the following is not a tab located in the Properties dialog box?

Advanced

Which of the following functions has the ability to copy all results to a new location?

Advanced Filter

Which of the following has the ability to restrict data view to only information that fits predetermined criteria?

Advanced Filter

When using Advanced Filtering empty cells in the criteria range will return which of the following?

All records

Which of the following is not a predefined cell style category?

Analysis

Which of the following cannot be accessed via a hyperlink in Excel?

Another program

The first argument of the INDEX function is:

Array

Where are Trust Center options located?

Backstage

Where do you access the Excel Options dialog box?

Backstage

Where is the Accessibility Checker located?

Backstage

Where is the Template gallery located?

Backstage

Which of the following is not a customizable feature within Excel?

Backstage

Which of the following are used in VBA to leave notes or instructions regarding the macro?

Comments

Which of the following is not true regarding comments in an Excel workbook?

Comments are indicated by a black triangle

What tool is best suited to combine multiple versions of a shared workbook into one document?

Compare and Merge

Which of the following tools is best suited to check the workbook contents to see what data and features are not compatible with previous versions?

Compatibility Checker

When tracking changes, which of the following options is no longer available?

Conditional formatting

When worksheets are grouped which of the following actions will not occur across all worksheets?

Conditional formatting

Which feature is best suited to split imported text into multiple columns?

Convert Text to Columns Wizard

Which of the following is not a tool to help provided a unified look and feel within a workbook?

Custom functions

Which database function should be used to count records with empty cells?

DCOUNTA

Which database function will return the largest value from a dataset based on preset criteria?

DMAX

Which database function will return the smallest value from a dataset based on preset criteria?

DMIN

Which of the following database functions is best suited to add total salaries from a database that are higher than $30,000?

DSUM

Which of the following is not a statistical function

DSUM

Which of the following tools is best suited for checking a workbook for personal data?

Document Inspector

Which of the following is an integrated option for sending files to others?

E-mail

Which of the following describes importing data into Excel but do not maintaining a link to the original data source?

Embed

Which of the following is not a tool to check a workbook for errors?

File Inspector

Which of the following is not an argument in a database function?

Filter

Which of the following features will automatically complete lists?

Flash Fill

Which of the following is a feature in Excel that can often perform the same task as the PROPER function?

Flash Fill

Which of the following is not an Excel Options category?

Format

Which of the following changes will Excel not track?

Formatting

Which of the following items cannot be added to the Ribbon?

Formula

Which of the following would cause the error #DIV/0! to appear?

Formula attempts to divide a value by zero or an empty cell

Which of the following is not part of XML?

Hyperlink

Which function is best used to return a value if an error exists in a cell?

IFERROR

Which function should be used to mask zero values in templates?

IFERROR

Returns the value or the reference to a value within a range based on X and Y coordinates.

INDEX

Which function will return the intersection of a specific row and column?

INDEX

Which of the following functions does not manipulate text?

INDEX

Which of the following functions returns a value or the reference to a value within a range based on X and Y coordinates?

INDEX

Which of the following functions will return the interest payment of a loan?

IPMT

Which of the following objects can be used to launch a macro?

Image

Which of the following items is not stored as metadata in a workbook?

Imported images

Which of the following would cause the error #VALUE! to appear?

Incorrect data used in an argument

Which of the following items is not stored inside VBA modules?

Index documents

Author properties can be updated from which category in the Backstage view?

Info

All of the following could produce a #NAME? error with the exception of which one?

Invalid arguments in a function

What error will cause #NUM! to appear?

Invalid arguments in a function

Which of the following is true about a protected worksheet?

It cannot be edited

What is the purpose of the CONCATENATE function?

Joins text strings

Which function is best suited to return the specified number of characters from the start of a text string?

LEFT

Which function will convert a text string to lowercase?

LOWER

Which of the following is not true about locked cells?

Locked cells can be edited

Which of the following is not a good practice when creating a template?

Locking view settings

What is the first argument of the IF function?

Logical_test

Which of the following is not a data validation stop style?

Lookup

Where can XML files be opened in Excel?

Open dialog box

Which of the following functions will exclude quartiles 0 and 4 in its calculations?

QUARTILE.EXC

Which function is best suited to calculate quartiles including quartiles 0 and 4?

QUARTILE.INC

Identify the statistical function used if the rank value returned for duplicate values was 8.5?

RANK.AVG

Which of the following functions will use average values to determine the rank of a number within a list if duplicate values are present?

RANK.AVG

Which of the following functions will rank two values evenly if there is a duplicate value present?

RANK.EQ

Which function will calculate the periodic interest rate of a loan with a $500 payment on a $20000 loan paid back over 5 years?

RATE

Which function is best suited to return the specified number of characters from the end of a text string?

RIGHT

Where is the New Comment command located?

Review tab

Where is the Protect Sheet command located in the Ribbon?

Review tab

Where is the Share Workbook command located within Excel?

Review tab

Where is the Track Changes feature located?

Review tab

Which of the following is not an option when highlighting changes?

Reviewed

What message is displayed in the status bar when a connection is being updated?

Running background query

Which of the following functions is best suited to replace the word "Doctor" with "Dr." in a text string?

SUBSTITUTE

Which of the following functions is best suited to add numbers based on one condition?

SUMIF

Which of the following is not a limitation when working with Web queries?

Tables that contain foreign characters

Which of the following is a required element of XML?

Tag

The maximum number of IF statements in one formula is 64.

True

Which of the following Excel Options categories contains information about protecting your privacy?

Trust Center

Which of the following is not a Trust Center option?

Trusted Calculations

Which of the following scenarios would trigger the Resolve Conflicts dialog box in a shared workbook?

Two users attempt to change the same cell at the same time

What is the cause of the error message "File in Use"?

Two users open the same unshared workbook

Which function will convert a text string to all capitals?

UPPER

In the function =IF(E5 < J7,F5*K7,IF(E5 < =J8,F5*K8,F5*K9)), F5*K7 is the:

Value_if_true

What is the second argument of the IF function?

Value_if_true

What auditing tool is best used to monitor the changes in a cell over time?

Watch Window

Which of the following tools is best suited for setting up a connection to a table on a Web page?

Web query

When is the input message displayed in a cell that contains a validation rule?

When the cell is clicked

Where can all connections in a workbook be viewed or edited?

Workbook Connections dialog box

Which of the following is a limitation of sharing workbooks?

Workbooks that contain tables may not be shared

What governing body created XML?

World Wide Web Consortium

In Excel, hyperlinks appear as:

blue text with a blue underline.

To ungroup worksheets:

click a worksheet tab for a sheet that is not grouped.

To group nonadjacent worksheet tabs:

click the first worksheet tab, press and hold Ctrl, and then click each additional worksheet tab.

To group adjacent worksheets:

click the first worksheet tab, press and hold Shift, and then click the last worksheet tab.

This file type uses commas to separate data into columns.

csv

What does XML stand for?

eXtensible Markup Language

.xlsb files do not support macros.

false

A cell that contains a comment is marked with a blue triangle.

false

A hyperlink cannot be used to access an e-mail address.

false

Access database tables cannot be imported into Excel.

false

Advanced filtering will not copy results to a new location.

false

An Internet connection is not required to send an Excel workbook via e-mail.

false

By default all cells are locked.

false

Comments cannot be viewed in the VBA editor.

false

Custom cell styles cannot be removed.

false

Custom functions can be created with the macro recorder.

false

Custom styles cannot be applied to other workbooks.

false

Dependent cells contain formulas independent of other cells.

false

Excel cannot export .CSV files.

false

Excel cannot save workbooks for previous versions of Excel.

false

Flash Fill is located on the Ribbon.

false

If the criteria of an advanced filter is blank no records will be returned.

false

If the destination file is closed when you change data in the source file, the destination file does automatically update to match the source file.

false

Macro settings cannot be edited in the Trust Center.

false

Once applied custom backgrounds cannot be deleted.

false

Once created a custom function cannot be edited.

false

Once created, macro buttons cannot be deleted.

false

PPMT should be used to calculate the specific interest paid on one installment of a loan.

false

Shared workbooks only function properly on network drives that are read-only.

false

The #DIV/0! error indicates a misspelled word in Excel.

false

The FV function is best suited for calculating the current value of an investment.

false

The LOWER function will capitalize the first letter of a text string.

false

The NPER function would be best used to determine the periodic interest rate of an investment.

false

The PROPER function will convert every character in a text string to lowercase.

false

The PV function would be best suited to calculate the future value of an investment.

false

The Ribbon cannot be customized.

false

The VLOOKUP function can be used to create a 3-D formula.

false

The macro recorder can append a previously recorded macro.

false

The split bar gives the user the ability to view two different workbooks simultaneously.

false

To compare and merge workbooks, the workbooks cannot be shared.

false

To remove a hyperlink, right-click it, and then select Link Options.

false

Web queries refresh data automatically.

false

When arranging windows, tiled is not an option.

false

When creating a history worksheet using change tracking, the worksheet is automatically saved.

false

Workbook comments can only be removed one at a time.

false

XML elements cannot be nested.

false

You embed the data within a worksheet when you import data and maintain the link to its original source.

false

When importing an Access database table, Excel:

formats the data in default table style

Web queries cannot accurately import data from Web sites that are password protected.

true

When a signature line is added, the document becomes read-only.

true

When a stop is chosen as the error style using data validation, the user will not be able to continue.

true

When a worksheet is split, any changes made to one pane updates the entire worksheet.

true

When active, the Document Panel displays above the current workbook.

true

When connections are being refreshed, Excel displays the message "Running background query" in the status bar.

true

When creating templates, IFERROR should be used to mask zero values.

true

When information is chosen as the error style using data validation, the user will be able to input the incorrect data.

true

When opening a second window of the current workbook :2 will appear after the title.

true

When workbooks are shared users can see changes made by others.

true

When worksheets are grouped all structural changes will be copied across worksheets.

true

Worksheets can be hidden to help manage available screen space when dealing with large files.

true

XML documents can be imported into Excel.

true

XML stands for eXtensible Markup Language.

true

When using Advanced Filtering, the criteria range must contain at least:

two rows

What is the default file extension for a template?

.xltx

When using the MATCH function with an exact match lookup_value, the match type must be set to:

0

When using the QUARTILE.INC function which quartile would include the lowest value in the dataset?

0

Which of the following percentiles is excluded when using the PERCENTILES.EXC function?

0

How many condition arguments can be defined with the SUMIF function?

1

When using the QUARTILE.INC function which quartile would include the highest value in the dataset?

4

The second quartile of both QUARTILE.EXC and QUARTILE.INC defines what percentile?

50th

=INDEX(A2:B5,MATCH(MAX(B2:B5),B2:B5,0),1) is an example of a nested function.

true

A 3-D reference is a pointer to a cell in another worksheet.

true

A PMT of zero can be used in the FV function.

true

A forgotten password within Excel cannot be retrieved.

true

A run time error will occur if a sub procedure is run on a protected workbook.

true

A user can create custom cell styles.

true

A workbook marked as final cannot be password protected.

true

A workbook marked as final is read-only.

true

All templates should contain instructions.

true

By default automatic updates of links are disabled.

true

By default, Excel creates absolute cell references in external references.

true

By default, the macro recorder uses absolute references.

true

CSV files can be imported into an Excel workbook.

true

CUMIPMT calculates the cumulative interest throughout a loan.

true

CUMPRINC contains six arguments.

true

Change tracking can only be activated in shared workbooks.

true

Custom backgrounds can be applied to Excel worksheets.

true

Customization of the Quick Access Toolbar can be exported.

true

Documents can have multiple authors defined in the document properties.

true

Excel can export PDF files.

true

Flash Fill can auto fill numerical lists.

true

Flash Fill can often perform the same tasks as the PROPER function.

true

Font attributes can be controlled with cell styles.

true

Form controls are located on the Developer tab.

true

Good, Bad, and Neutral are predefined cell styles.

true

Hidden comments do not print.

true

If an IF statement has four outcomes, it will require three logical tests.

true

If no values exist in the logical argument, the AND function returns the #VALUE! error.

true

Images can be used as hyperlinks

true

Importing is the process of inserting external data, data created or stored in another format, into the current application.

true

In order for the AND function to return a true value, all arguments must be true.

true

In order for the NOT function to return a true value, all arguments must be false.

true

In order for the OR function to return a true value, one or more arguments must be true.

true

Indentation indicates the hierarchy structure in XML.

true

Macros are stored in modules.

true

Metadata is attached to each Excel workbook.

true

OctoberSales.xlsx is an example of CamelCase notation.

true

Once lost, a password cannot be retrieved.

true

Shared workbooks cannot be marked as final.

true

Tab-delimited files use tabs to separate data into columns.

true

Templates can be located and downloaded in the templates gallery.

true

Text files can be imported into Excel workbooks.

true

Text functions such as CONCATENATE and UPPER can be nested for more precise results.

true

The #NUM! error indicates an invalid argument used in a function.

true

The CONCATENATE function could combine the words Microsoft and Excel into one text string.

true

The CUMPRINC function requires both starting and ending evaluation dates.

true

The Document Inspector will remove personal data from a workbook.

true

The IFERROR function will perform an action if the current value in a cell produces an error.

true

The IPMT function should be used to calculate the specific interest paid on one installment of a loan.

true

The MATCH function can be used to match words.

true

The MATCH function match_type must be set to 0 when matching words.

true

The MATCH function will return a value of 1 if the given lookup_value is the largest number in an array of numbers.

true

The Quick Access Toolbar can be customized.

true

The RATE function returns the periodic rate for an investment or loan.

true

The SUBSTITUTE function will replace the word doctor with Dr. in a text string.

true

The UPPER function will capitalize every character of a text string.

true

The VBA editor can be opened with the key stroke Alt+F11.

true

The Watch Window will update as user defined cells change.

true

The criteria range of a database function must contain at least one column heading and one cell of information.

true

The database argument of any database function requires the selection of the entire table.

true

The maximum number of characters for a password is 255.

true

The maximum number of text strings supported by the CONCATENATE function is 255.

true

The user cannot change automatically updated properties.

true

To perform an advanced filter with an OR condition you must select at least two rows of the criteria range.

true

Unvisited hyperlinks appear blue with a blue underline.

true

Which of the following is an alternative to using the CONCATENATE function?

&

Which of the following is the proper format for a 3-D reference?

'Worksheet Name'!RangeOfCells

What is the proper format of an external reference to a workbook or worksheet thats name contains spaces; source and destination files are in the same folder?

'[WorkbookName]Worksheet'!Cell

Which of following is the default file format for Excel 97-2003?

.XLS

What is the default file format in Excel 2013?

.XLSX

Which of the following is the file extension for a Personal Macro Workbook?

.xlsb

Which of the following formats does not support macros?

.xlsx

Which of the formats below will not support sub procedures using VBA?

.xlsx

What is the maximum number of strings that can be manipulated with the CONCATENATE function?

255

What is the password character limit in Excel?

255

If there are four possible outcomes, how many logical tests are required?

3

This should be used when referencing cells on another worksheet.

3-D reference

If the formula =B2*B3 is located in cell C3, which cell is not a precedent?

C3

In the formula =B2*B3 is located in cell C3, which cell is the dependent cell?

C3

What is the default folder for Personal Macro Workbooks in Windows 8?

C:\Users\Username\AppData\Roaming\Microsoft\Excel\XLStart

What is the default save location for templates?

C:\Users\username\Documents\CustomOfficeTemplates

Which of the following is a file type that cannot be imported into Excel?

CAD

Which of the following functions is best suited to count numbers based on multiple conditions?

COUNTIFS

Which of the following functions will calculate the total interest paid between select periods?

CUMIPMT ****

Which of the following functions will calculate the total principal paid between select periods?

CUMPRINC ****

Which of the following is not a formula auditing tool?

Calculation Options

What is indicated by red arrows when tracing precedents?

Cells that cause errors

What is indicated by blue arrows when tracing precedents?

Cells with no errors

Which of the following is an option to edit a comment?

Click Edit Comment in the Comments Group of the Review tab

Which of the following options will refresh connections within an Excel workbook?

Click Refresh All on the Connections group

Which of the following is not a way to remove panes from a window that has been split?

Click Remove Split in the View tab

Which of the following actions will open another window of the current workbook?

Click the View tab, and then click New Window in the Window group

Which of the following is not a default command of the Quick Access Toolbar?

Close

Which of the following are settings that control how imported data in cells connect to their source data?

Data range properties

Where are Web query tools and options located?

Data tab

Where is the Text to Columns Wizard located in Excel?

Data tab

What formula auditing tool can be used to control the data input from the user?

Data validation

Which of the following tabs contains Form Controls?

Developer

Which of the following sources cannot be imported into Excel?

Direct image files from a web page

What is the best method to consolidate three workbooks into another workbook?

External cell references

Which function will calculate the final value of an investment of $100 a month that earns 4% interest over 5 years?

FV

Conditional formatting can be applied to a set of grouped worksheets.

False

Comments in VBA appear in what color?

Green

When creating a Web query which option preserves all original formatting?

HTML formatting

Which of the following is not an Office theme?

Helvetica

Which of the following is a feature of change tracking?

Highlight changes

Which of the following functions does not support multiple conditions?

MATCH

Which of the following functions returns the position of a value in a list?

MATCH

Which of the following is the best choice to lookup values when VLOOKUP and HLOOKUP are not possible?

MATCH and INDEX

Which of the following is not a function for evaluating multiple conditions with only two possible outcomes?

MAX

Which function is best suited to return the specified number of characters from the middle of a text string?

MID

Where can a macro be deleted?

Macro dialog box

Which of the following is a method for creating macros?

Macro recorder

Which of the following tools is best suited to complete repetitive tasks in Excel?

Macros

Which of the following is not true about compare and merge?

Merged workbooks cannot be exported

Which function will return the total number of periods on a $20000 loan at 5% interest and a $600 payment?

NPER

Which of the following calculates the net present value of an investment, given a fixed discount rate?

NPV

=IF(E5 < J7,F5*K7,IF(E5<=J8,F5*K8,F5*K9)) is an example of a(n):

Nested IF function

Which of the following applications can be used to create XML documents?

Notepad

Which function is best suited to determine a students test score percentile based on all class scores?

PERCENTRANK.EXC

Which of the following functions cannot be used as a 3-D formula?

PMT

Which of the following functions will return the principal payment of a loan?

PPMT

Which function is best suited to capitalize the first letter of each word in a text string?

PROPER

Which function will calculate the current value on an investment that will earn 5% interest on yearly payments of $100 over 10 years?

PV

Where is the Insert Background feature located?

Page Layout tab

Where is the Themes gallery located?

Page Layout tab

Which dialog box allows the user to print all comments?

Page Setup

Which of the following areas is not checked by the Accessibility Checker?

Print area

Which of the following cannot be modified in a custom cell style?

Print area

Which of the following is not a tool to improve efficiency in a common workbook that is used by numerous employees in a business?

Print settings

Which of the following is not controlled with cell style formats?

Print settings

Which of the following is not prevented when a worksheet is protected?

Printing

AutoCorrect options are located in which Excel Options category?

Proofing

Which of the following is true when synchronize scrolling is enabled?

Side by side worksheets will scroll at the same rate

Which of the following online storage tools is integrated into Excel 2013?

SkyDrive

Which of the following is not an option when arranging windows?

Stacked

Which of the following is not a default cell style?

Standard

Which of the following is not a best practice when creating a macro?

Start and stop the recording as needed

Where are the default cell styles located?

Styles group

Which of the following is the proper beginning for a sub procedure named "Test"?

Sub Test()

Which function is best suited to remove extras spaces from the beginning of a text string?

TRIM

Where are macros recorded with the macro recorder stored?

The current workbook

Which of the following is not true about a workbook that is Marked as Final?

The file is marked as shared

What happens if you rename the source file of a worksheet that is used in an external reference?

The linked data will appear in red text

What happens when data that is externally linked is edited and both the source and destination file are open?

The links will automatically update

What does the order argument of the RANK.EQ function define

The order in which numbers are ranked

What happens if a user violates a validation rule and a stop style is applied?

The user will not be able to continue

Where are custom cell styles saved?

The workbook in which you created the style

Which of the following is not a method for protecting the worksheet against changes?

Track Changes

Which feature is best suited to record edits made to a document over time?

Track changes

Which of the following is the best option for transferring data between incompatible systems?

XML

Once XML data is imported, where can the data source be manipulated?

XML Source task pane

What is the following syntax < ?xml version="1.0" encoding="UTF-8"? >

XML declaration

When worksheets are grouped, which of the following is true?

[Group] appears in the title bar

What is the proper format of an external reference to a workbook or worksheet thats name does not contains spaces; source and destination files are in the same folder.

[WorkbookName]Worksheet!Cell

What is the proper format for creating an external reference with no spaces in the file name located in the same folder as the destination file?

[WorkbookName]WorksheetName!RangeOfCells

Which of the following formats is supported as a background in Excel?

jpeg

The default comment print setting is:

none.

When using Advanced Filtering < > is the equivalent of:

not equal to

In the FV function, the rate argument refers to the:

periodic rate

Visited hyperlinks in Excel appear as:

purple text.

To group all worksheets:

right-click a worksheet tab and click Select All Sheets.

To edit or remove a hyperlink:

right-click it and then select Edit Hyperlink to open the Edit Hyperlink dialog box.

Which of the following file types uses tabs to separate data into columns?

tab-delimited

Which of the following is a not an Excel file type?

text file

When the DAVERAGE function returns #DIV/0:

there are no records that fit the criteria

3-D formulas automatically update when data is added.

true

< !-- Created June 29 1979 -- > is an XML comment.

true

< ?xml version="1.0" encoding="UTF-8"? > is an XML declaration.

true


Set pelajaran terkait

Med Surge Summative Exam2,3,4,6,24,25

View Set

HA Chapter 2: Health History and Interview Prep U Questions

View Set

Hearing: the body senses: the chemical senses

View Set

MedSurg: Prioritization Ch 2 CV management

View Set

CompTIA Network+ - Module 5 - Network Troubleshooting and Tools

View Set

Chap 5: Bones of Skull & Facial #1, & Suture Review

View Set