Excel Chapter 1-2 Questions

If a cell contains =$N$21 and two new columns are inserted in front of column N and three rows are inserted above row 21, what happens to the =$N$21?

It becomes =$P$24

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

January Payroll Information

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

MIN

What is not a direct option on the AutoSum drop down menu?

Median

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

Status Bar

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

The file size

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

false

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

group the worksheets

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

true

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

New workbooks typically contain how many worksheets?

1

The ROUND function requires how many arguments?

2

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 would not be considered text?

=2*2

Which of the following would not give the same result for "=(5+32+75+21)/4"?

=AVERAGEIF(5+32+75+21,4)

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

Absolute

Which of the following is not one of the recommendations when first designing a spreadsheet?

Estimate the amount of time required to complete the spreadsheet

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

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

False

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

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

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

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

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

False

Use the Find command to jump to a cell that is not currently visible.

False

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

False

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

False

Where is the Show Formulas command found?

Formula Auditing group on the formulas tab

The default number format is ________.

General

Which of the following is not a category of functions?

Graphing

Which of the following is not a valid Cell Style?

Heading 3

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.

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

In the Page Layout tab, Scale to Fit group, select Automatic in the Width drop-down box

Functions can be selected by using the ________.

Insert Function dialog box

Which of the following is not a valid lookup function? P

LLOOKUP

Which status bar statistic can you not enable?

Range Name

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

Transpose

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

All IF functions have three arguments.

True

Bottom Align is the default vertical alignment.

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

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

Your column is not wide enough

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

date( )

Excel stores dates as numbers with 0 being 0 CE according to the Gregorian calendar.

false

FV is a required argument in the PMT function.

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 want to unmerge cells you click the Unmerge alignment option.

false

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

false

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

false

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

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

How is text aligned by default?

left

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

median

What is not a direct option on the AutoSum drop down menu?

median

What describes a function's purpose?

name

How many functions does Excel provide?

over 400

Which of the following is not considered an Excel element?

print preview box

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

set margins

What can you not do directly from the Backstage, Print screen view?

switch to formula view and print formulas

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

All IF functions have three arguments.

true

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

true

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

true

It is relatively easy to copy Excel cells into other Office programs.

true

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

true

Using Alt + Enter is a text wrapping option.

true

You could use both as the test in an IF function and get the same results. You would just switch the second and third arguments.

true

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

use the merge and center alignment

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

true

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

=SUM(A4/A11)

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

Which of the following is not a valid keystroke for navigating around a worksheet?

Alt + Up arrow

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

COUNTA

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

Cell Protection

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(,)

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

Cut the range, then use the Paste Special option called transpose

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 copy and pasted three columns over and two rows down, what would the resultant cell reference become?

E$14

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

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

False

Where can you find more alignment options?

Format cells dialog box

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

Formatting

What is not one of the tabs in Excel?

Mailings

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

Order of Operations

What is the default method of referencing cells in formulas?

Relative

What actually changes the value Excel stores to a user determined number of decimal places?

Round function

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

Square Brackets [ ]

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

True

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

True

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

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

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

Use the fit to option

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)

Adding color to cells is not considered a professional design strategy.

false

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

false

Besides the Page Setup dialog box, where else can you create headers or footers?

Insert tab, Text group, Header & Footer

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

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

Using Alt + Enter is a text wrapping option. T or F

True

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

Value if neither true or false