digital information technology semester 2 course review

what symbol is used to designate an absolute cell reference?

$

what is the argument in this function? =AVERAGE(F3:F26)

(F3:F26)

how many picture layouts are available to apply?

30

In excel , all formulas must begin with what symbol

=

You want to enter a series of data down a column. What would be the best tool for this job?

auto fill

graphical representation of data

chart

how to enter text in a cell

click in the center

merge cells

combine 2 or more cells

which number format would you use for the total sales per month

currency

what is the character that separates data entries from one another

delimiter

what term is the mathematical equation used in excel to preform calculations?

formula

what is an art related object

illustration

what tab to click to build a chart

insert

add header and footer in excel

insert>header and footer

how to add graphic elements to an excel worksheet

insert>picture

error message #######

the column is too small

why would you change the coloum width

to fit all the data

What can passwords protect?

worksheets

conditional formatting

An Excel feature that enables you to specify how cells that meet one or more given conditions should be displayed.