Excel Final1

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

You use the ____ sheet in the Format Cells dialog box to position data in a cell by centering it, for example.

Alignment

F2

Alternate to double-clicking the cell to edit it.

Which of the following is the maximum number of active data tables per worksheet?

As many as you want

Which of the following is the maximum number off active data tables per worksheet?

As many as you want

The ______ button allows you to choose whether you want to copy the values from the source area to the destination area with or without formatting

Auto Fill Options

Which of the following Option buttons fives options for filling cells following a fill operation? Autofill options Auto Correct options Insert Options Paste Options

Auto Fill Options

Which of the following Option buttons gives options for filling cells following a fill operation?

Auto Fill Options

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.

Auto calculate

The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.

Auto correct

The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.

Auto fill options

The ___ feature works behind the scenes, fixing spelling and grammar

AutoCorrect

_______ corrects two initial capital letters by changin the second letter to lowercase

AutoCorrect

You can click the ____ button to undo an automatic correction.

AutoCorrect Options

When you first create a table, Excel automatically enables ____.

AutoFilter

The date you change a file is an example of a(n) ____ property.

Automatically Updated

Function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

Average

Error messages begin with the ____ symbol

#

Error messages begin with the ____ symbol.

#

____ refers to cells not wide enough to display the entire entry

#####

____ refers to cells not wide enough to display the entire entry.

#####

Indicates a cell is using a name Excel does not recognize

#NAME?

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

#REF!

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.

#REF!

What is the path to the What-If Analysis button?

(DATA tab | Data Tools group)

Which of the following is the path to the Goal Seek button?

(DATA tab | Data Tools group)

Which of the following is the path to the Name Manager button?

(FORMULAS tab | Defined Names group)

Which of the following is the path to the 'Lookup & Reference' button?

(FORMULAS tab | Function Library group)

Which of the following is the path to the Financial button and the PMT function?

(FORMULAS tab | Function Library group)

Which of the following is the path to the Increase or Decrease Indent button?

(HOME tab | Alignment group)

Which of the following is the path to the Insert Cells arrow?

(HOME tab | Cells group)

The path to the Format Painter button is ____.

(HOME tab | Clipboard group)

Which of the following is the path to the Copy and Paste buttons?

(HOME tab | Clipboard group)

Which of the following is the path to the 'Sort & Filter' button?

(HOME tab | Editing group)

Which of the following is the path to the Fill button?

(HOME tab | Editing group)

Which of the following is the path to the Sum arrow?

(HOME tab | Editing group)

Which of the following is the path to the Borders button?

(HOME tab | Font group)

Which of the following is the path to the Comma Style button?

(HOME tab | Number group)

Which of the following is the path to the Cell Styles button?

(HOME tab | Styles group)

Which of the following is the path to the Conditional Formatting button?

(HOME tab | Styles group)

Which of the following is the path to the Format as Table button?

(HOME tab | Styles group)

Which of the following is the Ribbon path to the Cell Styles button?

(HOME tab/ Styles Group)

Which of the following is the path to the Protect Sheet button?

(REVIEW tab | Changes group)

Which of the following is the path to the Spelling button?

(REVIEW tab | Proofing group)

Which of the following is the path to the Total Row check box?

(TABLE TOOLS DESIGN tab | Table Style Options group)

To hide an entire workbook on an unattended computer, click the Hide button on the ____.

(VIEW tab | Window group)

Which of the following is the path to the Zoom button?

(VIEW tab | Zoom group)

Which of the following is the path to the Copy and Paste buttons? (home tab/ Copy group) (home tab/ paste group) (home tab/ Clipboard group) (home tab/Formulas group)

(home tab/ Clipboard group)

When you decrease the row height to ____, the row is hidden.

0

When you decrease the row height to ______ the row is hidden. 0 1 2 3

0

When you first enter text, its angle is ____ degrees, and it reads from left to right in a cell

0

When you first enter text, its angle is ____ degrees, and it reads from left to right in a cell.

0

While creating an Excel worksheet, several decisions will determine the appearance and characteristics of the finished worksheet. List some guidelines

1. Select titles and subtitles for the worksheet 2. Determine the contents for rows and columns. 3. Determine the calculations that are needed. 4. Determine where to save the worksheet 5. Identify how to format various elements of the worksheet. 6.Decide on the type of chart needed. 7.Establish where to position and how to format the chart. 8. Choose a name for the worksheet. 9.Determine the best method for distributing the workbook.

how many charts does Microsoft offer

10

Excel remembers the last ____ actions you have colmpeted

100

Excel remembers the last ___

100 actions

Excel offers ____ chart types

11

