Excel BIM I

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

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.

PDF

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


Kaugnay na mga set ng pag-aaral

Protestant reformation webquest and video analysis

View Set

ESC5 Lesson 6 Text Two - 狄晓晴

View Set

Maintaining a Healthy Body Composition and Body Image Assignment

View Set

Vistas 2, Chapter 9, ea-¿Qué? and ¿cuál? 1. Activity #98 Textbook, ¿Qué? and ¿cuál? Estructura 9.3

View Set

Myers Psychology 8e - Chapter 01

View Set

Chapter 1.2: How are our Ecological Footprints Affecting the Earth?

View Set

Toddlers/Preschoolers-Pediatric Nursing

View Set