Ultimate MS Excel Quiz Questions! Trivia

22 Questions | Total Attempts: 219

Settings

Excel Quiz

• 1.
• A.

=sumif

• B.

=sum

• C.

=

• D.

=sumif(

• 2.
Common Functions that we use most often are
• A.

=Sum

• B.

=Average

• C.

=Min

• D.

=Max

• E.

All of the above

• 3.
Excel aloows you to create ____________________________ that refer to column and row labels in place of the cell reference or range.
• A.

• B.

Natural Language Formulas

• C.

Arguments

• D.

Functions

• 4.
A ________triangle appears in the upper-right corner of any cell with an attached __________________.
• A.

Green triangle, note

• B.

Red triangle, comment

• C.

Green triangle, comment

• D.

Red triangle, note

• 5.
A block of cells in an Excel worksheet.
• A.

Area

• B.

Range

• C.

Cell

• D.

Active cell

• 6.
A range of cells can be __________________or ____________________.
• A.

Connected, nonconnected

• B.

• C.

Contiguous, noncontiguous

• 7.
Worksheets that are selected as a unit; any action performed on this unit will affect all the worksheets in the group.
• A.

Active

• B.

Grouping

• C.

Attached

• 8.
A Range name may use up to ________ characters.
• A.

355

• B.

155

• C.

255

• D.

555

• 9.
The format for an IF statement is:
• A.

=SUM(condition,x,y)

• B.

=IF(condition,x,y)

• C.

=(condition,x,y)

• 10.
Correct format for a SUMIF statement is
• A.

=SUMIF(range, critera,sum_range)

• B.

=SUMIF(range,sum_range,critera)

• C.

=SUMIF(sum_range,critera,range)

• 11.
A graphic that allows you to compare and contrast data in a visual format.
• A.

Plot

• B.

Legend

• C.

Chart

• 12.
A chart placed as an object within a worksheet.
• A.

Chart sheets

• B.

Embedded chart

• C.

Categories

• 13.
All charts use axes except
• A.

Bar

• B.

Line

• C.

Plot

• D.

Pie

• 14.
A chart actually has two backgrounds: the larger _______ _______ and the smaller ______ ______ which can be formmatted.
• A.

Tick mark, background

• B.

Chart area, plot area

• C.

Data axis, value axis

• 15.
A chart that occupies its own worksheet.
• A.

Embedded chart

• B.

Chart sheet

• C.

Stand alone chart

• 16.
A key that identifies each of the data series in a chart.
• A.

Key

• B.

Map

• C.

Legend

• 17.
Name the three parts that are typically found in a chart.
• A.

Data series, Series labels and Catefory labels

• B.

Name box, value labels, name labels

• C.

X axis, y axis, z axis

• 18.
Name two of the several ways to enhance a Chart Background.
• A.

Delete table

• B.

I D K

• C.

• 19.
A ______________ends the argument.
• A.

Quotation mark

• B.

Closed parenthesis

• C.

Comma

• D.

Period

• 20.
Name three rules for naming ranges.
• A.

• B.

Spaces are not allowed, do not start with range names, may include letters, numbers, underscores,blackslashes

• C.

• 21.
To display a comment in a worksheet
• A.

Roll mouse over red triangle

• B.

Open comment cell

• C.

Must highlight cell

• 22.
When you use "Natural Language" in a formula the name must be spelled exactly as the oolumn or row label.
• A.

NO

• B.

YES

Related Topics