All Categories
Computer Skills
Explore questions in the Computer Skills category that you can ask Spark.E!
- You update or refresh PivotTable report data.
- A field that is being removed from the PivotTable report is indicated by a(n) ________ attached to the pointer as you drag.
- To reverse an AutoCorrect adjustment, immediately click the Redo button on the Quick Access toolbar.
- The IFS function, unlike the IF function, returns the first FALSE condition.
- Which of the following Excel features recognizes a pattern in the data of a worksheet?
- You can edit a document directly on the Print tab in Backstage view.
- Which symbol represents that a cell is an absolute cell reference in a function or formula?
- The COUNTIF function counts the number of cells within a range that meet the criteria entered.
- When you copy a formula to another cell and the cells in the formula change, the cells are known as relative cell references.
- When you move a formula, the cell references within the formula do not change, no matter what type of cell reference you use.
- How do you know if some rows of a table have been hidden from view when a filter is invoked?
- AutoFill will fill a series when you establish a pattern ___
- The ________ is an area where you can position fields to use for filtering the PivotTable and thereby enabling you to display a subset of the data in the PivotTable report.
- The COUNT function counts the number of cells in a range that ___
- You must select ________ on a worksheet to create a pie chart.
- If a sheet tab has ___ you know that it is not selected.
- Which of the following displays trends over time?
- Analytical functions are useful to analyze a group of measurements.
- The values in parentheses in the SUM function (and other functions) are known as
- The ___ technique refers to moving cell contents from one location to another by just using the mouse.