Excel Chapters 1-11 T/F Flashcards
Microsoft Excel 2010 stores spreadsheets in files called workbooks.
True
A spreadsheet is a collection of numbers, not text.
False
The name of the active workbook appears in the status bar of the Excel window.
False
Excel workbooks can contain two kinds of sheets.
True
The formula bar displays the value or formula of the active cell.
True
You can use the Go To dialog box to navigate to a specific worksheet.
True
Scrolling through sheet tabs does not change the active sheet in the workbook window.
True
The AutoComplete feature automatically completes an entry based on previous entries in a column.
True
Charts can be embedded into worksheets.
True
If you click the Print Active sheet(s) option button in the Print tab, the entire workbook will be printed.
False
Text is truncated when the cell that it resides in is not wide enough to display all of it.
True
Text is right-aligned in cells, like number data.
False
To create a line break within a cell, press Alt + Enter.
True
A documentation sheet is a valuable element if you intend to share the workbook with others.
True
In an electronic spreadsheet, you need to manually recalculate when you change the entries.
False
You are in Edit mode any time you are entering or changing the contents of a cell.
True
When the paper orientation is set on landscape, the contents will print across the width of the page.
False
In Page Layout view, the dotted line indicates the print area.
True
Formatting changes only the appearance of data - it does not affect the data itself.
True
By default, text is black and cells have no background fill color.
True
You can use a picture or image as the background for all the cells in a worksheet.
True
Background images do not print in Excel.
True
After you merge a range into a single cell, you cannot realign its content.
False
You can rotate cell contents in Excel so that they appear at any angle or orientation.
True
When a worksheet is printed, the gridlines that surround the cells are printed by default.
False
Modifying the number format affects the value stored in the workbook.
False
If you revise a style in Excel, the appearance of any cell formatted with that style must be updated manually.
False
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
If you use colors that are not part of a theme, changing the theme will not change those colors.
True
A table style treats the table as a single object rather than a collection of cells.
True
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
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
Conditional formats are dynamic, so a cell’s appearance will change to reflect its current value.
True
A conditional format can make negative numbers red and positive numbers black.
True
Excel has only two conditional formats—data bars and highlighting.
False
Top/Bottom Rules is a form of Conditional Formatting that allows you options to select the bottom 10% of data.
True
When you use conditional formatting to highlight cells in a worksheet, you do not need to include a legend.
False
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
When you enter a formula into a cell, Excel interprets cell references in the formula in relation to the cell’s location.
True
The Rand( ) function falls under the Statistical category.
False
Optional arguments are always placed last in the argument list.
True
One challenge of nesting functions is to make sure that you include all of the parentheses.
True
Functions are organized in the Function Library group in the Function tab on the Ribbon.
False
A mixed reference “locks” one part of the cell reference while the other part can change.
True
To enter a mixed reference, type $ after either the row or column reference.
False
Not all functions have arguments.
True
Functions can be incorporated as part of larger formulas.
True
COUNT is a Statistical function.
True
In the Function Arguments dialog box, required arguments are in bold type.
True
You can open the Insert Function dialog box by clicking the Insert Function button on the Ribbon.
False
The Format Painter button is on the Clipboard group.
True
Using the AutoFill feature is more efficient than copying and pasting.
True
In the list of AutoFill Options, the Fill Formatting Only option is the default setting.
False
AutoFill can recognize some patterns if you plug in a minimum of at least two values, such as “Monday, Tuesday.”
True
You can build decision-making capability into a formula through the use of a logical function.
True
If a formula contains several functions, Excel starts with the outermost function and then moves inward.
False
The Function Library is a group on the Ribbon.
True
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
Every chart must have a data source.
True
When selecting a data source for a pie chart, select all rows and columns, including total rows and columns.
False
By default, embedded charts display the chart and any text or figures on separate pages.
False
Charts include individual elements that can be formatted, including the chart area, the chart title, the plot area, data markers, and a legend.
True
A chart style is similar to a cell style or a table style in that it formats several chart elements at one time.
True
To change a border color on a chart, click the Color button to open the color palette.
?
In pie charts with legends, it’s best to make the slice colors as similar as possible.
False
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
You can rotate a 3-D chart along the x-axis, y-axis, and z-axis
False
In Excel, charts do not remain linked or connected to their data sources if they appear in different worksheets.
False
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
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
Excel has a built-in format to display four-digit year values, so you do not need to create one.
False
Excel allows you to overlay a legend on a chart as a space-saving option.
True
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
Line charts are best suited for representing data that follows some sequential order.
True
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
Embedded charts can be moved and resized.
True
The lengths of data bars are based on the value of each cell in the selected range.
True
Chart sheets show both charts and worksheet data.
False
Using multiple worksheets makes it more difficult for you to group your data.
False
A worksheet cluster is a collection of two or more selected worksheets.
False
Once you group a collection of worksheets, any changes you make to one worksheet are applied to all sheets in the group.
True
If a worksheet group includes all the worksheets in a workbook, you can edit only the active worksheet.
True
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
Using multiple worksheets with identical layouts enables you to use 3-D references to quickly summarize the data in another worksheet.
True
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
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
The workspace file contains the location and name of the file as well as the actual workbooks and worksheets.
False
Excel has some templates that are automatically installed on your hard disk.
True
When you use a template, you can make any changes you want to the workbook without affecting the template file.
False
When you create a new workbook from a template, an unnamed copy of the template opens.
True
A workbook based on a specific template always displays the name of the template followed by the date.
False
A template can use most Excel features except macros.
False
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
All template files have the .xlts file extension.
False
In Backstage view, the New from existing button opens a copy of the selected file, not the selected file.
True
You can save your files directly from Microsoft Office 2010 onto SkyDrive from Worksheet view.
True
You can view, but cannot edit, workbooks in the Excel Web App.
False
After you have a Windows Live ID, you can access your SkyDrive and the Office Web Apps.
True
Only a few types of computers can read text files.
False
Text files are rarely used for storing data.
False
Most software programs can both save and retrieve data in a text file format.
True
Excel can open a text file into a worksheet, where you can then format it as you would any data.
True
Excel can save a workbook as a text file, preserving only the data values, without any of the formats applied to it.
True
Columns in delimited text files are always vertically aligned as they would be in a spreadsheet.
False
In addition to delimited text, you can also organize data with a fixed-width file.
True
By default, the Text Import Wizard will start importing text with the first row of the file.
True
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
The Text Import Wizard’s attempt to define the number and location of columns is always correct.
False
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
When using the Text Import Wizard, you can specify a column’s format before the column is imported.
True
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
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
You cannot specify how you want the data to appear in a query.
False
When you save a query, you are actually placing the query choices you have made into a file.
True
In the last part of writing a query, you specify how to sort the data.
True
By modifying a query’s properties, you can add new columns to your worksheet, change the sort order options, or specify a filter.
True
Databases such as those created in Access are examples of relational databases.
True
Microsoft supports a library of built-in Web queries.
True
