1 / 63

BCIS IB, (Test 1) Excel Lessons 1, 2 and 3 Press Space bar to Advance Frame

BCIS IB, (Test 1) Excel Lessons 1, 2 and 3 Press Space bar to Advance Frame. 1. A cell is the intersection of a _____ and a _____. Column and row. 2. Is the purpose of a worksheet/spreadsheet to summarize text documents?.

zoltan
Télécharger la présentation

BCIS IB, (Test 1) Excel Lessons 1, 2 and 3 Press Space bar to Advance Frame

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. BCIS IB, (Test 1) ExcelLessons 1, 2 and 3Press Space bar to Advance Frame

  2. 1. A cell is the intersection of a _____ and a _____.

  3. Column and row

  4. 2. Is the purpose of a worksheet/spreadsheet to summarize text documents?

  5. NO! – To work with values and calculate numbers, Not to work with text.

  6. 3A. When numeric data is ________ than the column, Excel can display a series of number signs (###) in the cell (if the cell is a value).

  7. Wider

  8. 3A. When text data is wider than the column, does Excel show ####’s?

  9. NO!, (1) It can spill into the next column or (2) it can be truncated – cut off on the right

  10. 4. If you need to make changes, once you have entered data into a cell, can you change or edit it or do you have to re-enter it?

  11. You can use several different methods to change or edit the data. Press F2, click in the formula bar, or click in the cell.

  12. 5. One way to move data in a worksheet/ spreadsheet is using the _____ and _____ method.

  13. Drag and Drop(select, click, drag, and drop)

  14. 6. Just like with Word, Excelallows you to change the font style ________or ________, and also ________.

  15. Bold, Italics, or Underline

  16. 7. One way to copy cells is to use the Drag and Drop method plus the ? key.

  17. Ctrl

  18. 8. Freezing Panes will freeze rows _____ and columns to the ____ of the highlight.

  19. Above and Left

  20. 9. Excel recognizes the contents of a cell as a formula when a ? sign is the first character in the cell.

  21. An Equals (=)

  22. Is Saving a worksheet in Excel significantly different from saving a document in Word?

  23. No, it’s done the same way.

  24. 11. A group of selected cells is a ?

  25. Range

  26. 12. The cell ready for data entry is the ?

  27. Active Cell

  28. 13. A collection of computerized worksheets is called ?

  29. A Workbook(a file of a collection of worksheets)

  30. 14. Excel uses the term computerized spreadsheet to mean the same as a

  31. Worksheet

  32. 15. All ? options make multiple copies if more than one destination cell is selected.

  33. Fill commandsFill Down (Ctrl D)Fill Right (Ctrl R)Fill upFill Left

  34. 16-A. Unless otherwise specified, what is the alignment for numbers?

  35. Right alignment

  36. 16-B. Unless otherwise specified, what is the alignment forText?

  37. Left alignment

  38. 17. What are the steps to cut and paste data?

  39. 1. Select data to be copied2. Click the copy button3. Place highlight in cell where you want data copied4. Click paste button

  40. 1. Select data to be copied 2. Click the copy button 3. Place highlight in cell where you want data copied 4. Click paste button

  41. 18. When the border is double clicked what feature adjusts the column width to its longest entry?

  42. AutoFit/Best Fit

  43. 19. What are the steps to copy data using the drag and drop method?

  44. 1. Select data to be copied2. Move pointer to top boarder of highlighted cells3. Hold down CTRL key4. Drag highlight in cell where you want data copied5. Release Mouse (and CTRL) button(s)

  45. 20. What is the purpose of a spreadsheet?

  46. work with values and calculate numbers.

  47. 21. Freezing panes will freeze rows ____ and columns to the ____ of the highlight.

  48. Rows above and columns to the left

  49. 22. What does Excel call a collection of computerized spreadsheets?

  50. Workbook

More Related