Excel Chapter 2, Excel Chapter 1, Microsoft Word Review

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

Placeholder text

Non-printing text that holds a place in a document where you can type.

Constant Value

Numbers, text, dates, or times of day that you type into a cell

Center alignment

The alignment of text or objects that is centered horizontally between the left and right margin.

Numbered row headings

The area along the left edge of a worksheet that identifies each row with a unique number

Active cell

The cell, surrounded by a black border, ready to receive data or be affected by the next Excel command

Chart layout

The combination of chart elements that can be displayed in a chart such as the title, legend, labels for the columns and the table of charted cells.

Underlying value

The data that displays in the formula bar

Line spacing

The distance between lines of text in paragraph.

Chart

The graphic representation of data in a worksheet. It is usually easier to understand than a table of numbers.

Cell

The intersection of a column and a row

Sheet tabs

The labels along the lower border of the Excel window that identify each worksheet

Sheet tabs

The labels along the lower border of the workbook window that identify each worksheet.

Column heading

The letter that displays at the top of a vertical group of cells in a worksheet

Chart style

The overall visual look of a chart in terms of its graphic effects, colors, and backgrounds

Alignment

The placement of paragraph text relative to the left and right margins.

Worksheet

The primary document that you use in Excel to work with and store data, and which is formatted as a pattern of uniformly spaced horizontal and vertical lines

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.

Fill handle

The small black square in the lower right corner of a selected cell

Margins

The space between the text and the top, bottom, left, and right edges of the paper.

Select all box

A box in the upper left corner of the worksheet grid that, when clicked, selects all of the cells in a worksheet

Chart elements button

A button that enables you to add, remove, or change chart elements such as the title, legend, gridlines, and data labels

Chart Filters button

A button that enables you to change which data displays in the chart.

Chart styles button

A button that enables you to set a style and color scheme for your chart

Data bar

A cell format consisting of a shaded bar that provides a visual cue to the reader about the value of a cell relative to the other cells; its length represents the value in the cell.

Absolute Cell Reference

A cell reference that refers to cells by their fixed position in a worksheet. It remains the same when the formula is copied

Legend

A chart element that identifies the patters or colors that are assigned to the categories in the chart

Column chart

A chart in which the data is arranged in columns and that is useful for showing how data changes over a period of time or for illustrating comparisons among items

Increase indent

A command moves your paragraph farther away from the margin.

Freeze Panes

A command that enables you to select one or more rows or columns and lock them into place.

Merge & Center

A command that joins selected cells in an Excel worksheet into one larger cell and centers the contents in the merged cell.

Decrease indent

A command that moves your paragraph closer to the margin.

Find and replace

A command that searches the cells in a worksheet, or selected range, for matches and then changes each match to the value of your choice.

Cell Style

A defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading

SmartArt

A designer-quality visual representation of your information that you can create by choosing from among many different layouts to effectively communicate your message or ideas.

MEDIAN Function

An Excel function that finds the middle value that has as many values above it in the group as are below it.

NOW Function

An Excel function that retrieves the date and time from your computer's calendar and clock and inserts the information into the selected cell.

Left Alignment

An arrangement of text in which text aligns at the left margin, leaving the right margin uneven.

Right alignment

An arrangement of text in which the text aligns at the right margin, leaving the left margin uneven.

Justified alignment

An arrangement of text in which the text aligns evenly on both the left and right margins.

Formula Bar

An element in the Excel window that displays the value or formula contained in the active cell

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

Inline Object

An object or graphic inserted in a document that acts like a character in a sentence.

Cell address

Another name for a cell reference

Spreadsheet

Another name for a worksheet

X-axis

Another name for the horizontal (category) axis

Y-axis

Another name for the vertical (value) axis

Cell content

Anything typed into a cell

Accounting Number Format

Applies a thousand comma separator, a fixed U.S. dollar sign, applies two decimal places, and leaves a small amount of space at the right edge of the cell to accommodate a parenthesis for negative numbers.

Conditional format

A format that changes the appearance of a cell - for example, by adding cell shading or font color - based on a criteria; if the criteria is true, the cell is formatted, and if the criteria is false, the cell is not formatted.

IF Function

A function that uses a logical test to check whether a condition is met, and then returns one value if true and another value if false.

Floating object

A graphic that can be moved independently of the surrounding text characters.

