NEW
Font size
WorksheetsEmpowerment Technologies Quiz 2
Total questions: 10
Worksheet time: 5mins
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
