computer science ch. 1-2

What error will you get if you type a function name incorrectly?

#NAME?

What will you see if you enter the TODAY function without the parenthesis?

#NAME?

Which of the following is not a valid number format?

$-1,000.00

If the cell reference $A5 in a formula is copied and pasted over two columns and down two rows from its original cell, what the cell reference become in the new cell?

$A7

In the formula, -1+(2-3)+5/6-6^2, what will Excel evaluate first?

(2-3)

Which of the following would not be considered text?

-2*2

New workbooks typically contain how many worksheets?

1

One point is how big?

1/72 of an inch

The ROUND function requires how many arguments?

2

In military time, 15:00 is ________ in non-military time.

3:00 PM, 3 PM, 3 P.M.

If you will be paying monthly for six years to pay off a car, then you would enter ________ in the NPER argument in the PMT function.

6*12, 72

In the formula, -1+(2-3)+5/6-6^2, what will Excel evaluate second?

6^2

Which of the following is not a valid formula?

=#12/31/2014#-#12/31/2015#

If a cell containing the formula =$B$14 is not copy and pasted, but moved four columns over and four rows down, what would the resultant cell reference become?

=$B$14

Which of the following is not a valid logical test?

=>

Which of the following is not a valid =IF statement?

=IF(A5>19,Greater,Not Greater)

If A7=21, which of the following =IF statements would produce the result of "Much Greater"?

=IF(A7<14,"Greater",IF(A7>20,"Much Greater","Not Greater than 20"))

Which of the following would not produce the correct monthly payment on a loan of $13,000 which will be paid off in 5 years with an annual interest rate of 6%?

=PMT(6%,60,-13000)

Which of the following does not comply with the preferred way of using the SUM function?

=SUM(A4/A11)

I. COUNT II. COUNTA III. COUNTBLANK IV. IF V. NPER A. Only uses calculable values B. Evaluates true and false statements C. Includes text, but not blank cells D. Length of time you will be paying on a loan E. Only includes empty cells

A, C, E, B, D

I. Paste Special II. Transpose III. Flash Fill IV. Accounting number format V. Currency number format A. Opens a gallery of options for pasting B. Puts the $ at the left margin of the cell C. Flips rows and columns when pasted D. Puts the $ next to the leftmost number E. Fills in data based on previous column's data

A, C, E, B, D

I. Zoom control II. Workbook III. Worksheet IV. Sheet tab V. Cell A. Makes the text on the screen smaller or larger B. Contain labels, values and formulas C. The intersection of a column and a row D. Shows the name of the worksheet E. The same as a spreadsheet

A, E, B, D, C

Which is not a valid range?

A1:A3, B1:B3

Which of the following is not a valid test in an =IF statement?

A4-B4

What two functions compute the central tendency of values?

AVERAGE and MEDIAN

If you wanted to reference a cell in a formula and you did not want that cell to change when copying and pasting you would use what kind of reference?

Absolute

The ________ feature displays any values in the column that match what the user has typed so far.

AutoComplete

The ________ feature helps you complete an incremental series.

Autofill

I. Values II. Picture III. Paste Link IV. Linked Picture V. Paste A. A reference to the cells, not the cell contents B. Unformatted results of formulas C. Cell contents and all formatting D. A non-editable copy of your data E. Changes if the content changes

B, D, A, E, C

I. =A54 II. =$A54 III. =$A$54 IV. =SUM(A54:B97) V. "Ohio" A. Function B. Relative reference C. Ensures text entry D. Mixed reference E. Absolute reference

B, D, E, A, C

I. Name Box II. Order of operations III. Formula IV. Fill handle V. Pointing A. Always begins with an equals sign (=) B. Small green square used to perform various actions C. Displays the address of the active cell D. Also known as semi-selection E. PEMDAS

C, E, A, B, D

I. Median II. Average III. Sum IV. Table array V. Breakpoint A. Total B. Lowest value in a series C. Midpoint value D. Range used for looking up values E. Arithmetic mean

C, E, A, D, B

I. Normal view II. Page Layout view III. Page Break Preview IV. View controls V. Sheet tab navigation A. Displays data and page breaks B. Allows you to go to the first, previous, next, or last sheet in a workbook C. Does not display margins or page breaks D. Icons that let you change views E. Displays data and margins

C, E, A, D, B

I. XFD II. Range III. Value IV. Semi-selection V. Text A. A measurable amount B. Also called pointing C. The last possible column in a worksheet D. A combination of letters not used in calculations E. A group of cells selected at the same time

