Excel Module 1, 2,3

true

false

true

false

false

true

False

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

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

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

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

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

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.

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

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

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

An adjacent range is a collection of separate ranges

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

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

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.

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

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

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

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

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

​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 _____.

​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 _____.

​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.

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

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

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

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

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

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

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

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

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

Formatting changes only the appearance of data—it does not affect the data itself. _________________________ true or 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?

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

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

The cell reference for the merged cell is the upper-right cell reference. _________________________ 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

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

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

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

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

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

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

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

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.

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

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

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

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

significant digits

constants

comparison operator

logical function

approximate match lookup

exact match lookup

horizontal lookup table

lookup table

lookup function

WORKDAY function

fill handle

error value

Goal Seek

trail and error

what-if analysis

nested

COUNTA function

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

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

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

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

A lookup table organizes numbers or text into categories

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

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

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

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

____ 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

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

The ____________________ is the middle value from a sample.

SYNTAX

______ 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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Interest is the amount of money being loaned. True or false?