Excel Chapter 2 Test Review

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

A(n) _______________________ sign is the arithmetic operator that directs Excel to perform the multiplication operation.

* asterick

If the following arithmetic operations all are found in a formula with no parentheses, which one is completed last?

+

Moving from left to right, the first calculation in the order of operations is ______________________.

- (negation)

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

AVERAGE

To start a new line in a cell, press the __________________ keys.

Alt + enter

_______________________ shows the actual formulas you have entered, instead of the resulting values.

Formula version

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

Page layout

To use Range Finder to verify that a formula contains the intended cell reference, double-click the cell containing the formula you want to check. (True or False)

True

When a formula is entered into a cell, Excel will calculate the result. (True or False)

True

_____________ shows the results of the formulas you have entered, rather than the actual formula.

Values version

The _____________ Number format inserts a comma every three positions to the left of the decimal point, and causes numbers to be displayed to the nearest hundredth.

comma

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

condition

Formatting that appears only when the value in a cell meats conditions that you specify is called ________________ formatting.

conditional

Pressing the ____________________ keys on the keyboard will display formulas on the worksheet instead of values.

ctrl + `

The ________________________________ Format displays numbers with a floating dollar sign to the immediate left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent.

currency number

You can enter functions _______________. a. with the keyboard or mouse b. with the insert function c. with the SUM menu d. all of the above

d. all of the above

The / arithmetic operator represents ________________.

division

To set the row height or column width to best fit, _____________ click the boundary of the row heading or column heading.

double

You should ______________ click a function name in the Formula AutoComplete list to select the function.

double

To alert that you are entering a formula and not text. type a(n) ___________________ preceding the formula.

equal sign (=)

The use of a __________ color in a cell or range of cells sets off the cell or range of cells sets off the cell or range from other portions of the worksheet by changing the background color of the cell.

fill

A ____________ dollar sign is displayed to the far left in the cell, often with spaces between it and the first digit.

fixed

To assign a dollar sign to appear immediately to the left of the first digit with no spaces, use a __________________________.

floating dollar sign

Typing =av in a cell and having AVEDEV, AVERAGE, etc. pop up displays the _______________________________ feature.

formula autocomplete

A(n) ______________ formula is a prewritten formula that is built into Excel.

function

Clicking the ________________ opens the Insert Function dialog box.

fx button to the left of the formula bar

Clicking the _______________________ button to the left of the formula bar opens the Insert Function dialog box-it allows you to create function formulas and learn more about Excel's functions.

insert function (fx)

The > (is, is not) a valid Excel arithmetic operator.

is not

The default view in Excel is ______________ view.

normal

You can choose a category in the ______________ tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear.

number

The order in which formula calculations are performed when there is more than one operator in the formula is called the ____________________________.

order of operations

You can use ______________________ to override the Order of Operations in order to calculate certain operators first - no matter how low on the Order of Operations they fall.

parentheses

The _______________ button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.

percent

A(n) ___________ is a measure of cell height and width.

pixel

To print a range of cells in the active worksheet, click _____________________ option in the Settings area in the Print gallery.

print section

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

range finder

When you copy a formula with relative cell references down a row, _____________________________.

row references change in formula

Excel has a(n) _____________ feature that allow you to check the worksheet for spelling errors.

spell checker

In the order of operations, the last operation Excel performs is ________________________.

subtraction

The ________ button menu allows you easy access to five often-used functions.

sum

A ____________ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects.

theme

___________________ Number Format displays numbers with a fixed dollar sign to the left of the number, inserts a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent. (hundredths place).

Accounting

When Excel follows the order of operations, the formula, 6 + 3 * 8, equals ______________.

30

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

Best fit

______________ is the process of finding and correcting errors in a worksheet.

Debugging

A condition for a cell can only be true or false. (True or False)

False

A style is a predefined set of colors, fonts, chart styles, and fill effects that can be applied to the entire workbook. (True or False)

False

In the formula = 4 * 6 - 8, the subtraction operation (-) is completed before the multiplication operation (*). (True or False)

False

Normal view is the default Excel view that allows you to create or modify a worksheet while viewing how it will look in the printed format. (True or False)

False

The Currency Style format cannot be used with a floating dollar sign. (True or False)

False

You can instruct Excel to display fewer decimals than are currently shown in the cell with the Increase Decimal Button. (True or False)

False

the order of operations works from right to left. (True or False)

False

Use the _______________ functions to display the highest value in a range.

MAX

The ______________ function is used to determine the lowest number in a given range.

MIN

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

Margins

Point mode allows you to create formulas more accurately and more quickly using the mouse to enter cell references. (True or False)

True

Currency Number format displays floating dollar signs in the selected number. (True or False)

True

Excel attempts to guess which cells you want to include in the function by looking for ranges that are touching or ____________________ to the selected cell and that contain numeric data.

adjacent

When Excel automatically sets the width of a column based on the widest entry in the column, it is called __________________.

best fit

Which of the following happens when you enter =G15 into a cell? a. Excel recalculates the worksheet b. Excel assigns the sum of the values in the previous 15 cells to the active cell c. Excel assigns the value in cell G15 to the active cell d. Nothing; =G15 is an invalid entry

c. Excel assigns the value in cell G15 to the active cell

You (can, cannot) format an entire column at once.

can


Kaugnay na mga set ng pag-aaral

ACCT 202 - Chapter 13 Learnsmart

View Set

unit 2.03, 2.04 and 2.05 test personal finance

View Set

Exam 1:Homeostasis, genetics, fluid and electrolyte disturbance, anemia, ABG, immunity NCLEX questions

View Set