TestOut Review EXCEL 5.6-5.7-5.8-5.9

Evelyn is preparing a budget spreadsheet in Excel and needs to add the amounts spent in January and February. Which symbol should she use for addition in her Excel formula?

• +

• /

• *

• -

Elijah and Aiden are calculating their total savings. If Elijah's savings are in cell A1 and Aiden's savings are in cell A2, what formula should they use to find the total?

• =SUM(A1, A2)

• =A1 + A2

• =SUM(A1:A2)

• =ADD(A1, A2)

Grace is working on a monthly sales report in Excel and wants to quickly fill in the dates for each day of the month without typing them manually. Which feature allows her to do this by dragging the fill handle over the cells?

• Data Generator

• AutoComplete

• Filler Tool

• Fill Handle

Abigail and James are working on a school project where they need to calculate the total cost of materials. If the price of one item is in cell A1 and the quantity needed is in cell A2, what formula should they use to find the total cost?

• =SUM(A1,A2)

• =A1+A2

• =A1*A2

• =A1/A2

Samuel has created a monthly budget spreadsheet in Excel and wants to apply a formula calculating expenses across several months. How can Samuel copy this formula to adjacent cells?

• Right-click and select 'Copy' then 'Paste' in the adjacent cells

• Drag the fill handle across the adjacent cells.

• Type the formula manually in each adjacent cell

• Use the 'Copy' button in the toolbar and then manually paste in each cell

Henry is working on a monthly sales report in Excel. What is the benefit of using the auto-fill feature for him?

• Allows for automatic data entry for adjacent cells

• Creates duplicate entries for adjacent cells

• Increases the file size to adjacent cells

• Copies data or formulas to adjacent cells

David is working on a budget spreadsheet in Excel and wants to ensure that a specific cell reference remains constant when copying the formula to other cells. Which symbol should David use to create an absolute reference in Excel formulas?

• %

• #

• $

• &

Grace is working on her Excel assignment and needs to lock a cell reference to ensure it doesn't change when she copies the formula to other cells. What key can she press to add $ absolute to a cell reference?

• F4 Function Key

• F6 Function Key

• F8 Function Key

• F10 Function Key

Isla is managing a small store and wants to calculate the total sales for products that meet a certain condition, such as being in a specific category. The formula she should use to add values in a specified range that meet this condition is called:

• SUMIFS

• SUMIF

• COUNTIF

• SUBTOTAL

Daniel is organizing a book club and wants to count the number of books that belong to a specific genre. Which function should he use?

• Sumif

• Productif

• Averageif

• Countif