Shared Flashcard Set

Details

Chapter 4 Excel
Chapter 4
114
Computer Science
11th Grade
10/23/2016
Click here to study/print these flashcards.

Create your own flash cards! Sign up here.

Additional Computer Science Flashcards

 

 

Cards

Term
False
 Definition
True or False: The width of column A is 1.57 (16 pixels). One way to adjust the width is to position the mouse pointer on the right boundary of column heading A and then drag to the left until the ScreenTip indicates Width
Term
True
 Definition
True or False: Two of the more powerful aspects of Excel are its wide array of functions and its capability
of organizing answers to what-if questions.
Term
True
 Definition
True or False: Global formatting assigns formats to all the cells in all of the worksheets in a workbook.
Term
False
 Definition
True or False: Excel does not allow you to format cells before you enter the values.
Term
True
 Definition
True or False: The Name Manager can help add clarity to your formulas by allowing you to assign names to cells.
Term
True
 Definition
True or False: Worksheets often have column titles at the top of each column and row titles to the left of each row that describe the data within the worksheet.
Term
True
 Definition
true or False: Worksheets often have column titles at the top of each column and row titles to the left of each row that describe the data within the worksheet.
Term
False
 Definition
True or False: A cell name is created from column and row titles through the use of the Title command on the Insert menu.
Term
False
 Definition
True or False: A name can be a minimum of 10 characters to a maximum of 399 characters.
Term
True
 Definition
True or False: After you set the print area and save the workbook, Excel remembers this setting the next time you open the workbook.
Term
All open workbooks
 Definition
When you first install Excel, Excel shows ____ in the taskbar.
Term
global
 Definition
Assigning formats to all of the cells in all of the worksheets in a workbook, is called ____ formatting.
Term
1.0
 Definition
When a cell is formatted to display percentages, a potential problem arises when you start to enter numbers greater than or equal to ____.
Term
The accompanying figure shows a ____.
Answer
 Definition
template
Term
A brace allows you to point out a large item or a group of items that you want to ____________________.
 Definition
annotate
Term
What happens if Excel replaces a text string?
 Definition
All of the above
Term
When Excel is first installed on a computer, it places commonly used shapes in the Recently Used Shapes area in the Shapes gallery.
 Definition
True
Term
The number of digits is one of the arguments in the ROUND function.
 Definition
True
Term
If you create a worksheet for someone who does not have Excel, save the worksheet as a(n) ____ file.
 Definition
PDF
Term
Use the ____________________ function on formulas that potentially can result in more decimal places than the format displays in a given cell.
 Definition
ROUND
Term
A single character, word, or phrase is referred to as a(n) ____.
 Definition
string
Term
A format code is a series of ____ that defines how a cell entry assigned a format will appear.
 Definition
format symbols
Term
In the accompanying figure, column C shows a growth series.
 Definition
False
Term
A range that spans two or more sheets in a workbook is called a ____________________ range.
 Definition
3-D
Term
Excel allows you to print page numbers and the sheet name of each sheet.
 Definition
True
Term
A section in a format code can be ____.
 Definition
zeros
Term
Many business applications require data from several worksheets to be summarized on one worksheet.
 Definition
True
Term
Data placeholders are helpful to users of templates.
 Definition
True
Term
Excel will update links automatically if ____.
 Definition
the linked workbooks are open
Term
A code such as &[Page] instructs Excel to insert the ____________________ number.
Answer
 Definition
page
Term
The headers and footers for chart sheets must be assigned separately from ____________________.
 Definition
worksheets
Term
When the Excel Template file type is chosen in the Save as type box, Excel automatically changes the contents of the Save in box to the Templates folder created when Office 2007 was installed.
 Definition
True
Term
"1,1,1," is an example of a linear series.
 Definition
False
Term
A(n) ____ always appears in the same position in a cell (regardless of the number of significant digits).
 Definition
fixed dollar sign
Term
A style is a group of format specifications that ____.
 Definition
are assigned to a style name
Term
One efficient way to create the workbook is first to create a template, save the template, and then copy the template to a workbook as many times as necessary.
 Definition
