Go! 15/16

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

data marker

column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point; related data points form a data series

freeze panes

command that enables you to select one or more rows or columns and freeze (lock) them into place; the locked rows and columns become separate panes

merge & center

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

autofit

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

auto fill

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

workbook

Excel file that contains one or more worksheets

average function

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

max function

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

min function

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

median function

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

function

a formula that Excel has already built for you that performs calculations by using specific values in a particular order or structure

logical test

any value or expression that can be evaluated as being true or false

autosum

button that provides quick access to the SUM function

absolute cell reference

cell reference that refers to cells by their fixed position in a worksheet

legend

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

formula

equation that performs mathematical calculations on values in a worksheet

if function

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

chart

graphic representation of data in a worksheet; data presented as a chart is usually easier to understand than a table of numbers

x-axis

horizontal (category) axis

row

horizontal group of cells in a worksheet

cell

intersection of a column and a row

sum function

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

worksheet

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

process of arranging data in a specific order based on the value in each field

what-if analysis

process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet

scaling

process of shrinking the width and/or height of printed output to fit a maximum number of pages

data series

related data points represented by data markers; each data series has a unique color or pattern represented in the chart legend.

data point

value that originates in a worksheet cell and that is represented in a chart by a data marker

y-axis

vertical (value) axis


Set pelajaran terkait

Chemistry LearnSmart Chapter 10 - CH 125

View Set

Biology Unit 9 Quiz 1: Principals of Ecology

View Set

Іспит міжнар відносини і світова політика

View Set

2.1 Cell Checkpoint (Richardson)

View Set

Pass point/ Quiz questions Adult Exam I

View Set