Excel Functions and Features Quiz

The correct formula for summing cells B2 and C2 is:

• +Sum(B2…C2)

• =Sum(B2:C2)

• =Sum(B2;C2)

• =Sum(B2…C2)

• =Sum(B2,C2)

The steps for using Hlookup and Vlookup are almost the same. The difference lies in the use of ...

• The helper table

• The pointer

• The parentheses

• Pressing enter

• The function

The function used to calculate the sum of numeric data is ...

• Sum

• Min

• OR

• Max

• Average

The function used to determine the largest value is ...

• Sum

• Min

• Count

• Max

• Average

The command used to save an Excel worksheet is ...

• Ctrl + A

• Ctrl + N

• Ctrl + B

• Ctrl + V

• Ctrl + S

Which of the following is not included in the Microsoft Office program group?

• Microsoft Excel

• Microsoft Power Point

• Microsoft Access

• Microsoft Word

• Microsoft Windows Vista

The command used to duplicate data is ...

• Cut and Paste

• Copy and Cut

• Copy and Save

• Copy and Paste

• Select All and Copy

When working with Excel, information about the page, rows, columns, etc. can be seen in the ...

• Status Bar

• Format Bar

• Menu Bar

• Toolbar

• Formula Bar

The Excel function formula to determine the average value is ...

• Average

• MIN

• MAX

• Count

• If

The Excel function formula to determine the number of data is ...

• Average

• MAX

• SUM

• MIN

• Count