EXCEL: Formulas, Functions, and Formatting

Ace your homework & exams now with Quizwiz!

function

A _____ is a prewritten formula that is built into excel.

condition

A _____ is made up of two values and a relational operator.

zero

A blank cell in Excel has a numerical value of _____ .

equal sign

An _____ alerts excel that you are entering a formula or function and not text.

Range Finder

An easy way to verify that a formula references the cells that you want it to reference is to use excel's _____ .

conditional formatting

Formatting that appears only when the value in a cell meets specific conditions is called _____ .

multiplication

In the formula: =A4/B4+C5-D5*E6 the _____ operation is performed first.

100

The Percent style button is used to display a value determined by multiplying the cell by _____, rounding the result to the nearest percent, and adding a percent sign.

comma

The _____ Style format inserts a comma every three positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredths.

Adjust to

The _____ box allows you to specify the percentage of reduction or enlargement in the printout of a worksheet.

Auto Fill Options

The _____ button gives options for how to fill cells following a fill operation.

Trace Error

The _____ button lists error-checking options following the assignment of an invalid formula to a cell.

fixed

The _____ dollar sign displays to the far left in a cell.

average

The _____ function sums the numbers in the specified range and then divides the sum by the number cells with numeric values in the range.

formulas

The _____ version of a worksheet show the actual formulas.

*

The arithmetic operator for multiplication is _____ .

min

Use the _____ function to determine the lowest number in a range.

max

Use the _____ function to display the highest value in a range.

arguments

Values used with a function are called _____ .

0

When you decrease a column width to _____ , the column is hidden.

Greater than

Which of the following is a valid conditional formatting operator found in the New Formatting Rule dialog box?

comma style format

which can be assigned to a range of cells by clicking the comma style botton inserts a comma every three position to the left of teh deimal point and causes number to be displayed to teh nearest hundredths

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

asterisk

following d4 is the arithmentic operator that directrs excel to perform the multiplicationpoeration

relative cell references

if you copy across then excel asjusts the colum portion of celll references

blank cell

in excel has a munerical value of zero

pixel

is a dot on the screen that contains a color

theme

is a predifined set of colors fonts charts styles cell styles and fill effects that can entries within their respective colums improves the appearance of the worksheet

recalculates

Every time you enter a value into a cell in the worksheet, Excel _____ all formulas.

#REF!

Excel displays which of the following for an invalid reference?

18.5*B4

The formula _____ multiples the contents of cell B4 by 18.5.

order of operations.

The order in which calculations are performed in a formula is called the _____ .

debugging

The process of finding and correcting errors in a worksheet is called _____ .

Ctrl+Accent Mark

To display your worksheet in formula view, press _____ .

four-digit years

To ensure that Excel interprets year values the way you intend, use _____ .

parentheses

To override the order of operations, use _____ .

F8

To select a range using the keyboard, press the _____ key and then use the arrow keys.

Range Finder

To verify that a formula contains the intended cell references, use Excel's _____ .

Point mode

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

Hiding

_____ cells is a technique you can use to hide data that might be sensitive or not relevant to a report.

Best fit

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

circular reference

a formula in a cell that contains a refernce back to itself

hidding cells

is a technique you can use to hide data that might not ve relevant to a particular report or senitive data that you do not want others to see

order of operation

is as follows first negation(-) then all percentages (%) then all exponentiations(^) then all multiplications(*) and divisioin(/) and finally all addition(+) and subtractino(-)

header

is common content that prints on every page of a worksheet

debugging

is the process of finding a correcting errors in the worksheet

formuals version

of teh worksheet which shows the actual formuals you have entered rather than teh resulting values

values version

of the worksheet which shows the results of the formuls you have entered rather than the actual formuals

floating dollar sign

that appears immeiately to the left of the first digit eith no spaces use the currency style

normal view

the defualt view tht you have worked in up until this point in the book

fixed dollar sign

to the far left in teh cell often with spaces between it and the first digit

accounting number format

with a dollar sign to the left of the munber inserts a common every three position to the left of the deciamal point and displays numbers to the nearest cent

spell checker

you can use the check a worksheet for spelling errors


Related study sets

Employee Benefits sem 1 financial math EDG

View Set

Arranging a Marriage in India Reading Guide

View Set