Identify the letter of the choice that best matches the phrase or definition.
A. Fills a destination area using the format of the source area; no content is copied.
B. Pastes the contents and format of the source area.
C. Copies the format and contents.
D. Returns a number that corresponds to the system date and time beginning with December 31, 1899.
E. Keeps a cell reference constant when copying a formula or function.
F. Assigns a value to a cell based on a logical test.
G. Indicates a cell is using a name Excel does not recognize.
H. Shows the relationship or proportion of parts to a whole.
I. Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell.
J. Determines the value of a cell on which the formula depends.
A. Fill Formatting Only
B. Keep Source Formatting
C. Fill Series
D. NOW function
E. absolute cell referencing
F. IF function
G. #NAME?
H. pie chart
I. what-if analysis
J. goal seeking
You might also like to view...
Reports and subreports are commonly used to show related records from tables in a(n) ________ relationship
Fill in the blank(s) with correct word
?Case 19-2 Cindy, an intern at a publishing house, has to use Microsoft Access 2016 to prepare forms and database reports for all the outgoing articles in that particular month. Since the records are huge, Cindy uses wildcard characters to perform searches in the report. Which of the following wildcard searches should Cindy use to find the term "Masters" in the report?
A. ?Mast* B. ?M? C. ?[M_____S] D. ?%Masters%
________ is the process of inserting information from a source file, using a format that you specify, into a destination file
Fill in the blank(s) with correct word
What is meant by a spot color?
What will be an ideal response?