Empowerment Technologies Quiz 2

Which of the following is the correct total counts of rows in Microsoft

Excel 2016?

• 66,336

• 66,333

• 1,048,576

• 1,048,373

This chart distributes categories evenly along the horizontal axis and

the vertical axis. The horizontal axis connects the plotted points,

providing a clear picture of data trends.

• Bar

• Doughnut

• Line

• Pie

This is use to show combination of chart types to display widely varied

data?

• Area

• bubble

• Combo

• Stock

Which dialog box will appear when you use Ctrl + 1 shortcut key in

Microsoft Excel?

• Add-ins

• Format Cells

• Illustrations box

• Recommended Charts

Which is the correct total counts of columns in Microsoft Excel 2013?

• 16,381

• 16,382

• 16,383

• 16,384

This function is used to count the number of cells that contains

something in them with the correct criteria in place.

• Count

• CountNow

• Counting

• Countif

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?

• Average

• Sum

• Mean

• Median

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.

• Range

• Criteria

• Average Range

• Logical Test

What function in Microsoft Excel is used to add a certain range of cells

when condition is met?

• Sumif

• Addif

• Totalif

• Plusif