Flashcards
exam
Cards in this deck (25)
- 1To cancel entry before entering it into the cell, press theESC key.
- 2worksheet is used to manipulate data1) An Excel
- 3the___ or check box completes an entry.Enter key
- 44) By default, text is4) left-aligned.
- 5What is meant by order of Operations?PEMDAS
- 6What is meant by recalculationIt recalculates all formulas
- 7in Excel has a numerical value of zero.A blank cell
- 8A______is a predefined set of colors, fonts, chart styles, cell styles, and fill effects.theme
- 9_______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
- 10What is the Range FinderTo check which cells are reference in the formula assigned to the active cell
- 11Pressing the _____ key, removes the marqueeESC
- 12The _______ returns a number that corresponds to the system date and time beginning with December 31, 1899.NOW function
- 13_________ to show the relationship or proportion of parts to a whole.A Pie chart
- 14How do you create cell namesNamebox or rightclick and select define name
- 1536) You can path to the What-If Analysis button by going to ______Data tab | Data Tools group
- 16To prevent round-off errors, use the ______function.ROUND
- 17What is VLOOKUP and HLOOKUPHLookup is used when the table direction is Horizontal
VLookup is vertical. - 18_______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
- 19Like the AutoFilter query technique, the _________displays a subset of the table.Advanced Filter command
- 2052) The ____________ function is useful when you want to add values in a range only if they meet a criteriaSUMIF
- 21What is consolidation?The process of summarizing data included on multiple worksheets on one worksheet
- 22What 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.
- 23that spans two or more sheets in a workbook is called a 3-D range.A range
- 24Text to be displayed in a number format, must be in" " (quotation marks)
- 25It is recommended that you use the _____function on formulas that potentially can result in more decimal places than the applied format displays.ROUND