Excel Test

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

relative cell reference

address of a cell based on the relative position of the cell that contains the formula and the cell referred to

AVERAGE function

adds group of values, then divides the result by the number of values in the group

formula

an equation that performs mathematical calculations on values in 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 being true or false

cell content

anything typed into a cell

number value

constant value consisting of only numbers

general fund

describe money set aside for the normal operating activities of a government entity such as a city

workbook

excel file that contains one or more worksheets

statistical functions

excel functions such as average, that are useful to analzye a group of measurements

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

logical functions

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

row

horizontal group of cells in a worksheet

constant value

information such as numbers, texts, dates, or times of day that you type into a cell

cell

intersection of a column and a row

sheet tabs

labels along the lower border of the excel window that identify each worksheet

max function

largest value in a range

SUM function

predefined formula that adds all the numbers in a selected range

function

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

what-if analysis

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

NOW function

retrieves and then displays the date and time from your computer

order of operations

rules for performing multiple calculations within formula

bevel

shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled

pie chart

shows relationship of each part of a whole

fill handle

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

Min function

smallest value in a range

comparison operators

symbols that evaluate each value to determine if it is the same (=), greater than (>), less than (<) or in between a range of values as specified by the criteria

data

text or numbers in a cell that are not a formula

sparklines

tiny charts embedded in a cell that give a visual trend summary alongside your data

column

vertical group of cells in a worksheet

chart sheet

workbook sheet that contains only a chart

COUNTIF function

a statistical function that counts the number of cells within a range that meet the given condition and which has two arguments - range of cells to check and the criteria

spreadsheet

another name for a worksheet

conditional format

format that changes the appearance of a cell based on a condition

MEDIAN function

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

chart

graphic representation of data in a worksheet

absolute reference cell

refers to cells by their fixed position in a worksheet


Kaugnay na mga set ng pag-aaral

Information Technology Project Management Mid Term

View Set

APUSH Chapter 13-17 Exam questions

View Set

Insurance exam review 9. Life Insurance

View Set

Chapter 21: Care of the Normal Newborn

View Set

International Business Final Exam

View Set

Unit 1: Sexuality -STI HPV (Human Papillomavirus)

View Set

5.4.2 Standard Deviation and Variance

View Set

Health Assessment - Chapter Nineteen

View Set