CEABD

If you wanted to count the number of entries in a list that contained numbers, text, and blank cells, but ignore the text and blank cells, which function would you use?

COUNT

The ________ function counts the number of calculable values, but ignores cells that have text or are empty.

COUNT

Which function would you use if you wanted to count the number of values, but ignore cells that have text or are empty?

COUNT

What punctuation is used to separate the two cell references in a range?

Colon (:)

What do you use to separate arguments in a function?

Comma (,)

I. Formula AutoComplete II. Quick Analysis III. Function ScreenTip IV. Logical test V. Syntax A. Can be used to apply formatting and insert basic functions B. Pop-up description C. A set of rules D. Matches letters as you type E. Evaluates to True or False

D, A, B, E, C

I. Enter II. Cancel III. Status bar IV. Zoom control V. Formula bar A. Reverts back to previous data B. Shows the contents of the active cell C. Displays information about a command or operation as it is being performed D. Accepts the data E. Allows you to see more or less on the screen at one time

D, A, C, E, B

I. Absolute cell references II. Relative cell references III. Mixed cell references IV. Argument V. Function A. Part of it changes when you copy and paste a formula B. Changes when you copy and paste a formula C. Simplifies complex calculations D. Does not change when you copy and paste a formula E. Required input in a function

D, B, A, E, C

I. =???(B7>9,"Bigger","Smaller") II. =???(12%/12,360,-120000) III. =???(A4,B4:F9,2) IV. =???(B9:E21) V. =???() A. NOW B. PMT C. VLOOKUP D. IF E. SUM

D, B, C, E, A

Which of the following will not return the system clock's date?

DATE()

What does the AVERAGE function not ignore?

Dates

If a cell containing =B$14 is copied and pasted three columns over and two rows down, what would the resultant cell reference become?

E$14

I. Right arrow II. Page Down III. Home IV. End V. Ctrl + Home A. Moves active cell down one screen B. This does nothing by itself C. Moves active cell to column A, row 1 D. Moves active cell to column A in that row E. Moves right one cell in the same row

E, A, D, B, C

I. VLOOKUP II. HLOOKUP III. Lookup table IV. Lookup value V. Column index number A. Data is organized in rows B. Column that contains the return values C. Cell that contains the value to be looked up D. Has the data used with HLOOKUP or VLOOKUP E. Data is organized in columns

E, A, D, C, B

I. AutoComplete II. Auto Fill III. Column heading IV. Row heading V. Alignment A. The letter in the cell reference "F4" B. Helps complete a logical sequence C. The number in the cell reference "F4" D. Refers to how data are positioned in the boundaries of a cell. E. Matches the letters you type to another value in the column if the letters match

E, B, A, C, D

I. NOW() II. TODAY() III. PV IV. RATE V. PMT A. Current amount of a loan B. Helps figure out how much a loan will cost each month C. A good example is interest D. Returns the system date E. Returns the system date and time

E, D, A, C, B

Which keyboard shortcut puts the user in cell edit mode?

F2

Which keyboard shortcut toggles through the types of reference options?

F4

What keyboard shortcut will automatically update any formulas using =TODAY() or =NOW()?

F9

The ________ feature can pull only part of a cell's value and place it into another cell.

Flash Fill, FlashFill

What Paste option would you choose if you wanted to maintain the formatting of the copied cell, but not its contents?

Formatting

Functions can be selected by using the ________.

Insert Function dialog box

Which of the following names of worksheet tabs would be best?

January Payroll Information

Which of the following is not a valid lookup function?

LLOOKUP

The ________ function finds the largest value in a range.

MAX

What function computes the value in which one-half of the data is above and one-half is below.

MEDIAN

The ________ function finds the smallest value in a range.

MIN

Which function would you use to find the oldest date in a range?

MIN

The ________ function is similar to the TODAY() function, except that it also returns the system time.

NOW(), =NOW()

What action changes the actual number of decimal places Excel stores instead of just changing what is displayed?

ROUND function

Which status bar statistic can you not enable?

Range Name

What does Excel use to indicate optional arguments in a function?

Square brackets []

Which Paste option would you choose if you wanted to flip the rows and columns?

Transpose

What is the best practice for centering a title over multiple columns?

Use the Merge and Center alignment

Which of the following is not an argument associated with the IF function?

Value if neither true nor false

