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.
Your result
- 0 correct
- 0 wrong
- 0 blank
-
Question 1
In a spreadsheet, what does cell reference C4 identify?
Correct answer: D
A cell reference is a column letter followed by a row number. C4 sits where column C meets row 4.
-
Question 2
Cells B2 through B5 contain 10, 20, 30 and 40. What is the result of =SUM(B2:B5)?
Correct answer: A
The colon defines a range from B2 to B5, so all four values are added: 10 + 20 + 30 + 40 = 100.
-
Question 3
What character must a spreadsheet formula start with so the program calculates it?
Correct answer: C
Typing = tells the program that what follows is a formula. Without it, the entry is treated as plain text.
-
Question 4
In a spreadsheet, a formula uses $A$1. What happens to that reference when the formula is copied to another cell?
Correct answer: B
The dollar signs make the reference absolute, so it does not adjust when copied. Without them, the reference is relative.
-
Question 5
What does =AVERAGE(4, 8, 9, 11) return?
Correct answer: A
The sum is 32 and there are 4 numbers, so the average is 32 / 4 = 8. The value 32 is the sum, not the average.
-
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?
Correct answer: D
Filtering hides rows that do not meet criteria and can be undone. Sorting only reorders rows, and does not hide any.
-
Question 7
Cell B2 contains 55. What does =IF(B2>=60,"Pass","Fail") display?
Correct answer: C
The test 55 >= 60 is false, so the formula returns the third part, "Fail".
-
Question 8
In a word processor, which feature lets you generate a table of contents automatically?
Correct answer: B
A table of contents is built from paragraphs formatted with heading styles. Manual bold text looks like a heading but is not recognized.
-
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?
Correct answer: A
Mail merge combines one template with a list of recipients to create personalized copies. Find and replace would require manual changes for each person.
-
Question 10
Which word processor feature lets a reviewer suggest edits that the author can accept or reject one by one?
Correct answer: C
Track changes marks insertions and deletions with the reviewer's name so the author can review each edit. Print preview only shows how pages will print.
Questions you leave blank are not counted as wrong.