Computer Skills Questions
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.