Empowerment Technologies Quiz

What application program is designed to create spreadsheets which can later be used to analyze statistical data?

• Microsoft Excel

• Microsoft OneNote

• Microsoft Word

• Microsoft Publisher

Which of the following Microsoft Excel functions can be used to add a range of cells?

• Sum

• Plus

• Total

• Add

Which tab in the formal cells dialog box can be used to change the orientation of the text?

• View

• File

• Orientation

• Alignment

Which of the following is NOT part of the syntax for AVERAGEIF?

• Range

• Average range

• Logical test

• Criteria

Which of the following shortcut keys in Microsoft Excel can be used to show the format cells dialog box?

• Ctrl + 1

• Alt + 1

• Ctrl + F

• Shift + F

What function is used to count the number of cells that contains something in them with the correct criteria in place?

• Counting

• CountNow

• Countif

• Count

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

• Percent

• Accounting

• Comma

• Date/Time

A function in Microsoft Excel which is used to get the average of a range of cells?

• Mean

• Average

• Median

• Sum

A syntax in the AVERGAEIF function that includes the value or label which determines if the cell is part of the range to be averaged.

• Logical Test

• Range

• Criteria

• Average Range

What function in Microsoft Excel is used to add a certain range of cells when condition is met?

• Plusif

• Addif

• Sumif

• Totalif