Excel Chapter 1-2 Questions

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

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

Bottom Align is the default vertical alignment.

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

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

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

You can select a range by using the Name Box.

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

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

Which of the following is not a valid formula?

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

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

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

What is not one of the tabs in Excel?

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

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

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

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?

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

Excel assigns date number 1 to January 1, 1900.

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

What do you use to separate arguments in a function?

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

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

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

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

All IF functions have three arguments.

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

Functions can be selected by using the ________.

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

The default number format is ________.

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

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

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

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

Where can you find more alignment options?

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.

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

Which of the following is not considered an Excel element?

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

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

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

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

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

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

How many functions does Excel provide?

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

All IF functions have three arguments.

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%?

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.

The most used logical function is the IF function.

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?

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?

What is the default method of referencing cells in formulas?

What two functions compute the central tendency of values?

The VLOOKUP function has four required arguments.

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

Which is not a valid range?

Which of the following is not a valid number format?

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

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

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

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

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

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

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?

Which of the following is not a category of functions?

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

What describes a function's purpose?

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

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

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

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

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

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

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

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

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

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

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

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

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

A range is specified by its ________.

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

Which of the following is not a valid Cell Style?

Which keyboard shortcut puts the user in cell edit mode?

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

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

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

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

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

What does the AVERAGE function not ignore?

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

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

The ROUND function requires how many arguments?

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

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

Which keyboard shortcut toggles through the types of reference options?

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

The VLOOKUP function has four required arguments.

How is text aligned by default?

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

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

Using Alt + Enter is a text wrapping option.

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

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

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

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

Where is the Show Formulas command found?

Which of the following would not be considered text?

New workbooks typically contain how many worksheets?

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.

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

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

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

FV is a required argument in the PMT function.

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

Which status bar statistic can you not enable?

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

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

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

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

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

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

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

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

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

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.