Computer Literacy Computer Skills

Computer Literacy Practice Test: Spreadsheets and Word Processing

  • Spreadsheets and Word Processing
  • 10 questions
  • 13 minutes

Ten questions on everyday spreadsheet and document skills. Tip: in a spreadsheet, a formula always begins with an equals sign.

Tap an option to mark your answer. You can change your mind, or tap the same option again to leave the question blank. The correct answers and explanations appear when you finish the test.Tap an option to answer; tap it again to leave the question blank.

Advertisement
Advertisement
  1. Question 1

    In a spreadsheet, what does cell reference C4 identify?

  2. Question 2

    Cells B2 through B5 contain 10, 20, 30 and 40. What is the result of =SUM(B2:B5)?

  3. Question 3

    What character must a spreadsheet formula start with so the program calculates it?

  4. Question 4

    In a spreadsheet, a formula uses $A$1. What happens to that reference when the formula is copied to another cell?

  5. Question 5

    What does =AVERAGE(4, 8, 9, 11) return?

  6. Question 6

    In a table of customers, you want to temporarily show only the rows for customers in one city without deleting the others. Which feature should you use?

  7. Question 7

    Cell B2 contains 55. What does =IF(B2>=60,"Pass","Fail") display?

  8. Question 8

    In a word processor, which feature lets you generate a table of contents automatically?

  9. Question 9

    A company wants to send the same letter to 200 customers, each with their own name and address on it. Which feature is designed for this?

  10. Question 10

    Which word processor feature lets a reviewer suggest edits that the author can accept or reject one by one?

Questions you leave blank are not counted as wrong.

Advertisement

More Computer Skills tests

All Computer Literacy tests
13:00

Do you want to finish the test?