What are some function?

Sum, Average, Maximum, and Minimum

What is a cell reference?

Gives instructions for How cell data is used in calculations, indicates a cell’s location

What do formulas use?

Addition, Subtraction, Multiplication, Division

What is a cell address?

refers to one specific location on a spreadsheet.

What is a Spreadsheet?

to organize, report innumber form., -an arrangement of cells in columns and rows

What is Merge used for?

used to combine two or more cells; default is center.

What is Label Classification?

used for cells containing text/numbers that not in math.

What is Value Classification?

Indicates that the data can be used in calculations.

refers to a group of adjacent cells.

classified according to its intended purpose

Name some formatting for spreadsheets

Font size and style, header/footer

instructs the software to perform a calculation.

What is wrap used for?

used to align multiline text within a cell.

individual locations on a spreadsheet.

a file which contains one or more spreadsheets.

studbud

Spreadsheet Study Guide

18 termsStudBud Administration1 play

Spreadsheet study guide for upcoming post test!!!

Flashcards18 cardsFPractice quizPHost liveL

Questions 18

Answers

1
Name some more formatting for spreadsheets
Merge cells
Font Style
Justification
MAX
2
What are some function?
Mean, Median, Mode
Sum, Average, Maximum, and Minimum
Sum, Label, Hour, Top
3
What is a cell reference?
Provides a cell's data
Gives instructions for How cell data is used in calculations
Gives instructions on how to make a spreadsheeet
indicates a cell’s location
4
What do formulas use?
Addition, Multiplication, Sensation
Addition, Subtraction, Division, Calculation
Addition, Subtraction, Multiplication, Division
5
What is a cell address?
Specific location on a monitor
refers to one specific location on a spreadsheet.
One specific location in a business document
Specific location in a presentation
6
What is a Spreadsheet?
to organize, report innumber form.
-an arrangement of cells in columns and rows
Arrangement of tables and chairs
Used to Calculate, read, and do presentations
7
What is Merge used for?
Used to combine 20 or more cells
used to combine two or more cells; default is center.
Used to combine 0 or 1 cells
8
What is Label Classification?
used for cells containing text/numbers that not in math.
Used for cells that have only text
Used for Cells that only contain numbers
9
What is Value Classification?
Indicates that the data can be used in calculations.
Indicates data to be used in labels and formatting
I have absolutely no idea, I should've studied
Indicates that the data will be used in the title
10
What is Cell Range?
Refers to one specific cell
refers to a group of adjacent cells.
11
What is Cell Data?
Classified according to its main calculation
classified according to its intended purpose
Classified according to its indent
12
What is a basic function?
A shortcut for a classification
A shortcut for a label
a shortcut for a formula.
13
Name some formatting for spreadsheets
Cells
Font size and style
header/footer
Data classification
14
What is a Formula?
Instructs the software to perform a dance
instructs the software to perform a calculation.
Instructs a software as a label
15
What is wrap used for?
Align cells in a spreadsheet
used to align multiline text within a cell.
Align label in a column
Align data in a row
16
What is the order of operations?
PAMDES, as in common math
PEMDAS, as in common math
PMRDAS, as in common math
17
What are cells?
individual locations on a spreadsheet.
Locations in a presentation
Locations on a computer
Locations in a business document
18
What is a workbook?
A file which contains one or more books
a file which contains one or more spreadsheets.
A file which contains four or more spreadsheets

Spreadsheet Study Guide Flashcards | StudBud