Logical functions

A group of functions that test for specific conditions and that typically use conditional tests to determine whether specified conditions are true or false.

Series

A group of things that come one after another in succession; for example, January, February, March, and so on

Row

A horizontal group of cells in a woksheet

Bulleted list

A list of items with each item introduced by a symbol such as a small circle or check mark, and which is useful when the items in the list can be displayed in any order.

Numbered list

A list that uses consecutive numbers or letters to introduce each item in a list.

Text Box

A moveable resizable container for text or graphics.

SUM Function

A predefined formula that adds all the numbers in a selected range of cells

SUM function

A predefined formula that adds all the numbers in a selected range of cells

Function

A predefined formula that performs calculations

Theme

A predefined set of colors, fonts, lines and fill effects that coordinate with each other

Dot Leader

A series of dots preceding a tab that guides the eye across the line.

Spin box

A small box with an upward and downward pointing arrow that lets you move rapidly through a set of values by clicking.

Tab

A specific location on a line of text, marked on the Word ruler, to which you can move the insertion point by pressing the Tab key, and which is used to align and indent text.

COUNT

A statistical function that counts the number of cells in a range that contain numbers.

COUNTIF Function

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.

Rotation Handle

A symbol with which you can rotate a graphic to any angle; displays above the top center sizing handle.

Volatile

A term used to describe and Excel function that is subject to change each time the workbook is reopened. Example: NOW Function

Sparkline

A tiny chart in the background of a cell that gives a visual trend summary alongside your data; makes a pattern more obvious

Column

A vertical group of cells in a worksheet

Print Titles

An Excel command that enables you to specify rows and columns to repeat on each printed page.

AutoFit

An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column

Auto Fill

An Excel feature that generates and extends values into adjacent cells based on the values of selected cells.

Workbook

An Excel file that contains one or more worksheets

AVERAGE Function

An Excel function that adds a group of values, and then divides the result by the number of values in the group.

MAX Function

An Excel function that determines the largest value in a selected range of values.

MIN Function

An Excel function that determines the smallest value in a selected range of values.

Format

Changing the appearance of cells and worksheet elements to make a worksheet attractive and easy to read

Nonprinting characters

Characters that display on the screen, but do not print; also called formatting marks.

Criteria

Conditions that you specify in a logical function.

Split

Cuts the window into multiple resizable panes so that you can view multiple distant parts of your worksheet at one time.

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.

Statistical Functions

Excel functions, including the AVERAGE, MEDIAN, MIN, and MAX functions, which are useful to analyze a group of measurements.

Artistic effects

Formats applied to images that make pictures resemble sketches or paintings.

Picture effects

Formatting that enhances a picture with effects such as a shadow, glow, reflection, or 3-D rotation.

Picture Styles

Frames, shapes, shadows, borders, and other special effects that can be added to an image to create an overall visual style for the image.

AutoComplete

If the first few characters you type in a cell match an existing entry in the column, Excel fills in the remaining characters for you.

Shapes

Lines, arrows, stars, banners, ovals, rectangles, and other basic shapes with which you can illustrate an idea, a process, or workflow.

Layout Options

Picture formatting options that control the manner in which text wraps around a picture or other object.

Graphics

Pictures, charts, or drawing objects.

Flash Fill

Recognizes a patter in your data and then automatically enters in values based on examples of the output you want.

Data series

Related data points represented by data markers

Data

Text or numbers in a cell

Bullets

Text symbols such as small circles or check marks that precede each item in a list.

Comma style

The Excel number format that inserts thousand comma separators and applies two decimal places

Paste

The act of placing cells contents that have been copied or moved to the Clipboard into another location.

Drag and drop

The action of moving a selection by dragging it to a new location.

Range

Two or more selected cells on a worksheet that are adjacent or nonadjacent


Set pelajaran terkait

Life Insurance - Review Overall Test Prep Questions Missed

View Set

SCM 421 Topic 5: Sourcing Risk Management and Mitigation

View Set

CH. 14 Understanding individual behavior

View Set

Elsevier Saunders NCLEX PN - 8th Edition - Pharmacology

View Set

Physical Science Chapter 11 Sections (1-3)

View Set

CIS 288 Fundamentals of Cybersecurity

View Set

Chapter 51: Assessment and Management of Patients With Diabetes

View Set