Computer Concepts 1

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

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

PDF

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


Set pelajaran terkait

Assessment of Digestive and Gastrointestinal Function

View Set

Digestive System: The Accessory Organs

View Set

Theory of Reasoned Action/Theory of Planned Behavior

View Set

Chapter 33: The Microbe-Human Ecosystem

View Set

Controlling Program Flow in JavaScript (Quiz)

View Set