WorksheetsExcel Expert
Total questions: 46
Worksheet time: 30mins
You can use the ____ function to pull data from a PivotTable so that you can reference the data in a location outside of the PivotTable—either on the same worksheet or in another worksheet.
NOPIVOTDATA
USEPIVOTDATA
PULLPIVOTDATA
GETPIVOTDATA
A _____ is an additional line you add to a chart that does not correspond directly to any actual data in the worksheet.
Trend line
drift line
veer line
Which of the following is a method used to create a chart template?
Right-click in the Chart Area and select Save as Template on the shortcut menu.
File, Save as a chart template
You cannot save a chart as a chart template
Two or more chart types such as line and column would be considered to be a ___ ___.
Combo Chart
Dual Chart
Multi Chart
A tool that filters the entire PivotTable, restricting the sums, counts, averages, and so on, to only those fields selected in the slicer or filter field.
Slicer
Manual Filter
Trimmer
A term that describes when two tables have a connection between two fields.
Relationship
Linked fields
Collaborated fields
A highly configurable table that condenses large amounts of data. It is used to analyze and display numerical data in detail and to answer unforeseen questions about data.
PivotTable
Table as Chart
Filtered Table
A graphical representation of the data in a PivotTable.
PivotChart
Chart
Pie chart
A chart placed on a worksheet rather than on a separate chart sheet
embedded chart
imbedded chart
A chart that uses the left side (or top) of the chart as one value axis (y-axis) and the right side (or bottom) of the chart as a second value axis (y-axis)
dual-axis chart
tri-axis chart
L-axis chart
A row or column of data represented by a line, set of columns, bars, or other chart type.
data series
data label
information series
The entire chart and all its elements
Chart area
Chart sheet
Chart title
What is the parameters of a function?
Arguments
Criterion
Condition
A formula in which the result is determined by the presence or absence of a particular condition.
Conditonal Formula
Argument Formula
Criterion Formula
A condition you specify to limit which records are returned when filtering data.
Criteria
Query
Filter
An efficient way to search for and insert a value in a cell when the desired value is stored elsewhere in the worksheet or even in a different workbook.
Lookup Function
Search Function
CONCATENATE Function
Data in a table arranged in rows and columns. A table of text, numbers, or values that you use for the formula.
Table array
Table set
Table range
Name of the dialog box that enables you to create, edit, delete, and filter range names in a workbook.
Name Manager
Rules Manager
Range Manager
Excel functions returns both the current date and time in a cell.
NOW
PRESENT
TODAY
CURRENT
Argument in both the VLOOKUP and HLOOKUP function syntax refers to the range in which you want to look up data. Hint: it is arranged in rows and columns
Table Array
Spreadsheet
Table Set
Table Range
AND, OR, and NOT functions are included in which category of Excel functions
Math and Trig
Logical
True/False
Discrete Math
Financial function is used to determine the number of periods for an investment or the number of loan payments
NPER
NPAY
NINV
NFIN
Group on the Data tab includes commands that enable you to connect to external data sources and create new queries in the workbook.
Get and Transform
Query
Connections
Data Tools
The value 1 entered into a cell and formatted as a date corresponds with which of the following dates in Excel?
January 1, 1900
January 1, 2000
January 1, 1901
January 1, 2001
This function goes down the first column until a match is found and then looks in one of the columns to the right to find the value in the same row?
VLOOKUP
HLOOKUP
CLOOKUP
RLOOKUP
The ___ function reverses the value of its argument.
NOT
IS
FLIP
OPPOSITE
The ___ function returns TRUE if all its arguments are true, and FALSE if one or more arguments are false.
AND
OR
IF
NOT
With the __ function, only one of the arguments has to be true for the function to return a TRUE value.
OR
NOT
AND
IF
This function is a lookup functions that can help you locate a specific item or the position of an item in a specified range.Use the ____ function to return a value or the reference to a value in a specified range.
INDEX
MATCH
VLOOKUP
HLOOKUP
You can use the SUMIFS, COUNTIFS, and AVERAGEIFS functions to perform ____ operations on a range of data.
STATISTICAL
COUNTING
MATH
You can use _____ to check for common errors in your formulas.
error checking
formula audit
formula check
The ___ command enables you to debug a formula by stepping through each part of a formula individually.
Formula Options
Evaluate Formula
On the Data tab, in the Forecast group, Excel has a drop-down button named What-If Analysis. What are they?
Goal Seek, Scenario Manager , and Data Table
Goal Seek, Projections, Data Table
Scenario Manager, Projections, Data Table
To display the two numbers 1,540,257.14 and 2,250,444.18 as 1.54 M and 2.25 M, respectively. Which number format must be applied to the first two numbers?
#,##0.00,,"M"
#,##0.00,,"N"
#,#0.00,,"M"
#,##0.00,,"B"
Option on the Conditional Formatting menu is used to display colored bars that represent the values in cells
Data Bars
Bar Chart
Bar Graph
The name of the default document theme in Excel 2016
Office
Normal
Calibri
Times
Ribbon tab in Excel 2016 that provides access to macro settings and form controls.
Developer
File
Insert
Data
Which number format is used to display the month as a single text character (such as N for November)?
mmmmm
mmmm
mm
Which method is used to change "Sao Paulo" to "São Paulo"?
Use the Symbol button on the Insert tab while in edit mode.
Use a shortcut key
Draw it over the a
A basic macro is a recording of a sequence of commands and typed entries that you can then reply elsewhere in the worksheet.
false
true
Which of the following is the file extension used for Excel Template files?
.xlsm
.xltx
.xlsx
.xlam
Which of the following represents the syntax for a structured reference to a field in an Excel table?
FieldName[TableName]
TableName[FieldName]
[FieldName]TableName
[TableName]FieldName
Which of the following statements best describes how to copy macros from one workbook to another?
Drag the module from one project to another in the Project Explorer window of the Visual Basic Editor
Use the Record Macro button on the Developer tab
Use the Add-Ins button on the Developer tab
Open the Visual Basic Editor and type RUN COPYMACROS in the Project Explorer window
Which of the following methods is used to display a hidden tab on the ribbon?
On the View tab, in the Show group, click the Tabs button and select the tab you want to display.
Right-click any tab on the ribbon and select Display Hidden Tabs
On the Home tab, in the Cells group, click Insert and then select Show Hidden Tabs
Display the Excel Options dialog box, select Customize Ribbon, and then select the check box next to the name of the tab you want to add.
What is the name of the feature that saves copies of your files at specified intervals?
Protect Sheet
Track Changes
AutoRecover
Document Recovery
What is the name of the separate worksheet that temporarily lists all tracked changes in a shared workbook?
Changes
History
Review
Tracking
