BCIS 2610 Excel

If the VLOOKUP function cannot find the lookup value,the _______ error value is displayed in the cell.

#N/A

New Excel workbooks contain how many worksheets?

3

What value does this function return: =AVERAGE (3, 6, 7, 8)?

6

What is the default column width?

8.38 standard-sized characters— about 8 or 9 characters

What is a chart style?

A chart style is similar to a cell style or a table style in that it formats several chart elements at one time. You can change the color and appearance of the slices by selecting a different chart style from the Chart Styles gallery on the Chart Tools Design tab.

What is a line chart?

A line chart compares values from several categories with a sequential order, such as dates and times that occur at evenly spaced intervals. The values are indicated by the height of the line.

What does a green triangle in a cell indicate?

A potential error

What is the syntax of the Average function?

AVERAGE (number1, number2, number3, ...)

You press the ____________ key to display the Key tips, which are labels that appear over each tab and command on the ribbon.

Alt

To enter additional lines in a cell, press the ____________.

Alt+Enter keys

What symbol appears at the beginning of a function?

An equal sign =

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

AutoFit

To see more Border options, in the Font group on the Home tab, click the __________.

Borders button arrow

What is an embedded chart? What are the advantages and disadvantages of the embedded chart?

By default, a chart is inserted as an embedded chart, which means the chart is placed in a worksheet next to its data source. The advantage of an embedded chart is that you can display the chart alongside any text or figures that can plain the chart's meaning and purpose. A disadvantage is that an embedded chart covers worksheet cells, which might contain data and formulas.

n spreadsheet terms, a(n) _____ contains an Excel chart that provides a visual representation of spreadsheet data.

Chart Sheet

The _____ calculates the total number of values.

Count

To toggle in and out of formula view, press the ________ keys.

Ctrl+` keys. The ` grave accent symbol is usually located above the Tab key on your keyboard.

On the ribbon, click the ____________ tab to display Backstage view.

FILE

True or False? If you increase the font size of characters, you can fit more text within a given cell.

False

True or False? To deselect a range, click in the selected range again.

False

True or False? Worksheets cannot be deleted.

False

True/False: A type style is a set of characters that employ the same typeface.

False

True/False: AutoFill copies content but not formats from a cell or range into an adjacent cell or range.

False

True/False: Combining several cells into one cell is called aligning.

False

True/False: Flash Fill enters formulas, not text.

False

True/False: If you change any values or labels in the data source, the chart must be manually updated to show the new content.

False

True/False: Only fonts, not colors or cell styles, are organized in theme and non-theme categories.

False

True/False: The Format Painter copies data as well as formatting.

False

True/False: The Format Painter will allow you to copy formatting only to adjacent cells.

False

True/False: To add a collection of numbers, use the COUNT function.

False

True/False: You cannot change the background image of a worksheet.

False

True/False:If you leave a cell blank,the COUNT A function will include it.

False

True/False:The small black square in the lower-right corner of a selected cell or range is called the AutoFill button.

False - it is called a 'fill handle'

True/False: The Themes group is found on the HOME tab.

False, it is found on the PAGE LAYOUT tab

True/False: The #NUM! error value means that a cell reference used in a formula or function is no longer valid.

False; it means invalid numbers are used in a formula or function

The most efficient way for copying only formatting is to use the _______ feature.

Format Painter

A(n) _____ is a mathematical expression that calculates a value.

Formula

Dates are actually measured from what date?

January 1, 1900 at 12 a.m.

A ________ is a key that shows each color used in the worksheet and what it means.

Legend

The _____ allows you to see the effects of formatting options on the workbook's appearance before you apply them.

Live Preview

To merge and center text in multiple cells, click the ___________ button.

Merge & Center

Excel stores dates and times as _______.

Numbers

The _______ function can be used to calculate the payment schedule required to completely repay a mortgage or other type of loan.

PMT

Which chart compares relative values of different categories to the whole?

Pie Chart

A ______ is a single point on a computer monitor or printout.

Pixel

How can you correct the problem without re-keying the formula?

Press F2 (to edit the cell); press the Home key (to move the insertion point to the beginning of the cell); press the Equal sign; and press Enter

_______ is the amount of money being loaned?

Principal

