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