Excel Chapters 1-11 T/F

Question 1

Microsoft Excel 2010 stores spreadsheets in files called workbooks.

Answer 1

True

Question 2

A spreadsheet is a collection of numbers, not text.

Answer 2

False

Question 3

The name of the active workbook appears in the status bar of the Excel window.

Answer 3

False

Question 4

Excel workbooks can contain two kinds of sheets.

Answer 4

True

Question 5

The formula bar displays the value or formula of the active cell.

Answer 5

True

Question 6

You can use the Go To dialog box to navigate to a specific worksheet.

Answer 6

True

Question 7

Scrolling through sheet tabs does not change the active sheet in the workbook window.

Answer 7

True

Question 8

The AutoComplete feature automatically completes an entry based on previous entries in a column.

Answer 8

True

Question 9

Charts can be embedded into worksheets.

Answer 9

True

Question 10

If you click the Print Active sheet(s) option button in the Print tab, the entire workbook will be printed.

Answer 10

False

Question 11

Text is truncated when the cell that it resides in is not wide enough to display all of it.

Answer 11

True

Question 12

Text is right-aligned in cells, like number data.

Answer 12

False

Question 13

To create a line break within a cell, press Alt + Enter.

Answer 13

True

Question 14

A documentation sheet is a valuable element if you intend to share the workbook with others.

Answer 14

True

Question 15

In an electronic spreadsheet, you need to manually recalculate when you change the entries.

Answer 15

False

Question 16

You are in Edit mode any time you are entering or changing the contents of a cell.

Answer 16

True

Question 17

When the paper orientation is set on landscape, the contents will print across the width of the page.

Answer 17

False

Question 18

In Page Layout view, the dotted line indicates the print area.

Answer 18

True

Question 19

Formatting changes only the appearance of data - it does not affect the data itself.

Answer 19

True

Question 20

By default, text is black and cells have no background fill color.

Answer 20

True

Question 21

You can use a picture or image as the background for all the cells in a worksheet.

Answer 21

True

Question 22

Background images do not print in Excel.

Answer 22

True

Question 23

After you merge a range into a single cell, you cannot realign its content.

Answer 23

False

Question 24

You can rotate cell contents in Excel so that they appear at any angle or orientation.

Answer 24

True

Question 25

When a worksheet is printed, the gridlines that surround the cells are printed by default.

Answer 25

False

Question 26

Modifying the number format affects the value stored in the workbook.

Answer 26

False

Question 27

If you revise a style in Excel, the appearance of any cell formatted with that style must be updated manually.

Answer 27

False

Question 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.

Answer 28

True

Question 29

If you use colors that are not part of a theme, changing the theme will not change those colors.

Answer 29

True

Question 30

A table style treats the table as a single object rather than a collection of cells.

Answer 30

True

Question 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.

Answer 31

True

Question 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.

Answer 32

False

Question 33

Conditional formats are dynamic, so a cell’s appearance will change to reflect its current value.

Answer 33

True

Question 34

A conditional format can make negative numbers red and positive numbers black.

Answer 34

True

Question 35

Excel has only two conditional formats—data bars and highlighting.

Answer 35

False

Question 36

Top/Bottom Rules is a form of Conditional Formatting that allows you options to select the bottom 10% of data.

Answer 36

True

Question 37

When you use conditional formatting to highlight cells in a worksheet, you do not need to include a legend.

Answer 37

False

Question 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.

Answer 38

False

Question 39

When you enter a formula into a cell, Excel interprets cell references in the formula in relation to the cell’s location.

Answer 39

True

Question 40

The Rand( ) function falls under the Statistical category.

Answer 40

False

Question 41

Optional arguments are always placed last in the argument list.

Answer 41

True

Question 42

One challenge of nesting functions is to make sure that you include all of the parentheses.

Answer 42

True

Question 43

Functions are organized in the Function Library group in the Function tab on the Ribbon.

Answer 43

False

Question 44

A mixed reference “locks” one part of the cell reference while the other part can change.

Answer 44

True

Question 45

To enter a mixed reference, type $ after either the row or column reference.

Answer 45

False

Question 46

Not all functions have arguments.

Answer 46

True

Question 47

Functions can be incorporated as part of larger formulas.

Answer 47

True

Question 48

COUNT is a Statistical function.

Answer 48

True

Question 49

In the Function Arguments dialog box, required arguments are in bold type.

Answer 49

True

Question 50

You can open the Insert Function dialog box by clicking the Insert Function button on the Ribbon.

Answer 50

False

Question 51

The Format Painter button is on the Clipboard group.

Answer 51

True

Question 52

Using the AutoFill feature is more efficient than copying and pasting.

Answer 52

True

Question 53

In the list of AutoFill Options, the Fill Formatting Only option is the default setting.

Answer 53

False

Question 54

AutoFill can recognize some patterns if you plug in a minimum of at least two values, such as “Monday, Tuesday.”

Answer 54

True

Question 55

You can build decision-making capability into a formula through the use of a logical function.

Answer 55

True

Question 56

If a formula contains several functions, Excel starts with the outermost function and then moves inward.

Answer 56

False

Question 57