To select adjacent ranges, hold down the ___________ key and then select the range.

Shift

What is the Short Date format?

The abbreviated format for dates, mm/dd/yyyy

If you forget to put an = sign at the beginning of a formula, what will appear in the cell?

The actual data you entered, not the calculation

If you create a copy of an existing worksheet and insert it between some existing sheets how will the copied worksheet be identified?

The worksheet will have the same name as the original, but with a (2) following the name.

True or False? A worksheet can contain the following type of data: text, numeric values, dates, and calculated values.

True

True or False? Functions are used to simplify formulas.

True

True/False: A pie chart compares relative values of different categories to the whole.

True

True/False: A relative reference is a cell reference that changes when it is copied and pasted in a new location.

True

True/False: A style is a collection of formats.

True

True/False: After you apply a table style, you can choose which table elements you want included in the style.

True

True/False: An error indicator appears in the upper-left corner of the cell with the error value.

True

True/False: An exploded pie chart moves one slice away from the pie as if someone were taking the piece out of the pie.

True

True/False: By default, Excel does not add background color to worksheet cells.

True

True/False: Charts remain linked or connected to their data sources, even if they appear in different worksheets.

True

True/False: Conditional formatting in a worksheet is special formatting applied when certain cell values meet one or more conditions.

True

True/False: Excel has built-in styles to format worksheet titles.

True

True/False: Functions are organized in the Function Library group.

True

True/False: Italic and bold are examples of a font style.

True

True/False: Leader lines can be added to labels placed outside the slices to connect them to their corresponding slices.

True

True/False: Text is oriented within a cell horizontally from left to right.

True

True/False: The Office theme is the default theme.

True

True/False: The color of pie slices can be changed.

True

True/False: The process for creating a column chart is the same as for creating a pie chart.

True

True/False: The values returned by the TODAY and NOW functions are updated automatically whenever you reopen the workbook or enter a new calculation.

True

True/False: Theme colors are the 12 colors that belong to the workbook's theme.

True

True/False: To make a worksheet active, click on the sheet tab.

True

True/False: You can click the Transpose button to paste the column data into a row or to paste the row data into a column.

True

True/False: You can reverse more than one action by clicking on the Undo button's list arrow.

True

True/False: You can save a workbook's theme as a file that can be used in other workbooks or Office files.

True

True/False: You can use cell styles and other formatting tools to individual cells and ranges to format Excel tables.

True

True/False:Like the COUNT function, many of Excel's statistical functions ignore cells that are blank or contain text.

True

True/False:The TODAY function doesn't have any arguments.

True

To retrieve there turn value from a vertical lookup table,you use the _______ function.

VLOOKUP

When does Flash Fill work best?

When the pattern is clearly recognized from the values in the data.

If you make a mistake while entering data, what can you do?

You can press the Esc key or click the Cancel button on the formula bar to cancel all of the changes you made while in editing mode.

If you don't want the cell reference to change when you copy the formula use the _______ reference.

absolute

A column chart turned on its side is called a(n) _______.

bar chart

Each cell is identified by a(n) _____, which is based on the cell's column and row location.

cell reference

Excel uses _______ to slow down the effect of changing data source values, making it easier to see how changing one value affects the chart.

chart animation

The ____ specifies the worksheet cells that contain the data on which the chart will be based.

chart options

The ____ provides a description of the chart.

chart title

A(n)_________is a symbol that indicates the relationship between two values.

comparison operator

A pie slice is an ample of a _______.

data marker

Each chart must have a(n) _______.

data source

A _____________ reminds you why you created a workbook and what it contains.

documentation sheet

Use the _____ symbol to make a cell reference absolute.

dollar $

To edit a cell's contents, you need to work in _____.

editing mode

To let Excel know you want to enter a formula, after clicking in a cell press the _______ key.

equal sign =

One type of what-if analysis that limits the data to a subset of the original values is a process called _______.

filtering

B$4 is an ample of a(n)_________ reference.

mixed

You can also open the Format Cells dialog box by ________ a cell, and then clicking Format Cells on the shortcut menu.

right-clicking

A ____________ is a collection of text and numbers laid out in a rectangular grid.

spreadsheet

The _____, or value, axis displays the values associated with the heights of each column.

vertical