________ can be used in calculations, whereas text cannot.

Values

Which Paste option would you choose if you wanted only the computed values to be pasted, but with all formatting intact?

Values & Source Formatting

What type of cell reference should be used when a value remains constant?

absolute

The current cell is also known as the ________ cell.

active

Cell ________ refers to how data are located within the boundaries of the cell.

alignment

The inputs in a function are specified by its ________.

arguments

What is the term for the inputs required in a function?

arguments

What feature in excel allows you to begin with a 1 in A1 and a 2 in A2 and complete the sequence through the number 30 and A30 without having to type in the entire sequence?

auto fill

A(n) ________ is a line you can put around a cell or range of cells for emphasis.

border

The ________ is the lowest value for a category in the table lookup table.

breakpoint, break point

The intersection between a column and a row is called a(n) ________.

cell

Which of the following is not included when you use a cell style?

cell protection

You should use ________ in formulas whenever possible instead of simply typing in numbers.

cell references

A(n) ________ is a collection of format characteristics that provides a consistent appearance within a worksheet and among similar workbooks.

cell style

Which of the following is not a way to widen a column?

click the column label and drag it to the right

In a lookup table, the number of the column which contains the return values is called the ________.

column index number

What do you adjust if you see ###### displayed in a cell?

column width

________ a carefully formatted worksheet can save you a lot of time when you need that formatting on another sheet.

copying

What is the best practice to switch the columns and rows in a range?

cut the range, the use the Paste special option called Transpose

The MIN and MAX functions can be used with ________ as well as numbers.

dates, variables, arguments, expressions

When you do not need the data on a worksheet you should ________ it to make the file smaller.

delete

FV is a required argument in the PMT function.

false

For the fill handle to work you need to have two cells selected.

false

If you do not need a row or column any more it is best to hide it instead of deleting it in case you change your mind.

false

If you omit the fourth argument in a VLOOKUP function, Excel will assume you intend the fourth argument to be False.

false

If you want to unmerge cells you click the Unmerge alignment option.

false

In Excel, columns are identified by numbers and rows by letters.

false

In the HLOOKUP function, the third argument is the column index number.

false

It is very important to sort the first column in a table lookup array in descending order.

false

Make sure to enter all cell reference in upper case when putting them in formulas.

false

The COUNTA function only counts text entries. It does not count calculable values or blank cells.

false

The COUNTBLANK function will count cells that contain formulas that compute to a value of zero (0).

false

The HLOOKUP function can only be used to find exact matches.

false

The PMT function uses three required arguments and no optional arguments.

false

The VLOOKUP function has four required arguments.

false

The cell at row 4 and column B, would be identified as 4B.

false

The contents of a cell can be seen in the Name box.

false

The row height should be the same size as the front height.

false

The two optional arguments in the PMT function allows the function to be used with variable loans.

false

The wrap text feature will automatically move any text that does not fit in a cell to the cell directly below it.

false

There are rare occasions when both the second and third argument of an IF function are executed.

false

To look up an exact match, what should you enter in the range_lookup argument?

false

When cells are merged, the merged cell's address becomes the address of the range.

false

When entering functions, the square brackets, [], indicate required values.

false

When you copy and paste a range the relative references do not change.

false

When you insert rows or columns all relative references are updated but not any absolute references.

false

You cannot hide column A or row 1 because they cannot be unhidden.

false

The ________ color is what is visible behind the value in a cell.

fill

What is the small green square in the bottom right of a cell called?

fill handle

Where can you find more alignment options?

format cells dialog box

What can you not do within the worksheet tabs shortcut menu?

format the workhseet

Number ________ controls how a value appears in a cell.

formatting

The ________ feature in Excel displays various options when you type an equal (=) sign and then begin typing a function name.

formula autocomplete, formula auto complete

Using ________ simplifies adding complex mathematical formulas to a cell.

functions, a function

The default number format is ________.

general

Which of the following is not a category of functions?

graphing

The best way to apply Page Setup options to multiple worksheets is to ________.

group the worksheets

What should you do if there are columns you need, but do not want to display?

hide the columns you do not want to display, then unhide them when finished

Shifting a cell's contents to the right or left to help it stand out from the row above or below is known as ________.

indenting

The ________ area is where you store the variable you will be using in the worksheet.

input

Which of the following is not true of the formula bar?

it allows you to pick from an assortment of formulas

Which of the following is not true about a fill color?

it cannot be applied to an entire row or column