Excel includes ____ database functions that allow you to evaluate numeric data in a table.

12

Use no more than ____ font types

2

When you enter a two digit year that is less than 30, Excel changes the year to______ A. 20xx B. 30xx C. 18xx D. 19xx

20xx

When you enter a two-digit year that is less than 30, Excel changes the year to ____.

20xx

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

26

When Excel follows the order of operations, the formula, 8*3+2, equals _____?

26

When excel follows the order of operations the formul, 8*3+2 equals_______ 40 26 48 13

26

The values ____ satisfy a custom filter criteria that displays records in which the Experience field contains a value greater than or equal to 3 and less than or equal to 5.

3, 4, 5

Which of the following patterns extends the fill series to 575, 550, 525

625, 600

Which of the following patterns extends the fill series to 575, 550, 525?

625, 600

To enter a number such as 6,000,000,000,000,000 you can type it out or enter_____

6E15

If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.

8.43

If you do not assign a format to a cell or cells in a column, the column width will remain _____ characters.

8.43

If you do not assign a format to a cell or cells in a column, the column width will remain ______ characters. 8.43 7.52 11.65 9.43

8.43

Which comparison operator means "not equal to"

<>

Which comparison operator means "not equal to"?

<>

Which of the following formulas contains an absolute cell reference?

=$B$4

Which of the following formulas contains and absolute cell reference

=$B$4

Which of the following calculations multiplies 23 by 0.01?

=23%

Which of the following calculations multiplies 23 by 0.01? =23% =23 =23+.01 =24-.01

=23%

The general form of the VLOOKUP function is ____.

=VLOOKUP(lookup_value, lookup_table, col_index_num)

All of the following are valid Excel arithmetic operators EXCEPT ____.

>

All of the following are valid Excel arithmetic operators except______ A. ^ B. * C. % D. >

>

To start a new line in a cell, press the ____ keys A. CTRL+ENTER B. TAB+ENTER C. ALT+ENTER D. SHIFT + ENTER

ALT+ENTER

To start a new line in a cell, press the ____ keys.

ALT+ENTER

Selects the cell one worksheet window to the right

ALT+PAGE DOWN

Selects the adjacent cell in the direction of the arrow on the key

ARROW

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.

AVERAGE

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. MIN SUM AVERAGE MAX

AVERAGE

Displays cell contents with two decimal places that align vertically

Accounting Number format

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.

Accounting number Format

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.

Accounting number format

Like the AutoFilter query technique, the ____ command displays a subset of the table.

Advanced Filter

The Conditional Formatting ____ dialog box displays all of the rules for the current selection or for the entire workbook.

Rules Manager

You can deselect multiple selected sheets beginning with the Sheet1 tab by pressing the ____ key and clicking the Sheet1 tab.

SHIFT

Highlights one or more adjacent characters to the right

SHIFT + RIGHT ARROW

Not used to clear a cell

SPACEBAR

The most common subtotal uses the ____ function.

SUM

Excel's ______, which adds all of the numbers in a range of cells, provides a way to calculate a total

SUM function

The ____ function is useful when you want to add values in a range only if they meet criteria.

SUMIF

CTRL+HOME

Selects A1

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

Fill handle

Small black square located in lower right corner of active cell

A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell

Sparkline

___ properties are associated with all Microsoft office doc and include author title and subject

Standard

_____ are/is used to add worksheet, column, and row titles on worksheet

Text

____ 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

Receiving range

The range of cells receiving the copy

A company or department may standardize with a specific ______ so that all of their documents have a similar appearance.

Theme

Which of the following is an extension of the fill pattern Sunday, Tuesday?

Thursday, Saturday, Monday

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

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.

Trace Error button

(True or False) Cooler colors tend to pull away from the reader.

True

(True or False) Point mode allows you to select cells for use in a formula by using your finger or the pointer.

True

(True or False) To Sum button menu allows you to enter one of five often-used functions easily into a cell.

True

(True or False) Excel has more than 400 functions that preform just about every type of calculation you can imagine.

True

(True or False) Moving from left to right, the first calculation in the order of operations is negation (-).

True

(True or False) The AVERAGE function requires that the argument be included within parenthesis following the function name.

True

A cell name often is created from column and row titles.

True

A column border is an unused column with a significantly reduced width.

True

A date stamp show the date a workbook, report, or other document was created or the period it represents

True

A nested IF function is one in which the action to be taken for the true or false case includes yet another If function

True

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area

True

An amortization schedule summarizes loan information over the life of the loan.

True

Assigning names to a cell or range of cells allows you to select them quickly.

True

Changing the order of sheets in a workbook allows you to position the most important worksheets first

