Exam III4
Help!
|
|
||||
|---|---|---|---|---|---|
| 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
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
quickms