ICS Excel 5

when you add data to the right of the table, excel includes the new ___________ in the table automatically.

column

if the data range is not correct, you can manually enter the cell range in the ___________.

dialogue

a ______________ can be an exact match, where every cell in the row contains the same data, or you can specify matching data for certain columns.

duplicate

when the user enters data that violates the data validation rule, an ____________ appears.

error message

When you define data as a table, excel provides a robust tool set for ______________ and _______________ the data.

formatting and analyzing

____________ is a shortcut for entering functions.

formula autocomplete

if you have a large spread sheet, you may want to _______ part of your worksheet so it is always visible.

freeze

when you merge cells together, excel will keep only the data in the uppermost _______ cell.

left

data validation rules can limit:

limit cell entries to a specific data type (such as a whole number or date) or a list of acceptable values

applies a longer format displaying the day of the week, month, and year: Monday, September 05, 1998

long date format

the ___________ function inserts the current date and time.

now

when cells have a data validation rule applies, you can add a _________ that will appear every time a user clicks one of the cells requiring data validation.

prompt

applies a simple format displaying one- or two-digit number representing the month, day and year: 9/5/1996

short date format

in excel, you can define a series of adjacent cells as a _________.

table

on _____________ click the remove duplicates button to remove them.

table tools design tab

certain data analysis tools, including creating subtotals and grouping outlines, are not available if the data are formatted as a ___________.

tables

the _____________ function inserts the only current date.

today

both now and today functions are ___________ that is, they are not constant

volatile

data validation rules

you can prevent users from entering invalid data or data that my cause errors in formulas