CIS 100 Excel Review

1. Excel is a computerized database
2. The entire document created using excel is know as a workbook
3. Rows are represented by numbers
4. Columns are represented by letters.
5. To make the program fit the entire screen, click on the maximize button.
6. The menu bar contains menus such as file, edit, and view.
7. The cell is where a column and a row intersect.
8. Excel has a maximum of 256 columns
9. By default, excel is made up of 3 worksheets
10. The indicator that moves on the screen is called the pointer
11. An active cell has a dark border around it
12. Text entries include letters, numbers, and symbols.
13. To select a cell in a worksheet click it.
14. The cell at the intersection of the first column and the first row is A1.
15. To complete a cell entry, press enter
16. Formulas are were arithmetic is used to calculate values in a worksheet
17. An excel formula always begins with =
18. The formula used to multiply A2 by A8 is   =A2*A8
19. When you enter a formula in a cell, the result is displayed in the cell.
20. To multiple use *, to add +, to subtract -, and to divide /
21. Select a cell and look at the formula bar in order to determine the formula for a given cell
22. To sum a range of cells, a colon should separate the first and last cell.
23. Input is the information you enter in a worksheet in order to calculate the desired results
24. Output is the resulting data that a worksheet produces
25. SUM is the most commonly used function in excel.
26. The result of = 2-10/2 is –3
27. According to excel, exponents are dealt with first in solving equations
28. Excel performs operations in an equation from left to right
29. The equal sign is the first thing that you type when entering an equation.
30. Relative cell references change when copied
31. When you instruct Excel to divide by zero you get #DIV/0!
32. To create an absolute reference you use the dollar sign
33. Excel automatically assigns the first sheet of a new workbook Sheet 1
34. Average is a statistical function
35. To print you document horizontally you must click on landscape in the page setup.
36. Charts are the visual representation of worksheet data
37. Column, pie, and line are types of excel charts.
38. Data series is a group of related data points.
39. The y-axis are the values plotted along the vertical axis.
40. The x-axis are the values plotted along the horizontal axis.
41. Before creating a chart, you must select the cells that contain the data you want to appear in the chart.
42. When using excel chart wizard, the first thing it ask for you to specify the type of chart you want.
43. Before you can move, resize, or copy a chart you must first select it.
44. A chart is selected if it has handles on the boundaries of the chart
45. If you change data in a worksheet, excel automatically update the chart within the worksheet.
46. Once you select a chart, you can move, resize, or copy it.
47. When you create a pie chart, excel automatically calculates the percentages for each slice.
48. A chart sheet is a special sheet that contains only one chart.
49. To explode a pie chart, click chart, click & drag slice away from the center of the chart.
50. Before you print an excel chart you should always save it.

Back to syllabus