2682675
| Question | Answer |
| To cancel entry before entering it into the cell, press the | ESC key. |
| worksheet is used to manipulate data | 1) An Excel |
| the___ or check box completes an entry. | Enter key |
| 4) By default, text is | 4) left-aligned. |
| What is meant by order of Operations? | PEMDAS |
| What is meant by recalculation | It recalculates all formulas |
| in Excel has a numerical value of zero. | A blank cell |
| A______is a predefined set of colors, fonts, chart styles, cell styles, and fill effects. | theme |
| _______displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent. | The Accounting number format |
| What is the Range Finder | To check which cells are reference in the formula assigned to the active cell |
| Pressing the _____ key, removes the marquee | ESC |
| The _______ returns a number that corresponds to the system date and time beginning with December 31, 1899. | NOW function |
| _________ to show the relationship or proportion of parts to a whole. | A Pie chart |
| How do you create cell names | Namebox or rightclick and select define name |
| 36) You can path to the What-If Analysis button by going to ______ | Data tab | Data Tools group |
| To prevent round-off errors, use the ______function. | ROUND |
| What is VLOOKUP and HLOOKUP | HLookup is used when the table direction is Horizontal VLookup is vertical. |
| _______formatting allows you to create rules that change the formatting of a cell or range of cells based on the value of a particular cell. | Conditional |
| Like the AutoFilter query technique, the _________displays a subset of the table. | Advanced Filter command |
| 52) The ____________ function is useful when you want to add values in a range only if they meet a criteria | SUMIF |
| What is consolidation? | The process of summarizing data included on multiple worksheets on one worksheet |
| What does drill through mean? | Allows you to enter a number once and copy it through worksheets so that it is entered in the same cell on all the selected worksheets. |
| that spans two or more sheets in a workbook is called a 3-D range. | A range |
| Text to be displayed in a number format, must be in | " " (quotation marks) |
| It is recommended that you use the _____function on formulas that potentially can result in more decimal places than the applied format displays. | ROUND |
Want to create your own Flashcards for free with GoConqr? Learn more.