Question
click below
click below
Question
Normal Size Small Size show me how
Exam III4
Question | Answer |
---|---|
Which function calculates the payment of a loan based on constant payments and constant rate? | PMT |
Wich function should you use to find the mean of a list of values? | average |
Wich function do you use to count the non empty cells? | counta |
Wich function should you use to change the contents of a cell based on a condition or criteria? | If |
wich function should you use to have information returned from a table? | Vlookup |
What feature should you use to eliminate the decimal portion of a number? | trunc |
what feature should you use to change the appearance of a cell based on criteria? | conditional formatting |
which function to display the current date and time? | now |
What function to display the date? | today |
which function should you use to return the sum of products of corresponding ranges or arrays? | sumproduct |
what feature to find the right input when you know the result you want? | goal seeking |
wich function should you use to join several text strings into one text string? | concatenate |
a cells unique address is it's...? | cell reference |
default view | normal view |
text is ____ aligned | left |
numbers are ____ aligned | right |
which feature to join several selected cells into 1 cell? | merge |
a prewritten formula that is built into excel | function |
which feature to check which cells are references in the formula assigned to the active cell? | range finder |
_____ allows you to select cells for use in a formula by using a mouse | point mode |
which format would you use to have a fixed dollar sign? | accounting |
which format would you use to have a floating dollar sign? | currency |
which view allows you to create or modify a worksheet while viewing how it will look in printed format? | page layout view |
how do you display the formulas version? | [ctrl] + [accent mark] |
the data is cleared and the format is reset to the default view when you ____ a cell | move |
the data and format remain intact when you _____ a cell | copy |
a row is inserted _____ | above |
a column is inserted ____ | to the left |
which feature would you use to keep the titles on the screen no matter how far you scroll down or to the right? | Freeze titles/panes |
a date is just a ____ since 1/1/1900 | number |
which addressing mode would you use to keep the column and row the same as you copy the formula? | absolute |
which address mode would you use to keep the column the same as you copy the formula? | mixed |
which addressing mode would you use to adjust the column and row as you copy the formula? | relative |
which feature would you use to scrutinize the impact of changing values in cells that are referenced by a formula in another cell? | what if analysis |
what's the small black square located in the lower right corner of an active cell? | fill handle |
the values that you use with a function | arguments |
the width of the column will be increased or decreased so that the widest entry will fit the column | best fit |