Computer Apps Master of Excel

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

The Excel operator for exponent

> only arrow points up

When specifying criteria in the Custom AutoFilter dialog box, use the ---------- wildcard to specify a single character.

?

Font

A predefined set of attributes that gives your Excel worksheet a professional look.

What is A2:D6?

A range

Range

A selection of two or more cells

Trendline

A series of data points on a line that shoes data values representing the general direction in a data series.

Data Bar

A type of conditional formatting that visually illistrates differences among values.

Which Excel function averages cells in a range based on a specified condition?

AVERAGEIF

When used in formulas, names automatically become ----- cell references by default.

Absolute

Which type of cell reference preserves the exact cell address in a formula?

Absolute

The HLOOKUP function searches horizontally --- of the table until the matching value is found.

Across the upper row

To find records for employees whose salary is greater than $60,000 and whose gender is female, use the......

Advanced Filter Command (Sorting more than one thing at a time)

If Denise specifies Jan* as a search criterion, which of the following will Excel locate? Jane January Janet All of the above

All of the Above

In the Data Validation dialog box, clicking List from the ------ list arrow allows you to type a list of specific options.

Allow

The file extension . xltx indicates what type of Excel file?

An Excel Workbook

Object

An independent element on a worksheet.

When performing an advanced filter, you specify ------ conditions by placing the criteria in the same row.

And

Keyboard shortcut letters.....

Are case sensitive

To show how individual volume changes over time in relation to total volume, use a(n) ------ chart.

Area Chart

Perform mathematical calculations such as adding and subtracting

Arithmetic Operators

What key(s) can you use on the keyboard to navigate a worksheet?

Arrow Keys

Double-Clicking the column line to the right of the column activates the --------- feature for the column.

AutoFit

To create a macro that will automatically run when a workbook is opened, you need to name it.....

Auto_Open

A statistical Function

Average

Which chart type do you use to compare distinct objects over time using horizontal bars?

Bar Chart

Chart

Before creating this, you need to plan the information you want to show.

Where do you commonly add new records to an Excel Table?

Below the last row of the existing table.

The default border color around a chart title is....

Blue

Which Visual BAsic EDitor window houses any explanatory text added to lines of code?

Code

Which Visual Basic Editor window houses the macro name?

Code

In the accompanying figure, the filter list arrow appears next to each ------ header.

Column

A(n) ------ chart compares distinct object levels using vertical bars; it is the Excel default.

Column Chart

An example of a9n0 ----- chart is a column chart with a line chart.

Combination Chart

A pie Chart ......

Compares sizes of pieces as part of a whole.

-------- formatting is automatically updated if you change data in the worksheet.

Conditional

Or

Conditions entered on different lines in an advanced filter.

And

Conditions entered on the same line in an advanced filter

Which Excel feature is used to break a data field into separate columns?

Convert Text to Columns

A multilevel sort calls for using the ------- feature.

Custom Sort

What group houses the Switch Row/Column button on the CHART TOOLS DESIGN tab?

DATA

-------- is the database function used to total values in a table.

DSUM

Metadata is information that describes.....

Data

Which of the following will NOT be affected or rearranged by choosing a new layout on the CHARTS TOOLS DESIGN tab? Data titles legend gridlines

Data

A collection of related data points is called a.....

Data Series

Name Box

Displays the active cell address

You can ------- the chart title text to select it.

Double-click

Allows the user to move or copy data from one cell to another without using the Clipboard.

Drag-and drop method

You can move a chart by selecting and dragging it's.....

Edge

You can change, or --------- the contents of an active cell at any time.

Edit

To add a shadow to an object, click the ----- button in the Format Chart Title pane, click shadow, and make to desired selections.

Effects

To specify a long list of valid entries you can type them ----- and the type the lis range in the Source text box.

Elsewhere in the worksheet

Increasing gap width adds space between each set of data on the chart by increasing the width of the chart's data series.

False

It is acceptable for dates to have a currency format.

False

