CorporalFang3159
(TCO 4) How many possibilities exist when thinking about the freeze…
(TCO 4) How many possibilities exist when thinking about the freeze options?
Group of answer choices
3 – Freeze Panes, Freeze Top Row and Freeze First Column
2 – Freeze Panes and Freeze Top Row
3 – Freeze Frames, Freeze Top Row and Freeze Last Column
1 – Freeze Panes
Flag question: Question 2Question 210 pts
(TCO 4) In Excel, the print area is defined as _____.
Group of answer choices
an individual piece of data, such as a last name
a complete set of data for an entity
the sequence in which pages print
the range of data to print
Flag question: Question 3Question 310 pts
(TCO 4) To convert a table back into a range, _____.
Group of answer choices
click within the table, click the Table Tools Design tab, and then select Convert to Range
click the Insert tab and then click Range in the Range group
select any cell in the worksheet and then click Existing Range in the Tools group
click in a cell and on the Home tab, and click the Insert arrow in the Cells group
Flag question: Question 4Question 410 pts
(TCO 4) Filtering the Last_Name column (field) to show only records that begin with the letter S is an application of _____.
Group of answer choices
the use of a table element as a formula
a Number Filter
a Text Filter
a Date Filter
Flag question: Question 5Question 510 pts
(TCO 4) To create a new Conditional Formatting Rule, _____.
Group of answer choices
convert the cell to a Range
select any cell in the table and then click New Rule in the Tools group
click in a cell and on the Home tab, and click the Cell Styles arrow in the Cells group
click Conditional Formatting from the Cell Styles group and select New Rule
Flag question: Question 6Question 610 pts
(TCO 4) Using Conditional Formatting to draw attention to cells that are blank _____.
Group of answer choices
displays a particular color based on the relative value of the cell contents to other selected cells
displays an icon representing a value in the top third, quarter, or fifth based on values in the selected range
helps locate where data may be missing
helps locate errors in cells quickly
Flag question: Question 7Question 710 pts
(TCO 4) The Subtotal command is located on the _____ tab.
Group of answer choices
Data
Formula
Page Layout
Insert
Flag question: Question 8Question 810 pts
(TCO 4) _____ are created to organize and summarize data in pivot tables.
Group of answer choices
Categories
Types
Titles
Levels
Flag question: Question 9Question 910 pts
(TCO 4) Data mining techniques, such as pivot tables can detect _____ of data.
Group of answer choices
patterns
categories
styles
groups
Flag question: Question 10Question 1010 pts
(TCO 4) The Insert Calculated Field dialog box requires you do all the following except _____.
Group of answer choices
enter formulas using field names instead of cell references
enter a description column heading for the calculated field
build formulas using mathematical operands such as +, -, and *
enter formulas using cell references