Content Frame
Note for screen reader users: There is text between the form elements on this page. To be sure that you do not miss any text, use item by item navigation methods, rather than tabbing from form element to form element

Online Study Guide
Excel Chapter 1: Creating a Worksheet and Charting Data - Online Study Guide

This activity contains 31 questions.

Question 1
1
Open Hint for Question 1 in a new window		 A worksheet is made up of a grid of individual
 
End of Question 1


Question 2
2
Open Hint for Question 2 in a new window		 The __________ displays the active cell reference.
 
End of Question 2


Question 3
3
Open Hint for Question 3 in a new window		 A group of selected cells that can be managed as a single unit is a
 
End of Question 3


Question 4
4
Open Hint for Question 4 in a new window		 Cell content is either a constant value or a
 
End of Question 4


Question 5
5
Open Hint for Question 5 in a new window		 Formulas that are provided by Excel are
 
End of Question 5


Question 6
6
Open Hint for Question 6 in a new window		 To view the formula that is used to determine a specific value in a cell, view the
 
End of Question 6


Question 7
7
Open Hint for Question 7 in a new window		 A cell's appearance is determined by its
 
End of Question 7


Question 8
8
Open Hint for Question 8 in a new window		 The Chart __________ leads you through the steps to create a chart.
 
End of Question 8


Question 9
9
Open Hint for Question 9 in a new window		 Complex data can be presented to individuals easily with a
 
End of Question 9


Question 10
10
Open Hint for Question 10 in a new window		 A chart placed on the worksheet that contains the data displayed in the chart is
 
End of Question 10


Question 11
11
Open Hint for Question 11 in a new window		 Use __________ to explain trends in your chart or worksheet.
 
End of Question 11


Question 12
12
Open Hint for Question 12 in a new window		 To delete __________ worksheets in a workbook, use the Shift key to select worksheets.
 
End of Question 12


Question 13
13
Open Hint for Question 13 in a new window		 __________ can be used to navigate the worksheets in an Excel workbook.
 
End of Question 13


Question 14
14
Open Hint for Question 14 in a new window		 __________ values are assigned to dates entered into a cell.
 
End of Question 14


Question 15
15
Open Hint for Question 15 in a new window		 Scroll boxes indicate how much of an Excel spreadsheet is displayed on the screen.
   
 
End of Question 15


Question 16
16
Open Hint for Question 16 in a new window		 The active cell is denoted by a green triangle in the top right corner of the cell.
   
 
End of Question 16


Question 17
17
Open Hint for Question 17 in a new window		 Row headings in Excel are designated by numbers, beginning in sequential order with 1.
   
 
End of Question 17


Question 18
18
Open Hint for Question 18 in a new window		 The only information that can be typed into a cell is numerical data.
   
 
End of Question 18


Question 19
19
Open Hint for Question 19 in a new window		 Formulas that display in the Formula Bar are considered underlying values.
   
 
End of Question 19


Question 20
20
Open Hint for Question 20 in a new window		 An advantage of Excel is that it can perform calculations on numbers, but it does NOT automatically re-calculate if you modify a number.
   
 
End of Question 20


Question 21
21
Open Hint for Question 21 in a new window		 AutoSum is a predefined formula that is used to add data in cells.
   
 
End of Question 21


Question 22
22
Open Hint for Question 22 in a new window		 The default Excel number format is Currency Style.
   
 
End of Question 22


Question 23
23
Open Hint for Question 23 in a new window		 The visual representation of data in a worksheet is a chart.
   
 
End of Question 23


Question 24
24
Open Hint for Question 24 in a new window		 Excel contains predefined chart designs with various sub-types within these designs.
   
 
End of Question 24


Question 25
25
Open Hint for Question 25 in a new window		 Headers and footers will display in Print Preview.
   
 
End of Question 25


Question 26
26
Open Hint for Question 26 in a new window		 A cell will display the formula and its value in the adjacent cell when it is printed.
   
 
End of Question 26


Question 27
27
Open Hint for Question 27 in a new window		 Sheets tabs can be renamed from the default names of Sheet1, Sheet2, and Sheet3 to descriptive worksheet names.
   
 
End of Question 27


Question 28
28
Open Hint for Question 28 in a new window		 To clear the formatting of a cell, make the cell active and click on the Delete key.
   
 
End of Question 28


Question 29
29
Open Hint for Question 29 in a new window		 Grouping a set of worksheets is a good way to apply standardized formatting across all worksheets at one time.
   
 
End of Question 29


Question 30
30
Open Hint for Question 30 in a new window		 Match the following terms to their meanings:
Using the pull-down menus, match each item in the left column to the corresponding item in the right column.
A Displays the cell address.
B Ready for data entry.
C Identifies the cell.
D Displays cell values that result from data or formulas.
E Is a value or formula.
[hint]
[hint]
[hint]
[hint]
[hint]
End of Question 30


Question 31
31
Open Hint for Question 31 in a new window		 Match the following terms to their meanings:
Using the pull-down menus, match each item in the left column to the corresponding item in the right column.
A Shows categories.
B Explains chart color codes.
C Represents values.
D Identify types of data.
E Numeric values.
[hint]
[hint]
[hint]
[hint]
[hint]
End of Question 31






Answer choices in this exercise appear in a different order each time the page is loaded.



Copyright © 1995-2008, Pearson Education, Inc., publishing as Pearson Prentice Hall
 Legal and Privacy Terms		Pearson Education

[Return to the Top of this Page]