Cell references and numbers that are used in formulas
What is Operands?
100
Parts of a function formula
What is Equal Sign. Arguments, and Function Name?
100
It determines the number of filled cells in a range that contain numbers.
What is COUNT Function?
100
Your worksheet contains a list of all of the students in a class with their ending percentage grades. Option that would only list the best 10 students in the class.
What is AutoFilter Top 10 Items?
100
Feature used to make the background of a picture “see through”
What is Set Transparent Color?
200
Logical functions used to display text or values if certain conditions exist such as displaying YES or NO.
What is IF?
200
The function formula to display the smallest number contained in the range
What is MIN?
200
The function formula to display the smallest number contained in the range
What is MIN?
200
Displays a subset of the data in a worksheet that meets certain criteria
What is AutoFilter or Filter?
200
Predesigned workbook files that you can use as the basis or model for new workbooks
What is Templates?
300
=AVERAGE(SUM(H4:H8) is an example of _____ function.
What is Nested?
300
After a function name, put all arguments in __.
What is Parenthesis?
300
Spreadsheets are often used to project results based on different data.
What is What-if Analysis?
300
Option used to sort from Z to A
What is Descending?
300
A collection of worksheets
What is Workbook?
400
Function used to add several cells together
What is SUM?
400
SUM, AVERAGE, COUNT, and MAX are examples of __.
What is Functions?
400
Option used to sort from 1 to 100
What is Ascending?
400
It temporarily removes a row or column from the screen.
What is Hiding?
400
Type of chart that uses horizontal rectangles to represent the data series
What is Bar Chart?
500
In the formula = MIN(B4:B10), B4:B10 are examples of _.
What is Arguments
500
The function formula to display the largest number contained in the range
What is MAX?
500
To trim the edges of a picture, choose __.
What is Crop?
500
Place the items in a table in alphabetic order
What is Sort?
500
A chart that uses rectangles of varying heights to illustrate the values in a worksheet.