Excel BIM I
Absolute Cell Reference
A cell reference that refers to cells by their fixed position in a worksheet.
Legend
A chart element that identifies the patterns or colors that are assigned to the categories in the chart.
Switch Row/Column
A charting command to swap the data over the axis—data being charted on the vertical axis will move to the horizontal axis and vice versa.
Filter
A command that displays only the rows that meet a criteria.
Freeze Panes
A command that enables you to select one or more rows or columns and lock them into place; the locked rows and columns become separate panes.
Sort
A command that organize data in a particular order.
Hide
A command that removes information from view in a worksheet.
Cell Style
A defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.
A Watermark
A faded image or text used as a background of a document is ________. a. A draft b. An Imprint c. Alt-Text d. A Watermark
CSV
A file type that saves the contents of the cells by placing commas between them and an end-of-paragraph mark at the end of each row.
A table
Information stored in rows and columns is referred to as ________. a. A record b. An array c. A chart d. A table
Page Break Preview
The Excel View in which you can adjust paging in a worksheet.
TRIM
The ________ function removes extra blank spaces from a string of characters. a. LEFT b. TRIM c. MID d. RIGHT
LEFT
The ________ function returns the specified number of characters from the beginning of a string of characters. a. RIGHT b. LEFT c. FRONT d. MID
Paste
The action of placing cell contents that have been copied or moved to the Clipboard into another location.
Plot Area
The area bounded by the axes of a chart, including all the data series.
Chart Layout
The combination of chart elements that can be displayed in a chart such as a title, legend, labels for the columns, and the table of charted cells.
Print Titles
The command on the Page Layout tab that enables you to repeat column or titles when printing a long worksheet.
Move Chart
The command that moves a chart to a worksheet that contains only a chart and no other worksheet data.
Subtotal
The command that totals several rows of related data together.
Chart Area
The entire chart with all of its elements is called the ________. a. Chart Element b. Chart Object c. Chart Area d. Plot Area
Sort
The process of arranging data in a specific order based on the value in each field.
Filter
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.
Conditional Formatting
A format that changes the appearance of a cell—for example, by adding cell shading or font color—based on a condition; if the condition is true, the cell is formatted based on that condition, and if the condition is false, the cell is not formatted.
Number Format
A specific way in which Excel displays number in a cell.
Countif
A statistical function that counts the number of cells within a range that meet the given condition and that has two arguments—the range of cells to check and the criteria.
Sparkline
A tiny chart in the background of a cell that gives a visual trend summary alongside your data; makes a pattern more obvious.
Line
A type of chart that displays trends over time.
Pie
A type of chart that shows the relationship of each part to a whole.
Data Point
A value that originates in a worksheet cell and that is represented in a chart by a data marker.
A widely used file format developed by Adobe Systems that lets you create a representation of electronic paper that displays your data on the screen as it would look when printed.
Chart Sheet
A workbook sheet that contains only a chart.
Auto Fill
An Excel feature that generates and extends values into adjacent cells based on the values of selected cells.
Average
An Excel function that adds a group of values, and then divides the result by the number of values in the group.
Max
An Excel function that determines the largest value in a selected range of values.
Scale to Fit
Excel commands that enable you to stretch or shrink the width, height, or both, of printed output to fit a maximum number of pages.
Name Box
An element of the Excel window that displays the name of the selected cell, table, chart, or object.
Formula
An equation that performs mathematical calculations on values in a worksheet.
Hyperlink
Colored and underlined text that you can click to go to a file, a location in a file, a webpage on the Internet, or a webpage on your organization's intranet.
Properties
Details about the Excel workbook that describe or identify the file, including the title, author name, subject, and keywords that identify the file's topic or contents, are called ________. a. Properties b. Identifiers c. Documents d. Shared Information
Get External Data
On the ribbon, on the Data tab, use commands in the ________ group to bring data from outside Excel into an Excel worksheet. a. Analysis b. Connections c. Data Tools d. Get External Data
Add Shape Below
To add a shape to a lower level of an organization chart, right-click the shape, click Add Shape, and then click ________. a. Add shape below b. Add Shape Above. c. Add Shape Before. d. Add Shape After.
Import
To bring data from other sources into Excel you ________ the data. a. Limit b. Export c. Query d. Import
Line
To display trends over time, use a ________ chart. a. Bar b. Column c. Pie d. Line
Protection
To prevent others from altering the formulas or changing other template components, you should use __________.
an Error Value
Tracer arrows are red if a cell contains:
Convert to Range
When you click the ________ button, the filtering arrows are removed from the cells, but the color and formatting of the table style remain. a. Convert to table b. Available Windows c. Convert to Range d. Get External Data
Absolute
When you use the fill handle to copy a formula across columns, cell references that should NOT change must be ________. a. Relative b. Constraint c. Absolute d. Mixed
Process
Which of the following SmartArt graphic categories would be best to show a timeline? a. Process b. List c. Pyramid d. Cycle