Exel MOS Practice Problems
A logical function that can be used to develop compound logical tests using up to 255 arguments.
AND function
An Excel function that adds a group of values, and then divides the result by the number of values in the group.
AVERAGE
A cell reference that refers to cells by their fixed position in a worksheet.
Absolute cell reference
One possible source of data for a PivotTable is a(n):
Access database file
The ____________ is a report in a workbook that is graphically represented in a PivotChart.
Associated PivotTable
An Excel feature that generates and extends values into adjacent cells based on the values of selected cells.
Auto Fill
A text function used to join up to 255 strings of characters.
CONCAT
A statistical function that counts the number of cells within a range that meet the given condition and that has two arguments—the range of cells to check and the criteria.
COUNTIF
A logical function that counts the cells that meet specific criteria in a specified range.
COUNTIF function
A logical function that counts the cells that meet specific criteria in multiple ranges.
COUNTIFS function
A file type that saves the contents of the cells by placing commas between them and an end-of-paragraph mark at the end of each row.
CSV
A defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.
Cell style
Objects that make up a chart
Chart elements
The combination of chart elements that can be displayed in a chart such as a title, legend, labels for the columns, and the table of chartered cells.
Chart layout
A workbook sheet that contains only a chart
Chart sheet
A workbook sheet that contains only a chart.
Chart sheet
Use this type of ActiveX control to allow the person filling out a form to indicate a choice.
Check Box
The ____________ button removes a filter from a slicer
Clear Filter
This type of ActiveX Control initiates an action when clicked
Command Button
A filter that uses more than one condition or that uses comparison operators.
Compound filter
A format that changes the appearance of a cell—for example, by adding cell shading or font color—based on a condition.
Conditional formatting
The command that moves a chart to a worksheet that contains only a chart and no other worksheet data.
Move Chart
A logical function that takes only one argument and is used to test one condition. If the condition is true, the function returns the logical opposite false; if the condition is false, true is returned.
NOT function
An Excel function that retrieves the date and time from your computer's calendar and clock and inserts the information into the selected cell.
NOW
A word or string or characters in Excel that represents a cell, a range or cells, a formula, or a constant value.
Name
An element of the Excel window that displays the name of the selected cell, table, chart, or object.
Name Box
The abbreviation for number of time periods in various Excel functions
Nper
A specific way in which Excel displays numbers in a cell.
Number format
A logical function that can be used to develop compound logical tests using up to 255 arguments. The function returns a value of TRUE if ANY of the conditions are met.
OR function
To modify the Quick Access Toolbar, on the File tab, click
Options
A widely used file format developed by Adobe Systems that lets you create a representation of electronic paper that displays your data on the screen as it would look when printed.
A text function that capitalizes the first letter of each word.
PROPER
The Excel View in which you can adjust paging in a worksheet.
Page Break Preview
A type of chart that shows the relationship of each part to a whole.
Pie
A(n) ____________ displays data series, categories, data markers, and axes in the same manner as a standard chart.
PivotChart
The area bounded by the axes of a chart, including all the data series.
Plot area
The total amount that a series of future payments is worth now
Principal
This prevents anyone from altering the formulas or changing other template components.
Protection
An Excel feature that helps you choose a chart type by previewing suggested charts based on patterns in your data.
Recommended charts
A logical function that contains one logic test—it will add values in a specified range that meet a certain conditions or criteria.
SUMIF
A logical function that will add values in multiple ranges that meet multiple criteria.
SUMIFS
Excel commands that enable you to stretch or shrink the width, height, or both, of printed output to fit a maximum number of pages.
Scale to Fit
A what-if analysis tool that compares alternatives.
Scenario manager
The location within which a defined name is recognized without qualification—usually either to a specific worksheet or to the entire workbook.
Scope
A command that organizes data in a particular order.
Sort
The process of arranging data in a specific order based on the value in each field
Sort
Before subtotaling a list, the list must be:
Sorted
A tiny chart in the background of a cell that gives a visual trend summary alongside your data makes a pattern more obvious.
Sparkline
Tiny charts that fit within a cell and give a visual trend summary alongside data.
Sparklines
A policy within an organization that all forms created within the organization will have a uniform appearance; the data will always be organized in the same manner.
Standardization
The command that totals several rows of related data together.
Subtotal
A charting command to swap the data over the axis—data being charted on the vertical axis will move to the horizontal axis and vice versa.
Switch Row/Column
The arrangement of the arguments in a function
Syntax
A special workbook that may include formatting, formulas, and other elements and is used as a pattern for creating other workbooks.
Template
A function that can be used to combine or separate data, change case, and apply formatting to a string of characters.
Text function
A command that displays arrows that indicate what cells are affected by the value of the currently selected cell.
Trace Dependents command
A command that displays arrows to indicate what cells affect the value of the cell that is selected.
Trace Precedents command
A text function that changes the case of the characters in a string, making all characters uppercase.
UPPER
An Excel function that looks up values that are displayed vertically in a column
VLOOKUP
The numerical scale on the left side of a chart that shows the range of numbers for the data points.
Value axis
The Paste option used to paste calculated values that result from the calculation of formulas along with the formatting applied to the copied cells.
Values & Number Formatting
The area in the layout section of the PivotTable Fields pane where data is summarized is the
Values area
PivotTable field names are formed from the source data's
column titles
Slicers are used to
filter data
The data for a PivotTable should be in the format of a
list
A series of commands that are grouped together as a single command is known as a:
macro
A combination of keys to execute a macro or program is known as a:
shortcut key
After you create a macro and assign it to a button or menu item, to ensure that it works as expected, it needs to be:
tested
The command that joins selected cells into one larger cell and centers the contents in the merged cell.
Merge & Center
A format that changes the appearance of a cell—for example, by adding cell shading or font color—based on a condition; if the condition is true, the cell is formatted based on that condition, and if the condition is false, the cell is not formatted.
Conditional formatting
To make a letter a shortcut key, precede the letter with:
Ctrl
A value that originates in a worksheet cell and that is represented in a chart by a data marker.
Data point
A text file in which the text is separated by commas or tabs.
Delimited
When developing and editing ActiveX controls, you work in
Design Mode
To give you the option of approving or blocking files that contain macros, you should set your macro security level to:
Disable all macros with notification
A chart that is inserted into the same worksheet that contains the data used to create the chart.
Embedded chart
A series of rows and columns that contains related data that is managed independently from the data in other rows and columns in the worksheet.
Excel Table
Buttons on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart are:
Field buttons
A command that displays only the rows that meet a criteria
Filter
The process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify.
Filter
The area in the layout section of the PivotTable Fields pane where you position fields by which you want to filter the PivotTable report, thus enabling you to display a subset of data in the PivotTable report is the
Filters area
This type of control is compatible with versions of Excel that do not support ActiveX.
Form control
An equation that performs mathematical calculations on values in a worksheet.
Formula
A command that enables you to select one or more rows or columns and lock them into place; the locked rows and columns become separate panes.
Freeze Panes
The value at the end of the time periods in an Excel function; the cash balance you want to attain after the last payment is made—usually zero for loans.
Future value
Command to move to a specific cell or range of cells in a large worksheet.
Go To
A what-if analysis tool that finds the input needed in one cell to arrive at the desired result in another cell.
Goal Seek
One of Excel's What-If Analysis tools that provides a method to find a specific value for a cell by adjusting the value of one other cell—find the right input when you know the result you want.
Goal Seek
A line that serves as a frame of reference for measurement and that borders the chart plot area.
Gridline
Colored and underlined text that you can click to go to a file, a location in a file, a webpage on the Internet, or a webpage on your organization's intranet.
Hyperlink
A logical function that checks whether one or more conditions are met and returns a value corresponding to the first TRUE condition.
IFS
When applying conditional formatting, a set of three, four, or five small graphic images that make your data visually easier to interpret.
Icon set
A text function that changes the case of the characters in a string, making all characters lowercase.
LOWER
Column and row headings that describe the values and help the reader understand the chart.
Labels
A chart element that identifies the patterns or colors that are assigned to the categories in the chart.
Legend
A type of chart that displays trends over time.
Line
An Excel function that determines the largest value in a selected range of values.
MAX
A text function that extracts a series of characters from a text string given the location of the beginning character.
MID
An Excel function that returns the minimum value among cells specified by a given set of conditions or criteria
MINIFS