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