The Function Library is a group on the Ribbon.

Answer 57

True

Question 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.

Answer 58

True

Question 59

Every chart must have a data source.

Answer 59

True

Question 60

When selecting a data source for a pie chart, select all rows and columns, including total rows and columns.

Answer 60

False

Question 61

By default, embedded charts display the chart and any text or figures on separate pages.

Answer 61

False

Question 62

Charts include individual elements that can be formatted, including the chart area, the chart title, the plot area, data markers, and a legend.

Answer 62

True

Question 63

A chart style is similar to a cell style or a table style in that it formats several chart elements at one time.

Answer 63

True

Question 64

To change a border color on a chart, click the Color button to open the color palette.

Answer 64

?

Question 65

In pie charts with legends, it’s best to make the slice colors as similar as possible.

Answer 65

False

Question 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.

Answer 66

True

Question 67

You can rotate a 3-D chart along the x-axis, y-axis, and z-axis

Answer 67

False

Question 68

In Excel, charts do not remain linked or connected to their data sources if they appear in different worksheets.

Answer 68

False

Question 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.

Answer 69

True

Question 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.

Answer 70

True

Question 71

Excel has a built-in format to display four-digit year values, so you do not need to create one.

Answer 71

False

Question 72

Excel allows you to overlay a legend on a chart as a space-saving option.

Answer 72

True

Question 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.

Answer 73

True

Question 74

Line charts are best suited for representing data that follows some sequential order.

Answer 74

True

Question 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.

Answer 75

True

Question 76

Embedded charts can be moved and resized.

Answer 76

True

Question 77

The lengths of data bars are based on the value of each cell in the selected range.

Answer 77

True

Question 78

Chart sheets show both charts and worksheet data.

Answer 78

False

Question 79

Using multiple worksheets makes it more difficult for you to group your data.

Answer 79

False

Question 80

A worksheet cluster is a collection of two or more selected worksheets.

Answer 80

False

Question 81

Once you group a collection of worksheets, any changes you make to one worksheet are applied to all sheets in the group.

Answer 81

True

Question 82

If a worksheet group includes all the worksheets in a workbook, you can edit only the active worksheet.

Answer 82

True

Question 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.

Answer 83

True

Question 84

Using multiple worksheets with identical layouts enables you to use 3-D references to quickly summarize the data in another worksheet.

Answer 84

True

Question 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.

Answer 85

False

Question 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.

Answer 86

True

Question 87

The workspace file contains the location and name of the file as well as the actual workbooks and worksheets.

Answer 87

False

Question 88

Excel has some templates that are automatically installed on your hard disk.

Answer 88

True

Question 89

When you use a template, you can make any changes you want to the workbook without affecting the template file.

Answer 89

False

Question 90

When you create a new workbook from a template, an unnamed copy of the template opens.

Answer 90

True

Question 91

A workbook based on a specific template always displays the name of the template followed by the date.

Answer 91

False

Question 92

A template can use most Excel features except macros.

Answer 92

False

Question 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.

Answer 93

True

Question 94

All template files have the .xlts file extension.

Answer 94

False

Question 95

In Backstage view, the New from existing button opens a copy of the selected file, not the selected file.

Answer 95

True

Question 96

You can save your files directly from Microsoft Office 2010 onto SkyDrive from Worksheet view.

Answer 96

True

Question 97

You can view, but cannot edit, workbooks in the Excel Web App.

Answer 97

False

Question 98

After you have a Windows Live ID, you can access your SkyDrive and the Office Web Apps.

Answer 98

True

Question 99

Only a few types of computers can read text files.

Answer 99

False

Question 100

Text files are rarely used for storing data.

Answer 100

False

Question 101

Most software programs can both save and retrieve data in a text file format.

Answer 101

True

Question 102

Excel can open a text file into a worksheet, where you can then format it as you would any data.

Answer 102

True

Question 103

Excel can save a workbook as a text file, preserving only the data values, without any of the formats applied to it.

Answer 103

True

Question 104

Columns in delimited text files are always vertically aligned as they would be in a spreadsheet.

Answer 104

False

Question 105

In addition to delimited text, you can also organize data with a fixed-width file.

Answer 105

True

Question 106

By default, the Text Import Wizard will start importing text with the first row of the file.

Answer 106

True

Question 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.

Answer 107

True

Question 108

The Text Import Wizard’s attempt to define the number and location of columns is always correct.

Answer 108

False

Question 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.

Answer 109

False

Question 110

When using the Text Import Wizard, you can specify a column’s format before the column is imported.

Answer 110

True

Question 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.

Answer 111

True

Question 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.

Answer 112

True

Question 113

You cannot specify how you want the data to appear in a query.

Answer 113

False

Question 114

When you save a query, you are actually placing the query choices you have made into a file.

Answer 114

True

Question 115

In the last part of writing a query, you specify how to sort the data.

Answer 115

True

Question 116

By modifying a query’s properties, you can add new columns to your worksheet, change the sort order options, or specify a filter.

Answer 116

True

Question 117

Databases such as those created in Access are examples of relational databases.

Answer 117

True

Question 118

Microsoft supports a library of built-in Web queries.

Answer 118

True