What is true about an input area?

it is used when certain values are used repeatedly throughout the worksheet.

How is text aligned by default?

left

When you use the VLOOKUP function, the ________ column in the array is used to look up the value.

left, first

What describes a function's purpose?

name

It is called a(n) ________ function when a function is used inside of another function.

nested

A(n) ________ range contains multiple ranges that are not positioned in a contiguous cluster in the worksheet.

nonadjacent

What can the phrase "Please Excuse My Dear Aunt Sally" help you remember?

order of operations

The ________ area contains the formulas which are dependent on values found elsewhere in the sheet.

output

The ________ area is designed to contain formulas which are dependent on values in the input area.

output

In the PMT function, the PV argument refers to the ________ of the loan.

present value

The TODAY() and NOW() functions are updated every time you open or ________ the spreadsheet.

print

The ________ feature allows you to see how a document would print before you actually print it.

print preview

_______ tool is a set of analytical tools that appears when you select a range.

quick analysis

A(n) ________ is a group of cells which have been selected at the same time.

range

If the annual interest rate is 12% and payments are made monthly, then you would enter .01 in the ________ argument in the PMT function.

rate

What is the default method of referencing cells in formulas?

relative

________ references change when formulas are copy and pasted.

relative, mixed

The ________ function actually changes the number of decimal places in the value.

round

Which Excel function changes the value to a desired number of decimal places?

round

Using ________ often decreases the amount of time it takes to enter cell references in formulas.

semi-selection, semi selection

When working with dates, Excel actually assigns ________ numbers to each date.

serial

What can you not do from the Page Setup, Sheet tab?

set margins

A(n) ________ is a type of file that organizes data in rows and columns.

spreadsheet

Where does Excel automatically display statistics like count, average, and sum when a range of values is selected?

status bar

What can you not do directly from the backstage, print screen view?

switch to formula view and print formulas

A function's ________ defines the rules by which the function operates.

syntax

What term refers to the necessity of following the rules when it comes to using functions?

syntax

The range that contains the lookup table is called the ________.

table array

What would not be a typical item to have in a header or footer?

the file size

What does pressing the Enter key while in a cell, do?

the value is set, and the cell below becomes the active cell

A range is specified by its ________.

top left and bottom right cells

A good practice when entering function names is to type them in lowercase and see if Excel converts them to upper case.

true

A lookup table should contain at least two rows and two columns, not counting headings.

true

Adding color to cells is considered a professional design strategy.

true

All IF functions have three arguments.

true

Bottom Align is the default vertical alignment.

true

Displaying cell formulas can help find errors in formulas more easily.

true

Excel assigns date number 1 to January 1, 1900.

true

Functions can be nested inside the arguments in the various lookup functions.

true

If you are looking up exact values in a lookup table then it does not matter how the table is sorted.

true

If you will never copy and paste a formula you do not have to be concerned about absolute, relative, or mixed references.

true

In a mixed reference you can put the dollar sign ($) in front of the column or row indicator.

true

It is acceptable to use values in formulas when you know those values will never change.

true

It is always a good practice to test each formula you enter for accuracy.

true

It is relatively easy to copy excel cells into other office programs.

true

Right-clicking a column heading, then selecting Insert, will add a new column to the left of the current column.

true

The default calculation using the PMT function will produce a negative number.

true

The fill handle allows you to copy and paste formulas to adjacent cells.

true

The most used logical function is the IF function.

true

The test in an IF function must evaluate to either a True or a False.

true

This is a valid way to use the MAX function: =MAX(a4:d11, f1:f2)

true

Using Alt + Enter is a text wrapping option.

true

You can hide or delete multiple rows or columns by using the Ctrl or Shift key and then selecting the rows or columns you want to hide or delete.

true

You can move a range by using the cut and paste commands.

true

You can select a range by using the name box.

true

You could use both A3>b9 or B9<A3 as the test in an IF function and get the same results. You would just switch the second and third arguments.

true

The test argument in an IF statement must evaluate to either ________.

true or false, false or true

What is the best way to make sure your worksheet prints on only one page?

use the fit to option

A(n) ________ is a collection of one or more related worksheets.

workbook, spreadsheet

If you have too many words in a cell, but you cannot allow them to bleed over into the next cell, you would use the ________ feature in Excel.

wrap text

The ________ feature allows you to move some text to another line within the same row.

wrap text

What does it mean when you have ####### in a cell?

your column is not wide enough