Trivia Quiz: How Well You Know MS Excel Functions?

1. The format for an IF statement is:

=SUM(condition,x,y)

=IF(condition,x,y)

=(condition,x,y)

2. A function must always start with

=sumif

=sum

=

=sumif(

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

NO

YES

4. Common Functions that we use most often are

=Sum

=Average

=Min

=Max

All of the above

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

Plot

Legend

Chart

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

Key

Map

Legend

7. A block of cells in an Excel worksheet

Area

Range

Cell

Active cell

8. All charts use axes except

Bar

Line

Plot

Pie

9. Name three rules for naming ranges.

Spaces are allowed, can start with a range name, Y2008.

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

Must make sense, can start with a number, spaces are allowed.

10. A ______________ends the argument.

Quotation mark

Closed parenthesis

Comma

Period

11. A chart placed as an object within a worksheet.

Chart sheets

Embedded chart

12. A triangle appears in the upper-right corner of any cell with an attached __________.

Green triangle, note

Red triangle, comment

Green triangle, comment

Red triangle, note

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

Active

Grouping

Attached

14. A chart actually has two backfrounds: the larger ___ _ and the smaller __ which can be formatted.

Tick mark, background

Chart area, plot area

Data axis, value axis

15. To display a comment in a worksheet

Roll mouse over red triangle

Open comment cell

Must highlight cell

16. A chart that occupies its own worksheet.

Embedded chart

Chart sheet

Stand alone chart

17. A Range name may use up to ________ characters.

355

155

255

555

18. Name the three parts that are typically found in a chart.

Data series, Series labels and Catefory labels

Name box, value labels, name labels

X axis, y axis, z axis

19. Correct format for a SUMIF statement is

=SUMIF(range, critera,sum_range)

=SUMIF(range,sum_range,critera)

=SUMIF(sum_range,critera,range)

20. Excel allows you to create ____________________________ that refer to column and row labels in place of the cell reference or range.

Comments

Natural Language Formulas

Arguments

Functions

21. A range of cells can be or __.

Connected, nonconnected

Adjancent,non adjancent

Contiguous, noncontiguous

22. Name two of the several ways to enhance a Chart Background.

Delete table

I D K

Ask my buddy

Submit