NEW
Font size
Worksheetsexcel terms
Total questions: 17
Worksheet time: 9mins
______that allows the user to check for multiple conditions and returns true if all conditions are met and false if any of the conditions are not met.
conditional formatting
ADD function
data validation
countif function
A feature that creates rows and columns based on values in the selected cells.
cell style
avg if function
data validation
auto fill
A function that returns the average in a range of cells based on one specified criterion.
average
IF
avg if
none
Provides an option to autofill data across a row or column using a user-established pattern.
goal seek
fill series
if series
adding series
A function that allows the user to make a comparison between two values and then returns a true or false result.
AVG IF FUNCTION
IF FUNCTION
COMPARE FUNCTION
RESULT FUNCTION
A list of commands that are recorded or coded with the purpose of executing the commands using a single command.
Micro function
recorder function
coding function
macro
This option allows a user to set protection settings on a worksheet with a password.
workbook protection
worksheet protection
saving protection
excel savings protection
A function that returns the current date.
Month function
day function
Today function
current function
A function that adds up all of the numbers in a range of cells based on a criterion that the user specifies.
sum function
sumif functions
sumifs function
adding function
A tool that allows a user to establish the format of data that is entered into cells.
User function
ENTER function
format function
data validation
A type of chart used to plot more than one data series using a second axis.
TWO AXIS
DUAL AXIS
AXIS
CHART AXIS
WHICH TYPE OF SOFTWAR IS BEST FOR ADDING NUMBERS
WORD
POWERPOINT
ACCESS
EXCEL
WHICH APP IS BEST FOR WRITING A REPORT?
WORD
EXCEL
POWERPOINT
ACCESS
a combination of a column letter and a row number that identifies a cell on a worksheet.
CELL RELAVTIVE
CELL ADDRESS
CELL REFERENCE
CELL LOCATION
s one that does not change when it's moved, copied or filled. This way, the reference points back to the same cell, no matter where it appears in the workbook.
NO CHANGE REFERENCE
CELL RELATIVE REFERENCE
ABSOLUTE CELL REFERENCE
MIXED REFERENCE
a type of reference in which either the column is made constant or the row is made constant. When we make any column or row constant then the column name or row number does not change as we copy the formula to other cell(s).
RELATIVE CELL REFERENCE
ABSOLUTE REFERENCE
MIXED CELL REFERENCE
COMMON REFERENCE
basic cell references that adjust and change when copied or when using AutoFill.
STYLE CELL REFERENCE
RELATIVE CELL REFERENCE
ABSOLUTE CELL REFERENCE
MIXED CELL REFERENCE
