wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Empowerment Technologies Quiz 2

Total questions: 10

Worksheet time: 5mins

Name
Class
Date
1.

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

Excel 2016?

a)

66,336

b)

66,333

c)

1,048,576

d)

1,048,373

2.

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.

a)

Bar

b)

Doughnut

c)

Line

d)

Pie

3.

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

data?

a)

Area

b)

bubble

c)

Combo

d)

Stock

4.

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

Microsoft Excel?

a)

Add-ins

b)

Format Cells

c)

Illustrations box

d)

Recommended Charts

5.

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

a)

16,381

b)

16,382

c)

16,383

d)

16,384

6.

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

something in them with the correct criteria in place.

a)

Count

b)

CountNow

c)

Counting

d)

Countif

7.

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

a)

Percent

b)

Accounting

c)

Comma

d)

Date/Time

8.

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

of cells?

a)

Average

b)

Sum

c)

Mean

d)

Median

9.

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.

a)

Range

b)

Criteria

c)

Average Range

d)

Logical Test

10.

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

when condition is met?

a)

Sumif

b)

Addif

c)

Totalif

d)

Plusif