True

Excel automatically selects the Left column check box in the Create Names from Selection dialog box in order to determine which option to select automatically.

True

If worksheet, column, and row titles are frozen above and to the left of cell B13, B13 can be selected by pressing CTRL+HOME

True

If you enter a formula using Point mode and tap and click a cell that has an assigned name, then Excel will insert the name of the cell rather than the cell reference.

True

Im the accompanying figure, the formula in cell B14 (=B13+(1-$B$4)) contains an absolute reference

True

In the accompanying figure, worksheet titles are frozen above and to the left of cell B13

True

Many Ribbon commands, galleries, and shortcut keys function as toggles or switches

True

Once you set a print area, Excel will continue to print the specified range, rather than the entire worksheet.

True

Rotated text also allows you to fit more text into a smaller column width

True

Studies have shown that more than 25 percent of all business worksheets have errors

True

The <= comparison operator means less than or equal to

True

The FV function returns the future value of an investment based on periodic, constant payments and a constant interest rate.

True

The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it

True

The best alternative to define the formulas in a data table involves using the cell references preceded by an equal sign.

True

The equal sign (=) precedes a formula.

True

The most common error when entering a formula is to reference the wrong cell in the formula.

True

The path to the Logical button is (Formulas tab / Function Library group)

True

To include additional formulas in a one-input data table, enter them in adjacent cells in the same row as the current formulas and then define the entire new range as a data table.

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

When Range Finder is active, you can drag the outlines from one cell to another cell to change the cells referenced in the formula, provided the cells have not been named.

True

When a cell is formatted for a percent, if you enter the number .5 Excel translates the value as 50%.

True

When you change a value on which a chart is dependent, Excel immediately redraws the chart based on the new value

True

When you format a cell to display percentages, Excel assumes that whatever you enter into that cell in the future will be a percentage.

True

When you rest the mouse pointer over a chart item, such as the legend, Excel displays a chart tip containing the name of the item

True

With a three-dimensional chart, you can change the view to better show the section of the chart you are trying to emphasize

True

You can double-tap or double-click a cell with a formula and Excel will use Formula Seek to highlight the cells that provide data for the formula.

True

You can nest IF functions as deep as you want, but after you get beyond a nest of three IF functions, the logic becomes difficult to follow

True

The ____ function is used when a table direction is vertical.

VLOOKUP

Which of the following is the path to the Zoom button

View tab / Zoom group

To hide an entire workbook on an unattended computer, click the Hide button on the ___.

View tab | Window group

Of warmer and cooler colors, the kind of colors that tend to reach toward the reader are ____ colors.

Warmer

you can use a _____ to view an XPS file

XPS Viewer

After shrinking entries to fit in cells, consider using the ____ slider on the status bar to make the entries more readable.

Zoom

Range

a series of two or more adjacent cells in a column or row.

Names are ___ cell references.

absolute

Names are ____ cell references.

absolute

Keeps a cell reference constant when copying a formula or function

absolute cell referencing

The ________ displays numbers with a fixed dollar sing to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent. comma style accounting number percent style currnecy style

accounting

An excell entry can contain___

all characters

in excel a number can contain the characters

all the above

Replace options

allows you to choose whether you want to copy the values from the source area to destination area with formatting

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

An ___ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest over a period.

amortization schedule

A(n) ____________________ is a series of fixed payments made at the end of each of a fixed number of periods at a fixed interest rate.

annuity

To enter number as text precede it with _____

apostrophe

For the VLOOKUP function to work correctly, the table ____ must be in sequence from lowest to highest.

arguments

The left column values in a table array are called table ____.

arguments

Use the _____ to complete a entry and move to the next cell

arrow

Data is in ____ sequence if it is in order from lowest to highest.

ascending

Cell references in a formula are called ____

assumptions

Cell references in a formula are called ____.

assumptions

You can click the ______ button to undo an automatic correction. auto Fill options autocorrect options Paste options Trace err0r

autocorrect options

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

A ____ cell in Excel has numerical value of zero. blank formatted copied filled

blank

The most popular background color is_____ blue white red yellow

blue

Cell ___ help to set off sections of a worksheet.

borders

Cell ____ can be used to distinguish the different functional parts of a worksheet.

borders

The arguments in ____ in the ScreenTip for a function are optional.

brackets

All of the following are valid Excel arithmetic operators except... a. * b. ! c. > d. %

c. >

In a table, a column that contains formulas or functions is called a(n) ____.

calculated column

To enter data in cell, you must first select or activate the ____

cell

___ ensures that users do not change the values inadvertently that are critical to the worksheet.

cell protection

