Excel quiz 2
A file type developed by Microsoft that provides a visual image of a spreadsheet is a portible document format file.
false
A one-variable data table will allow you to see how different interest rates and different payment periods will affect a monthly payment.
false
A question mark (?) in a search criteria will allow you to search for multiple items in the field.
false
A row label corresponds to a data series in a PivotTable report.
false
A to Z indicates that a list will be sorted in descending order.
false
An error is indicated in a cell by a triangle that appears in the top-right corner of the cell when an error is found.
false
An error value is the result of a formula that Excel can evaluate correctly.
false
Because each slicer that you create is designed to filter on a specific PivotTable field, it is likely that you will create only one slicer to filter a PivotTable report.
false
By using the Watch Window, you will need to repeatedly scroll or go to different parts of your worksheet to inspect, audit, or confirm formula calculations and results in a large worksheet.
false
Charts and SmartArt graphics depend on underlying data in a worksheet.
false
Detail data does not refer to the subtotaled rows that are totaled and summarized.
false
Goal Seek is a method to find a specific value for a cell by adjusting the value of several other cells.
false
If the PivotTable Field List is not visible within the PivotTable, you can click any cell in a PivotTable report to display it.
false
If you click Ignore Error, the error is NOT marked to be ignored for each consecutive check.
false
If you need to make changes to a template, it is not necessary to remove protection.
false
If your worksheet is wider than one page, you will also want to repeat the row titles on each page when you print or view the spreadsheet.
false
In the Error Checking rules options, all but the next to last rule are selected by default.
false
Line charts MUST consist of only one line.
false
New data cannot be inserted into a named range.
false
New shapes cannot be added to a SmartArt graphic.
false
Once you have created a chart, it is not possible to change the range of data that is displayed.
false
Resetting ignored errors will not reset all errors in all worksheets in the active workbook.
false
Standardization means designing a workbook so that individuals cannot enter data into cells.
false
Templates can only be used on the computer on which they are created.
false
The cell reference M$10 can be used as a defined name.
false
To quickly locate specific text, formatting, or type of information within a workbook, use the Find command.
false
To select all the columns that represent a data series in a column chart, you must click on each column individually.
false
To stay within your budget, an alternative to borrowing less money would be to decrease the number of years of payment.
false
When borrowing money, the interest rate is usually quoted per month.
false
When filtering by format and value using AutoFilter in Excel, each of the filter types are not mutually exclusive for the column, where you can use can use one filter at a time.
false
You can plot both totals and details on the same chart.
false
You can reduce the horizontal and vertical size of the printed data by changing the arrangement of the number of pages in a workbook.
false
You cannot change a defined name.
false
You cannot display parts of a PivotTable report on separate pages.
false
169) Payments on a loan are usually made monthly.
true
A PivotTable can have both local and shared slicers.
true
A PivotTable report starts with automatic updating each time that you open the workbook.
true
A PivotTable reports starts with automatic updating each time you open the workbook.
true
A SmartArt graphic is a visual representation of information and ideas.
true
A data series is a group of related data.
true
A graphical representation of the data in a PivotTable report is a PivotChart report.
true
All shapes in an organization chart must be the same color.
true
An advantage to naming a range of cells is that you can use the name in a formula in other parts of your workbook.
true
An organization chart depicts reporting relationships within an organization.
true
As you type in the Text Pane, the text appears simultaneously in the SmartArt graphic.
true
By default, the details for a value field in a PivotTable are displayed.
true
Charts and diagrams communicate data visually.
true
Data tables are used to view and compare the results of different operations.
true
Data tables make it easy to calculate multiple versions in one operation.
true
Data validation improves accuracy.
true
Defining data as a table prior to sort operations is optional.
true
Defining data as a table prior to sorting the data is optional.
true
Dependent tracer arrows are red when showing a cell that contains an error.
true
Excel includes predesigned templates.
true
Excel worksheets and workbooks can be saved as Web pages, no matter how large or how many worksheets there are in the file.
true
Goal Seek can be used to determine how much you can borrow to stay within your budget.
true
Goal Seek is a data tool used for What-If Analysis.
true
High Point, Low Point, and Last Point markers can be used to further emphasize the visual story that sparklines depict.
true
If data within an Excel spreadsheet is not organized so that Excel can outline it automatically, you can create an outline manually.
true
In a Lookup function, the formula refers to the defined range as the table array.
true
In the PMT function, a minus sign is placed before the amount of the principal so that payments are shown as a positive value.
true
In the PivotTable Field List, you can rearrange existing fields by using one of the four areas at the bottom of the layout section.
true
It is not required to format the selected range in a spreadsheet as a table, it can be a table or a database.
true
Like a spelling checker that checks for errors in data that you enter in cells, you can implement certain rules to check for errors in formulas.
true
Naming cells has no effect on the displayed or underlying values.
true
Organizations use standardization and protection when creating templates for commonly used forms.
true
Preformatted SmartArt styles can be applied from the Design tab.
true
Present value (Pv) represents the amount of the loan before any payments are made.
true
Slicers are easy-to-use filtering components that enable you to quickly filter data in a PivotTable report.
true
Slicers that are connected to and used in more than one PivotTable are called shared slicers.
true
Slicers that are used in one PivotTable only are called local slicers.
true
Sparklines give a visual trend summary alongside your data.
true
The AutoFill feature will duplicate a pattern of values that you set in the beginning cells.
true
The Error Checking command checks for common errors that occur in formulas.
true
The PMT function calculates the payment for a loan based on constant payments and at a constant interest rate.
true
The criteria range indicates how the displayed records in a spreadsheet are filtered.
true
The criteria range must have a row for the column headings and at least one row for the criteria.
true
The data table is one of a group of Excel's What-If Analysis tools.
true
The first step in using a lookup function is to define the range of cells that will serve as the table array.
true
The totals and subtotals of an associated PivotTable report are ignored in a PivotChart report.
true
To apply an effect to shapes in an organization chart, you must hold Ctrl and click on all shapes individually to select them.
true
Using the Advanced command disables the AutoFilter command and removes the AutoFilter arrow from the column headings.
true
When a new row is inserted in a named range, Excel adjusts formulas accordingly.
true
When a template design is complete, you should enable protection.
true
When selecting a range of cells for a chart, it is sometimes necessary to include an empty cell in the selection.
true
When using compound criteria, all the conditions must be met for the records to be included in the results.
true
When you create a custom list, the list remains available for all workbooks that you use in Excel.
true
When you open a template from the Templates folder in Backstage view, a new copy of the template opens as a workbook.
true
You can change the values on the value axis to increase or decrease the variations among the numbers displayed.
true
You can create your own themes, cell styles, and table styles in Excel.
true
You can customize your table by creating and applying a custom table of your own design.
true
You can only have one watch per cell.
true
You would use a wildcard character to search a field when you are uncertain of the exact value for which you are searching.
true
f the copied data contains a formula, this formula overwrites the data in the calculated column.
true
When creating a data table, the PMT function must be entered in the upper left corner of the range of data.
true4
