Microsoft Excel Basics Year 10 Pre - Quiz

What is the function of the SUM function in Excel?

• Calculates the average of a range

• Finds the highest value in a range

• Adds up all the numbers in a range

• Counts the number of cells in a range

Which icon is used to bold text in Excel?

• The italic "I"

• The underline "U"

• The bold "B"

• The strikethrough "S"

How can you copy the content of a cell?

• Ctrl + X

• Ctrl + C

• Ctrl + V

• Ctrl + A

What does the “Fill Handle” allow you to do in Excel?

• Copy text from one cell to another

• Automatically fill a series of numbers or dates

• Delete a cell’s content

• Format cells

Which tab in Excel do you use to create a chart?

• Home

• Insert

• Data

• Review

How do you change the font size of text in a cell?`

• Right-click on the cell and select "Format Cells" → "Font Size"

• Go to the "Home" tab and select the desired font size from the "Font Size" dropdown menu

• Double-click the cell and manually type in the new font size

• Press "Ctrl + F" and choose "Font Size" from the dialog box

What does the “AutoFit Column Width” feature do?

• Automatically adjusts the height of a row

• Automatically adjusts the width of a column to fit its contents

• Automatically formats the text in a column

• Automatically adds a border around a column

Which function would you use to find the smallest value in a range?

• =MAX()

• =MIN()

• =SUM()

• =AVERAGE()

How do you insert a new row into a worksheet?

What is the purpose of the “Conditional Formatting” feature?

• Change the font style of cells

• Apply different formatting based on cell values

• Merge cells into one

• Create a chart based on data