COMP B5 - Excel Test

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

Freeze panes

A command that enables you to lock rows or columns in place

Conditional format

A format that changed the appearance of a cell based on a condition

Function

A predefined formula that performs calculations by using specific values in a particular order or structure

Formula

An equation that performs mathematical calculations on values in a worksheet

Workbook

An excel file that contains one or more worksheets

Spreadsheet

Another name for a worksheet

Cell address

Another name for cell reference

Value

Another name for constant value

Logical test

Any value or expression that can be evaluated as true or false

Cell content

Anything typed into a cell

Criteria

Conditions that you specify in a logical function

Number values

Constant values consisting of only numbers

Statistical functions

Excel functions, such as Average, that are useful to analyze a group of measurements

AVERAGE function

Function that adds a group of values then divides by the number of values in the group

COUNTIF function

Function that counts the number of cells within a range

MAX function

Function that determines largest value in a range

MIN function

Function that determines smallest value in a range

MEDIAN function

Function that finds the middle value

IF function

Function uses logical test to check whether condition is met, returns one value if true and another false

Logical functions

Functions that test for specific conditions, typically use conditional tests

Row

Horizontal group of cells in a worksheet

Cell

Intersection of a column and row

Sheet tabs

Labels that identify each worksheet

Constant value

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

SUM function

Predefined formula that adds all the numbers in the selected range

Comparison operator

Symbols that evaluate each other if it is the same

Data

Text or numbers in a cell

Chart

The graphic representation of data in a worksheet

Fill handle

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

Column

Vertical group of cells in a worksheet


Ensembles d'études connexes

MS2- Musculoskeletal- NCLEX-RN Book

View Set

Florida 2-40 health exam chapter 4

View Set

Chapter 19: Speed, Agility, and Quickness Training Concepts

View Set

Texas Principles of Real Estate 2 - Chp. 3 Real Estate Financing Principles

View Set

Common Birth Defects Practice questions

View Set

Ch 08: Security Strategies and Documentation

View Set

Religious pluralism and theology

View Set