Mastering Excel: Essential Knowledge and Techniques

1. E X C E L 1pt 1 pt 1 pt 1pt 1 pt 2 pt 2 pt 2pt 2pt 2 pt 3 pt 3 pt 3 pt 3 pt 3 pt 4 pt 4 pt 4pt 4 pt 4pt 5pt 5 pt 5 pt 5 pt 5 pt

2. 1.1 The file extension usually associated with a Microsoft spreadsheet is: A. .dot B. .exe C. .ppt D. .xls

3. 1.1 What is D. .xls?

4. 1.2 To add a dollar sign to a number in a particular cell, • Select Edit from the tool bar. • Select Format from the tool bar. • Select Insert from the tool bar. • Select Tools from the tool bar.

5. 1.2 What is B. Select Format from the tool bar?

6. 1.3 The first step in creating a formula that adds a list of numbers is to: • Click in the cell where you want the formula to appear. • Press Enter. • Type an equal sign. • Write the formula using the names of the cells.

7. 1.3 What is A. Click in the cell where you want the formula to appear?

8. 1.4 answer

9. 1.4 question

10. 1.5 answer

11. 1.5 question

12. 2.1 Instead of writing a long formula you could use: • An Average • A Column • A Function • An Option

13. 2.1 What is C. A Function?

14. 2.2 Before you can create a chart you must first • Select the data, then choose Data. • Select the data, then choose Format. • Select the data, then choose Insert. • Select the data, then choose View.

15. 2.2 What is C. Select the data then choose Insert?

16. 2.3 ________ is a grid of rectangles. • Cell • Formula • Sheet • Value

17. 2.3 What is C. Sheet?

18. 2.4 answer

19. 2.4 question

20. 2.5 answer

21. 2.5 question

22. 3.1 There are ________ rows in one Excel spreadsheet. • 230 • 1,000 • 25,000 • 65,536

23. 3.1 What is D. 65,536?

24. 3.2 To Select a cell: • A. Move the cursor to the cell and hold down the mouse button. • B. Move the cursor to the cell and left click once. • C. Select the cell, then choose Format. • D. Select the cell, then choose Insert.

25. 3.2 What is B. Move the cursor to the cell and left click once.

26. 3.3 An Excel spreadsheet has ____ columns. A. 26 B. 100 C. 210 D. 256

27. 3.3 What is D. 256?

28. 3.4 answer

29. 3.4 question

30. 3.5 answer

31. 3.5 question

32. 4.1 The third cell in the second column is labeled _______. • A. Cell 3 • B. Cell 3B • C. Cell B3 • D. Cell B^3

33. 4.1 What is C. Cell B3?

34. 4.2 ________ is a mathematical expression that the computer will evaluate. • A. Formula • B. Function • C. Value • D. Tool.

35. 4.2 What is A. Formula?

36. 4.3 The icon that is an arrow curving counter clockwise is the ____________ button. • A. Delete • B. Edit • C. Insert • D. Undo

37. 4.3 What is D. Undo?

38. 4.4 answer

39. 4.4 question

40. 4.5 answer

41. 4.5 question

42. 5.1 “Dragging and dropping” is an example of _________. • A. Adding a row. • B. Copying and pasting cell contents. • C. Moving cell contents. • D. Selecting a cell to delete.

43. 5.1 What is B. Copying and pasting cell contents?

44. 5.2 To arrange data in ascending order, • A. Select Data, then Sort. • B. Select Insert, then Function. • Select Tools, then Options. • Select View, then Custom View.

45. 5.2 What is A. Select Data, then Sort?

46. 5.3 The expression, “=A1+B1,” is an example of • A. A Cell. • B. A Formula. • A Label. • A Value.

47. 5.3 What is B. A Formula?

48. 5.4 answer

49. 5.4 question

50. 5.5 answer