Excel Level 1

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

Excel Level 1

This questionnaire is to judge the level of Excel knowledge for the upcoming class. Answer as many questions as you can.

Email *

What is your name? *

1. A worksheet is a computerized *

5 points

table

spreadsheet

workbook

space

2. Rows are labeled by *

5 points

Numbers

Letters

Numbers and letters

3. Columns are labeled by *

5 points

Numbers

Letters

Numbers and letters

4. When words are typed in, by default it they are aligned to the ________ side of the cell. *

5 points

Left

Right

Center

Justify

5. When numbers are typed in, by default it they are aligned to the ________side of the cell. *

5 points

Left

Right

Center

Justify

6. The enter key moves the cursor to the *

5 points

Down

Right

Left

7. The Tab key moves the cursor to the *

5 points

Down

Right

Left

8. In Excel, a formula is an expression that operates on values in a range of cells or a cell. Choose an example of a formula. *

5 points

SUM(A2:D2)

=A2;G2

=(A2*B2)+(F2*G2)

=A2 x B2

9. Every formula starts with an *

5 points

SUM

10. Define the following operators: + _ * / *

5 points

Divide

Plus

Multiply

Subtract

11. If column B contains values in rows 3,4,5,6, what would the formula to add look like? *

5 points

=B2+B3+B4+B5+B6

=B3+B4+B5+B6

=(B3:B6)

=SUM[B3:B6]

12. Identify the commands below *

5 points

Bold, Italic, Underline

Bold, Indent, Underline

Blue, Italic, Underline

Blue, Ivory, Undo

13. How do you insert a new worksheet? Check all that apply. *

5 points

Insert > Insert Sheet

Use the Plus sign on the keyboard

Use the Plus sign by the sheet tabs

Home > Insert > Insert Sheet

Required

14. A sheet tab can be moved within a workbook? *

5 points

True

False

15. How do you rename a sheet tab? Check all that apply

5 points

You can't rename a sheet

Double-click the sheet tab, and type the new name.

Right-click the sheet tab, click Rename, and type the new name.

Use the keyboard shortcut Alt+H > O > R, and type the new name.

16. When applying a "decrease decimal format", does the number actually change? *

5 points

Yes

Maybe

17. While entering a value, you noticed ########, what happened? *

5 points

You typed 8 hashtags

Your rows was too short.

Your numbers were not valid

Your column was too narrow

18. What does this command do?

5 points

It paints a picture

It is used to apply values

It is used to cut and paste formatting styles

It is used to apply formatting styles

Clear selection

19. What are the purposes of parenthesis ( ) in a formula? Give 2 answers

5 points

To indicate which values are to be used for a result

Values that will be addressed later

To give precedence in the order of operations

To enclose a range a cells

Parenthesis are not used in formulas

20. Which commands allows you to arrange data so that it is easier to analyze? Check all that apply

5 points

Sort

Filter

Pivot Table

Conditional Formatting

Clear form

Never submit passwords through Google Forms.

This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy

Forms