EXCEL TEST3
The ___ condition requires that all of the selected criteria be true for the record to be displayed
And
With the Last Quarter criteria filter, quarters are defined as, for example, ____.
April, May, June
_____ order arranges labels in reverse alphabetical order from A to Z
Ascending
When you save a workbook that contains external reference formulas Excel stores the most recent results of those formulas in the ____ file.
Destintation
When you have more than one sort field, you should use the Sort ____ to specify the sort criteria.
Dialog box
The ____ arrangement option layers the open workbooks on the screen.
Cascade
After you filter a column, the ____ Filter command becomes available so you can remove the filter and redisplay all the records.
Clear
A formula can include a reference to another workbook (called an ____ reference), which creates a set of linked workbooks.
External
Defined names are automatically substituted for existing range references in a formula.
False
Each column represents a record that describes some attribute or characteristic of a person, place, or thing
False
Even when the worksheet is unprotected, the locked property determines whether or not changes can be made to a given cell.
False
Which of the following is a true statement Juan can make about defined names as he is explaining the rules to you
The name can include letters, numbers, periods, and underscores
When you use the point-and-click method to build formulas with external references, Excel enters all of the required punctuation, including quotation marks
True
You can split the worksheet window into ____ separate panes
Two or four
An input message appears when the cell becomes active, and can be used to specify the _____ of data the user should enter in that cell.
Type
Every cell in a workbook has a(n) _____ property that determines whether or not changes can be made to that cell.
Locked
In the Allow dialog box, the ___ option means that the cell will only accept integers
Whole Number
The _____ dialog box displays all of the names in the workbook
Name Manager
Which of the following is NOT a valid defined name
Net-Income
In addition to displaying subtotals, the subtotal feature "____" your worksheet so you can control the level of detail that is displayed
Outlines
In Excel, a collection of similar data can be structured in a(n) ___ of rows and columns
Range
Like cell ____, a worksheet group can contain adjacent or nonadjacent sheets.
Ranges
You cannot change data directly in the PivotTable. Instead, you must edit the Excel table, and then ____, or update, the PivotTable to reflect the updated data.
Refresh
To delete the hyperlink but keep the text, right-click the hyperlink cell, and then click ____ Hyperlink.
Remove
In Excel, a table is a range of related data that is managed independently from the data in other ____ in the worksheet
Rows and cloumns
____ rows and columns lets you keep headings on the screen as you work with the data in a large worksheet
Freezing
A worksheet ____ is a collection of two or more selected worksheets.
Group
After Brooke has helped Simon to resolve his original problem, Simon asks her about another linked workbook he has received. The source files for this workbook have not been included, but Simon would like to use the workbook with the most recent values from the source file. What should Brooke tell him?
He can open the workbook and click the Continue button in the Edit Links dialog box
By default, the PivotTable report uses the ____ function for numbers in the Values area.
SUM
The default ____ for a hyperlink is the folder location and the name of the file to which you will link
ScreenTip
____ are usually represented by words with colored letters and underlines or images
Hyperlinks
The ____ alert accepts the invalid data but still allows you to cancel the data entry
Information
The ___ criteria filter requires that records displayed to have the current date
TODAY
To un-group worksheets, you can click a sheet ____ of a sheet not in the group
Tab
To move a worksheet or worksheet group to another location in the same workbook, select the worksheets and then drag and drop them by the selected sheet ____.
Tabs
A ____ is a workbook that you can open with the text formats and formulas already built into it
Template
In the Allow list box in the Data Validation dialog box, the ____ option means that the cell will accept only text of a specified number of characters
Text Length
Sometimes when you build a worksheet for other users, you may decide to add a(n) _____ message to a cell even if you do not validate the data in that cell.
Input
To solve a workbook with macros, the default Excel workbook format needs to change to a macro-enabled workbook, which has the ____ file extension
xlsm
When you reference a cell or range in a different worksheet, the ____ separates the sheet reference from the cell reference.
!
Range names must begin with _____.
A letter or underscore
The ____ criteria filter requires the records displayed to have the specified text string anywhere
Contains
You have a lot of familiarity with ranges from an earlier Excel class, but you know that there is an alternative that will give you access to additional features that you do not have with a cell range. What is that option?
Convert the range to a table.
If Cali wants to find all of his campers named Cathy, Carla, and Carey, what should she do?
Create a text filter using the Begins With operator to display all records that have "Ca" at the beginning of the text value
The worksheet range _____ references the worksheets, "Sheet 1", "Sheet 2", "Sheet 3", "Sheet 4"
Sheet 1:Sheet 4
A digital ____ is like a seal of approval
Signature
When you reference cells and ranges in other worksheets, if the worksheet name contains spaces, you must enclose the sheet name in ____.
Single quotation marks
Every ____ consists of an object that contains a button for each unique value in that field.
Slicer
A table name cannot include ____.
Spaces
The following are Excel-supported error alert types: _____.
Stop, Warning, and Information
Protecting the _____ prohibits users from renaming, deleting, hiding, or inserting worksheets.
Structure
In VBA, macros are called _____ procedures
Sub
Simon tells Brooke that when he attempts to open a workbook, the Edit Links dialog box appears with the message "This workbook contains one or more links that cannot be updated." Brooke suggests several possible causes of this error message. Which of the following is a possible cause?
The workbook was sent to him without links
Which of the following statements about hyperlinks in Excel workbooks is correct
They can be used to jump to a specific cell or range within the active worksheet, another worksheet or another workbook.
Each macro must have a unique name that begins with a letter.
True
Once you group a collection of worksheets, any changes you make to one worksheet are applied to all sheets in the group.
True
Any blanks or parentheses in a row or column label will be changed to _____ in defined names.
Underscore characters
The Excel data ____ feature restricts data entry to follow a defined set or rules
Validation
Jared has heard that ScreenTips can be used in conjunction with hyperlinks. Which of the following statements about ScreenTips is correct?
You can specify the contents of a ScreenTip when you create a hyperlink
Which of the following is true about Excel tables (as opposed to structured ranges of data)?
You cannot freeze the top row of the worksheet.