If existing functions in Excel use ranges of cells that are affected by inserting or deleting rows or columns, the ________ ranges are updated automatically
A) syntax
B) argument
C) selected
D) segmented
B
You might also like to view...
The Alice for statement uses ____ to increase the index.
A. i&& B. index-=1 C. i++ D. index+=1
Two or more tables which contain duplicate data is an example of:
A) many-to-many relationships. B) data redundancy. C) data backup. D) one-to-many relationships.
When setting custom calculation options in a PivotTable, what does % of Parent Row Total calculate?
A) Displays each value as a percentage of the respective row total. The values in each row total 100% B) Displays each value as a percentage of the respective column total. The values in each column total 100% C) Displays values as: (value for the item) / (value for the parent item on rows) D) Displays each value as a percentage of the grand total
A(n) ________ is a custom program or additional command that you can install to extend the functionality of a Microsoft Office program.
Fill in the blank(s) with the appropriate word(s).