Excel Week 4 Draft

Isabella is working on a financial report and needs to save her document. What is the file extension for an Excel spreadsheet that she should use?

• .xls

• .docx

• .ppt

• .pdf

What is the function of the SUM formula in Excel?

• Multiply numbers
• Add numbers
• Divide numbers
• Subtract numbers

Samuel is working on a presentation and needs to adjust the font style and size of a cell in his Excel spreadsheet. Which tab should he use?

• Home

• Insert

• Formulas

• Data

Elsie is working on an Excel spreadsheet for her project and needs to save her progress. Which shortcut should she use?

• Ctrl + C

• Ctrl + X

• Ctrl + V

• Ctrl + S

How do you add a new row in an Excel spreadsheet?

• Right-click and select Insert
• Press Ctrl + R
• Click on the row number and press Delete
• Click on the row number and press Enter

What does the function =AVERAGE(A1:A5) in Excel do?

• Adds up the values in cells A1 to A5
• Multiplies the values in cells A1 to A5
• Divides the values in cells A1 to A5
• Calculates the average of the values in cells A1 to A5

How do you freeze panes in Excel?

• Select "View" tab and click on "Freeze Panes"
• Press Ctrl + F
• Right-click on the row you want to freeze
• Press Ctrl + Z

In a school project, Sebastian, Eesha, and Anaya each scored different points in a quiz. If their scores were recorded in cells A1 to A3 respectively, what does the function =MAX(A1:A3) do?

• Finds the smallest value among Sebastian's, Eesha's, and Anaya's scores

• Finds the highest value among Sebastian's, Eesha's, and Anaya's scores

• Multiplies the scores of Sebastian, Eesha, and Anaya

• Adds up the scores of Sebastian, Eesha, and Anaya

Ava, Florence, and Grace are collaborating on a project report in Excel. How do they merge cells to create a title section?

• Select the cells, right-click and choose Merge Cells

• Press Shift + M

• Press Ctrl + M

• Double-click on the cells

How do you apply a border to a cell in Excel?

• Right-click and select "Add Border"
• Go to "Home" tab, click on the border icon and choose a border style
• Press Ctrl + B
• Go to "Insert" tab and choose "Border"