Excel GO! - Complete Study Guide 1-3, 5-6
The IFS function, unlike the IF function, returns the first FALSE condition.
False
The MAC version of Excel functions exactly like the PC version.
False
Both the List and the Criteria ranges use absolute references.
True
Defining data as a table prior to sorting the data is optional.
True
A cell reference that refers to a cell by its fixed position in a worksheet is referred to as being:
absolute
The type of cell reference that refers to cells by their fixed position in a worksheet is:
absolute
A cell surrounded by a black border and ready to receive data is the:
active cell
The values that an Excel function uses to perform calculations or operations are the:
arguments
Match each of the following mathematical operations to its order: multiplication and division addition and subtraction expressions within parentheses exponentiation
third fourth first second
An Excel workbook contains one or more _____ that are stored in the workbook.
worksheets OR spreadsheets
An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is:
AutoFit
To specify three or more criteria for a particular column, use a(n) _____ filter.
advanced
Selecting the range before you enter data saves time because it confines the movement of the active cell to the selected range.
True
When selecting a range of cells for a chart, it is sometimes necessary to include an empty cell in the selection.
True
A municipal government fund that reports income and expenditures related to municipal services for which a fee is charged in exchange for goods or services is:
an enterprise fund
Use the _____ mark wildcard to search criteria that represents a single position or character that is unknown in a group of specified values.
question
The data that displays in the Formula Bar is referred to as the:
underlying value
The y-axis is also known as the:
value axis
A number that determines the spacing between tick marks and between the gridlines in the plot area is the:
major unit value
The process of locking cells in a workbook so that users cannot make any changes is:
protection
When you create a template, Excel adds the file extension:
.xltx
You should plot both totals and details on the same chart.
False
The command that locates and selects specific text, formatting, or type of information within a workbook quickly is:
Find
I know its long
Hope it helped!! :)
The SmartArt type that shows a continual process is a:
cycle
The graphic element such as a column, bar, or pie slice that represents a single data point is a:
data marker
The chart element that identifies the patterns or colors that are assigned to the categories in the chart is the _____
legend
An optional element added to a template to prevent someone from disabling a worksheet's protection is a:
password
The _____ controls the minimum, maximum, and incremental values on the value axis.
scale
_____ means that all forms created within an organization will have a uniform appearance; the data will always be organized in the same manner.
standardization
The NOW function is _____ meaning that it will update automatically each time the workbook is opened.
volatile
If you see an error message when using the IFS function, it might mean that you did not include a default value if all the conditions are FALSE.
True
The Text Pane is populated with placeholder text that you replace with your information.
True
Shift + Tab Shift + Enter PgDn Ctrl + End Tab
Moves left one cell Moves one cell up Moves down one full screen Moves to the last cell in the last column of the active area of a worksheet Moves right one cell
A feature with which you can rotate text diagonally or vertically in a cell and is useful when you need to label a narrow column is:
Orientation
The SmartArt type useful for creating an organization chart is a:
hierarchy
The default file format for Excel 2016:
.xlsx
Match the terms or phrases with their meanings: Custom Filter Extract Advanced Filter Comparison Operators Criteria
A filter with which you can apply complex criteria to a single column. Used for copying selected rows to another part of the worksheet. A filter that can specify three or more criteria for a particular column, apply complex criteria to two or more columns, or specify computed criteria. Symbols that evaluate each value to determine if it is the same, greater than, less than, or in between a range of values specified by the criteria. Conditions that you specify in a logical function or filter
Match the following functions with their description. SUM MEDIAN AVERAGE COUNTIF COUNT
Adds a range of cells Locates the middle value in a range of cells Adds a range of cells and divides by the number of values in the range Counts the number of cells in a range that meet the given condition Counts the number of cells in a range that contain numbers
Match the terms or phrases with their meanings: Database Field Detail Data Subtotal Command List
An organized collection of facts related to a topic. A specific type of data such as name or social security number that is stored in columns. The subtotaled rows that are totaled and summarized; typically adjacent to and either above or to the left of the summary data. The command that totals several rows of related data together by automatically inserting subtotals and totals for the selected cells. A series of rows that contains related data that you can group by adding subtotals.
The operator that requires each and every one of the comparison criteria that you specify must be true is the:
And comparison operator
A line chart can have only one line.
False
A logical test includes one of three values designated in three different cells.
False
All Excel charts have a minimum of three background elements.
False
Both charts and SmartArt graphics depend on underlying data in a worksheet.
False
Consecutive operators with the same level of precedence are calculated from right to left.
False
Ctrl + = is a keyboard shortcut that starts the Sum function in a worksheet.
False
The AutoCalculate feature displays three calculations by default: Sum, Subtraction, and Multiplication.
False
_____ charts show values across the stages in a process.
Funnel
Command used to move to a specific cell or range of cells in a large worksheet:
Go To
A language web browsers can interpret
HTML
A command that joins selected cells in an Excel worksheet into one larger cell and centers the contents in the merged cell:
Merge & Center
The function that retrieves and then displays the date and time from your computer is the:
NOW function
A feature that displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas is called:
Quick Analysis tool
Excel 1G
Study Guide
Excel 2G
Study Guide
Excel 3G
Study Guide
Excel 5G (4G Excluded)
Study Guide
Excel 6G
Study Guide
Operator Pixel Number values Underlying value Data
Symbol used to specify the type of calculation that you want in a formula A dot of light on a screen Constant values consisting only of numbers Data that displays in the Formula Bar Text or numbers in a cell
A pie slice is an example of:
a data marker
Match each of the following terms to its definition: Goal Seek what-if analysis Format Painter Formula Bar Formula AutoComplete
a feature that finds the input needed in one cell to arrive at a desired result in another cell process of changing values in cells to see how those changes affect the outcome of formulas in a worksheet a feature that applies formats one cell or range to another cell or range a part of the Excel window that displays the results of a cell a feature that displays function names based on the first letter that you type
The starting point when you divide the amount of increase by it to calculate the rate of increase is the:
base
The area along the bottom of a chart that identifies the categories of data is the:
category axis
The x-axis is also known as the:
category axis
In a chart, each data point—bar, slice, and so on—has a unique:
color or pattern
A sort order that you can define is a:
custom list
Numbers sorted from highest to lowest are sorted in:
descending order
The worksheets that contain the details of the information summarized on a summary sheet are called:
detail sheets
The action of pulling out a pie slice from a pie chart for emphasis is called:
explode
The area where you place the results when copying the results of a filter to another location in the worksheet:
extract area
A single piece of information that is stored in every record:
field
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 is called:
filtering
The Excel command that recognizes a pattern in your data and then automatically fills in the values when you enter examples of the desired output is:
flash fill
The areas surrounding a 3-D chart that give dimension and boundaries to the chart are known as the walls and _____
floor
An element in the Excel window that displays the value or formula contained in the active cell is the:
formula bar
A(n) _____ is a prewritten formula that looks at one or more values, performs an operation, and then returns a value.
function
The default format that Excel applies to numbers is the:
general format
The percent by which one number increases over another number is the percentage rate of:
increase
A chart type that displays trends over time is a:
line chart
The value in a chart's value axis that determines the spacing between tick marks and between the gridlines in the plot area is the
major unit
An element of the Excel window that displays the name of the selected cell, table, chart, or object is the:
name box
The process of moving within a worksheet or workbook:
navigate
The symbols with which you can specify the type of calculation you want to perform in an Excel formula are:
operators
Excel follows a set of mathematical rules called the _____
order of operations
A portion of a worksheet window bounded by and separated from other portions by vertical or horizontal bars is a:
pane
The action of placing cell contents that have been copied or moved to the Clipboard into another location is called:
paste
The target destination for data that has been cut or copied using the Office Clipboard is the:
paste area
A(n) _____ displays the relationship of each part of a whole.
pie chart
The area bounded by the axes of a chart, including all the data series, is the:
plot area
A value that originates in a worksheet cell and that is represented in a chart by a data marker is a data:
point
The Excel command that enables you to specify rows and columns to repeat on each printed page is:
print titles
A feature that outlines cells in color to indicate which cells are used in a formula is called:
range finder
To force data into a selected number of pages, use the _____ command.
scale
The page formatting that reduces the horizontal and vertical size of the printed data by a percentage or by the number of pages that you specify is:
scaling
A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the:
select all box
Related data points represented by data markers are referred to as the data:
series
The labels along the lower border of the workbook window that identify each worksheet are the:
sheet tabs
To organize data in a particular order is to:
sort
The process of arranging data in a specific order based on the value in each field is called:
sorting
Tiny charts embedded in a cell that give a visual trend summary alongside your data are:
sparklines
A worksheet where totals from other worksheets are displayed and summarized is a:
summary sheet
The file type that saves an Excel file with tabs between each cell in a row and a paragraph return at the end of each row:
tab delimited text file
A series of rows and columns that contains related data and that is managed independently from other data is an Excel:
table
Match the following terms with their definition. Logical test IF function Comparison operator Conditional format Data bar
Any value or expression with a true or false result Checks whether a condition is met and returns a true or false value Compares values in an Excel function or formula Formatting applied to a cell based on a criterion A shaded bar that provides a visual cue about the value of a cell relative to other cells
The Excel feature that generates and extends values into adjacent cells based on the values of selected cells is:
Auto Fill
The Find and Replace feature cannot be restricted to a range.
False
The NOW function only requires one argument.
False
The first sort level is sometimes referred to as the primary sort.
False
Use the F1 key to cancel a moving border after you have copied and pasted.
False
When you select the data range for a pie chart, you should be sure to include the total cell on the worksheet.
False
Tiny charts that fit within a cell and give a visual trend summary alongside data.
Sparklines
Match the following five chart elements to their descriptions: tick marks axis chart area category labels plot area
The short lines that display on an axis at regular intervals. A line that serves as a frame of reference for measurement and that borders the chart plot area. The entire chart and all its elements. Display along the bottom of the chart to identify the category of data. The area bounded by the axes of a chart, including all the data series.
Match the following five terms to their meanings: sparklines column chart labels embedded chart chart sheet
Tiny charts that fit within a cell and give a visual trend summary alongside data. Presents data graphically in vertical columns and is useful to make comparisons among related data. Column and row titles that describe the values and help the reader understand the chart. A chart inserted into the same worksheet that contains the data used to create the chart. A worksheet that contains only a chart.
Pyramid is a category of SmartArt graphics that uses a series of pictures to show relationships.
True
To create sparklines, first select the data you want to plot.
True
When using compound criteria on the same row, all the conditions must be met for the records to be included in the results.
True
