NEW
Font size
WorksheetsExcel 2019 - Part 2 (Test)
Total questions: 26
Worksheet time: 13mins
How do you lock a cell in a function?
F2
F9
F4
Ctrl+A
Which is NOT a valid cell name?
Cell Name1
CellName1
Cell_Name
Cell_Name_1
Which of the following is the correct syntax for the TODAY function?
=TODAY(Date)
=TODAY()
=TODAY(05/05/2016)
=TODAY(A1)
Which of the following is NOT a LOGICAL FUNCTION?
GREATER THAN
OR
NOT
AND
One you have sorted a table in Ascending orderc, how do you remove the sort?
Click Clear Sort in the Sort command in the Sort & Filter group on the Data tab.
Right-click and choose Remove Sort.
Use the Undo command.
Save the workbook, close it and reopen it.
You have sorted three columns in sequence. Which one is the primary sort.
First column you sorted
Second column you sorted
Third column you sorted
None of the columns are sorted
To perform and advanced filter, what is one of the two items that needs to be defined in the Advanced Filter dialog box?
Cell Range
Worksheet Range
Named Range
List Range
What function set allows you to perform calculations on subsets of data?
SUBSETS
LOOKUP
SEARCH
SUBTOTAL
What is a trendline?
A graphical representation which follows the exact placement of data points.
The algorithm Excel uses when saving documents in 97-2003 format.
The line in a cell that represents a graphical representation of drifts (trends) or variations in a data series.
A line connecting data labels to their respective data points.
What is an array?
A range of cells highlighted in Excel.
Multiple worksheets grouped together.
A range of data entered into a computer's memory and accessed by Excel.
A visual depiction of values from a range of cells.
What key-stroke combination is required to create an array?
Control + Shift + Enter
Control + Enter
Alt + Shift + Enter
Alt + Enter
What is a graphical representation of numerical values and relationships in a dataset?
Trendlines
Charts
Category / Value Axis'
Elements
What is a PivotTable?
A static table that summarizes, organizes, and compares large amounts of worksheet data.
An interactive table that summarizes, organizes, and compares large amounts of worksheet data.
An interactive table that summarizes, organizes, and compares large amounts of worksheet data.
An Excel element that allows you to filter data in a static worksheet.
PivotTable work best with Transactional Data. What is Transactional Data?
Raw data that has been summarized.
Data with both column labels and row labels.
Summarized data with row labels.
Raw data with column labels.
True or False? A PivotTable works best when there are no duplicates in any column.
True
False
Which function allows you to generate a summary from a PivotTable and place it elsewhere in a worksheet?
PIVOTDATA
SUMPIVOTDATA
ANALYZEPVT
GETPIVOTDATA
Which feature allows you to filter by any date entries in a PivotTable?
DATETIME
Timeline
Chronological Filter
Quantum Analysis
You have selected a range of cells across multiples and would like to name each column by it's column label name. Which command would you use?
Define Name in the Defined Names group on the Formulas tab.
Use in Formula in the Defined Names group on the Formulas tab.
Create from Selection in the Defined Names group on the Formulas tab.
Name Manger in the Defined Names group on the Formulas tab.
You are using the Formula AutoComplete to write your functions. Name a method you can use to enter the function or named range into the cell?
Click once on the function or named range.
Highlight the function or named range and press the Tab key.
Highlight the function or named range and press the Enter key.
Highlight the function or named range and press the right arrow key.
In Excel, what is the term used when placing a function or formula inside of another function or formula?
Inserting
Placing
Combining
Nesting
True or False? To change the data of a chart, you must delete the chart and reinsert it using it's saved Template.
True
False
What function adds all of its arguments that meet multiple criteria?
SUMIF
COUNTIF
OFFSET
SUMIFS
Where would you find, and be able to use, all of the functions available to Excel in one dialog box?
More Functions in the Function Library group on the Formulas tab
More Functions in the Function Library group on the Data tab
Insert Function in the Function Library group on the Formulas tab
Insert Function in the Function Library group on the Data tab
The default calculation method in Excel is to Automatically calculate the work book. What other four options are available?
Automatic Except for Data Tables
Manual
Calculate on Save
Calculate Now
The arguments used in the IF functions are:
Logical 1, Logical 2, Logical 3
Logical 1, True, False
Lookup Value, Table Array, Column Index Number
Logical Test, Value if True, Value if False
3 ways to join text string are:
The COMBINE function, flash fill, Text to Columns
The CONCATENATE function, using the Ampersand key, flash fill
The TEXTJOIN function, Autofill, using the Ampersand key
Flash fill, Text to Columns, Data Validation
