Combo with "Chapter 11 myitlab Isaac Toivonen" and 5 others
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?
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