NEW
Font size
WorksheetsAdvanced Excel
Total questions: 20
Worksheet time: 10mins
The formula that adds values in a specified range that meet a certain condition or criteria is called:
SUMIFS
SUMIF
COUNTIF
SUBTOTAL
Under the order of arithmetic operators, Excel will calculate division before exponents.
TRUE
FALSE
The absolute cell reference uses which symbol:
$
%
*
&
To combine text that is in two different cells, use the formula:
COMBINE
MATCH
CONCATENATE
SUBTOTAL
In formulas, spaces count as characters.
TRUE
FALSE
To add a special sort order to a “Sort By” list, you would use:
SORT A to Z
SUBTOTAL
FILTERS
CUSTOM SORT
In VLOOKUP, the column # refers to the column in the:
table array
worksheet
workbook
list
To create a drop-down list in a cell or cell range, you would use:
the LIST function
DATA VALIDATION
NAME MANAGER
a VLOOKUP function
Unlocked cells are NOT editable if a worksheet or workbook is protected.
TRUE
FALSE
A table can have blank columns and rows in it, if they are selected when the table is created.
TRUE
FALSE
In Excel 2016 mini toolbar is an efficient formatting tool that can be accessed by:
Clicking the view tab on the ribbon
Right clicking a cell selection
Clicking the office button
Clicking the status bar
Which conditional formatting feature can be used to identify duplicate values on a worksheet?
Data Bars
Highlight Cell Rules
Top / Bottom Rules
Color Scales
Cell A2 contains the following e-mail address: support@excel-skills.com
Cell B2 contains the following formula: =MID(A2,FIND(“@”,A2)+1,LEN(A2)-FIND(“@”,A2)+1)
What is the result of the formula in cell B2?
@
excel-skills.com
support
#VALUE
To count how many cells have text in them, use the function:
COUNT
COUNTIF
COUNTA
SUMIF
