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
