Excel Module 1, 2,3

The appearance of non-theme fonts, colors, and effects remains unchanged no matter which theme is applied to the workbook. _________________________ true or false?

true

fill handle

A box that appears in the lower right corner of a selected cell or range.

Goal Seek

A feature that automates the trial-and-error process by allowing you to specify a value for the calculated item, which Excel uses to determine the

false

A formula is written using operands that combine different values, resulting in a single value that is then displayed in the cell. ______ true or false?

WORKDAY function

A function that displays the date of a weekday that is a specified number of weekdays past a starting date

lookup table

A function that retrieves a value from a table of data that matches a specified condition.

lookup function

A function that retrieves a value from a table of data that matches a specified condition.

logical function

A function that returns a different value depending on whether the given condition is true or false.

COUNTA function

A function that tallies how many cells in specified range contain any entries (numbers, dates, or text).

true

A keyboard shortcut is a key or combination of keys that you press to access a feature or perform a command. true or false?

horizontal lookup table

A lookup table in which the compare values are located in the first row.

approximate match lookup

A lookup where the lookup value falls within a range of numbers in the compare values in the lookup table.

exact match lookup

A lookup where the lookup value falls within a range of numbers in the compare values in the lookup table.

error value

A message in a cell that indicates some part of a formula is preventing Excel from returning a calculated value.

comparison operator

A symbol that indicates the relationship between two values.

constants

A value in a formula that doesn't change.

what-if analysis

A way to explore the impact that changing input values has on calculated values in a workbook.

trail and error

A way to perform what-if analysis by changing one or more of the input values to a value you estimate to see how it impacts the calculated results

​Antoinette is part of a college department creating a number of student files with Microsoft Excel. She is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status. ​Each worksheet will contain a specific class with the students' grades for the entire term. In order to determine the current student grade, Antoinette would have to use the _____ function.

AVERAGE

The ____________________ function will not include any cell in the range containing a non-numeric value in the final tally.

COUNT

You already created a line chart, but now decide that you want to change this to a pie chart. To do this, you click ___ from the Type Group Tools Design tab. ⸰ Alter Existing ⸰ Chart ⸰ New Chart ⸰ Modify Chart ⸰ Change Chart Type

Change Chart Type

To remove conditional formatting in Excel, click ____________________ after clicking the Conditional Formatting button.

Clear Rules

____________________ removes the data from the row or column as well as removes the row or column itself.

Deleting

An adjacent range is a collection of separate ranges

False

Column width is expressed in terms of the number of characters a column can contain or the size of the column in points

False

Speed Fill enters text based on patterns it finds in the data. _

False

When text wraps within a cell, the column width increases so that all of the text within the cell is displayed.

False

The ____________________ tab in the Format Cells dialog box in Excel provides options for creating and applying background colors and patterns to cells.

Fill

The ____________________ copies the formatting from one cell or range to another cell or range without duplicating any of the data.

Format Painter

Use the ____________________ button in the Alignment group on the Home tab to increase the size of the indention used in a cell.

Increase Indent

The ____________________ is the middle value from a sample.

MEDIAN

A(n) ____________________ reference contains both relative and absolute references.

MIXED

The active cell is highlighted with a thick green border, its cell reference appears in the ____________________, and the corresponding column and row headings are highlighted.

Name Box

true

Normal view shows how the worksheet will appear when printed. true or false?

Changing the number of decimal places displayed in a cell does not change the value stored in the cell. _________________________ true or false

T

Each header and footer has three sections—a left section, a center section, and a right section. _________________________ true or false

T

true

The AutoComplete feature automatically completes an entry based on previous entries in a column. true or false

false

The name of the active workbook appears in the status bar of the Excel window. true or false?

significant digits

The number of digits that should be displayed for a calculation; they indicate the accuracy of the measured and calculated values.

false

The sheets in a workbook are identified in the sheet tabs at the top of the workbook window. true or false

nested

To place one thing inside another, such as a function inside another function.

A common business practice is to include a worksheet named Documentation that contains a description of the workbook, the name of the person who prepared the workbook, and the date it was created.

True

AutoFit changes the column width or row height to display the longest or tallest entry within the column or row. _______

True

Cutting moves the selected content, whereas copying duplicates the selected content.

True

In the formula, =2+6*2, addition would be calculated after multiplication. ___

True

Numeric data is any number that can be used in a mathematical calculation.

True

The formula bar displays the value or formula of the active cell.

True

False

When you insert a new row, the existing rows are shifted down and the new row has the same width as the row above it.

SYNTAX

____________________ is a set of rules which specifies how a function should be written.

Use ____ references when you want different formulas to refer to the same cell ⸰ relative ⸰ mixed ⸰ absolute ⸰ fixed

absolute

Placing a chart in a ___ display only the chart and no worksheet cells

chart sheet

When you ____________________ a workbook, a dialog box might open, asking whether you want to save the workbook.

close

A(n) ____________________ of the original range is placed in the new location without removing the original range from the worksheet.

copy

A ____ contains the actual values that are plotted on the chat.

date series

A footer appears at the top of each printed page. _________________________ true or false

false

A theme is a collection of formatting options that include a specified font, font size, font styles, font color, fill color, and borders. _________________________ true or false

false

By default, Excel sets the page margins to 0.5 on the left and right margins and 0.75 on the top and bottom margin. _________________________ true or false

false

Combination charts enable you to show three sets of data the chart type that is nest for each data set. true or false?

false

Excel organizes fonts into theme and non-theme fonts. _________________________ true or false?

false