Excel lets you format ____________________ before you enter data, when you enter data, incrementally after entering sections of data, and after you enter all the data.

cells

A ____ conveys a visual representation of data

chart

A(n) ____ is a separate sheet in a workbook that contains only a chart

chart sheet

Charts can either be embedded in a worksheet or placed in a separate ____.

chart sheet

AutoCalculate area

displays common calculations

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.

green triangle

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.

green triangle

A ____ is text and graphics that print at the top of each page.

header

To prevent sensitive data from being seen in a worksheet, you can hide the worksheet by clicking ___ on the shortcut menu.

hide

Which of the following is the path to the Comma style button? Hometab/ Alignment tab Hometab/ Fontgroup Hometab/ Cells group Hometab/ number group

hometab/ number group

Which of the following is the path to the Conditional Formatting button? Hometab/Editinggroup Stylestab/Formattinggroup Formatting group/ Styles group Hometab/ styles group

hometab/ styles group

Which of the following is the path to the Sum button? editing tab/home group home tab/Editing group Hometab/ Clipboard group Calculation tab/ editing group

hometab/editing group

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.

indirect

The ____ option button lists formatting options following an insertion of cells, row, or columns autocorrect insert auto fill paste

insert

clicking the _____ opends the Insert Function dialog box shown int eh accompanying figure. Insert function box on the formula bar function dialog box launcher Function button Functions and formulas button on the status bar

insert function box on the formula bar

The ____ is a blinking vertical line that indicates where the next typed character will appear.

insertion point

The _____ is a blinking line

insertion point

In the accompanying figure, the split double arrow mouse pointer ____

is the result of moving the mouse pointer to the boundary between column heading A and column heading B

The ____ identifies the colors assigned to each bar in the chart on a worksheet

legend

A ____ chart often is used to illustrate changes in data over time

line

In the Sort dialog box, shown in the accompanying figure, the ____ is the Sort by field.

major sort key

combining two or more selected cells into one cell called ____ cells

merging

The easiest way to select a cell is to select it with a

mouse pointer

A cell ___ often is created from column or row titles.

name

A cell ____ often is created from column or row titles.

name

Rather than manually setting a print area each time you want to print a range, you can ____ the range.

name

Rather than setting a print are each time you want to print a range, you can ___ the range.

name

You can select a cell or range by typing it's ___ in the Name Box and pressing the Enter key.

name

You can select any cell by entering its cell reference in the

name box

To print individual sections of a worksheet, ___ these sections then print them by ___.

name, 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

nested

A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

nested

With a ___ 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

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.

operations

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of _______ that you use in algebra. placement positioning operations selections

operations

You can select a worksheet so that it will fit on one page with an option on the ___ tab in the Page Setup dialog box.

page

_____ allows you to create or modigy a worksheet while viewing how it will look in printed format. normal page layout page break preview full screen

page layout

You should create a ___ 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

Shows the relationship or proportion of parts to a whole

pie chart

Careful _____ can reduce your efforts in making a worksheet

planning

You can delete a data table by selecting the data table and then ____.

pressing the DELETE key

You can delete a data table by selecting the data table and then ___.

pressing the Delete key

To pring a range of cells in teh actinve worksheet, click _______ in the Settings area in the Print gallery, as shown in the accompanying figure. print active sheets print selection print entire workbook none of the above

print selection

When building a worksheet for novice users, you should ___ the cells in that 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.

protect

Cell ____________________ ensures that users do not change values inadvertently that are critical to the worksheet.

protection

The process of filtering activity based on one or more filter criteria is called a ____.

query

____ ensures that users do not change values inadvertently that are critical to the worksheet.

Cell protection

____ formatting allows you to create rules that change the formatting of a cell or range of cells based on the value of a particular cell.

Conditional

To change an active table back to a normal range of cells, right-click the table, point to Table on the shortcut menu, and then tap or click ____ on the Table submenu.

Convert to Range

What is the path to the What-If Analysis button?

Data Table | Data Tools group

Which of the following is the path to the Goal Seek button

Data tab / Data Tools group

____________________ like the kind shown in the accompanying figure have one purpose: to organize the answers to what-if questions.

Data tables

The Chart tools contextual tabs include the___ tabs

Design Format Layout

The range of cells receiving the content of copied cells is called the

Destination area

To open the Format Cells dialog box with the Alignment sheet active, click the Format Cells ____

Dialog Box Launcher

To open the Format Cells dialog box with the Alignment sheet active, tap or click the Alignment Settings ____.

Dialog Box Launcher

What effect does theAccounting Number Format have on the selected cells?

Displays cell contents with two decimal places that align vertically

What effect does the Comma Style format have on the selected cells?

