IT TEST REVIEW PART 1

The command to hide and unhide columns and rows is found in the _____ groups in the Format menu.

Cells

The _________ command deletes the information and formatting from a group of selected cells.

Clear Contents

Filters can be applied to both text and ______ fields.

Number

To a worksheet, it must be ________

Active

To add a second level to a sort, use the ________ option in the Sort dialog box.

Add Level

When multiple filters are applied they __________

Are additive

To add a row to a table make the active cell in the row _________ where you want the row inserted.

Below

A page break is represented by a _______ line.

Blue dashed

To edit the data in a table field, click the ______ that you want to modify.

Cell

Set a print area by pressing the _______ key and dragging your mouse to highlight the required area, and then click Set Print Area.

Control

To go to the top of your spreadsheet quickly, use the ____ keys.

Control and Home

The social security number by itself in a record would be considered _______

Data

Excel tables are based on ______ concepts.

Database

Options for modifying the appearance of table data are in the __________ drop down list

Design

A quick way to display the GoTo command is to press the ______ key.

F5

__________ names in tables should be unique for clarity purposes.

Field

In Ecvel tables, columns are ________

Fields

Specific data can be extracted for viewing by using __________

Filters

To change every occurence of 2005 to 2007 in a worksheet, use the _______ command to keep from having to modify each individual occurrence.

Find and Replace

____ column and road headings enable you to view data easily in large spreadsheets.

Freezing

The ______ enables you to move to a cell quickly by typing the desired cell reference in it and pressing enter.

GoTo Dialog Box

If there are certain columns of information that you do not want to be viewed by others, _____ the columns

Hide

All the records in a table can be used in a report to form useful _______.

Information

Tables are created from the ________ tab

Insert

_____ fields are used to sort table data.

Key

Cells must be ________ and the sheet protected to prevent edits being made to the data.

Locked

The default style for tables is ________

Medium 9

To sort information in a table that has common information in a key field, you may want to perform a __________ sort

Multiple level

Key fields are used to __________ table data.

Organize

The ____ of a printed page is controlled on the Page Layout tab.

Orientation

To control the order in which pages are printed, use the _____ option in the Page Setup dialog box.

Page Order

_____ show you where information separates at the bottom of one page and the top of the next.

Page breaks

It is possible to set a _______ on a protected sheet to allow users with authority to edit data.

Password

IN Excel tables, rows are _____

Records

If there is data that is not viewable on your computer screen, you can use the ______ to move the screen left or right as neccessary.

Scroll Bars

To print one column of a worksheet, highlight the column and choose to print the:

Selection

To print column and row headings on all pages, set the options in the ______ command in the Page setup group.

Set Print Area

Columsn, rows, and _______ can be hidden or unhidden as needed.

Sheets

To organize the records in your table by last name, use the ___________

Sort Command

The options to arrange data in ascending or descending order are found in the __________ group.

Sort and Filter

Table data can be ______ to arrange it in a logical order.

Sorted

The Page Break Preview button is located on the :

Status bar

The ________ command calculates a total for groups of specific data.

Subtotal

_________ reports include subtotals for groups of records.

Summary

Data is converted to information

TRUE

Excel's comparable tool to a database is a _______

Table

Rows of similar information can be contained in a _________ in Excel

Table

To find predefined table layouts, access the ________ group.

Table Styles

To find the sum of a column of data in a table, use the ___________ option.

Total rows

If you delete the wrong row from a table, use the _______ to reverse the deletion.

Undo