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.