Editing Techniques & Auto Fill Quiz

What does the Autofit feature do?

• Changes the cell color

• Deletes the contents of the cell

• Adjusts the column width to fit the contents

• Changes the font size of the text

Which command is used to place text into multiple lines in a single cell?

• Unmerge Cells

• Merge & Center

• Merge Cells

• Wrap Text

What does the Merge command do?

• Changes the font style of the text

• Deletes the contents of the cell

• Splits the current cell into multiple cells

• Combines the contents of selected cells into a new larger cell

Which option merges selected cells in the same row into one larger cell?

• Unmerge Cells

• Merge & Center

• Merge Across

• Merge Cells

What is the Auto Fill feature used for?

• Changing the font color of the text

• Merging cells

• Deleting all the data in the worksheet

• Filling cells with data that follow a pattern or are based on data in other cells

How can you insert a static date in Excel?

• Type =NOW() in the formula bar

• Type =TODAY() in the formula bar

• Press Ctrl + Shift + ; (semi-colon)

• Press Ctrl + ; (semi-colon)

What does a red indicator in the corner of a cell indicate?

• The cell has an error

• The cell is locked

• The cell has a comment

• The cell is empty

What can you do with comments in Excel?

• Delete all comments in the worksheet

• Add notes to individual cells

• Merge comments

• Change the font size of the text

How can you format a comment in Excel?

• Change the shape of the comment

• Change the font color of the comment

• Merge the comment with the cell

• Delete the comment

What does the Merge Across option do?

• Merges selected cells in the same row into one larger cell

• Splits the current cell into multiple cells

• Combines the contents of selected cells into a new larger cell

• Unmerges cells