To open a non-native file directly in Excel, use the _____ option to navigate to a specific folder and then click the File Type option box to display a drop-down list of all the files types that Excel can open.
Blog
What does PDF stand for?
What does PDF stand for?
Removing the connection between the source file and the dest…
Removing the connection between the source file and the destination file allows which of the following?
The method of formatting even-numbered rows in a table diffe…
The method of formatting even-numbered rows in a table differently from odd-numbered rows is called
Why are text files useful for sharing data with others?
Why are text files useful for sharing data with others?
In a _____, Excel copies the formula from the first cell to…
In a _____, Excel copies the formula from the first cell to the remaining cells in the column immediately after the formula is entered.
Use Excel’s _____ feature when you know the result but don’t…
Use Excel’s _____ feature when you know the result but don’t know what input value will achieve that result.
Before creating subtotals for a range of data, be sure to re…
Before creating subtotals for a range of data, be sure to remove any _____ within the range to be grouped and subtotaled.
Using data tables provides a means of analyzing various outc…
Using data tables provides a means of analyzing various outcomes in a calculation without
What advice does Chapter 5 give regarding creating scenarios…
What advice does Chapter 5 give regarding creating scenarios?