excel Ch. 2

Ace your homework & exams now with Quizwiz!

Comma style format

which can be assigned to a range of cells by clicking the Comma style button, inserts a comma every three positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredths.

condition

which is made up of two values and relational operator, is true or false for each cell in the range.

values version

which shows the results of the formulas you have entered rather than the resulting values.

Accounting Number Format

with a dollar sign to the left of the number, inserts a comma every three positions to the left of the decimal point.

formula

you can assign a formula to a cell, and Excel will calculate the result.

spell checker

you can use to check a worksheet for spelling errors.

Range Finder

use Range Finder to check which cells are referenced in the formula assigned to the active cell.

fixed dollar sign

when you use accounting number format button to assign the accounting number format, Excel displays a fixed dollar sign to the far left cell, often with spaces between it and the first digit.

formulas version

Excel also can display and print the formulas version of the worksheet, which shows the actual formulas you have entered, rather that the resulting values.

MAX function

Excel includes a function called the MAX function that displays the highest value in range.

functions

Excel includes prewritten formulas called functions to help you compute a range of values and statics.

conditional formatting

Excel lets you apply formatting that appears only when the value in a cell meets conditions that you specify. you can apply conditional formatting to a cell, a range of cells, the entire worksheet, or the entire workbook.

circular reference

a formula in a cell that contains a reference back to itself is called a circular reference.

point mode

allow you to select cells for use in a formula by using the mouse.

Page Layout view

allows you to create or modify a worksheet while viewing how it will look in printed format.

margins

are those portions of a printed page outside the main body of the printed document and always are blank when printed.

relative cell references

if you copy across, then excel adjusts the column portion of cell references. these cell references are called relative cell references.

blank cell

in Excel has a numerical value of zero, which would have resulted in an error message.

pixel

is a dot on the screen that contains a color.

theme

is a predefined set of colors, fonts, chart styles, cell styles, and fill effects can be applied to an entire worksheet.

hiding cells

is a technique you can use to hide data that might not be relevant to a particular report or sensitive data that you do not want to see.

header

is common content that prints on every page of a worksheet.

debugging

is the process of finding and correction errors in the worksheet.

best fit

means that the width of the column will be increased or decreased so the t the widest entry will fit in the column.

order of operations

moving from left to right in a formula, the order of operations is as follows: first negation (-), then all percentages (%), then all exponentiations (^), then all multiplications (*) and divisions (/) and finally all additions (+) and subtractions (-).

AVERAGE function

sum the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range C4:C12

asterisk

the asterisk (*) following d4 is the arithmetic operator that directs Excel to perform the multiplication operation.

Normal view

the default view that you have worked in up until this point in the book is called normal view.

equal signs

the equal sign (=) preceding d4*e4 alerts excel that you are entering a formula or function and not text.

arguments

the values that you use with a function are called arguments.

floating dollar sign

to assign a floating dollar sign that appears immediately to the left of the first digit with no spaces, use the Currency style.

MIN function

to determine the lowest number in the range.


Related study sets

ถาม-ตอบ พรบ ศุลกากร ชุดที่ 1

View Set

Health Law Concepts and Compliance - Ch 3

View Set

Chapter 19: PrepU - Conditions Existing Before Conception

View Set

Lesson 2 The First Global Economic Systems

View Set

RN Fundamentals content mastery practice test

View Set

Chapter 2 Test Psychological Assessments

View Set

Intermediate Accounting - Chapter 3 SB

View Set

Cellular adaptation, injury and death

View Set