Displays cell contents with two decimal places and commas as thousands separators

The / arithmetic operator indicates ______.

Division

____ the Format Painter button and the drag through the non adjacent ranges to paint the formats to the ranges

Double-click

____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.

Double-click or double-tap

A check mark in the ____ check box speeds up printing by ignoring formatting and not printing most graphics.

Draft quality

Moves insertion point to end of data in cell

END

Moves the insertion point to the end of data in a cell

END

An alternative to clicking the Paste button is to press the ____ key

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

Clicking the ____ completes an entry

ENTER key

Pressing the ____ key(s) removes the marquee from the source area

ESC

To cancel an entry before entering in the cell , press _____

ESC

To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.

ESC

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.

Equal Sign (=)

Which of the following happens when you enter the formula =G15 into a cell?

Excel assigns the value in cell G15 to the active cell

If you click a 3-D Pie chart so that all the slices are selected, you can drag one of the slices to explode it, leaving the remaining slices unexploded

False

If you drag the fill handle to the left or up, Excel will increment the series rather than decrement the series

False

Spreadsheet specialists usually format a worksheet before they enter any data.

False

The NETWORKDAYS function check a formula for correctness

False

The PMT function has two arguments: rate and payment.

False

The print options available on the Margins tab in the Page Setup dialog box pertain to the way the worksheet will appear in the printed copy or when previewed.

False

The range of entries that determines the size of the slices in a Pie chart is called category names

False

The syntax of the IF function if IF(logical_test), value_if_false, value_if_true)

False

When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns

False

You can add only a maximum of five conditional formats to a range.

False

You can select nonadjacent ranges using the SHIFT key

False

You can use the ROUND function to determine how much the borrower of a loan still owes at the end of each year.

False

You cannot use column and row titles within formulas when you want to refer to the related data by name.

False

You should create worksheets as if you are going to use them only once.

False

Fills a destinations area using the format source area; no content copied

Fill Formatting Only

The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.

Fill Formatting Only

The ____ Auto Fill Options that fills the destination area using the format of the source area; no content is filled

Fill Formatting Only

Which of the following Auto Fill Options menu options is the same as the Fill Series option?

Fill Months

Copies the format and contents

Fill Series

The small black square located in the lower-right corner of the heavy border around the active cell.

Fill handle

____ indicates how text characters are emphasized

Font style

Is text and graphics that print at the bottom of every page.

Footer

You can add and format a range border by right-clicking the selected range and clicking ____ on the resulting shortcut menu.

Format Cells

One of reasons Excel is such a valuable tool is that you can assign a ______ to a cell, and Excel will calculate the result.

Formula

The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.

Formula

You can choose which rules you want Excel to use by enabling and disabling them in the ____ area in the Excel Options dialog box.

Formulas

Which of the following is the path to the Name Manager button?

Formulas tab | Defined Names group

Which of the following is the path to the Financial button and the PMT function?

Formulas tab | Function Library group

A prewritten formula that is built into Excel.

Function

____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.

Goal

____ seeking assumes you can change the value of only one sell referenced directly or indirectly to reach a specific goal for another cell

Goal

The ____ function is used when the table direction is horizontal.

HLOOKUP

Moves insertion point to beginning of data in cell

HOME

Selects the cell at the beginning of the row that contains the active cell.

HOME

Which of the following is the path to the Comma Style button?

HOME tab/ Number Group

Which of the following is the path to the Conditional Formatting button?

HOME tab/ Styles Group

Is text and graphics that print at the top of each page.

Header

To prevent sensitive data from being seen in a worksheet, you can hide the worksheet by clicking ____ on the shortcut menu.

Hide

____________________ portions of a workbook lets you show only the parts of the workbook that the user needs to see.

Hiding

Which of the following keys moves the insertion point to the beginning of data in a cell?

Home

Which of the following is the Ribbon path to the Cell Styles button?

Home Tab: styles group

Which of the following is the path to the Increase or Decrease Indent button

Home tab / Alignment group

Which of the following is the path to the Insert button

Home tab / Cells group

The path to the Format Painter button is ____

Home tab / Clipboard group

Which of the following is the path to the Fill button?

Home tab | Editing group

Which of the following is the path to the Cells Styles button?

Home tab | Styles group

Which of the following is the path to the borders button?

Home tab | font group

The ____ function is useful when you want to assign a value to a cell based on a logical test

IF

The ____ function is useful when you want to assign a value to a cell based on a logical test.

IF

Assigns a value to a cell based on a logical test

IF function

The ____ function returns the value or reference of the cell at the intersection of a particular row and column in a table or range.

INDEX

