Introduction to Functions Answers

15 verified answers2 views
1
Free Preview

What are some tips to keep in mind when sorting data? Check all that apply.Remember that data will change when sorted.Remember that data will not change when sorted.Rows and columns can be sorted.Only one row or column can be sorted at once.Multiple criteria can be used to sort data.Sorting cannot be undone.

A
Remember that data will change when sorted.
B
Remember that data will not change when sorted.
C
Rows and columns can be sorted.
D
Only one row or column can be sorted at once.
E
Multiple criteria can be used to sort data.
F
Sorting cannot be undone.
2
Free Preview

Click the tab.

A
Formulas
B
Data
C
Insert
D
View
7

What is the definition of filtering data?

A
delete data that does not fit criteria from worksheet
B
organize data that fits criteria
C
hide data that does not fit criteria from display
D
alphabetize data based on criteria
8

What is the best location for the criteria range when filtering data?

A
immediately above the data you wish to sort
B
immediately below the data you wish to sort
C
immediately to the left of the data you wish to sort
D
immediately to the right of the data you wish to sort
10

Which option is an appropriate database function syntax?

A
DSUM(A4:D8,“Unit Cost”,A1:B2)
B
=SUMA4:D8,“Unit Cost”,A1:B2)
C
=DSUM(A4:D8“Unit Cost”A1:B2)
D
=DSUM(A4:D8,“Unit Cost”,A1:B2)
11

What does an outline do?

A
combines data from different worksheets
B
copies the headings to the Clipboard
C
performs calculations
D
groups data by levels
12

Select .

A
any cell in the data block
B
the first cell in the worksheet
C
all cells in the worksheet
D
the last cell in the worksheet
13

Click the tab.

A
Formula
B
Insert
C
Data
D
Review
14

What is the purpose of the Subtotal feature?

A
summarizes data for analysis
B
copies the headings to the Clipboard
C
performs calculations
D
groups data by levels
15

In the group, click to access the Subtotal dialog box.

A
Get & Transform Data
B
Queries & Connections
C
Sort & Filter
D
Outline

Did you find these answers helpful?