Excel Crash Course Exam Questions and Answers(SCORED A+)

manipulating data inside a cell - ANSWER-*F2* is the command that puts you inside a cell: -pressing the F2 key once shows you the components of the formula you created earlier, puts you inside a cell and enables you to navigate through it to edit the existing cell data -pressing the F2 key twice activates the cursor and enables you to move to different cells, worksheets, and even other open Excel files *Shift arrow key* will highlight characters one at a time *Shift Ctrl arrow key* will highlight contiguous ranges of characters deleting and clearing cell data - ANSWER-hitting *Delete* does NOT delete the formatting in the cell to truly delete a cell: -*Alt h e* (Home tab > Clear) -from the drop-down, chose the appropriate actions *(Alt h e) a*: clears ALL contents of the cell *(Alt h e) f*: clears only the cell FORMAT *(Alt h e) c*: clears only the cell CONTENT -this is the same as hitting Delete *(Alt h e) m*: clears only the cell COMMENTS right and down fills - ANSWER-highlight the range *Ctrl R* tells Excel to look at the LEFTMOST column of a range of highlighted cells and copy and paste the inputs and formulas in that column to all the columns to the right *Ctrl D* does the same thing for rows that Ctrl R does for columns, telling Excel to look at the topmost row of a range of highlighted cells and to copy and paste the inputs and formulas in that row down to all the rows below it inserting comments - ANSWER-enter the cell and type *Shift F2* hit *Esc* twice to exit the comment area to edit an existing comment: go to the cell and press *Shift F2* to delete a comment: press *Alt h e am* inserting rows - ANSWER-highlight the row BELOW the row where you want to add a row press *Shift spacebar* to highlight the entire row press *Ctrl Shift +* to insert the row note: Excel will insert the row ABOVE the row that is highlighted inserting columns - ANSWER-*Ctrl Spacebar* to highlight the entire column *Ctrl Shift +* to insert the column