Toggles between INsert and Overtype mode

INSERT

Which of the following keys toggles between Insert mode and overtype mode?

INSERT

When assigned to a cell, the ____ function returns a number that corresponds to the system data and time beginning with December 31, 1899

NOW

When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.

NOW

Returns a number that corresponds to the system date and time beginning with December 31, 1899

NOW function

The default view in Excel is called ...

Normal

The default view in Excel is called ____ view.

Normal

Which of the cell contents is extended to Qtr3, Qtr4, Qtr1 by dragging the fill handle?

Qtr2

Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?

Qtr2

Pressing the ____ key completes an entry, and goes to next cell

RIGHT ARROW

To prevent round-off errors, use the ____ function.

ROUND

A ____ is a series of two or more adjacent cells in a column or row or a rectangular

Range

To check which cells are referenced in the formula assigned to the active cell.

Range Finder

You can use the ____ to check which cells are referenced in the formula assigned to the active cell.

Range Finder

You can ensure correctness in your formulas by carefully checking them using ____

Range finder

The ____ is the small black square located in the lowerright corner of the heavy border around the active cell.

fill handle

In the accompanying figure, the ranges E4:I4 and F13:I13 are formatted with a _____ dollar sign. fixed formatted floating none of the above

fixed

An increase_____gives more impact to the text in a cell

font size

A ____ is text and graphics that print at the bottom of every page.

footer

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

format

You can add and format a range border by right-clicking the selected range and clicking ___ on the shortcut menu.

format cells

The _______ Autocomplete list contains those functions that alphabetically match the letter you type following the equal sign. function formula equal calculate

formula

As you type, Excel displays the entry in the _____ and also displays the Cancel box and the Enter box on the formula bar

formula bar

Similar to the spell checker, Excel has a ___ that check formulas in a worksheet for rule violations.

formula checker

You can choose which rules you want Excel to use by enabling and disabling them in the ___area in the Excel Options dialog box, as shown in the accompanying figure.

formulas

you can use the ____ to check which cells are referenced int he formula assigned to the active cell. formula finder range finder calculation finder function finder

Range finder

A ____ is a prewritten formula that is built into Excel.

function

A ____ reference is an adjusted cell reference in a copied and pasted formula.

Relative

The adjusted cell references in a copied and pasted formula are called ____ cell references.

Relative

The person or persons requesting the worksheet should supply their requirements in a ____ document.

Requirments

____ text often provides a strong visual appeal

Rotated

____ text often provides a strong visual appeal.

Rotated

Which of the following is NOT a type of conditional formatting?

Row Banding

A ________ is a prewritten formula that is built into Excel. A. function B.feature C. task D. calculation

function

Names are ___ to the workbook.

global

Names are ____ to the workbook.

global

Determines the value of a cell on which the formula depends

goal seeking

Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell

goal seeking

A ____ total sums all of the data in a row or column.

grand

____ causes adjacent rows to have different formatting so that each row in the table is distinguished from surrounding rows.

Row banding

With a database function, if one of your arguments is a field name and the field name is text, rather than a cell reference, number, or range, the argument must be enclosed in ____.

quotation marks

In the accompanying figure, the Print area box accepts a name or a ___ to print.

range

In the accompanying figure, the Print area box accepts a name or a ____ to print.

range

In a table, or database, the data related to each person or item is called a ____.

record

A ____ reference is an adjusted cell reference in a copied and pasted formula

relative

The adjusted cell references in a copid and pasted formula are called _____ references. related relative pasted alternative

relative

The adjusted cell references in a copied and pasted formula are called ____ cell references.

relative

The automatically adjusted cell reference in a pasted formula is called _______

relative reference

You should supply requirements for worksheets in a _____ document

requirements

Which of the following is the path to the Spelling button? Hometab/ Progging group Proofing tab/ spelling group Review tab/ Proofing group Reiveiw tab/ checking group

review tab/ proofing group

Pressing the ____ key to complete an entry activates the adjacent cell to the right.

right arrow

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

right parenthesis

Excel automatically appends the _______ to complete the AVERAGE function when you click the Enter box or press the ENTER key. left parentesis right bracket right parenthesis left bracket

right parenthesis

To prevent round-off errors, use the ___ functinon.

round

Point mode allows you to ____, as shown in the accompanying figure.

select cells for use in a formula using the mouse pointer

Point mode allows you to _____ select cells for use in a formula using the keyboard select a function from the Sum button list select cells for use in a formula using the mouse pointeredit cell contents directly in the cell

select cells for use in a formula using the mouse pointer

The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it

three

Format a worksheet

to emphasize certain entries and make it easier to read

You can insert a ____ at the bottom of a table.

