02/08/2021 Pre-Test

It is a program designed to create spreadsheets that can later be used to analyze statistical data

• Microsoft Word

• Microsoft Excel

• Microsoft Publisher

• Microsoft OneNote

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

• Percent

• Comma

• Accounting

• Date/Time

A function that adds a range of cells

• ADD

• PLUS

• SUM

• TOTAL

This is the tab in the format cells 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 cells

• 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 cells that contain something in them if the criteria are met.

• COUNT

• COUNTNOW

• COUNTING

• COUNTIF

A function used to add a certain range of cells if a condition is met.

• SUMIF

• ADDIF

• TOTALIF

• PLUSIF

the shortcut key for the format cells dialog box.

• Ctrl + F

• Shift + F

• Ctrl + 1

• Alt + 1

Syntax in the AVERAGIF 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