Excel Summative Test 2

Which is used to copy a formula by dragging?

• Drag handle
• Copy tool
• Formula marker
• Fill handle

In what tab will you go to change the font size of your text?

• Review
• Format
• Home
• Insert

Which of the following cursor is used to move a cell from one place to another?

• Four headed arrow

• Fill handle

• Two headed arrow

• Selection Arrow

Which shortcut is used to select all rows?

• Ctrl + A
• Shift + A
• Ctrl + X
• Ctrl + S

To insert a Column between A and B, which column should you select?

• B
• D
• C
• A

100% is to Percentage format while $100 is to _____.

• Money format
• Cash format
• Currency format
• Dollar format

Which of the following is used to remove data in a cell?

• Clear Content

• Delete Cell

• Delete Column

• Delete Row

What key can be press to edit the data into a cell?

• F2
• Tab
• Ctrl+Alt+Del
• Shift+Enter

In excel, in what command group will you find filter command?

• Home
• Insert
• Data
• Review

Which of the following command is used to arrange data from Smallest to Largest?

• Arrange

• Filter

• Group

• Sort