Excel Test 1

Submit

2. A cell is an intersection of a column and row.

True

False

Submit

4.

Each Excel worksheet is made up of columns and rows.

True

False

5. Every workbook created in Excel must be saved and assigned a name to distinguish it from other workbooks.

True

False

6. Excel requires every formula to begin with an equal sign (=).

True

False

7.

Font Color

Cell Fill Color

Font Size

8.

Title bar

Menu bar

Tool bar

The Title bar displays both the name of the application and the name of the spreadsheet.

Explanation

The Title bar displays both the name of the application and the name of the spreadsheet.

9. The following cell is named_____________

C3

3C

C-#3

Submit

11. Sheet tabs can be renamed by simply double clicking on the them and typing in the new name.

True

False

12. Use to add a border around a range of cell

True

False

13. You can revise any formula that was previously written in a worksheet.

True

False

14. Used when to save a new file for the first time or save an existing file with a different name.

Save

Open

Save as

15. Used to open an existing file from a floppy disk or hard drive of your computer.

Save

Open

Save as

16. The _______ menu contains all the operations that we will discuss in this lesson: New, Open, Close, Save and Save As.

File

Save

Title

17.

Undo button

Redo button

Backspace button

18. Identifies the largest number in a range of cells.

MIN

SUM

MAX

19.

Double-click on the cell that contains the information to be changed.

True

False

20. Click the gray Row heading to select the entire row.

True

False

21. Formulas can be created by using either numbers or cell references in the definition.

True

False

22. The ___________ cell, or the cell that can be acted upon, reveals a dark border.

Formula

Live

Active

23. You do not have the ability to insert new worksheets if needed or delete others you no longer want.

True

False

24. _____________________ (double headed arrow) can be used to change a column width.

Adjustment tool

Redo button

Auto Fill Button

25. In Excel, never do math "in your head" and type the answer in a cell where you would expect to have a formula calculate the answer.

True

False

26. Press ________ or click the Enter button on the Formula bar. This step ends the formula.

Enter

Control

Shift

27.

Click-and-hold the left mouse button and drag left or right, up or down to the last cell you want to select.

To work in a range of cells

To delete a range of cells

To choose a range of cells

28. Click the Copy button. Marching "ants" appear around the copied cell(s).

True

False

29. ____________ worksheets allows you to apply identical formulas and/or formatting across all the worksheets in the group.

Bunching

Grouping

Auto Select

30. If the cells and columns you want to select are not directly next to one another, select one of the ranges you want to select, and hold down the _______ key while selecting other ranges.

Control

Shift

Alt

31. Click the gray rectangle in the upper left corner to select half worksheet.

True

False

32.

Auto Sum Buttton

Auto Average Button

Both

33. If you're saving the file for the first time and you do not choose a file name, Microsoft Excel will not assign a file name for you.

True

False

34. The__________________ method allows you to copy a formula and fill it into many different consecutive cells at the same time.

Auto formula

Auto save

Fill formula

35. You cannot use copy and paste to copy a formula to other cells.

True

False

36.

Tool bar

Menu bar

Instruction bar

Menu bar

The Menu bar displays all the menus available for use in Excel 2003.

Explanation

Menu bar

The Menu bar displays all the menus available for use in Excel 2003.

37. To multiply two cells the formula, B2 and B3, you would need to insert a multiplication operator the letter "x" between them.

True

False

38. A Workbook defaults to three worksheets. A Workbook must contain at least two worksheets.

True

False

39.

A darkened border, called the cell pointer, identifies it.

True

False

40. The default font in a spreadsheet is ____________ points

Ariel 12

Times New Roman 10

Arial 10

41.
Bold, Italize, highlight

True

False

42. ___________ cell references in a formula always refer to the same cell or cell range in a formula.

Absolute

Auto complete

Fill

43.

Type the ____________ to let Excel know that an add operation is to be performed.

Sum function

Addition sign (+)

All of the above

44. **(5-2)*3**

Perform the operation in parenthesis (5-2) first and then multiply by 3. The answer is 9. perform multiplication first

Perform subtraction first

45. Excel's______________ feature keeps track of previously-entered text. If the first few characters you type in a cell match an existing entry in that column, Microsoft Excel fills in the remaining characters for you.

Autofinish

Autofill

AutoComplete

Excel Test 1

1. Each row is named by a ____________.

2.

What first name or nickname would you like us to use?

2. A cell is an intersection of a column and row.

3. This is an example of ____________________________ headings.

4. Each Excel worksheet is made up of columns and rows.

5. Every workbook created in Excel must be saved and assigned a name to distinguish it from other workbooks.

6. Excel requires every formula to begin with an equal sign (=).

7.

8.

9. The following cell is named_____________

10. _________________________ formulas involve more than one mathematical operation.

11. Sheet tabs can be renamed by simply double clicking on the them and typing in the new name.

12. Use to add a border around a range of cell

13. You can revise any formula that was previously written in a worksheet.

14. Used when to save a new file for the first time or save an existing file with a different name.

15. Used to open an existing file from a floppy disk or hard drive of your computer.

16. The _______ menu contains all the operations that we will discuss in this lesson: New, Open, Close, Save and Save As.

17.

18. Identifies the largest number in a range of cells.

19. Double-click on the cell that contains the information to be changed.

20. Click the gray Row heading to select the entire row.

21. Formulas can be created by using either numbers or cell references in the definition.

22. The ___________ cell, or the cell that can be acted upon, reveals a dark border.

23. You do not have the ability to insert new worksheets if needed or delete others you no longer want.

24. _____________________ (double headed arrow) can be used to change a column width.

25. In Excel, never do math "in your head" and type the answer in a cell where you would expect to have a formula calculate the answer.

26. Press ________ or click the Enter button on the Formula bar. This step ends the formula.

27. Click-and-hold the left mouse button and drag left or right, up or down to the last cell you want to select.

28. Click the Copy button. Marching "ants" appear around the copied cell(s).

29. ____________ worksheets allows you to apply identical formulas and/or formatting across all the worksheets in the group.

30. If the cells and columns you want to select are not directly next to one another, select one of the ranges you want to select, and hold down the _______ key while selecting other ranges.

31. Click the gray rectangle in the upper left corner to select half worksheet.

32.

33. If you're saving the file for the first time and you do not choose a file name, Microsoft Excel will not assign a file name for you.

34. The__________________ method allows you to copy a formula and fill it into many different consecutive cells at the same time.

35. You cannot use copy and paste to copy a formula to other cells.

36.

37. To multiply two cells the formula, B2 and B3, you would need to insert a multiplication operator the letter "x" between them.

38. A Workbook defaults to three worksheets. A Workbook must contain at least two worksheets.

39. A darkened border, called the cell pointer, identifies it.

40. The default font in a spreadsheet is ____________ points

41. Bold, Italize, highlight

42. ___________ cell references in a formula always refer to the same cell or cell range in a formula.

43. Type the ____________ to let Excel know that an add operation is to be performed.

44. (5-2)*3

45. Excel's______________ feature keeps track of previously-entered text. If the first few characters you type in a cell match an existing entry in that column, Microsoft Excel fills in the remaining characters for you.

4.

Each Excel worksheet is made up of columns and rows.

19.

Double-click on the cell that contains the information to be changed.

27.

Click-and-hold the left mouse button and drag left or right, up or down to the last cell you want to select.

39.

A darkened border, called the cell pointer, identifies it.

41.
Bold, Italize, highlight

43.

Type the ____________ to let Excel know that an add operation is to be performed.

44. **(5-2)*3**