Computer Apps Master of Excel
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.