total row

The ______ options button lists error checkingoptions 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 int he menu identifies the error and the remainder of the menu contains commands you can click.

trace error button

The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.

two

When working with a large worksheet, you can split the window into ____ panes

two or four

When working with a large worksheet, you can split the window into ____ panes.

two or four

The first step in creating an effective worksheet is to make sure you ____.

understand what is required

To ensure you create an effective worksheet you should _____

understand what is required

The ____ button allows you to erase recent cell entries.

undo

If you wish to allow another worksheet user to be able to manipulate some cells, leave those cells ____.

unprotected

When considering which cells another worksheet user should be able to manipulate, leave the cells ___.

unprotected

Data tables must be built in a(n) ____ area of a worksheet.

unused

Data tables must be built in an ___ area of a worksheet.

unused

With a solid understanding of the requirements document, an understanding of necessary decisions, and a sketch of the worksheet, the next step is to ____

use Excel to create the worksheet

Similar to the spell checker, Excel has a formula checker that checks formulas in a worksheet for rule ____.

violations

Allows data to be easily summarized and charted

worksheet

An Excel ____ allows data to be summarized and charted easily.

worksheet

To enter data in a cell, you must first select the ____.

Cell

Deletes characters to the left of the insertion point

BACKSPACE

While typing in a cell, you can press the _____ key to delete all the characters back to and including the incorrect character you just typed

BACKSPACE

Why is the VLOOKUP function used more often than other lookup functions?

Because most tables are vertical

Means that the width of a column will be increased or decreased so the widest entry will fit in the column.

Best Fit

Colors jump out a dark background and are easiest to see.

Bright

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

You can open the Format Cells dialog box by pressing the ____ keys.

CTRL+1

You can open the Format Cells dialog box by pressing the ______ keys. SHIFT+TAB CTRL+1 ALT+1 SHIFT+F1

CTRL+1

You can press the ____ keys to open the Format Cells dialog box

CTRL+1

You can press the ____ keys to open the Format Cells dialog box.

CTRL+1

press ___ to select the entire work sheet

CTRL+A

Apply Bold font style

CTRL+B

you can apply the bold font by pressing _______

CTRL+B

To copy cell contents you can select teh cell and then press the _____ keys. CTRL+V CTRL+X CTRL+B CTRL+C

CTRL+C

To copy cell contents, you can select the cell and then press the ____ keys.

CTRL+C

Displays the Find dialog box

CTRL+F

Pressing the ____ keyboard shortcut key(s) selects cell A1.

CTRL+HOME

selects cell A1

CTRL+HOME

To paste copied cell contents you can press the _____ keys. CTRL+C CTRL+P CTRL+V CTRL+X

CTRL+V

To paste copied cell contents, you can press the ____ keys.

CTRL+V

A formula in a cell that contains a reference back to itself.

Circular reference

The Copy button copies the contents and format of the source area to the Office ____, a reserved place in the computer's memory

Clipboard

The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer's memory.

Clipboard

You should use a ____ chart to compare values side by side, broken down by category.

Clustered Column

You can enter the correct range in a function by typing the beginning and ending cell references separated by _____

Colon

you can enter the correct range in a function by typing the beginning and ending cell references separated by a

Colon (:)

Merging

Combining two or more selected cells

Displays cell contents with two decimal places and commas as thousands seperators

Comma style

Which of the following happens when you enter the formula =G15 into a cell? Excel recalculates all formuals in the worksheet Excel assigns the sum of the values in the previous 15 cells to the active cell Excel assigns the value in cell G15 to the active cell Nothing, =G15 is an invalid formula

Excel assigns the value in cell G15 to the active cell

MC: A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.

Exploded

____ records allows you to pull data from a table so that you can analyze or manipulate the data further.

Extracting

You can select a range using the keyboard by pressing the ____ key and the and ARROW key F2 f4 F6 F8

F8

(True or False) Best fit means that the width of the column will be increased or decreased by a percentage you specify.

False

(True or False) The range automatically selected by Excel is always correct.

False

