21) For general work in Excel spreadsheets, the tools and selection under the DATA tab are most useful.
22) In Excel, the FORMULAS tab is used for creating complex formulas.
23) A user enters a formula into cell G9. Which of the following would be possible if the user presses the F2 function key after selecting the cell G9?
A) The formula in G9 can be edited without retyping the entire formula.
B) The formula can be copied to the clipboard.
C) A graph can be created based on the cells that appear in the formula.
D) The formula in the cell can be locked.
24) If a user enters the value 100 into cell G1, presses Enter, and then clicks the cell G1, a rectangle will be drawn around the cell with a little black box in the lower right-hand corner. Which of the following occurs if the user drags that little black box down to cell G7?
A) Excel will display values that progressively increase by 100 in each of those cells.
B) All of those cells will remain blank.
C) Excel will display the value 100 in all of those cells.
D) All of those cells' values will be multiplied by 100.
25) A user enters a1 and a2 into cells G1 and G2, respectively. If the user selects those two cells and drags the small black box to the four cells below them, then the four cells will display ________.
A) a3, a4, a5, and a6
B) b1, b2, c1, and c2
C) A1, A2, A1, and A2
D) a1, a2, a1, and a2
26) If a user enters "jan" and "feb" in cells E1 and E2, respectively, selects those two cells and drags the small black box to three more cells below them, then ________.
A) the three cells will remain empty
B) Excel will display an error message
C) the three cells will display "jan," "feb," and "jan," respectively
D) the three cells will display "mar," "apr," and "may," respectively
27) Data can be imported to Excel from other programs.
28) Excel lacks features that can add data into a spreadsheet based on a pattern.
29) If the months of a year are entered in the text form, then Excel does not recognize them as a pattern.
30) Using the F2 function key is recommended when a user has a long value in a cell and wants to edit a letter or two without retyping the whole entry.