II Partial Computer

studied byStudied by 101 people
4.3(11)
get a hint
hint

Converting text to columns

1 / 29

Tags & Description

Studying Progress

0%
New cards
30
Still learning
0
Almost done
0
Mastered
0
30 Terms
1
New cards

Converting text to columns

is very useful in Excel. For example, if you have a list with first and last names in a single cell, separating the names into separate cells will make the data easier to work with when searching, filtering or editing.

New cards
2
New cards

Conditional Formatting

is great for formatting a cell(s)—like, changing font or fill color—based on criteria or rules you set.

New cards
3
New cards

COUNTIF function

is great for counting an entry if it meets certain criteria

New cards
4
New cards

Removing Duplicates

Sometimes a large spreadsheet may have duplicate rows. This usually occurs when more than one person enters data into a shared worksheet

New cards
5
New cards

Sheet Protection

Password protect your worksheets so your work is

not modified by unauthorized persons.

New cards
6
New cards

Password protect

your worksheets so your work is not modified by unauthorized persons.

New cards
7
New cards

Excel table feature

converts a list of data into a formatted table

New cards
8
New cards

pivot table

is an interactive table that allows you to group and summarize large amounts of data in a concise table.

New cards
9
New cards

Data field

A field from the source worksheet that contains values to be summarized.

New cards
10
New cards

Report filter

Data fields in this area act as filters for the pivot table report.

New cards
11
New cards

Column labels

Data fields in this area determine the arrangement of data shown in the columns of the pivot table.

New cards
12
New cards

Row labels

Data fields in this area determine the arrangement of data shown in the rows of the pivot table.

New cards
13
New cards

Values

Data fields in this area determine which data are presented in the cells of the pivot table

New cards
14
New cards

Page field

A field from the source data that you assign to a page (or filter) orientation in a pivot table report.

New cards
15
New cards

Column field

A field from the source data that you assign to a column orientation in a pivot table report.

New cards
16
New cards

Item

A subcategory of a row, column, or page field.

New cards
17
New cards

Row field

A field from the source data that you assign to a row orientation in a pivot table report. For example, Region and Salesperson are row fields.

New cards
18
New cards

Data area

The cells in a pivot table report that contain summarized data.

New cards
19
New cards

Filters

can be used to narrow down the data in your worksheet, allowing you to view only the information you need

New cards
20
New cards

header row

In order for filtering to work correctly, your worksheet should include a

New cards
21
New cards

cumulative

Filters are , which means you can apply multiple filters to help narrow down your results.

New cards
22
New cards

Filter command on the Data tab.

To remove all filters from your worksheet, click the

New cards
23
New cards

Advanced date filters

can be used to view information from a certain time period, such as last year, next quarter, or between two dates

New cards
24
New cards

Advanced number filters

allow you to manipulate numbered data in different ways.

New cards
25
New cards

alphabetical and numerical

You can sort data in …. …. order

New cards
26
New cards

Filter your data

When you add a filter, anyone with access to your spreadsheet will see the filter too. Anyone with permission to edit your spreadsheet will be able to change the filter.

New cards
27
New cards

Filter by condition

Choose conditions or write your own.

New cards
28
New cards

Filter by values

To hide data points, uncheck the box next to the data point and click OK.

New cards
29
New cards

Search

Search for data points by typing in the search box.

New cards
30
New cards

Filter by color

Choose which text or fill color to filter by. You can filter by conditional formatting   colors, but not alternating colors.

New cards

Explore top notes

note Note
studied byStudied by 38 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 14 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 75 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 4 people
Updated ... ago
4.0 Stars(1)
note Note
studied byStudied by 3 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 11 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 10 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 1591 people
Updated ... ago
4.7 Stars(14)

Explore top flashcards

flashcards Flashcard36 terms
studied byStudied by 15 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard75 terms
studied byStudied by 6 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard56 terms
studied byStudied by 12 people
Updated ... ago
5.0 Stars(3)
flashcards Flashcard37 terms
studied byStudied by 3 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard67 terms
studied byStudied by 5 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard71 terms
studied byStudied by 99 people
Updated ... ago
5.0 Stars(2)
flashcards Flashcard47 terms
studied byStudied by 22 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard66 terms
studied byStudied by 208 people
Updated ... ago
5.0 Stars(2)