Exam 2: Microsoft Excel Basics

You can remove conditional formatting rules by clicking the ____ group on the Home tab, clicking the Conditional Formatting button arrow, and then clicking Clear Rules.

FIGURE EX 10-1 In Figure EX 10-1 above, item 1 points to the ____.

Case EX 13-1 Kim is a photographer. To supplement her income, she also teaches a basic photography class in her studio. She uses an Excel workbook to keep track of information related to her class. The columns in her worksheet are: Student Name, Address, Phone number, Fees, Fees Paid. To find out the number of students in her class based on the Student Name column, she can use the ____ function.

The VLOOKUP function finds data when it is displayed horizontally in the lookup table.

The function ____ returns the estimated variance of the numbers in the range.

The ____ function returns the current date and time based on the computer's date and time settings.

After you have created a macro, you cannot make changes to it.

You can filter PivotChart data.

The monthly interest rate is determined by dividing the annual interest rate by 12 ____________________.

Case EX 14-2 Joe works as the manager of an auto repair shop. To help him with his work, Joe has created a macro for creating a table with a set number of columns. He needs to regularly create these tables in his worksheets. To make it easier to run the macro, Joe decides to assign the macro to a ____.

Case EX 5-2 Sam is using the functions within Excel to complete questions in a school homework assignment. Sam needs to round some figures in a worksheet. The Round function is considered to be a _____ function.

Case EX 3-1 Vanessa is learning how to split a worksheet window. What should Vanessa do to start the process of splitting a window horizontally?

The chart element called ____ is a grid that displays the data plotted in the chart.

To insert a blank worksheet, click the Insert Cells tab next to the existing sheet tabs.

The SUM function that adds the numbers in the range D5:D17 is ____.

Figure EX 13-1 In Figure EX 13-1 above, item 1 points to the ____.

The Scenario feature is a type of " what-if " analysis.

Excel's auditing feature, ____, finds the cells that are used in the function.