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