BIM 1 Spring 25 Review

How does using a dollar sign ($) in a cell reference affect formulas in Excel?

• It makes the reference absolute, so it does not change when copied to another cell.

• It makes the reference relative, so it always changes when copied.

• It removes the reference from the formula.

• It highlights the cell in yellow.

How can you use the Fill Handle in Excel?

• To automatically continue a series, such as numbers or days, into adjacent cells.

• To merge multiple cells into one cell.

• To apply conditional formatting to selected cells.

• To delete the contents of selected cells.

Name two types of sheet views in Excel.

• Normal and Page Layout.

• Grid and Chart.

• Formula and Data.

• Header and Footer.

What is Conditional Formatting used for in Excel?

• Conditional Formatting is used to highlight cells based on specific rules.

• Conditional Formatting is used to sort data alphabetically.

• Conditional Formatting is used to create charts automatically.

• Conditional Formatting is used to protect worksheets from editing.

Name two types of charts you can insert in Excel.

• Bar chart and Pie chart.

• Text chart and Image chart.

• Sound chart and Video chart.

• Shape chart and Color chart.

What does the AutoFit feature do in Excel?

• AutoFit automatically adjusts the width or height of a cell to fit its contents.

• AutoFit deletes empty rows and columns in a worksheet.

• AutoFit merges multiple cells into one cell.

• AutoFit applies a filter to the selected data.

How can you protect formulas in Excel?

• By locking formulas and protecting cells.

• By changing the font color to white.

• By saving the file as a PDF.

• By hiding the worksheet tabs.

Where can you find the PivotTable option in Excel?

• In the Insert tab.

• In the Home tab.

• In the Data tab.

• In the Review tab.

Which keyboard shortcut is used to insert a new worksheet in Excel?

What are Word Styles and Templates used for?

• They are used to apply consistent formatting and structure to documents.

• They are used to create new fonts for documents.

• They are used to encrypt documents for security.

• They are used to check spelling and grammar only.