Page Break Preview identifies manual page breaks with a dotted blue line and automatic page breaks with a solid blue line. _________________________ true or false?

false

Text and numbers are displayed vertically within cells. _________________________ true or false

false

The cell reference for the merged cell is the upper-right cell reference. _________________________ true or false

false

One of the benefits of conditional ____________________ is that it helps you analyze data by highlighting significant trends in data.

formatting

A(n) ____________________ is a named operation that replaces the arithmetic expression in a formula.

function

A(n) ____________________ is text printed in the top margin of each page.

header

After you describe a function in the Search for a function box in the Insert Function dialog box, click ____.

insert

The ____________________ organizes all of the functions by category and allows you to search for functions that perform particular calculations.

insert function dialog box

​Antoinette is part of a college department creating a number of student files with Microsoft Excel. She is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status. ​When Antoinette shares her worksheet with other colleagues, she wants to ensure that everyone knows why certain cells are highlighted. To accomplish this, she will create a _____.

legend

When you specify a print area for a nonadjacent range, you are also inserting a(n) ____________________ page break.

manual

A(n) ____________________ includes a series of questions that help you think about the purpose of the workbook and how to achieve your desired results.

planning analysis sheet

The region that is sent to the printer from the active sheet is known as the ____________________.

print area

Some cell references are called ____________________ references because they are always interpreted in relation to the location of the cell containing the formula

relative

The range of the value or ____, of an axis is based on the values in the data source.

scales

Keyboard ____________________ can help you work faster and more efficiently because you can keep your hands on the keyboard.

shortcuts

The goal of a ____ is to convey the maximum amount of information within a very small space.

sparkline

Ten ____________________ colors — dark red, red, orange, yellow, light green, green, light blue, blue, dark blue, and purple — are always available regardless of the workbook's theme.

standard

A column chart turned on its side is called a bar chart, with the length of the bar determined by the data value. true or false

the answer is true

A lookup table organizes numbers or text into categories

the answer is true

An error value begins with a pound sign (#) followed by an error name that indicates the type or error, true or false

the answer is true

An error value indicates that some part of a function is preventing Excel from returning a calculated value.

the answer is true

One challenge of nesting functions is to make sure that you include all of the parentheses.

the answer is true

When a formula includes a cell reference, Excel interprets that cell reference as being located relative to the position of the current cell.

the answer is true

Functions are organized in the Function Library group on the FORMULAS tab

the answer istrue

A(n) ____________________ is a collection of formatting that specifies the fonts, colors, and graphical effects used throughout the workbook.

theme

Interest is the amount added to the principal by the lender. Is this true or false?

this answer is true

A conditional format can make negative numbers red and positive numbers black. true or false

true

By default, Excel displays text in a black font color. _________________________ true or false

true

Calculated values too large to fit into the cell are displayed in scientific notation. _________________________ true or false

true

Conditional formats are dynamic, so a cell's appearance will change to reflect its current value. _________________________ true or false

true

Excel charts are either placed in their own chart sheets or embedded in a worksheet t/f ___?

true

Formatting changes only the appearance of data—it does not affect the data itself. _________________________ true or false

true

If you want to print only part of a worksheet, you can set a print area, which is the region of the worksheet that is sent to the printer. _________________________ true or false

true

The Format Painter does not copy formatting applied to selected text within a cell, and it does not copy data. _________________________ true or false?

true

​Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. ​Harold needs to format several cells with 11pt Calibri font, two decimal places, right-aligned, and a blue font color. The most efficient way to accomplish this would be to _____.

use Format Painter

Susan is in charge of the inventory reports for her company. She will need to find specific inventory items as well as project increases in inventory costs. To get ready she will create a worksheet and use the Microsoft Excel 2016 Analysis tools. Susan wants to automate the trialanderror process by allowing her to specify a value for a calculated item, which Excel uses to determine the input value needed to reach that goal. She can use ______. ⸰ Goal set ⸰ If Conditional ⸰Goal Seek ⸰Data Validation

⸰ GoalSeek

______ functions find values in tables of data and insert them in another location in the worksheet such as cells or in formulas. ⸰ Find ⸰ Average ⸰ Lookup ⸰v?

⸰ Lookup

Susan is in charge of the inventory reports for her company. She will need to find specific inventory items as well as project increases in inventory costs. To get ready she will create a worksheet and use the Microsoft Excel 2016 Analysis tools. Susan designs a worksheet with the inventory number, description, quantity, unit cost, reorder point and value. To find values in tables of data, and insert them in another location in the worksheet such as cells or in formulas, she will use ________. ⸰ Mix function ⸰ Sum function ⸰ CountA function ⸰ Lookup Function

⸰ Lookup Function

Ellen is a recent college graduate. She has decided to open a TShirt business and would like to create budget worksheet using Microsoft Excel 2016. She need to keep track of her expenses and income for the year. Ellen's spending varies from month to month. She wants to calculate the total expenses for each month. She wants to see all of the arguments associated with the SUM function so she clicks the ____ then clicks SUM to open the Function Arguments dialog box. ⸰ Financial button in the Function Library group ⸰ Math & Trig button in the Formula group ⸰ Financial button in the Formula group ⸰ Math & Trig button in the Function ⸰ Library group

⸰ Math & Trig button in the Function

____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table. ⸰ Mixed ⸰ Matched ⸰ Absolute ⸰ Relative

⸰ Mixed

In "SUM(number1 [, number2, number3, ...])", number 1, number 2, and number 3 may be numbers or ____. ⸰ letters ⸰ cell references ⸰ operators ⸰ symbols

⸰ cell references