MS Excel " Quiz 1" Tutorial For Beginners Survey

Question Title

* 2. What is your location?

Winnipeg, MB

Regina, SK

Saskatoon, SK

Itasca, IL

Tukwila, WA

Vaughan, ON

Other

Question Title

* 3. What is your role/job title/department?

Question Title

* 4. Please list all formatting functions. Select All that Apply:

Accounting

Comma

Fraction

Freeze Pane

Merge & Center Cells

Question Title

* 5. Please name the Pivot Table Fields?

Filters

Range

Columns

Rows

Values

Data

Question Title

* 6. Which are basic formulas in Excel? Select All that Apply:

Addition

Subtraction

Sum

Count

Max

Question Title

* 7. True or False? Analyze your data function provides recommended charts and data insight based on your selected data.

True

False

Question Title

* 8. The intersection of a row and a column is called a ¬¬¬¬¬¬________.

Worksheet

Cell

Sum

Chart

Question Title

* 9. A group of cells is called a ________.

Cell Cluster

Chart

Multicell

Cell Range

Question Title

* 10. Where is the fill handle located?

In the bottom-right corner of the selected cell

On the right side of the Home tab on the Ribbon

At the beginning of any formula or function

In Backstage view

Question Title

* 11. In this image, why does the value in cell G1 look slightly different from the value in the formula bar?

Currency number format

Conditional formatting

Using a formula

Absolute cell reference

Question Title

* 12. You can click the tabs at the bottom of a workbook to switch between ________.

Worksheets

Permissions

Number Formats

Formulas

Question Title

* 13. Let’s say you’re trying to find your average grade. What’s wrong with the formula shown in the image?

Use the count function

Use the quotation marks instead of parentheses

Nothing wrong with formula

Should include an equals sign (=)

Question Title

* 14. True or false; You can view a formula by double-clicking the cell that contains the formula.

True

False

Question Title

* 15. Which of the following is an absolute cell reference?

#A2

$A$2

A:2

Question Title

* 16. How would you rate the relevance of this material to your day-to-day job?

Extremely valuable

Somewhat valuable

Not valuable at all

Question Title

* 17. Did you learn anything about the position/topic that you didn’t know prior to this?

Question Title

* 18. How would you rate the relevance of this material to your day-to-day job?

A great deal

A moderate amount

None at all

Question Title

* 19. If you gained new knowledge, be specific!

Question Title

* 20. What kind of content would you like to see in the future to help improve your day-to-day work life? Check all that apply:

Current updates in the industry

Step-by-step guides to using specific software/programs

Shortcuts in the programs I currently use

Other

MS Excel " Quiz 1" Tutorial For Beginners

Question Title

* 1. What is your name? (First, Last)

Question Title

* 2. What is your location?

Question Title

* 3. What is your role/job title/department?

Question Title

* 4. Please list all formatting functions. Select All that Apply:

Question Title

* 5. Please name the Pivot Table Fields?

Question Title

* 6. Which are basic formulas in Excel? Select All that Apply:

Question Title

* 7. True or False? Analyze your data function provides recommended charts and data insight based on your selected data.

Question Title

* 8. The intersection of a row and a column is called a ¬¬¬¬¬¬________.

Question Title

* 9. A group of cells is called a ________.

Question Title

* 10. Where is the fill handle located?

Question Title

* 11. In this image, why does the value in cell G1 look slightly different from the value in the formula bar?

Question Title

* 12. You can click the tabs at the bottom of a workbook to switch between ________.

Question Title

* 13. Let’s say you’re trying to find your average grade. What’s wrong with the formula shown in the image?

Question Title

* 14. True or false; You can view a formula by double-clicking the cell that contains the formula.

Question Title

* 15. Which of the following is an absolute cell reference?

Question Title

* 16. How would you rate the relevance of this material to your day-to-day job?

Question Title

* 17. Did you learn anything about the position/topic that you didn’t know prior to this?

Question Title

* 18. How would you rate the relevance of this material to your day-to-day job?

Question Title

* 19. If you gained new knowledge, be specific!

Question Title

* 20. What kind of content would you like to see in the future to help improve your day-to-day work life? Check all that apply:

Question Title

* 21. If you selected other material that you would like to see in the future, please be specific:

Question Title

* 22. Was there anything unclear in the material that you would like your manager or the Frontier-U team to expand on?