True
Term
Match case means that the search ____ and the cell contents must match the word exactly the way it is typed
 Definition
is case sensitive
Term
____________________ are used in a template to guide users of the template regarding what type of data to enter in cells.
 Definition
Placeholders
Term
Saving a template is just like saving a workbook, except that the file type ____ is selected in the Save as type box in the Save As dialog box.
 Definition
Template
Term
An) ____________________ series multiplies values by a constant factor.
 Definition
growth
Term
Serves as a digit placeholder. If the value in a cell has more digits to the right of the decimal point than number signs in the format, Excel rounds the number. Extra digits to the left of the decimal point are displayed.
 Definition
# (number sign)
Term
Functions like a number sign (#), except that if the number is less than 1, Excel displays a 0 in the ones place.
 Definition
0 (zero)
Term
Ensures Excel will display a decimal point in the number.
 Definition
. (period)
Term
Displays numbers as percentages of 100.
 Definition
% (percent)
Term
Displays a comma as a thousands separator.
 Definition
, (comma)
Term
Displays a floating sign ($, +, or –).
 Definition
$ or + or –
Term
Displays a fixed sign ($, +, or –) to the left in the cell followed by spaces until the first significant digit.
 Definition
* (asterisk)
Term
Displays the characters in the cell in the designated color.
 Definition
[color]
Term
Displays parentheses around negative numbers.
 Definition
( )
Term
Skips the width of the character that follows the underscore.
 Definition
_ (underscore)
Term
If two different styles are assigned to a range of cells, Excel ____.
 Definition
adds the second style to the first
Term
For workbooks to be successful and survive their expected life cycle in a business environment, they must be well documented and easy to understand.
 Definition
True
Term
The ____ function is most useful in formulas where year, month, and day are formulas, not constants.
 Definition
DATE
Term
Entering a number once and having it be entered in the same cell on all worksheets is called ____.
 Definition
drilling an entry
Term
The Merge Styles button in the Cell Styles gallery allows styles to be merged from other ____________________.
 Definition
workbooks
Term
A brace is a rectangular area of variable size in which you can add text.
 Definition
False
Term
A workspace file ____.
 Definition
does not contain the actual workbook
Term
A function that sums all the values in all the cells in column A is ____.
 Definition
=sum(a:a)
Term
One way to arrange workbooks in an Excel window is to ____ them.
 Definition
cascade
Term
Before printing a worksheet, you can view the page breaks (boundaries) of what area of each page will print.
 Definition
True
Term
In the accompanying figure, how is each row in the column C series incremented by 2 digits?
 Definition
a start value and increment value were entered in cells C5 and C6
Term
How many worksheets are in a new workbook if you do not set a default?
 Definition
3
Term
The format assigned to the system date in a cell is temporary until it is assigned a permanent format.
 Definition
True
Term
In the accompanying figure, dummy data (sample data) is used in place of actual data to verify the formulas in the template.
 Definition
True
Term
Templates cannot contain macros or formulas.
 Definition
False
Term
When multiple worksheets are selected, the term ____________________ appears at the top of the title bar.
 Definition
[Group]
Group
Term
You can display tomorrow's date in a cell by adding -1 to the NOW function.
 Definition
False
Term
To search only a specified range of a worksheet, select the range before invoking the ____.
 Definition
Find command
Term
Templates help speed and simplify work because Excel users often work with very different problems.
 Definition
False
Term
An alternative to adding worksheets is to change the default number of worksheets before opening a new ____________________.
 Definition
workbook
Term
Excel inserts a dotted line above a row to indicate ____.
 Definition
a horizontal page break
Term
The form for indicating a 3-D reference from your is ____.
 Definition
location, workbook name, sheet name, cell reference
Term
To increase or decrease the white space surrounding the printed worksheet or chart, change the ____________________.
 Definition
margins
Term
A link is a reference to a cell or range of cells ____.
 Definition
in another workbook
Term
The DATE function is most useful in formulas where year, month, and day are formulas, not constants.
 Definition
True
Term
In the accompanying figure, to center the title in range A1:G1, use the Merge & Center button on the Ribbon.
 Definition
True
Term
The WordArt text added to a worksheet is called a(n) ____________________.
 Definition
object
Term
A recommended approach for consolidating data from other workbooks is to ____
 Definition
first bind the workbooks together using a workspace file
Term
Excel’s capability of ____________________ data through worksheets is an efficient way to enter data that is common among worksheets.
 Definition
drilling
Term
You can open all of the associated workbooks by opening the ____.
 Definition
workspace
Term
=sum(1:1) sums all the values in all the cells in ____________________.
 Definition
row 1
Term
n the accompanying figure, you could enter the date in cell G3 by using the NOW function
 Definition
True
Term
A format code can have as many as ____________________ sections.
 Definition
four
Term
The function =NOW()+14 does what?
 Definition
displays a date two weeks in the future
Term
In the accompanying figure, the color for the title and subtitle can be selected on the Fill Color palette
 Definition
True
Term
Match entire cell contents means that ____ and must be unique in the cell.
 Definition
the string cannot be part of another word or phrase
Term
In the accompanying figure, the width of columns C, D, E, F, and G could have been made wider all at once by selecting them as a range and dragging the left boundary of column G to the desired width.
 Definition
False
Term
What is the maximum number of worksheets that a workbook can have?
 Definition
depends on computer's memory
Term
Sample data used in place of actual data to verify the formulas is called ____________________ data.
 Definition
dummy
Term
In the accompanying figure, to put the text on two lines in cell D4 press CTRL+ENTER keys between the words “Total “and “Cost.”
 Definition
False
Term
How can a page break be moved?
 Definition
drag it on the Page Break preview
Term
A workbook that contains patterns for creating other workbooks is called a(n) ____.
 Definition
template
Term
To print nonadjacent worksheets of a workbook, use the ALT key.
 Definition
False
Term
What happens if Excel does not find the information in the search?
 Definition
A dialog box indicates the string cannot be found.
Term
A(n) ____________________ dollar sign always appears immediately to the left of the first significant digit in the cell.
 Definition
floating
Term
The rectangle will connect the text box shape and the brace shape.
 Definition
False
Term
In the accompanying figure, column B shows a linear series.
 Definition
True
Term
In the accompanying figure, the height of row 4 could have been adjusted by dragging the bottom boundary of row heading 4 to the desired height as indicated in the ScreenTip.
 Definition
True
Term
Using a(n) ____________________ allows you to begin your work with a preformatted worksheet.
 Definition
template
Term
The process of summarizing data included on multiple worksheets on one worksheet is called linking.
 Definition
False
Term
The form of the ROUND function is ____.
 Definition
=ROUND (number, number of digits)
Term
The process of summarizing data included on multiple worksheets on one worksheet is called ____.
 Definition
consolidation
Term
In the accompanying figure, the template is using standard accounting format for the numbers, which means____.
 Definition
it contains floating dollar signs in the first and total rows
Term
The sections in a format code are separated by a(n) ____________________.
 Definition
semicolon
Term
A ____________________ reference is a formula that depends on its own value.
 Definition
circular
Term
A header is printed at the top of every page in a printout; a footnote is printed at the bottom of every page in a printout.
 Definition
False
Term
To change from Enter mode or Edit mode to Point mode, start by ____.
 Definition
typing the EQUAL SIGN (=)
Term
Changing the margins is part of page setup, which defines the appearance and format of a printed worksheet.
 Definition
True
Term
The result of an arithmetic operation, such as multiplication or division, is ____ to the factor with the least number of decimal places.
 Definition
accurate
Term
The result of an arithmetic operation, such as multiplication or division, is ____ to the factor with the least number of decimal places.
 Definition
accurate
Term
The Normal format style is ____.
 Definition
initially assigned to all cells in a workbook
Term
In the accompanying figure, the total of column B was entered by ____.
 Definition
selecting cell B12 and then clicking the Sum button twice
Term
In the accompanying figure, the Format Cells dialog box was used for cells D12:G12 to assign a category named ____.
 Definition
Currency
Term
In the accompanying figure, the dummy data is ____.
 Definition
sample data used in place of actual data
Supporting users have an ad free experience!