A
A file that stores only text characters, not formatting or tables
Text File
This type of data table is created using the input from either a row or a column.
One-variable
What symbol on the keyboard do you use to show formulas
~
This function is used to convert text to title case.
PROPER
What is it called when your create a new cell style
Custom (cell style)
When customizing a date, which specifies the year with four digits?
yyyy
A group of formatting choices that can be applied in a single step.
STYLE
A set of design elements, including backgrounds, colors, and fonts that are applied to a spreadsheet.
THEME
A tool that copies formatting from one cell to another
Format Painter
The shading assigned to a cell.
Fill color
Decorative lines that can be applied to worksheet cells.
CELL BORDERS
This type of formula performs calculations across multiple ranges.
ARRAY
Header and Footer elements do not display in this view.
NORMAL
A function that counts the number of specified cells in a range
COUNTA
This command displays only rows that meet a specified condition.
FILTER
Use this option to change the formatting or underlying values of cells a they are pasted
PASTE SPECIAL
Select this option to remove filters from a table while keeping the table formatting.
CONVERT TO RANGE
Characters that are inserted and are not available on the keyboard.
SYMBOL
This function is used to join text from separate cells and columns
CONCATENATE
A watermark is typically inserted into this area of the page.
HEADER
A function that averages values based on multiple conditions.
AVERAGESIFS
The Function used to calculate the value of an investment or asset at some point in the future
FV - FUTURE VALUE
What is the last step you do when creating an array formula.
CTRL + SHIFT + ENTER
A function that return TRUE only when all of the conditions are true.
AND
This function is used to count the number if cells in a range that meet a certain criterion