Font size
WorksheetsDatabase and Lookup Functions Vocabulary
Total questions: 65
Worksheet time: 35mins
A table in the context of databases is:
A collection of data organized in rows and columns
A single piece of data
A type of database management system
A graphical representation of data
A database is a structured collection of data that is stored and accessed electronically. What is a database?
A type of software
A structured collection of data
A programming language
A hardware device
What are lookup functions used for?
To search for a value in a table or range
To perform arithmetic operations
To format text
To create charts
A lookup table is:
a data structure used to map input values to output values
a type of database
a programming language
a hardware component
A record in a database is:
single entry in a table, consisting of fields
collection of tables
type of database management system
programming language
What are fields in a database?
Columns in a table that store data attributes
Rows in a table that store data records
A type of database management system
A programming language used for databases
A banded row in a table is:
row with alternating colors for better readability
row with a single color
row with a border
row with merged cells
The HLOOKUP function is used for:
Searching for a value in the top row of a table or array and returning a value in the same column from a row you specify
Searching for a value in the first column of a table or array and returning a value in the same row from a column you specify
Calculating the sum of a range of cells
Finding the average of a set of numbers
What is the VLOOKUP function?
function to look up a value in a table by matching on the first column
function to calculate the sum of a range of cells
function to find the maximum value in a range
function to sort data in ascending order
A lookup value is:
a value that is searched for in a data set
a function used to sort data
a type of graph
a method of data entry
What is a calculated field?
A field that is manually entered by the user
A field that automatically updates based on a formula
A field that stores static data
A field that is hidden from users
A return value is:
a value sent back by a function to the caller
a type of loop in programming
a syntax error in code
a variable declaration
What are data bars?
A type of chart used to represent data visually
A feature in spreadsheet software that uses bars to represent the value of cells
A programming language for data analysis
A type of database management system
A computational field is a branch of study that involves the use of computers and algorithms to solve problems. Which of the following best describes a computational field?
A branch of study involving computers and algorithms
A field related to agriculture
A type of physical exercise
A method of cooking
A structured reference is:
a type of cell reference in Excel that refers to tables by their names.
a method of organizing files in a computer system.
a way to reference cells in a spreadsheet using row and column numbers.
a programming technique used in software development.
What is ascending order?
A way of arranging numbers from largest to smallest
A way of arranging numbers from smallest to largest
A way of arranging numbers randomly
A way of arranging numbers in pairs
Criteria are a set of principles or standards by which something may be judged or decided.
A set of principles or standards
A random choice
An undefined rule
A personal opinion
What is descending order?
Way of arranging numbers from smallest to largest
Way of arranging numbers from largest to smallest
Way of arranging numbers randomly
Way of arranging numbers in pairs
What are sort keys?
Keys used to sort data in a specific order
Keys used to encrypt data
Keys used to filter data
Keys used to delete data
In an Excel table, a field whose values are not entered but calculated based on other fields is called a _______.
calculated field
data field
input field
static field
The data values being retrieved by the lookup function from a lookup table are called _______.
return values
lookup keys
search indices
output variables
In conditional cell formatting, colored horizontal rectangles in a cell; the larger the number, the wider the _______.
data bar
cell border
font size
cell padding
A table column or field that contains a formula, function, cell reference, structured reference, or condition is called a _______.
calculated column
data field
static column
text field
To organize data, such as table rows, items in a list, or records in a mail merge, in ascending or descending order, based on criteria such as date, alphabetical order, file size, or filename is to _______.
sort
filter
merge
group
A reference that allows table formulas to refer to table columns by names that are automatically generated when the table is created is called a _______.
The arrangement of text alphabetically from A to Z, numbers from smallest to largest, and dates from oldest to newest is called _______.
ascending order
descending order
random order
mixed order
A logical rule by which data is tested and chosen is called a _______.
criterion
filter
algorithm
condition
Data sorted from highest to lowest, most recent to earliest, or alphabetically from Z to A is called _______.
descending order
ascending order
random order
unordered
The field or fields on which records are sorted in a query are called _______.
sort key
filter key
index key
search key
A query is:
A type of fruit
A computer virus
A request for information
A musical instrument
What are wildcard characters?
Special symbols used in search operations
Characters that represent themselves
Numbers used in calculations
Punctuation marks
A search string is:
a sequence of characters used to find specific data within a database or a set of documents.
a type of computer virus.
a programming language.
a hardware component.
The DCOUNT function is used to:
Count the number of cells in a database that contain numbers
Count the number of cells in a database that contain text
Count the number of empty cells in a database
Count the number of cells in a database that meet specific criteria
A criteria range is:
a range of cells that specifies the conditions for a function or formula.
a type of chart used to display data trends over time.
a method for sorting data alphabetically in a spreadsheet.
a tool for creating pivot tables in Excel.
What does it mean to extract range?
To determine the difference between the highest and lowest values in a set
To find the average of a set of numbers
To identify the median value in a set
To calculate the sum of all values in a set
The DAVERAGE function is used to:
Calculate the average of a database column based on specified criteria.
Find the maximum value in a database column.
Count the number of entries in a database column.
Sort the database in ascending order.
The MATCH function is used to:
Find the position of a value in a list
Match two lists together
Sort a list in ascending order
Calculate the sum of a list
What is the OR function?
A logical operation that returns true if at least one of the operands is true.
A mathematical function that multiplies two numbers.
A function that sorts a list in ascending order.
A programming function that reads input from the user.
The INDEX function is used to:
Return a value or reference of the cell at the intersection of a particular row and column in a given range.
Find the position of a value within a range.
Look up a value in a table by matching on the first column.
Calculate the sum of a range of cells.
A special symbol that substitutes for unknown characters in search text; the most common are the question mark (?), which stands for any single character, and the asterisk (*), which represents any group of characters. The special symbol used for any single character is ____.
?
*
@
#
A request for information from a data source in Power BI is called a ____.
query
report
dashboard
visualization
A function that counts the number of numeric entries in a table field that pass a test. The function that counts numeric entries in a table field is ____.
COUNTIF
SUMIF
AVERAGEIF
MAXIF
The sequence of letters entered in a search box is called a ____.
search string
search engine
search bar
search result
A range in which Excel copies the records that meet the comparison criteria in the criteria range in a search or filter to another part of the worksheet. The range where Excel copies records that meet criteria is called an ____.
extract range
data range
output range
filter range
A location separate from the table used to list specific search specifications. A location separate from the table for search specifications is called a ____.
criteria range
data range
search area
filter zone
In Excel, the function that returns the position number of an item in a range or table.
MATCH
INDEX
LOOKUP
SEARCH
The function that calculates the average of numbers is ____.
AVERAGEIF
SUMIF
COUNTIF
MAXIF
An alphabetical list of terms and topics and the page numbers on which they appear, usually appearing at the end of a document. Fill in the blank: An alphabetical list of terms and topics is called an (a) .
A logical function that returns TRUE if either part of the condition is true.
OR
AND
NOT
XOR
The AND function is a logical operation that returns true if:
both operands are true
at least one operand is true
both operands are false
at least one operand is false
The XOR function is a logical operation that outputs true or false based on the inputs. Which of the following best describes the XOR function?
Outputs true only if both inputs are true
Outputs true only if both inputs are false
Outputs true if one input is true and the other is false
Outputs true if both inputs are false
The NOT function is used to:
Return the opposite of a given logical value
Add two numbers together
Multiply two numbers together
Divide one number by another
The TRANSPOSE function is used to:
Convert rows to columns and vice versa
Sort data in ascending order
Filter data based on criteria
Calculate the sum of a range
A treemap chart is a type of data visualization that displays hierarchical data using nested rectangles. What is a treemap chart?
A type of data visualization that displays hierarchical data using nested rectangles
A chart that uses lines to connect data points
A graph that shows data using bars of different heights
A pie chart that represents data in a circular format
Outline symbols are used to:
represent the structure of a document
highlight important text
create visual diagrams
format text in bold
The AVERAGEIF function is used to:
Calculate the average of a range of cells that meet a specific condition.
Find the maximum value in a range of cells.
Count the number of cells that contain numbers.
Sum all the numbers in a range of cells.
A control field is:
a field used to control the flow of data
a field that stores metadata
a field used for error checking
a field that contains user input
A logical function that returns the word TRUE if both arguments are true.
AND
OR
NOT
XOR
A rarely used logical function that returns TRUE if either argument is true, and returns FALSE if both are true or false.
XOR
AND
OR
NAND
A logical function that uses a single argument and returns TRUE if the condition is false.
NOT
AND
OR
IF
A function that lets you change the orientation of a range—that is, return a vertical range of cells as a horizontal range, or vice versa.
TRANSPOSE
VLOOKUP
HLOOKUP
INDEX
An Excel chart that provides a hierarchical, visual view of data, making it easy to spot patterns and trends.
PivotChart
Bar Chart
Line Chart
Pie Chart
In Outline view, the buttons that, when clicked, change the amount of detail that appears in the outlined worksheet.
Expand/Collapse
Zoom In/Out
Show/Hide
Increase/Decrease
An Excel function that calculates the average of values within a range that meet multiple criteria.
AVERAGEIFS
SUMIFS
COUNTIFS
MAXIFS
A field on which you sort.
Sort Key
Filter Key
Index Key
Group Key
