Writing

Indicate whether the statement is true or false.

1. Excel simplifies the organization and maintenance of your data.
a. True
b. False

2. Comments added to an Excel worksheet are automatically printed by default.
a. True
b. False

3. The Ribbon in Excel is similar to the Ribbon used in Word.
a. True
b. False

4. An error value appears if the cell is not wide enough to show the result.
a. True
b. False

5. When creating formulas, there must be a closing parenthesis for every opening parenthesis.
a. True
b. False

6. In Excel, a cell’s width is automatically adjusted when the font size changes.
a. True
b. False

7. When you add a new column to your spreadsheet, the data shifts to the right.
a. True
b. False

8. To create a minus sign in a formula, use the hyphen key.
a. True
b. False

9. The COUNT and SUM functions are interchangeable.
a. True
b. False

10. When you use the Cut and Copy commands, the data and formats are also moved or copied.
a. True
b. False

11. If the text does not fit on one line of a cell, you can wrap to new lines.
a. True
b. False

12. To select an entire row, click the row heading.
a. True
b. False

13. To enter data in a cell, you must first make the cell active.
a. True
b. False

14. Spreadsheets are often used for reporting finances and managing expenses.
a. True
b. False

15. You can use the Format Painter feature to copy attributes assigned to a cell.
a. True
b. False

16. An example of a font size is 12 _____.
a. characters b. points
c. pixels d. millimeters

17. By default, new blank workbooks include ____ worksheet(s).
a. zero b. one
c. two d. three

18. The header and footer commands are located on the ____ tab.
a. HOME b. FILE
c. PAGE LAYOUT d. INSERT

19. In the accompanying figure, the space to the right of “fx” is called the ____.
a. name box b. active cell
c. title bar d. formula bar

Tyler is teaching Eleni how to perform calculations in her Excel worksheet.

20. Tyler tells Eleni that the * (asterisk) character is used to represent ____.
a. addition b. subtraction
c. multiplication d. division

Amy is new to using Excel and is learning how to enter data.

21. Amy learns that when you point to the fill handle, the pointer changes to a ____.
a. white plus sign b. crosshair
c. double-headed arrow d. single-headed arrow

22. A ____ contains column headings or field names in a data source.
a. header row b. column header
c. table header d. footer

23. All Excel formulas begin with ____.
a. the equal sign b. a number
c. a value d. an operand

24. A ____ is the design of the typeface.
a. point b. style
c. font d. format

25. To move to the first cell in a row, press ____.
a. Left arrow b. Ctrl+Home
c. Home d. Shift+Tab

26. ____ view displays the column and row labels separated from the worksheet cells.
a. Normal b. Page Layout
c. Full Screen Reading d. Page Break Preview

27. Data entered into a cell is also displayed in the ____ bar.
a. title b. formula
c. status d. name

28. By default, Excel aligns numbers at the ____ of the cell.
a. right b. left
c. center d. top

29. Excel refers to a spreadsheet as a ____.
a. worksheet b. workbook
c. table d. database

30. The ____ function multiplies values in the specified cells.
a. =PRODUCT b. =SUM
c. =COUNT d. =MEDIAN

Tyler is teaching Eleni how to perform calculations in her Excel worksheet.

31. Tyler tells Eleni that ____ is an absolute cell reference.
a. A1 b. $A1
c. A$1 d. $A$1

32. A(n) ____ cell reference does not change when the formula is copied or moved.
a. mixed b. complex
c. absolute d. relative

Identify the letter of the choice that best matches the phrase or definition.
a. Freeze
b. Split
c. Filter
d. Sort
e. Hide

33. Locks columns and rows to keep them visible