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