6.4 KiB
Week 2 Graded Quiz: Word Processing & Spreadsheets
Q1: Style Consistency
Marcus is writing a 20-page research paper in Word. He manually changes the font, size, and color of each section heading one by one. His professor tells him to change all headings from blue to black. What should Marcus have done from the start?
A. Used copy-paste for each heading so they all match B. Used built-in heading styles so he could update all headings at once by modifying the style C. Made all text the same size so headings aren't needed D. Used bold on every heading instead of changing colors
Answer: B Explanation: Heading styles let you format all headings consistently and update them globally in one step. Manually formatting each heading creates extra work every time you need to make a change.
Q2: Cell References in Formulas
In a spreadsheet, cell B2 contains the formula =A2*$D$1. If you copy this formula to cell B5, what will the formula become?
A. =A2*$D$1
B. =A5*$D$4
C. =A5*$D$1
D. =A2*$D$4
Answer: C
Explanation: A2 is a relative reference, so it shifts down 3 rows to A5 when copied. $D$1 is an absolute reference (dollar signs lock both column and row), so it stays $D$1 no matter where the formula is copied.
Q3: Choosing the Right Chart
Priya has a spreadsheet showing each department's percentage of the company's total budget. She wants to show how the whole budget is divided up. Which chart type is BEST?
A. Line chart B. Bar chart C. Pie chart D. Scatter plot
Answer: C Explanation: Pie charts are ideal for showing parts of a whole — in this case, how the total budget is split among departments. Line charts show trends over time, scatter plots show relationships between variables, and bar charts are better for comparing separate values.
Q4: SUM vs AVERAGE
Kenji's spreadsheet has test scores in cells C2 through C31 for 30 students. He wants to find the class average. Which formula should he use?
A. =SUM(C2:C31)
B. =AVERAGE(C2:C31)
C. =COUNT(C2:C31)
D. =SUM(C2:C31)/100
Answer: B
Explanation: AVERAGE calculates the mean by adding all values and dividing by the count automatically. SUM would give the total of all scores, not the average. Dividing SUM by 100 would also be wrong since there are 30 students, not 100.
Q5: Sorting vs Filtering
Elena has a spreadsheet of 500 customer orders. She only wants to see orders from California that are over $100, without removing any data. What should she use?
A. Sort the data by state, then manually scroll to find California B. Delete all rows that aren't California orders over $100 C. Apply filters to the State and Amount columns to show only matching rows D. Create a separate spreadsheet and copy the California rows into it
Answer: C Explanation: Filtering temporarily hides rows that don't match your criteria without deleting any data. You can filter by state and amount to see exactly what you need, then remove the filters to see everything again.
Q6: IF Function Logic
A teacher uses the formula =IF(B2>=60,"Pass","Fail") in cell C2. Student Jamie has a 58 in cell B2. What will cell C2 display?
A. Pass B. Fail C. 58 D. An error message
Answer: B Explanation: The IF function checks whether B2 is greater than or equal to 60. Since 58 is less than 60, the condition is FALSE, so the formula returns "Fail."
Q7: Formatting for Readability
Amir is preparing a quarterly sales report in Word to present to his manager. Which combination of formatting choices would make the document MOST professional and readable?
A. Use five different fonts to make each section visually distinct B. Use one or two fonts consistently, with heading styles, page numbers, and clear section breaks C. Maximize the amount of text per page by using 8pt font and no margins D. Underline all important words throughout the document and use ALL CAPS for emphasis
Answer: B Explanation: Professional documents use consistent formatting — one or two fonts, heading styles for structure, and page numbers for navigation. Multiple fonts, tiny text, and excessive underlining or ALL CAPS make documents harder to read and look unprofessional.
Q8: Formula Error Diagnosis
Fatima enters =SUM(A1:A10) in a spreadsheet and gets the result 0, even though she can see numbers in cells A1 through A10. What is the MOST likely problem?
A. The SUM function is broken in her version of the spreadsheet software B. The numbers in A1:A10 are stored as text, not as actual numbers C. She needs to use AVERAGE instead of SUM D. The formula should use semicolons instead of a colon
Answer: B Explanation: When numbers are stored as text (often from imports or copy-paste), formulas like SUM treat them as empty. This is a common spreadsheet issue — you can usually fix it by converting the cells to number format.
Q9: Page Layout for Printing
David needs to print a wide spreadsheet with 15 columns on a single page. The data currently spills onto a second page width-wise. What is the BEST approach?
A. Delete columns until it fits on one page B. Change the page orientation to landscape and/or use "Fit to Page" scaling C. Make the font size 4pt so everything fits D. Print it as-is and tape the two pages together
Answer: B Explanation: Landscape orientation gives you more horizontal space, and "Fit to Page" (or "Fit All Columns on One Page") automatically scales the content to fit. These are standard print layout tools designed for exactly this situation.
Q10: Combining Concepts
Sonia manages inventory for a small shop. She has a spreadsheet with columns: Product (A), Quantity (B), Price (C), and Total (D). She wants column D to multiply quantity by price, she needs to highlight any product with fewer than 10 items in stock, and she wants to sort by total value. Which set of features should she use?
A. A formula in column D (=B2*C2), conditional formatting on column B for values under 10, and sort by column D
B. A chart in column D, a filter on column B, and sort by column A
C. Manual calculation for column D, bold text for low stock, and sort by column C
D. An IF function in column D, a pie chart for column B, and filter by column D
Answer: A Explanation: A multiplication formula calculates totals automatically, conditional formatting visually highlights cells meeting a condition (like stock under 10), and sorting by column D arranges products by total value. This combination uses the right tool for each task.