BIM iCEV Spring Semester Exam REVIEW

Which of the following is displayed in the image?

• AutoComplete

• Pick from List

• Auto Fill

• Flash Fill

Which of the following locations contains the command to delete a macro?

• Delete macro dialog box

• Record macro dialog box

• Macro dialog box

• Analyze macro dialog box

Which of the following should be clicked to view the macros in the workbook?

• Analyze Macros option

• Record Macros option

• Stop Recording option

• View Macros option

Which of the following contains the location where you can name a macro?

• Macro menu

• Record Macro dialog box

• File tab

• Data tab

Which tab on the Ribbon contains the command to record a macro?

• View

• File

• Macro

• Insert

Which of the following is a series of commands and instructions grouped together as a single command to accomplish a task automatically?

• Filter

• Macro

• Sort

• Icon set

Which of the following is NOT true about sorting?

• A) Data is arranged in a certain order such as alphabetically or numerically

• B) Data is hidden if it does not meet the sorting criteria

• C) Data can be sorted by cell color

• D) Date and time data can be sorted chronologically

Which of the following applies formatting to cells depending upon the contents of the cells?

• Conditional formatting

• Filters

• Conditional sorting

• Style sets

Other than the Home tab, which tab on the Ribbon contains the commands for applying a filter or a sort?

• Data

• File

• Review

• View

Which group on the Home tab contains the commands to apply a filter or a sort?

• Editing

• Alignment

• Font

• Clipboard