which tab do you use to insert function, Home, Formulas, Insert, Which option allows you to duplicate an entire worksheet, Add &copy, Delete, Rename, What is the correct procedure to delete column D entirely from the worksheet, Cut, Delete, Insert, . Which pair of shortcuts should you press to copy a formula and paste it into adjacent cells, ) Ctrl + X to copy, and Ctrl + V to paste, ) Ctrl + C to copy, and Ctrl + V to paste, Ctrl + A to copy, and Ctrl + P to paste, If cell A2 contains 'January' and you drag the fill handle vertically down to cell A4, March, April, May, If cell A1 contains '10' and cell A2 contains '20', what happens when you select both cells and drag the fill handle down to A6, Excel repeats 10, 20, 10, 20, 10, 20, ) Excel continues the pattern with 30, 40, 50, 60, Excel calculates the sum 30 in all cells, which functions identify the (lowest) and (highest) values in a column of numbers, LOW() and =HIGH(), MIN() for lowest and =MAX() for highest, SMALL() and =LARGE(), IF formula example: =IF(A2>500, "Good Results", "Bad Results"). If cell A2 contains the value 644, what output will Excel display in cell B2?, False, Good Results, Bad Results, If cell A4 contains 74 and the formula is =IF(A4>500, "Good Results", "Bad Results"), what output is displayed in cell B4?, Bad Results, Good Results, True, What mouse cursor icon appears at the bottom-right corner of a selected cell when use autofill ?, A solid black plus sign (+), A four-pointed move arrow

Leaderboard

Visual style

Options

Switch template

Continue editing: ?