Computer Concepts 1
When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899. SYSDATE NOW DATETIME CURRENT
NOW
The default view in Excel is called ____ view Normal Standard Basic Vaules
Normal
Users can view a(n) ____ document without the software that created the original document. DOCM XPS PDF TFT
The ____ SmartArt graphic type illustrates decision trees. Picture Cycle Hierarchy List
Hierarchy
A(n) ____ contains instructions for filling areas of a template. building block AutoText area template key content control
content control
A ____ is text and graphics that print at the bottom of every page. footer toe margin stopper
footer
A(n) ____________________ is a type of paragraph formatting in which the first line extends to the left of the rest of the paragraph.
hanging indent
A(n) ____________________ is text and/or graphics printed at the top of each page in a document.
header
To prevent sensitive data from being seen in a worksheet, you can hide the worksheet by clicking ____ on the shortcut menu.
hide
To prevent sensitive data from being seen in a worksheet, you can hide the worksheet by clicking ____ on the shortcut menu. Hide Sheet Hide Rows and Columns Hide Workbook Hide
hide
Although you can use a dialog box to indent paragraphs, Word provides a quicker way through the ____. Quick Access Toolbar Office Button menu vertical ruler horizontal ruler
horizontal ruler
You can set up a worksheet to print in black and white with an option on the ____ tab in the Page Setup dialog box. Page Sheet Margins Header/Footer
Sheet
Cell references in a formula are called ____. assumptions comments numbers content
assumptions
A ____ is a formatted object that you can reuse in a document. content control content cluster building block theme font
building block
A(n) ____ resume is recommended by experts for an entry-level job search. indexed remastered chronological functional
chronological
A tag name is an identifier that links a(n) ____ to a source. citation index attribute field
citation
If you do not want the border style to carry forward each time the ENTER key is pressed, you need to ____. clear formatting return to the Standard style press the ESC key restore shading
clear formatting
The MLA documentation style requires that you ____________________ the entire research paper; that is, one blank line should display between each line of text.
double space
Using the mouse to move or copy cells is called ____. drop and drag drag and drop drag and copy drag and paste
drag and drop
A(n) ____ is a placeholder for data whose contents can change. attribute element field value
field
When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns. true false
false
While plagiarism is unethical, it is not considered an academic crime. true false
false
The small caps effect and expanded spacing are applied to characters using the ____ dialog box. Character Style Font Paragraph
font
With the accounting number style, a floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces. true false
false
Word never moves or adjusts automatic page breaks; however, Word adjusts manual page breaks that follow an automatic page break. true false
false
You can select nonadjacent ranges using the SHIFT key. true false
false
You do not have to select the rows in a table in order to move them. true false
false
The FV function returns the future value of an investment based on periodic, constant payments and a constant interest rate. true false
true
The equal sign (=) precedes a formula. true false
true
The range of entries that identifies the major groups for a clustered column chart are called the category names. true false
true
The shortcut keys, CTRL+ENTER, instruct Word to insert a manual page break. true false
true
To demote a current-level list item to a lower-level list item, you can press the TAB key. true false
true
To select a number format, you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear. true false
true
Two of the more powerful aspects of Excel are its wide array of functions and its capability of organizing answers to what-if questions. true false
true
When a cell is formatted for a percent, if you enter the number .5 Excel translates the value as 50%. true false
true
When a section break is created, you specify whether or not the new section should begin on a new page. true false
true
Word provides several built-in preformatted header designs for you to insert in documents. true false
true
You can use the Ignore All button to ignore the current and all future occurrences of a flagged word. true false
true
When working with a large worksheet, you can split the window into ____ panes. three or four four or five two or six two or four
two or four
If you wish to allow another worksheet user to be able to manipulate some cells, leave those cells ____.
unprotected
If you wish to allow another worksheet user to be able to manipulate some cells, leave those cells ____. locked indexed unprotected hybrid
unprotected
Data tables must be built in a(n) ____ area of a worksheet.
unused
Data tables must be built in a(n) ____ area of a worksheet. used unused upper-left lower-right
unused
Rather than manually setting a print area each time you want to print a range, you can ____ the range.
name
Rather than manually setting a print area each time you want to print a range, you can ____ the range. lock manipulate name validate
name
All of the following are examples of building blocks EXCEPT ____. footers page numbers text boxes narratives
narratives
You should create a(n) ____ when you want to keep others from changing the worksheet from protected to unprotected
password
You should create a(n) ____ when you want to keep others from changing the worksheet from protected to unprotected. password authorized user manager account administrative account
password
At a minimum, your resume should present all of the following EXCEPT ____. contact information past salaries earned objective educational background
past salaries earned
After you click the Draw Table command in the Add a Table gallery, the mouse pointer changes to the shape of a(n) ____. pencil eraser crosshair block arrow
pencil
In a SmartArt graphic, ____ text indicates where text can be typed in a shape. key baseline placeholder prefigured
placeholder
To replace ____ text in a content control, you select it and then type. indexed remastered building placeholder
placeholder
The adjusted cell references in a copied and pasted formula are called ____ cell references. related relative pasted alternative
relative
A ________________ is similar to prewritten text of documents. Word prepares the requested document with text and formatting common to all documents.
template
Use the ____ button on the TABLE TOOLS LAYOUT tab to display text vertically in a cell. Flip or Rotate Horizontal or Vertical Text Text Direction Vertical Text
text direction
To hide an entire workbook on an unattended computer, click the Hide button on the ____.
(VIEW tab | Window group)
Which of the following patterns extends the fill series to 525, 475, 425? (to the right) 650, 600 625, 575 560, 580 500, 475
625, 575
Error messages begin with the _____ symbol. ? = ! #
#
_____ refers to cells not wide enough to display the entire entry ##### &&&&& $$$$$ +++++
#####
By default, the Normal style places ____ points of blank space after each paragraph. 8 10 12 14
8
If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message. #NULL! #DIV/0! #N/A #REF!
#REF!
A cell ____ often is created from column or row titles.
(FORMULAS tab | Defined Names group)
Which of the following is the path to the Borders button?
(HOME tab | Font group)
Which of the following is path to the Cell Styles button?
(HOME tab | Styles group)
What is HTML?
(Hypertext Markup Language) is a set of codes that browsers can interpret.
What is a PDF?
(Portable Document Format) is a file created by Adobe Systems that shows all the elements of a printed document as an electronic image
What is XPS?
( XML Paper Specification) is a file format created by Microsoft that shows all elements of a printed document as an electronic image
Which of the following is the path to the Protect Sheet button?
(REVIEW tab | Changes group)
Word versions prior to Word 2007 have a ____ file type. .docx .doct .doc .dot
.doc
Word 2016 documents have a file type of ____. .docx .doct .doc .dot
.docx
File Extensions: Open Document Text PDF Plain Text Rich Text Format Single File Web Page Web Page Word 97-2003 Document Word 97-2003 Template Word Document Word Template XPS
.odt .pdf .txt .rtf .mht .htm .doc .dot .docx .dotx .xps
When you decrease the row height to ____, the row is hidden. 0 1 2 3
0
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____. 40 26 48 13
26
Which of the following formulas contains an absolute cell reference? =$B4 =B$4 =$B$4 =B4
=$B$4
All of the following are valid Excel arithmetic operators EXCEPT ____. ^ * % >
>
What is the difference between a chronological resume and a functional resume?
A chronological resume is a resume that is recommended by experts for an entry-level job search. A functional resume is a resume that groups information by skills and achievements.
The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell. Comma style format Accounting number format Percent style format Currency style format
Accounting number format
One way to add a correctly spelled word to the custom dictionary is to click the ____ button in the Spelling and Grammar dialog box. Add to Dictionary New Entry Add to Custom Custom Entry
Add to Dictionary
Which of the following Option buttons gives options for filling cells following a fill operation? Auto Fill Options AutoCorrect Options Insert Options Paste Options
Auto Fill Options
The _____ feature automatically corrects typing, spelling, capitalization, or grammar errors as you type them. AutoEntry AutoCorrect AutoAdd AutoSpell
AutoCorrect
The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range. DIVSUM RANGEAVG AVERAGE MAX
Average
To select nonadjacent text, select the first item, hold the ____ key, and then select the subsequent items. SHIFT CTRL ALT END
CTRL
To select noncontiguous ranges, after selecting the first range, hold down the ____ key an drag through the additional ranges of cells to select them.
CTRL
To select noncontiguous ranges, after selecting the first range, hold down the ____ key an drag through the additional ranges of cells to select them. ALT F3 CTRL F10
CTRL
The shortcut keys used to center a paragraph are ____. CTRL+T CTRL+M CTRL+SHIFT+T CTRL+E
CTRL+E
The shortcut keys, ______________________, instruct Word to insert a manual page break.
CTRL+ENTER
The shortcut keys used to increase paragraph indent are ____. CTRL+T CTRL+M CTRL+SHIFT+T CTRL+E
CTRL+M
The shortcut keys used to remove hanging indent are ____. CTRL+T CTRL+M CTRL+SHIFT+T CTRL+E
CTRL+SHIFT+T
The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer's memory. Ribbon Clipboard Folder File
Clipboard
The Office ____ is a temporary storage area. Warehouse Clipboard Storehouse Gallery
Clipboard
Each time the _____ key is pressed, the paragraph formatting in the previous paragraph is carried forward to the next paragraph. ENTER SHIFT CTRL ALT
ENTER
In the context of copying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to press the ____ key. ENTER ALT CTRL SHIFT
ENTER
Briefly discuss how Excel modifies cell references when copying and pasting formulas, including an explanation of absolute, relative, and mixed cell references.
Excel modifies cell references when copying formulas. While copying formulas, however, sometimes you do not want Excel to change cell references. To keep a cell reference constant when copying a formula or function, Excel uses a technique called absolute cell referencing. To specify an absolute cell reference in a formula, enter a dollar sign ($) before any column letters or row numbers you want to keep constant in formulas you plan to copy. For example, $B$4 is an absolute cell reference, whereas B4 is a relative cell reference. Both reference the same cell. The difference becomes apparent when they are copied to a destination area.A formula using the absolute cell reference $B$4 instructs Excel to keep the cell reference B4 constant (absolute) in the formula as it copies it to the destination area. A formula using the relative cell reference B4 instructs Excel to adjust the cell reference as it copies it to the destination area. A cell reference with only one dollar sign before either the column or the row is called a mixed cell reference. When planning formulas, be aware of when you need to use absolute, relative, and mixed cell references.
Which of the following Auto Fill Options menu options is the same as the Fill Series option? Fill Months Fill Without Formatting Fill Formatting Only Copy Cells
Fill Months
The ____ function is useful when you want to assign a value to a cell based on a logical test. IF NOW AND OR
IF
Describe five MLA documentation style requirements. Be specific in your explanation.
In MLA documentations style you have to use 12 point font. Your font also has to be in Times New Roman. You will also want to add a header with your last name and the page number. You will want to center your title and your paragraph. You also have to make sure your line spacing is using 2.0 and you have to make sure there is no space after your paragraph.
A resume should be concise, using action words and bulleted lists. What types of information should be included in a resume?
In a resume you should include your contact information, an objective, your work experience, your education, your skills, and your volunteer or leadership experience.
The ____ function displays the highest value in a range. MIN SUM MAX AVERAGE
MAX
Which of the following is an extension of the fill pattern Thursday, Saturday? Wednesday, Thursday, Saturday Thursday, Saturday, Monday Saturday, Sunday, Monday Monday, Wednesday, Friday
Monday, Wednesday, Friday
To insert a document into an open Word document, click the ____. Insert File button on the INSERT tab Object arrow on the INSERT tab Insert File on the FORMAT menu Insert on the FILE menu
Object arrow on the INSERT tab
What are two ways to delete a content control?
One way to delete a content control is right clicking on the selected text to display a shortcut menu and then you will click remove Content Control. Another option is you can select the content control and click the But button on the home tab and in the clipboard group.
The ____ function returns the present value of an annuity.
PV
The ____ function returns the present value of an annuity. FV PMT PV VDB
PV
You can scale a worksheet so that it will fit on one page with an option on the ____ tab in the Page Setup dialog box.
Page
____ is the process of copying an item from the Office Clipboard into the document at the location of the insertion point. Clipping Dragging Pasting Dropping
Paste
The ____________________ displays when you drag-and-drop text and allows you to change the format of the text that was moved.
Paste Options
To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery. Print Active Sheets Print Selection Print Entire Workbook none of the above
Print Selection
Click the Save button on the ____ to overwrite a previously saved file. Save menu SAVE tab File menu Quick Access Toolbar
Quick Access Toolbar
To prevent round-off errors, use the ____ function.
ROUND
You can use the ____ to check which cells are referenced in the formula assigned to the active cell. Formula Finder Range Finder Calculation Finder Function Finder
Range Finder
____ examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words.
The formula checker
Describe the order of operations that Excel uses to calculate formulas within a cell.
The order of operation starts with parenthesis, then it goes to exponents, multiplication, division, addition, and subtraction. These are in this order because when you have a formula that uses these things you have to find the answer using these steps otherwise you will get a totally different equation. Parenthesis is when the formula uses (), exponents is when a number is powered,4^2, multiplication is when you are finding the product, division is when you divide the numbers, with addition you are finding the sum, and with subtraction you are finding the difference.
List and describe at least five of the different types of SmartArt graphic types.
There is Process which is used to show a progression or sequential step in a task, process, or a workflow. There is a list which is used to show non-sequential or grouped blocks of information. It will maximize both horizontal and vertical display space for shapes. There is Matrix which is used to show the relationship of components to a whole in quadrants. There is Pyramid which is used to show proportional, interconnected, or hierarchical relationships with the largest component on the bottom and narrowing up. Finally there is Cycle which is used to represent a continuing sequence of stages, tasks, or events in a circular flow.
What are the shortcut keys used to create a line break?
To create a line break you can use the shift and enter as your shortcut keys.
How do you run the compatibility checker?
To run the compatibility checker you open the backstage view, click the Check for Issues button, Click Check Compatibility on the Check for Issues, and then click the Ok button.
What steps would you take to use a template?
To use a template you will open Word, then you would either type at the top what kind of template you are looking for, or if there is one in your files you would click open other documents and find it in your files. After you get the template you will fill in the blanks or you will replace the written words that are already on there.
The ____ button lists error-checking options following the assignment of an invalid formula to a cell. Find Error Explain Error Fix Error Trace Error
Trace Error
If you click the ____, Excel displays a menu; the first item in the menu identifies the error and the remainder of the menu contains commands from which you can choose cell boundary Error Checking button fill handle Trace Error button
Trace Error button
To create a watermark, you click the ____. Clip Art menu Background command on the FORMAT menu Watermark button on the DESIGN tab Style box
Watermark button on the DESIGN tab
Discuss the reasons and the two-step process for protecting a worksheet.
When building a worksheet for novice users, you should protect the cells in the worksheet that you do not want changed, such as cells that contain text or formulas. Doing so prevents users from making ill-advised changes to text and formulas in cells.When you create a new worksheet, all the cells are assigned a locked status, but the lock is not engaged, which leaves cells unprotected. Unprotected cells are cells whose values you can change at any time. Protected cells are cells that you cannot change.In general, all cells should be protected except those that require an entry by the user of the worksheet. Any cells containing formulas should be protected so that a user of the worksheet cannot modify the formulas. You should protect cells only after the worksheet has been tested fully and the correct results appear. Protecting a worksheet is a two-step process:1. Select the cells you want to leave unprotected and then change their cell protection settings to an unlocked status.2. Protect the entire worksheet.At first glance, these steps may appear to be backwards. Once you protect the entire worksheet, however, you cannot change anything, including the locked status of individual cells.
What key should you press when using the drag and drop editing method to copy?
When you are using the drag and drop editing method you should press the ctrl key and then move your pointer.
How can you add a section of content controls (specifically in a resume template)?
You can add a section of content controls by clicking on the content and in the bottom right corner you hit the plus sign.
What can you do in the Building Blocks Organizer?
You can sort building blocks, change their properties, or insert them in a document.
Where can you edit the AutoFormat as you type options?
You click the file on the ribbon to open the Backstage view, click the Options tab in the Backstage view, click the Proofing in the left pane, click the AutoCorrect Options button, click AutoFormat As You Type tab, select the appropriate checkboxes, and then click the Ok button in each open dialog box.
Explain in detail why you would want to display the formulas version of a worksheet? How do you get the formula version of the worksheet?
You would want to display the formulas version worksheet so you can see how you got to your answer and if the formula is correct. You would also want it because it helps you in the future to possibly correct any errors you made. To get the formula version of your worksheet you have to hit the control and accent button on your keyboard (Ctrl+~).
Names are ____ cell references.
absolute
A(n) ____ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest during each payment period.
amortization schedule
A(n) ____ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest during each payment period. dialog box amortization schedule formula checker data table
amortization schedule
If a(n) ____ prediction is correct, you can instruct Word to finish your typing with its prediction, or you can ignore it. AutoEdit QuickCorrect Quick Fix AutoComplete
autocomplete
In a process called ____, Excel continually reviews the workbook for errors in formulas as you create or manipulate it.
background formula checking
In a process called ____, Excel continually reviews the workbook for errors in formulas as you create or manipulate it. background formula checking workbook formula checking foreground formula checking background function checking
background formula checking
Cell ____ can be used to distinguish the different functional parts of a worksheet.
borders
Cell ____ can be used to distinguish the different functional parts of a worksheet. ranges values indices borders
borders
The Office font set uses the ____ font for body text. Calibri Times New Roman Cambria Arial
calibri
____ ensures that users do not change values inadvertently that are critical to the worksheet.
cell protection
____ ensures that users do not change values inadvertently that are critical to the worksheet. Cell protection Range Finder The formula checker A data table
cell protection
Before saving a document in an earlier Word format, you want to ensure that all of its elements are ____ with earlier versions of Word. indexed compatible concatenated formatted
compatible
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values. logical constant consistent calculated
constant
You use a(n) ____ to automate data analyses.
data table
Press the ____ key to delete a section break to the right of the insertion point. F4 DELETE BACKSPACE ESC
delete
The chapter lists all of the following types of proposal EXCEPT ____. expense planning research sales
expense
A cell reference with only one dollar sign before either the column or the row is called an absolute reference. true false
false
According to MLA style, on each page of the research paper, precede the page number by the title of the paper. true false
false
An alternative to a one-input data table is a three-input data table. true false
false
An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation. true false
false
As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations. true false
false
Best fit means that the width of the column will be increased or decreased by a percentage you specify. true false
false
Each section in a document must have the same margins as the others. true false
false
Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees. true false
false
Excel is case sensitive with respect to names of cells. true false
false
If an active document is saved by clicking the Save button on the Quick Access Toolbar, Word opens the Save As dialog box so a new file name can be assigned to the document. true false
false
If you want to move a table to a new location, you can click in the table to display the table move handle in the lower-right corner of the table and then drag the entire table to a new location. true false
false
SmartArt graphics cannot contain shapes. true false
false
Spreadsheet specialists usually format a worksheet before they enter any data. true false
false
The AutoCorrect feature in Word automatically formats quotation marks, dashes, lists, fractions, ordinals and other items. true false
false
The MLA style uses the term bibliographical references for works cited. true false
false
The PMT function has two arguments: rate and payment. true false
false
The range automatically selected by Excel is always correct. true false
false
To count words, click the Word Count indicator on the HOME tab to display the Word Count dialog box. true false
false
To follow the MLA style, single-space text on all pages and apply one and a half-inch top and bottom margins, and one-inch left and right margins. true false
false
You can add and format a range border by right-clicking the selected range and clicking ____ on the resulting shortcut menu.
format cells
Excel allows you to ____________________ the titles so that the titles remain on the screen no matter how far down or to the right you scroll. freeze stop delete enter
freeze
A ____ is a prewritten formula that is built into Excel. function feature task calculation
function
A(n) ____ resume groups information by skills and accomplishments. functional mastered chronological indexed
functional
Names are ____ to the workbook.
global
____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell. Goal Formula Option Function
goal
Word shades fields ____ on the screen. blue gray green tan
gray
When a formula fails to pass one of the rules and background formula checking is enabled, Excel displays a small ____ in the upper-left corner of the cell assigned the formula. blue square red circle green triangle green diamond
green triangle
A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell contiguous indexed direct indirect
indirect
A ______________ advances the insertion point to the beginning of the next physical line, ignoring any paragraph formatting
line break
____________________ is the amount of vertical space between lines of text in a document. Line spacing Paragraph spacing
line spacing
If you have a header and footer that you want to appear in all sections of a document, you would leave the ____ button selected on the Header & Footer Design tab. Link to Previous Copy of Previous Repeat Header Duplicate Header
link to previous
Use the ____ button on the TABLE TOOLS LAYOUT tab to create a single cell that spans across several rows in a table. Span Cell Merge Cells Blend Cells Single Cell
merge cells
A cell ____ often is created from column or row titles. function name formula data table
name
A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function. included other nested duplicate
nested
Click ____ in the Borders gallery to remove all borders. Remove Border No Border Clear Borders Delete Borders
no border
Each time you click the Increase Indent button, the paragraph is indented ____ inch. one one-half one-quarter one-eighth
one-half
With a(n) ____ data table you can vary the value in one cell.
one-input
With a(n) ____ data table you can vary the value in one cell. one-input two-input three-input unlimited-input
one-input
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra. placement operations positioning selections
operations
You can delete a data table by selecting the data table and then ____.
pressing the DELETE key
When building a worksheet for novice users, you should ____ the cells in the worksheet that you do not want changed, such as cells that contain text or formulas.
protect
When building a worksheet for novice users, you should ____ the cells in the worksheet that you do not want changed, such as cells that contain text or formulas. hide protect code delete
protect
To display formatting applied to text, use the ____ task pane. All Formats Display Formats Reveal Formatting Show Formats
reveal formatting
A(n) ____ proposal is a proposal that sells an idea, a product, or a service. academic research product-based sales
sales
All documents have at least one ____. page number section paragraph all of the above
section
To change page formatting for a portion of a document, a new ____ must be created in the document. line paragraph page section
section
Which of the following is not a valid format symbol? semi-colon (;) percent sign (%) dollar sign ($) comma (,)
semi-colon (;)
A font ____ defines one font for headings in a document and another font for body text. chapter aggregate cluster set
set
You can set up a worksheet to print in black and white with an option on the ____ tab in the Page Setup dialog box.
sheet
By default, a footnote text is _____. double-spaced, right-aligned, and a smaller font size than the text in the research paper double-spaced, left-aligned, and the same font size as the text in the research paper double-spaced, left-aligned, and a smaller font size than the text in the research paper single-spaced, left-aligned, and a smaller font size than the text in the research paper
single-spaced, left-aligned, and a smaller font size than the text in the research paper
A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell. section sparkline special sparkle
sparkline
Word provides several built-in ____ to help you quickly change the look of the entire document. style sets templates indexes masters
style sets
A thesaurus can be used to look up a(n) _____, or a word similar in meaning to a given word. synonym homonym antonym metronym
synonym
____ examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words. The Range Finder The formula checker A data table An amortization schedule
the formula checker
A cell name often is created from column and row titles. true false
true
A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area. true false
true
A sensitivity analysis is another name for a what-if analysis. true false
true
According to the MLA style, the first line of each entry on the works cited page begins at the left margin. true false
true
Although a variety of different styles of documentation exist for report preparation, each style requires the same basic information. true false
true
An amortization schedule summarizes loan information over the life of the loan. true false
true
As soon as you begin typing in a selected content control, your typing replaces the instructions in the control. true false
true
Excel has more than 400 functions that perform just about every type of calculation you can imagine. true false
true
If you add text, delete text, or modify text on a page, Word recalculates the location of automatic page breaks and adjusts them accordingly. true false
true
If you add text, delete text, or modify text on a page, Word recalculates the location of automatic page breaks and adjusts them accordingly. true false
true
In a multilevel list, the first level is displayed at the left edge of the list and subsequent levels are indented. true false
true
In addition to a predefined list of AutoCorrect spelling, capitalization, and grammar errors, you can create your own AutoCorrect entries to add to the list. true false
true
In the MLA style, footnotes and/or endnotes are used only for optional content or bibliographic notes. true false
true
According to the MLA style, the _____ is a list of sources that are referenced directly in a research paper. parenthetical citations page works cited page explanatory notes page superscript reference page
works cited page
____ is a file format created by Microsoft that shows all elements of a printed document as an electronic image. PDF XPS TIFF XLS
xps