Com S 113 Exam 2

What is the small green square in the bottom right of an active cell called?

• Sizing handle

• Fill handle

• Copy/Paste handle

• Move Cell Handle

Which of the following is not a valid formula?

• =D3

• =2*2

• =sum(1,2,3,4,5,6)

• =#12/31/2014#-#12/31/2015#

If the cell reference $A5 in a formula is copied and pasted over two columns and down two rows from its original cell, what the cell reference become in the new cell?

• $A5

• $A7

• $C5

• $C7

What does Excel not determine about the value axis when you create a chart?

• Average value

• Incremental value

• Start value

• End value

What feature in Excel automatically displays a list of field headings when you begin to create a structured reference?

• Reference AutoComplete

• Formula AutoComplete

• AutoComplete

• Nothing automatically displays a list of field headings

What does a + button indicate to the left of a row heading in an outline?

• You can expand the details of that category.

• The row has been modified.

• You can collapse the details of that category.

• There is a calculation in that cell.

A worksheet of faculty members at your university contains these columns in this sequence: Rank, Last Name, First Name, Department, and Salary. What is the first step to subtotal departmental salaries?

• Sort by Last Name

• Sort by Salary

• Sort by Rank

• Sort by Department

Which function is not a Subtotal function?

• MAX

• SUM

• AGGREGATE

• AVERAGE

Grouping is .....

• using a VLOOKUP function to categorize data

• joining rows or columns of related data into a single entity for analysis

• the top level in an outline

• joining unrelated data for analysis

A(n) .......................... is an interactive table which uses calculations to consolidate and summarize information.

• list

• PivotTable

• Table

• range