stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Spreadsheets -P6 Flashcards | StudBud
Explore
/
Spreadsheets -P6
Spreadsheets -P6
20 terms
·
StudBud Administration
·
103 plays
Spreadsheet vocabulary and concepts
Flashcards
20 cards
F
Practice quiz
P
Host live
L
Questions
20
Answers
1
A function used to calculate the average of some values
max
sum
average
min
2
A function used to calculate the lowest value in a range of cells
min
average
sum
max
3
The type of chart that compares numbers side to side
Line chart
Column chart
Surface chart
Pie chart
4
A predefined word that performs calculations by using specific values in a specific order.
Range
Formulas
Functions
Minimum
5
=A2 + B2 + C2
would be an example of what?
Minimum
Range
Functions
Formulas
6
Adds the numbers in a row or column
Merge and Center
Sort and Filter
Currency Tool
Sum Tool
7
Includes a group of cells in the same row or column
Range
Formulas
Functions
Minimum
8
Compares information Ex: Pie, bar, line
Charts and Graphs
Sort and Filter
Smart Art
Merge and Center
9
To put the $ symbol for a price in a numeric cell
=$ + number
you select the cell
currency format
type $
10
What type of data can you enter in a cell?
dates
text or labels
Numeric
All the answers are correct
11
The type of chart that is good for showing data changes over time
Line chart
Pie chart
Column chart
Surface chart
12
A computer application that helps organize information and data. Can create lists, tables, charts, and graphs
Column
Spreadsheet
Row
Cell
13
An expression that uses mathematical operations
Range
Formulas
Functions
Minimum
14
The type of chart that helps compare how much of the total comes from each part
Column chart
Surface chart
Pie chart
Line chart
15
A horizontal group of cells, contains information about the same subject
Spreadsheet
Column
Row
Cell
16
=SUM(A2:E2)
would be an example of what?
Minimum
Formulas
Range
Functions
17
A function used to calculate the highest value in a range of cells
min
sum
max
average
18
Makes up the rows and columns, holds single pieces of information
Cell
Column
Row
Spreadsheet
19
Combines two or more cells to create a new, larger cell.
Combine
make a calculation
Merge
create a new cell
20
A vertical group of cells
Row
Cell
Column
Spreadsheet