Excel Chapters 1-11 T/F Flashcards
(118 cards)
1
Q
Microsoft Excel 2010 stores spreadsheets in files called workbooks.
A
True
2
Q
A spreadsheet is a collection of numbers, not text.
A
False
3
Q
The name of the active workbook appears in the status bar of the Excel window.
A
False
4
Q
Excel workbooks can contain two kinds of sheets.
A
True
5
Q
The formula bar displays the value or formula of the active cell.
A
True
6
Q
You can use the Go To dialog box to navigate to a specific worksheet.
A
True
7
Q
Scrolling through sheet tabs does not change the active sheet in the workbook window.
A
True
8
Q
The AutoComplete feature automatically completes an entry based on previous entries in a column.
A
True
9
Q
Charts can be embedded into worksheets.
A
True
10
Q
If you click the Print Active sheet(s) option button in the Print tab, the entire workbook will be printed.
A
False
11
Q
Text is truncated when the cell that it resides in is not wide enough to display all of it.
A
True
12
Q
Text is right-aligned in cells, like number data.
A
False
13
Q
To create a line break within a cell, press Alt + Enter.
A
True
14
Q
A documentation sheet is a valuable element if you intend to share the workbook with others.
A
True
15
Q
In an electronic spreadsheet, you need to manually recalculate when you change the entries.
A
False
16
Q
You are in Edit mode any time you are entering or changing the contents of a cell.
A
True
17
Q
When the paper orientation is set on landscape, the contents will print across the width of the page.
A
False
18
Q
In Page Layout view, the dotted line indicates the print area.
A
True
19
Q
Formatting changes only the appearance of data - it does not affect the data itself.
A
True
20
Q
By default, text is black and cells have no background fill color.
A
True
21
Q
You can use a picture or image as the background for all the cells in a worksheet.
A
True
22
Q
Background images do not print in Excel.
A
True
23
Q
After you merge a range into a single cell, you cannot realign its content.
A
False
24
Q
You can rotate cell contents in Excel so that they appear at any angle or orientation.
A
True
25
When a worksheet is printed, the gridlines that surround the cells are printed by default.
False
26
Modifying the number format affects the value stored in the workbook.
False
27
If you revise a style in Excel, the appearance of any cell formatted with that style must be updated manually.
False
28
Red-green color blindness is the most common, so avoid using red text on a green background or green text on a red background.
True
29
If you use colors that are not part of a theme, changing the theme will not change those colors.
True
30
A table style treats the table as a single object rather than a collection of cells.
True
31
If you insert a new row at the top of the table, the new row becomes the header row and is formatted with the table style.
True
32
When you add a table style, be sure that all formatting is as you want it because table styles in Excel cannot be formatted once applied.
False
33
Conditional formats are dynamic, so a cell’s appearance will change to reflect its current value.
True
34
A conditional format can make negative numbers red and positive numbers black.
True
35
Excel has only two conditional formats—data bars and highlighting.
False
36
Top/Bottom Rules is a form of Conditional Formatting that allows you options to select the bottom 10% of data.
True
37
When you use conditional formatting to highlight cells in a worksheet, you do not need to include a legend.
False
38
It is not good practice to include descriptive information, such as the company name, logo, and worksheet title on each page of a printout in case a page gets into the wrong hands.
False
39
When you enter a formula into a cell, Excel interprets cell references in the formula in relation to the cell’s location.
True
40
The Rand( ) function falls under the Statistical category.
False
41
Optional arguments are always placed last in the argument list.
True
42
One challenge of nesting functions is to make sure that you include all of the parentheses.
True
43
Functions are organized in the Function Library group in the Function tab on the Ribbon.
False
44
A mixed reference “locks” one part of the cell reference while the other part can change.
True
45
To enter a mixed reference, type $ after either the row or column reference.
False
46
Not all functions have arguments.
True
47
Functions can be incorporated as part of larger formulas.
True
48
COUNT is a Statistical function.
True
49
In the Function Arguments dialog box, required arguments are in bold type.
True
50
You can open the Insert Function dialog box by clicking the Insert Function button on the Ribbon.
False
51
The Format Painter button is on the Clipboard group.
True
52
Using the AutoFill feature is more efficient than copying and pasting.
True
53
In the list of AutoFill Options, the Fill Formatting Only option is the default setting.
False
54
AutoFill can recognize some patterns if you plug in a minimum of at least two values, such as “Monday, Tuesday.”
True
55
You can build decision-making capability into a formula through the use of a logical function.
True
56
If a formula contains several functions, Excel starts with the outermost function and then moves inward.
False
57
The Function Library is a group on the Ribbon.
True
58
As you begin to type a function name within a formula into a cell, a list of functions that begin with the letters you typed appears.
True
59
Every chart must have a data source.
True
60
When selecting a data source for a pie chart, select all rows and columns, including total rows and columns.
False
61
By default, embedded charts display the chart and any text or figures on separate pages.
False
62
Charts include individual elements that can be formatted, including the chart area, the chart title, the plot area, data markers, and a legend.
True
63
A chart style is similar to a cell style or a table style in that it formats several chart elements at one time.
True
64
To change a border color on a chart, click the Color button to open the color palette.
?
65
In pie charts with legends, it’s best to make the slice colors as similar as possible.
False
66
Although 3-D charts are visually attractive, they can obscure the relationship between the values in the chart by making it difficult to see which slice is larger.
True
67
You can rotate a 3-D chart along the x-axis, y-axis, and z-axis
False
68
In Excel, charts do not remain linked or connected to their data sources if they appear in different worksheets.
False
69
One of Edward Tufte’s most important works is The Visual Display of Quantitative Information in which he laid out several principles for the design of charts and graphics.
True
70
When data bars are used with negative values, the date bars originate from the center of the cell with negative bars extending to the left and positive bars extending to the right.
True
71
Excel has a built-in format to display four-digit year values, so you do not need to create one.
False
72
Excel allows you to overlay a legend on a chart as a space-saving option.
True
73
Sparklines differ from data bars in that the sparklines are always placed in the cells containing the value they represent and each cell represents only a single bar from the bar chart.
True
74
Line charts are best suited for representing data that follows some sequential order.
True
75
If you cannot find the right chart to meet your needs, Excel allows you to create a custom chart based on the built-in chart types.
True
76
Embedded charts can be moved and resized.
True
77
The lengths of data bars are based on the value of each cell in the selected range.
True
78
Chart sheets show both charts and worksheet data.
False
79
Using multiple worksheets makes it more difficult for you to group your data.
False
80
A worksheet cluster is a collection of two or more selected worksheets.
False
81
Once you group a collection of worksheets, any changes you make to one worksheet are applied to all sheets in the group.
True
82
If a worksheet group includes all the worksheets in a workbook, you can edit only the active worksheet.
True
83
If you delete a value from one cell, the content is also deleted from the same cell in all the worksheets in the group.
True
84
Using multiple worksheets with identical layouts enables you to use 3-D references to quickly summarize the data in another worksheet.
True
85
When the source and destination workbooks are stored in the same folder, you still need to include the location information in the workbook reference that links the two files.
False
86
If the destination file is closed when you make a change in the source file, you choose whether to update the link to display the current values when you open the destination file or continue to display the older values from the destination file.
True
87
The workspace file contains the location and name of the file as well as the actual workbooks and worksheets.
False
88
Excel has some templates that are automatically installed on your hard disk.
True
89
When you use a template, you can make any changes you want to the workbook without affecting the template file.
False
90
When you create a new workbook from a template, an unnamed copy of the template opens.
True
91
A workbook based on a specific template always displays the name of the template followed by the date.
False
92
A template can use most Excel features except macros.
False
93
To delete the data values, you can also click the Clear button in the Editing group on the Home tab, and then click Clear Contents.
True
94
All template files have the .xlts file extension.
False
95
In Backstage view, the New from existing button opens a copy of the selected file, not the selected file.
True
96
You can save your files directly from Microsoft Office 2010 onto SkyDrive from Worksheet view.
True
97
You can view, but cannot edit, workbooks in the Excel Web App.
False
98
After you have a Windows Live ID, you can access your SkyDrive and the Office Web Apps.
True
99
Only a few types of computers can read text files.
False
100
Text files are rarely used for storing data.
False
101
Most software programs can both save and retrieve data in a text file format.
True
102
Excel can open a text file into a worksheet, where you can then format it as you would any data.
True
103
Excel can save a workbook as a text file, preserving only the data values, without any of the formats applied to it.
True
104
Columns in delimited text files are always vertically aligned as they would be in a spreadsheet.
False
105
In addition to delimited text, you can also organize data with a fixed-width file.
True
106
By default, the Text Import Wizard will start importing text with the first row of the file.
True
107
For a fixed-width text file to import correctly into Excel, there must be some way for the Text Import Wizard to know where each column begins and ends.
True
108
The Text Import Wizard's attempt to define the number and location of columns is always correct.
False
109
If a break is in the wrong location in the Data preview window, you double-click it to move it to a new location in the window.
False
110
When using the Text Import Wizard, you can specify a column's format before the column is imported.
True
111
In addition to specifying the format of data using the Text Import Wizard, you can also indicate which columns you do not want to import.
True
112
Eliminating columns using the Text Import Wizard is useful when there are only a few items you want to import from a large text file containing many columns.
True
113
You cannot specify how you want the data to appear in a query.
False
114
When you save a query, you are actually placing the query choices you have made into a file.
True
115
In the last part of writing a query, you specify how to sort the data.
True
116
By modifying a query's properties, you can add new columns to your worksheet, change the sort order options, or specify a filter.
True
117
Databases such as those created in Access are examples of relational databases.
True
118
Microsoft supports a library of built-in Web queries.
True
