1) The format that organizes information in the labeled columns and column rows is _____ format.
Graphical
Container
Matrix
Tabular
2) Formulas always begin with ______
=
3) Formulas in excel are created by using mathematical _______
Reference
Operators
MAX
Routines
4) A _____ is a built-in program that performs operations in data.
Subroutine
Formula
Function
Parameter
5) A(n) _____ cell is the cell that receive the result of an operation such as Paste or an AutoSum function
Adjacent
Active
Source
Destination
6) A(n) _____ cell is the cell that contains the data supplied to a function
Destination
Active
Adjacent
Source
7) A ______ formatting is a way to dynamically change the visual presentation of information in a manner that adds information to the worksheet
Default
Conditional
Tabular
Graphical
8) Excel uses the _____ presentation of information via charts and graphs.
Tabular
Container
Sectioned
Graphical
9) The base date for date and time data in Excel 2019 is ____
December 31, 999
January 1, 1900
December 31, 1899
January 1, 10000
10) A(n) ______ cell reference is the default reference in a formula to a cell address will automatically adjust when the formula is copied or extended to other cells.
Mixed
Absolute
Relative
All references to this