It is okay to assign a macro to the shortcut keystroke combination [CTRl[C], even tough that is Excel's shortcut combination for Copy.

False

Once you start recording a macro with the keyboard , you cannot switch to the mouse to enter commands.

False

Records are columns in a table that describe a characteristic about a field, such as a customer's last name or street address.

False

Subtotals can be used in an Excel table.

False

The CONCATENATE function breaks a text string into separate strings,

False

The Excel Macro Recorder not only records all commands and actions you take, it also records how ling it takes you to finish the macro.

False

The FIRST step in planning a macro is to record it.

False

The Hide and Unhide buttons in the Window group are used for hiding individual worksheet cells.

False

The IFERROR function is used to look for spelling errors in Excel.

False

The Match case option in the Find and Replace dialog box is used to search for duplicate records.

False

The Wildcard dialog box helps you find records in a table.

False

The data from a column that appears in a filter list arrow cannot be used as search criteria.

False

The horizontal Axis is also called the value axis.

False

The parts of an IF function are separated by parentheses.

False

The wildcard asterisk (*) always represents one single character.

False

To inspect a document for issues, you first click the Protect Workbook button in the Inspect Workbook area.

False

To open two instances of one Excel workbook, you need to open it twice from its original location.

False

To show and hide custom views, you click the Add View button in the Custom Views dialog box.

False

Use the Chart Tools button to remove a legend.

False

When using the Insert Function button or the Auto Sum list arrow. it is necessary to type the equal sign.

False

When you create custom views, you name the view first and then set the worksheet display.

False

When you insert a new column, the contents of the worksheet shift to the left from the point of the new column.

False

When you specify a complicated set of search criteria, it is a good idea to filter it in place rather than extract it.

False

Working with shapes, you will find the Rotate button in the Illustration group on the INSERT tab.

False

You can add new rows to a table by typing data directly below the last row, and then pressing [Tab]

False

You can apply conditional formatting to table cells in the same way that you can format a range of worksheet data.

False

You can change header and footer information using the Margins Design tab that opens on the Ribbon when a header or footer is active.

False

You must apply borders to all the cells in a worksheet' you cannot apply them only to selected cells.

False

When you enter a comment in macro programming code, you must type an asterisk otherwise, excel will think you have entered a command.

False (It's a comma)

The Format Painter button copies both the cell's content and formatting.

False (not formatting)

Dragging a chart object to a new location on the worksheet will change the data in the worksheet.

False (obvious)

Records are composed of.......

Fields

To continue a sequence in adjacent cells, such as months of the year, use the ---- feature of Excel.

Fill Handle

In a table, what appears in the cell of a column header?

Filter list arrow

What Excel features uses worksheet data to predict what should be entered into similar column cells?

Flash Fill

What object can you add to an Excel worksheet to make it easier for users to enter or select data?

Form Control

Where can you increase the maximum value on the value axis?

Format Axis pane

You can apply font styles and alignment options using the -----dialog box.

Format Cells

You can change colors, patterns, and borders of cells by using the Fill tab and the Border tab in the ---------- dialog box.

Format Cells

You can customize a legend using the options in the ------ pane.

Format Legend

You can format a macro button using 3-D effects by right-clicking the button, selecting ------- from the shortcut menu, then selecting 3-D effects.

Format Shape

What can you do with WordArt Text? Spellcheck it Format it Sort it Use it as a cell reference

Format it

To insert cells, click the insert list arrow in the Cells group on the --------tab, then click insert cell.

Home

Category Axis

Horizontal Axis (X-axis)

Which of the following can NOT be a target? Web site home page Word document Hyperlink Excel worksheet

Hyperlink

Which Excel function checks for errors and displays a message you specify if there is an error in a formula.

IFERROR

In the -------- window you can search for online pictures, etc. (pretty much anywhere you can get pictures from)

Insert Pictures

Which of the following is a way to edit grouped worksheets? Freeze the worksheet panes Protect them Create a read-only version Insert a header

Insert a header

To view the Document Inspector dialog box, click the Check for Issues button, and then click.....

Inspect Document

A worksheet displayed in its own window is called a(n)....

Instance

A company's internal website is called a(n).....

Intranet

With the data validation feature, you can restrict data to all of the following EXCEPT......

Invalid entries

Which of the following is NOT a benefit of a macro? It helps build complicated formulas It saves time It repeats a task the same way each time it is run It can be assigned to a button to make it easier

It helps build complicated formulas

Monica notices that the macro name in the Macro dialog box includes the workbook name between single quotation marks, followed by an exclamation point; this indicates that the macro.....

It is outside the active workbook

If Denise specifies Jan? as a search criterion, Excel will locate all of the following records EXCEPT....... Janet Jani Jane Jany

Janet

Which of the following can users search for to help them locate a workbook? groups keywords folder names links

Keywords

Which of the following is NOT a possible window arrangement in the Arrange Windows dialog box? Tiled Horizontal Cascade Layered

Layered

The VLOOKUP function searches vertically down the ------ of the table, then reads across the row until the matching value is found.

Left-most column

A(n) ------ identifies each data series in a chart, generally with a different color.

Legend

The default format for cells that meet a condition with conditional formatting is --------.

Light Red fill with dark red text.

Which chart type is the best candidate for emphasizing sales trends over a 6 month period.

Line Chart

The hyperlink button is in the ---- group on the INSERT tab.

Links

When you create a table, Excel automatically generates a -------- next to each column header that you can use to filter records.

List Arrow

------- shows you a fill color will look before you apply it.

Live Preview

Personal Macro Workbook

Location where commonly used macros are stored.

A condition that can be answered with a true or false response is called a(n) .........

Logical Test

Value Axis

Often contains numerical values that help you interpret the size of chart elements.

To ------- an Excel workbook, is to place it on a network or on the Web so that others can access it using their Web browsers.

Publish

What Excel feature would you use to compute and display an average of the data values in your chart?

Quick Analysis tool

The spelling button is found in the Proofing group on the -------- tab on the ribbon.

REVIEW

Before you can add subtotals to table data, you must convert it to a(n) ----- and then sort it.

Range

You assign shortcut key combinations to a macro in the.....

Record Macro dialog box

Tables are organized into rows, called.......

Records

The type of cell reference used to preserve the relationship to the formula location.

Relative

What kind of cell reference tells Excel to substitute new cell references within the copied formulas as necessary.

Relative

You can ----- a table field if the information stored in a field becomes unnecessary.

Remove

You insert a comment in a worksheet by using a command on the ----- tab on the Ribbon.

Review

To format a cell or range, first you select it, and then you apply the formatting using the -----, the Mini toolbar, or a keyboard shortcut.

Ribbon

If you create a conditional formatting rule you can modify it using the Conditional Formatting....

Rules Manager

You often create subtotals with the --- function.

SUM

Which Excel function totals only the cells in a range that meet given criteria?

SUMIF

Which chart type is the best candidate for spotting trends and extrapolating information based on research data?

Scatter Chart

In addition to using Excel's spreadsheet feature, you can analyze and manipulate data using a ------- structure.

Table

The CONCATENATE function joins two or more ---- into one.

Text Strings

What happens when you click the Move Chart button in the Location group of the CHART TOOLS DESIGN tab?

The Move Chart dialog box opens

Which Visual BAsic Editor window houses the module?

The Project Explorer Window

Which of the following removes only the contents of a selected row or column?

The [Delete] key

Once the Office Clipboard reaches its maximum, how does it handle new items that are copied or cut?

The clipboard automatically deletes the oldest item on the clipboard.

(And) as well as (Or) are logical conditions.

True

A chart sheet is a sheet in a workbook that contains only a chart, which is linked to the workbook data.

True

A data table displays the values used to generate the chart directly on the chart itself.

True

A delimiter is a data separator.

True

A mixed cell reference contains only one $

True

A watermark will print behind worksheet data.

True

After you add sparklines, they usually appear close to the data they represent.

True

An Excel complex formula uses more than one arithmetic operator.

True

Data can be consolidated from different workbooks in one worksheet.

True

Excel templates include budgets, balance sheets, and time cards.

True

Font is the size of the physical text.

True

If a number is divided by zero, the error value #DIV/0! will display in the cell.

True

If there are invalid cell references in a formula, the error value #REF! will display in the cell.

True

In order to see who has permission to open, copy , or change your workbook, click the FILE tab and review the information area.

True

Inserting extra spaces at the beginning of a cell entry in a table can affect sorting and finding data later.

True

Linking to a workbook means that any changes to the original values are automatically reflected in the consolidation sheet as well.

True

Move your pointer over the Data TAble list arrow to deselect legend keys.

True

Names that you assign to cells and cell ranges can be used in formulas.

True

One way to check worksheet formulas for errors is to display the formulas on the worksheet rather then the formula results.

True

Row heights will automatically adjust themselves when the font size changes.

True

Symbols, such as less than (<), greater than (>), and equal to (=), are all examples of comparison operators.

True

Tables are organized into records which are composed of fields.

True

The COUNTA function is used to count the number of cells in a range that contain numbers, dates, and or formulas.

True

The Excel Custom Views feature allows you to create several views of a worksheet without having to create separate sheets

True

The Find and Replace dialog box can be opened by clicking Find & Select button in the Editing group.

True

The Macro dialog box shows macros contained in all open workbooks.

True

The Personal Macro Workbook is a special workbook used only for macro storage.

True

The Synchronous Scrolling button allows you to scroll through arranged worksheets simultaneously.

True

The Use Relative References button is toggle, meaning it acts like an off/on switch.

True

The area in which data in cells may be changed is sometimes called the data entry area.

True

The cell lock option does not change the way a user interacts with a worksheet until the protection feature is activated.

True

The first character of a macro name must be a letter.

True

The menu that appears when you click filter list arrow includes data from that column.

True

The question mark (?) wildcard stands for any single character.

True

To delete a table row, place the cursor in any cell in the row you wish to delete, then click Delete Table Rows from the Delete list arrow in the cells group.

True

To name a range, select the range and then click Define Name button in the Defined Names group.

True

To open two instances of one Excel workbook, you open the file and then create a new window using the New Window button in the Window group.

True

To use spell-check in more than one sheet, you need to display each sheet seperatly and run the spell check again.

True

Using the cut command completely removes data from its original location, while the copy command leaves information in its original location.

True

When using the Advanced Filter command, a criteria range is not entered into a dialog box.

True

When you create a table, Excel automatically applies a default table style.

True

When you protect a worksheet, unlocked areas can still be changed.

True

With Excel, you can adjust the width of one or more columns by using the mouse.

True

WordArt can be created using the CHART TOOLS FORMAT tab.

True

WordArt text is a chape rather than a label in a cell.

True

You can add new rows and columns to a data table by dragging the sizing handle in the table's lower-right corner.

True

You can change the font and font size of any cell or range using the Mini toolbar.

True

You can change the maximum value of the vertical axis in the Format Axis pane.

True

You can filter records based on information in a specific field.

True

You can insert blank lines in the macro code to make the code more readable.

True

You can print a chart by itself or as part of the worksheet.

True

You can print a filtered table.

True

You can run a macro in any open workbook.

True

You can show and hide the Personal Macro Workbook as needed.

True

You can use a named range instead of a cell address in a formula

True

Criteria on ----- line(s) indicates an Or condition.

Two

What grop on the CHART TOOLS DESIGN tab do you use to change a chart to a combination chart?

Type

How do you insert blank lines as comments in the macro code to make the code more readable?

Type an apostrophe, then press [Enter]

Functions can be entered for formulas using all of the following methods EXCEPT

Typing the function argument

In place of spaces, what do you use in a macro name?

Underscores

Which of the following is NOT a guideline you should follow when planning a table? Plan and design your table Avoid blank rows Use a variety of formats for all cells in a column Avoid blank columns

Use a variety of formats for all cells in a column

Which of the following is NOT a guideline when naming a field? Field names should be short Use numbers to name fields Field names should be unique Use descriptive names

Use numbers to name fields

Criteria Range

Used in advanced filter to specify conditions for the filter

Value Axis

Vertical axis in a two-dimensional chart

When you use the Macro Recorder to create a macro, the instructions are recorded automatically in a programming language called.....

Vicual BAsic for Applications (VBA)

Data Marker

Visually represents each data point.

A ---- will print behind worksheet data.

Watermark

A translucent background design that prints behind your data is called a........

Watermark

You can use a spreadsheet to create-------------- by using variable values to investigate and sample different outcomes.

What if-data scenarios

*

Wildcard to specify a series of characters

?

Wildcard to specify a single character

Where do you select WordArt for your text?

WordArt styles gallery

A scatter chart......

compares trends over uneven time or measurement intervals.

Cell Pointer

dark rectangle that outlines the cell in which you are working

This is called the formula prefix

equal sign

In a pie chart, slices that are pulled away are said to be.....

exploded

Cell Address

identified by the coordinates of the intersecting column and row

The default file extension for an Excel 2013 workbook is .....

.xslx

In two-dimensional charts, data values are plotted on the x-axis.

False

-------- helps users locate, identify, and understand a file.

Properties

Which error code will display if a value in a formula is not available?

#NA

Which error code will display if a formula contains a text error?

#NAME

Which error code will display if a number is used invalidly in a cell?

#Num!

You can create an absolute cell reference by placing a ---------- in front of both the column letter and the row number of the cell address.

$

Absolute cell reference

$G$6

Mixed cell reference

$G6

When specifying criteria in the custom Auto Filter dialog box, use the ---- wildcard to specify any series of characters.

*

Which wildcard symbol is a substitute for any single character?

*

Cell references that reference other sheets behind the summary sheet are known as ------- references.

3D references

The COUNT function in Excel returns the number of all cells in a range that contain any type of data.

*False

Once created, the Personal Macro Workbook file is usually stored under the name "PERSONAL" with the extension of.......

.xlsb

The undo button lets you go back how many times?

100

What is the maximum of the Office Clipboard?

24

What do you click to preview the Clustered Column, Scatter, Stacked Area, and other chart options?

CHARTS tab at the top of the Quick Analysis Gallery

What do you click at the top of the Chart Styles gallery to preview data bar color choices?

COLOR

The Excel function that returns the number of cells in a range containing a specific word, date, or numeric data.

COUNT

Which Excel function counts the number of cells in a range?

COUNTIF

After you enter a single formula into a table cell, the ------ feature fills in the remaining cells with the formula's results.

Calculated Columns

You can change a column chart to a clustered bar chart using the ---- dialog box.

Change Chart Type

What do you use if the chart elements you want cannot be selected from the CHART ELEMENTS gallery?

Chart Elements list arrow on the Ribbon

After extracting table data, what button do you use to display the original table again?

Clear

Which option do you use to make sure a cell is free of contents and formatting.

Clear All

To clear a filter, click the ......

Clear button in the Sort & Filter group

How do you assign a macro to a button you created after right=clicking the "new" button?

Click Assign Macro on the shortcut menu, click the button's label under Macro name, then click OK

What should you do if your Personal Macro Workbook is listed in the Disabled items dialog box?

Click it's name, then click Enable

One method of execution a macro is.......

Click the Macros button on the DEVELOPER tab of the Ribbon.

What should you do if the Store macro in list box does not display "This Workbook" in the Record Macro dialog box after you type a macro name in the Macro name text box?

Click the list arrow and select This Workbook

To stop macro recording.......

Click the stop button in the status bar

A -------- is an individual media file, such as art, sound, animation, or a movie.

Clip

The Format Painter button is found in the ------- group on the HOME tab of the Ribbon.

Clipboard

Which Excel feature allows you to specify what data users can enter in a range of cells?

Data Validation

Each value in a cell selected for a chart is called a.......

Data point

Data Label

Descriptive text that appears above data marker in a chart.

Virus

Destructive software

Point

Equal to 1/72 of an inch

Which of the following save options should you use so that someone who has an earlier version of Excel can view your Excel document? Excel 2010 Workbook Excel 97-2003 Workbook Excel 2003-2007 Workbook Excel 98 and Later Workbook

Excel 97-2003 Workbook

You can display the DEVELOPER tab on the Ribbon using the --- dialog box.

Excel Options

Comments

Explanatory text in a macro.

When you ----- data, you place a copy of the filtered table in a range you have specified in the Advanced Filter dialog box.

Extract

When you create a chart, a data table often appears by default.

FAlse

You can add a text box using the CHART TOOlS ------ tab.

FORMAT

A bar chart and column chart are equivalent chart types in Excel.

False

A chart must be located in a specific cell or at a specific address range.

False

A named range can begin with a letter or number

False

A picture added to the worksheet background will show on screen and will also print.

False

A two-period moving average smoothes out fluctuations in data by using only the maximum data points.

False

A workbook containing a macro will not open if macros are disabled.

False

According to the order of precedence for arithmetic operators,operations contained within parentheses are performed last.

False

An Excel 2013 workbook has the file extension .xml

False

An absolute cell reference changes the cell references when the formula is copied to a new location.

False

Arguments are Excel's built-in formulas

False

Cell and range names can use uppercase and lowercase letters, digits, and spaces.

False

Cells in the data entry area are generally locked.

False

Field names should be similar to cell addresses, such as G2.

False

Greater than and less than are logical conditions.

False

If a value in a formula is not available, the error value #VALUE! will display in the cell.

False

Excel templates include all of the following EXCEPT Formulas, Formatting, Labels, Data

Formulas

If you are working with 3-D charts, you can increase the ------ to add depth to all categories of data.

Gap depth

If you want to enter header or footer information on one worksheet and have it appear on several other worksheets, you should first ----- the worksheets.

Group

The Find & Select button is found in the Editing group on the ----- tab on the Ribbon.

HOME

You can apply font styles and alignment options using the ------- tab on the ribbon.

HOME

Which tab and group will allow the insertion of rows and columns in a worksheet?

HOME tab, Cells group

The coding format used for all Web documents is called.....

HTML

Column Width

Has a default value of 8.43 characters, a little less than one inch.

The first row of a table that contains field names is called a .....

Header row

Excel automatically designates the Personal Macro Workbook as a(n) ------ file.

Hidden

MHTML is also known as....

MHT

To save a single-file Web page that integrates all worksheets and graphics from one workbook, you need to save the file as......

MHTML

If you need to make minor adjustments to a macro, Excel allows you to edit the....

Macro Code

The easiest way to create a macro is to use Excel's.....

Macro Recorder

Which method of entering a function requires the user to know the name and initial characters of a function?

Manually typing the function

You can format the high an low data points of sparklines in different colors after clicking the ---- button.

Marker Color

Which button do you click in the Function Library group to select SUMIF from the list of functions?

Math & Trig

Each Macro is stored as a(n)......

Module

To see additional table styles, click the Table Styles ---- button.

More

As chart elements, where do data labels appear?

Near or on the data markers

When moving a chart to a new Excel worksheet, where do you enter the name of the new worksheet?

New sheet text box

Category Axis

Often contains numerical values that help you interpret the size of chart elements.

When you generate subtotals, all levels of detail show in a(n) -------

Outline

A theme can be applied using the Themes button in the Themes group on the ---------- tab on the ribbon.

PAGE LAYOUT

The Print Titles button is on the ----- tab.

PAGE LAYOUT

Which tab contains the print options for gridlines and headings?

PAGE LAYOUT

Which text function capitalizes the first letter in a string of text?

PROPER

The Excel feature used to selectively copy formulas, values, etc. by choosing options such as "paste formulas only".

Paste List Arrow

Which of the following is NOT a Paste list arrow option? Pasting values only pasting values with number formatting pasting cell selectors pasting formulas only

Pasting cell selectors

Which of the following is NOT included in a table style? Pattern fills Type color Fill color Borders

Pattern fills

Extract

Place a copy of a filtered table in a range that you specify in the Advanced Filter dialog box.

What type of trendlines are used for data values which increase or decrease in an arc shape?

Power

As you record the macro, Excel automatically translates each action into ------ that you can later view and modify.

Program Code

What is Visual BAsic for Applications (VBA)?

Programming language

VBA

Programming language for macros

The ----- refers to where you will be able to use a named cell or range in worksheets.

Scope

Which button do you clickto add information about a hyperlink?

ScreenTip

A combination chart can add a(n) ---- axis to chart related data.

Secondary

On the SPARKLINE TOOLS DESIGN tab, how do you display or hide data markers on a sparkline?

Select or deselect the Markers check box in the (Show) group.

Macro

Set of programming instructions that performs tasks in the order you specify.

To create a button for a macro, click the ---- button in the Illustrations group on the INSERt tab.

Shapes

What happens after you click the Edit Shape button in the Insert Shapes group, then you click Edit Points?

Small black (squares) appear on the shape's perimeter.

------- lets you create diagram types including List, Process, Cycle, Hierarchy, Relationship, Matrix, and Pyramid.

SmartArt

An electronic application you use to perform numeric calculations and to analyze and present numeric data.

Spreadsheet

The -------- feature allows formulas to refer to table columns by names that are automatically generated when you create a table.

Structured Reference

Cell ------- are predesigned combinations of formats.

Styles

Font ------ are formats such as bold, italic, and underlining that you can apply to affect the way text and numbers look in a worksheet.

Styles

Shape ---- make it possible to apply multiple formats to a data series, such as an outline, fill color, and text color, all with a single click.

Styles

Which Excel feature provides a quick and easy way to group and summarize a range of data?

Subtotals

The Remove Duplicates button is found on the ---- tab.

TABLE TOOLS DESIGN

If you want to find the closest possible match, what do you enter in the RAnge-lookup text box in the Function Arguments dialog box? NEAR CLOSEST TRUE FALSE

TRUE

When cells are copied using Excel's copy function, what happens to the data in the copied cells?

The data remains in its original location.

Excel automatically creates a scale for the y-axis based on......

The highest and lowest values in the data series

Font

The name for a collection of characters (letters, numerals, symbols, and punctuation marks) with a similar, specific design.

In the formula =ROUND(D4:F4,0) what does the zero indicate?

The number of decimal places in the rounded number.

Data Series

The sequence of values that Excel uses to create a chart

The color of a hyperlink depends on the worksheet ------ colors.

Theme

What term applies to Sparkline Style Colorful #4? Data color Type color Design color Theme color

Theme color

When cells or rows are inserted or deleted in an Excel worksheet, how are cell references affected by the insertion or deletion?

They adjust automatically

------ marks indicate the scale of measure for each value on the y-axis.

Tick Mark

A(n) ---- is a series of data points on a line representing the general direction of a data series.

Trendline

Which of the following cannot be a hyperlink in Excel? filename graphic word title bar

Title Bar

AutoFilter

To display only the records that meet the criteria you specify.

Which feature do you use to add summary information to the end of a table?

Total Row check box in the Table Style Options group

To move one screen to the left press

[Alt][Page Up]

The default Excel shortcut key combination for a new macro is ---- followed by a blank box for you to enter an upper or lowercase letter.

[CTRL]

One way to display formulas is by pressing this key combination.

[CTRL][']

When you save an Excel workbook as an earlier version of Excel, what appears in the title bar when you open the file?

[Compatibility Mode]

To return to cell A1 use what shortcut?

[Ctrl][Home]

To add an additional record to a table, type below the last record, then press.....

[Enter]

Which keyboard shortcut turns on Edit mode?

[F2]

Which function key on the keyboard allows the Excel user to cycle through all possible combinations of relative, mixed, and absolute cell referenced for a formula?

[F4]

What appears in the title bar when you mark a workbook as final?

[Read-Only]

You can add multiple worksheets to a workbook by clicking the HOME tab on the Ribbon, pressing and holding -----------, and then clicking the number of existing worksheet tabs that correspond with the number of sheets you want to add, clicking the Insert list arrow in the Cells group on the HOME tab, then clicking Insert Sheet.

[Shift]

Function

a built-in formula that uses arguments to calculate information.

You can edit the contents of an active cell by...

just starting to type

Which of the following is not an option that the Data Labels can produce? Series name value of the data point legend name category name

legend name

The print title prints at the top of every.....

page

Which of the following is NOT one of the arguments off a PMT function? payment pv nper rate

payment

An Excel user should use a relative cell reference when it is important to ......

preserve the relationship to the formula location

Status Bar

provides a brief description of the active command or task in progress

A small, ----- triangle appears in the upper-right corner of a cell containing a comment.

red

Names of cells and ranges cannot use....

spaces

A hyperlink jumps to a......

target

Predesigned, formatted files that contain labels, values, formulas, and formatting.

templates

A common example of a text delimiter is a ......

thing that looks like a comma but isnt a comma.


Ensembles d'études connexes

Basic incident command system for initial response.

View Set

Chapter 65: Nursing Management - Arthritis and Connective Tissue Diseases

View Set

POSI 2310 Chapter 11: Congress: Balancing Nation Goals And Local Interest

View Set

The President's Cabinet-Executive Branch Departments

View Set

Unit 1: Structure and function of arteries, veins and capillaries

View Set

Unit 1 - Milestone 1 / Public Speaking

View Set