(True or False) An asterick (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

False

(True or False) As in algebra, you can use the brackets to override the order of operations Excel follows to perform calculations.

False

(True or False) The Accounting number format assigns a floating dollar sign.

False

(True or False) You cannot format an entire column at once.

False

A name cannot be assigned to two or more nonadjacent ranges.

False

An alternative to a one-input data table is a three-input data table.

False

Excel includes four types of Sparkline charts: Line, Column, Win/Lose, and Stock

False

Excel is case sensitive with respect to names of cells.

False

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.

Indirect

The ____ Option button lists formatting options following an insertion of cells, rows, or columns.

Insert

Which of the following keys toggles between Insert mode and Overtype mode?

Insert

Clicking the ____ opens the Insert Function dialog box.

Insert Function box in the formula bar

Clicking the ______ opens the Inserts Function Dialog Box.

Insert Function box in the formula bar

Pastes the contents and format of the source area

Keep Source Formatting

Text is ___ aligned in cell

Left

By default text is ____ in a cell

Left aligned

Undo Button

Located on Quick Access Toolbar,

The ____ function tells you the relative position of an item in a range or table, which is the same as a specified value in a specified order.

MATCH

Function displays the highest value in a range.

MAX

The ____ function displays the highest value in a range.

MAX

The ______ function displays the highest value in a range. MIN SUM MAX AVERAGE

MAX

Determines the lowest number in a range

MIN

The ____ function determines the lowest number in a range.

MIN

The ______ function determines the lowest number in a range MAX AVERAGE SUM MIN

MIN

Are those portions of a printed page outside the main body of the printed document and always are blank when printed.

Margins

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.

Operations

If you enter 90 in the Degrees box in the ____ area of the Format Cells dialog box, the text will appear vertically and read from bottom to top in the cell.

Orientation

____ is extremely useful for making large tables more manageable in size and appearance.

Outlining

The ___ function returns the present value of an annuity.

PV

The ____ function returns the present value of an annuity.

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

____ view allows you to create or modify a worksheet while viewing how it will look in printed format.

Page Layout

view shows the worksheet divided into pages as well as the header/footer information.

Page Layout View

view allows you to create or modify a worksheet while viewing how it will look in printed format.

Page layout view

The range of cells receiving copied content is called the ____ area.

Paste

You should use a ____ chart to show the relationship or proportion of parts to a whole

Pie

To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.

Print Selection

Worksheet _____ typically contain descriptive information about items in rows or columns information that helps to group the data in the worksheet

columns

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values

constant

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.

constant

The comparison criteria in the ____ range determine the records that will pass the test when the Advanced Filter dialog box is used.

criteria

If you deselect an item from the filter menu, it is called the filter ____.

criterion

In a clustered column chart, the names of each column are part of the ____ series.

data

You use a ___ to automate data analyses.

data table

You use a(n) ____ to automate data analyses.

data table

Which of the following is a suggested decision to make when you plan a workbook?

determine the necessary functions and formulas needed

You should _____ a function name in the Formula AutoComplete list to select the function. doubleclick click right click none of the above

double click

You should ____ a function name in the Formula AutoComplete list to select the function.

double-click or double-tap

A check mark in the ___ check box speeds up printing by ignoring formatting and not printing most graphics.

draft quality

Using the mouse to move or copy cells is called ____

drag and drop

Using the mouse to move or copy cells is called ____.

drag and drop

An ____ chart is drawn on the same worksheet as the data

embedded

Which of the following keys moves the insertion point to the end of data in a cell?

end

By clicking the _____ box completes an entry

enter

The data ___ section of a worksheet includes data items entered by a user of a worksheet.

entry

A Pie chart with one or more slices offset is called a(n) ____

exploded Pie chart

Each row of an Excel worksheet used to create a table can store a record, and each column can store a(n) ____.

field

If you wish to sign out of your Microsoft account tap or click ______ on the ribbon to open the backstage view and then tap or click that account tab to display the account gallery, and then tap or click sign out

file

Which of the following is not a valid format symbol

semi-colon

Which of the following is not a valid format symbol?

semi-colon (;)

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

You click the _____ tab of the worksheet you want to view in the Excel window

sheet

You can deselect multiple selected sheets beginning with the Sheet 1 tab by pressing the ___ key and clicking the Sheet1 tab.

shift

The field or fields selected for sorting records are called ____ keys.

sort

A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.

sparkline

____ Properties are associated with all Microsoft Office files and include author, title, and subject

standard

You can click the ____ button arrow to view a list of often used functions

sum

A ____ should be formatted so that the records are easily distinguished.

table

A worksheet's row-and-column structure can be used to organize and store a ____.

table

The VLOOKUP function uses the left column of the ____ to compare against a particular number in the main table.

table array

____ is/are used to place worksheet, column, and row tiles on a worksheet

text

___ 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

A ________ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects. scheme gallery theme style

theme

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.

theme


Set pelajaran terkait

Chapter 57: introduction to the urinary system

View Set

Middle Ages: Development of Feudalism-Essential Questions

View Set

OB Review + Pre-Lecture Quiz #1-5

View Set

How are the two major political parties similar and how are they different?

View Set

Chapter 7: The International Monetary System and the Balance of Payments

View Set