ADVANCED SPEADSHEET SKILLS

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

• Microsoft Excel

• Microsoft Word

• Microsoft Publisher

• Microsoft OneNote

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

• Percent

• Accounting

• Comma

• Date/Time

A function that adds a range of cell

• ADD

• PLUS

• SUM

• TOTAL

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

• alignment

• orientation

• file

• view

a function that gets the average of a range of cell

• AVERAGE

• SUM

• MEAN

• MEDIAN

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

• average range

• range

• logical test

• criteria

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

• COUNT

• COUNTNOW

• COUNTING

• COUNTIF

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

• SUMIF

• ADDIF

• TOTALIF

• PLUSIF

the shortcut key for the format cells dialog box

• Ctr + F

• Shift + F

• Ctr + 1

• Alt + 1

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

• range

• criteria

• average range

• logical test