ADVANCED SPEADSHEET SKILLS

A program designed to create spreadsheets which can later be used to analyze statistical data.

A number format that puts a dollar symbol before each value by default

A function that adds a range of cell

This is the tab in format cell dialog box where you can change the orientation of a text.

a function that gets the average of a range of cell

which among the following is not part of the syntax for AVERAGEIF

a function used to count the number of cell that contains something in them if the criteria are met.

a function used to add a certain range of cell if a condition is met

the shortcut key for the format cells dialog box

a syntax in the AVERAGEIF function that includes the value or label that determines if the cell is part of the range to be averaged