stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Excel Vocab Part 2 Flashcards | StudBud
Explore
/
Excel Vocab Part 2
Excel Vocab Part 2
35 terms
·
StudBud Administration
·
52 plays
The second 35 words
Flashcards
35 cards
F
Practice quiz
P
Host live
L
Questions
35
Answers
1
A format that controls how numerical data is displayed
Live View
Format
Number Format
Merge and Center
2
A cell address that can change in a copied formula
Format Painter
Copy
Relative Reference
Paste
3
A collection of coordinated fonts, colors, and effects for graphic elements
Percent Format
Auto Fill
Date
Theme
4
To adjust the size properly.
Show Formulas
Formula
Scale
Print Titles
5
The position for displaying and printing text either horizontally or vertically
Transpose
Drag-and-Drop
Cut
Orientation
6
Keyboard shortcuts for choosing ribbon commands that you display by pressing Alt.
Key Tips
Fill Handle
Default Column Width
Keyboard Shortcuts
7
A green box on the lower-right corner of the selected cell or range
Default Column Width
Key Tips
Keyboard Shortcuts
Fill Handle
8
The order in which Excel performs the mathematical operations specified in a formula
Order Of Precedence
Absolute Reference
Clipboard
SUM Function
9
A button that you click to restore a dialog box to it’s normal size after using the Collapse Dialog Button
Arithmetic (mathematical) Operator
Range
Collapse Dialog Button
Formula
10
A command that enables you to display the formulas in a worksheet.
Print Titles
Show Formulas
Scale
Formula
11
A feature that causes long cell entries to appear on multiple lines.
Wrap Text
Noncontiguous Range
Series
Contiguous Range
12
A cell entry that indicates a date or time and is stored as a date code in Excel.
Theme
Percent Format
Date
Auto Fill
13
The feature that enables Excel to create a series automatically.
Theme
Percent Format
Auto Fill
Date
14
Cells in a worksheet that acts as a block, but are not necessary adjacent to each other.
Noncontiguous Range
Wrap Text
Contiguous Range
Series
15
The command used to place a copy of data from the selected cell or range on the clipboard.
Paste
Copy
Format Painter
Relative Reference
16
A tool that enables you to copy formatting from a cell and apply it to another cell or range.
Copy
Paste
Format Painter
Relative Reference
17
A block of adjacent cells in a worksheet.
Wrap Text
Contiguous Range
Series
Noncontiguous Range
18
A block of cells in an Excel worksheet.
Collapse Dialog Button
Range
Formula
Arithmetic (mathematical) Operator
19
A format that shows you how a gallery formatting choice will appear in the worksheet
Number Format
Live View
Merge and Center
Format
20
A method to rearrange data by switching the positions of columns and rows.
Drag-and-Drop
Orientation
Cut
Transpose
21
A feature that enables you to automatically combine cells and center the contents
Merge and Center
Live View
Number Format
Format
22
Row and column labels that reprint on each page of a print out.
Print Titles
Scale
Show Formulas
Formula
23
The command used to remove data from a cell or range of cells and place it on the clipboard.
Orientation
Cut
Transpose
Drag-and-Drop
24
An instruction Excel uses to calculate a result.
Formula
Range
Arithmetic (mathematical) Operator
Collapse Dialog Button
25
A method used to move or copy the contents of a range of cells
Orientation
Transpose
Drag-and-Drop
Cut
26
A built-in calculation used to add a range of values together.
Clipboard
SUM Function
Absolute Reference
Order Of Precedence
27
A list of sequential numbers, dates, times, or text.
Wrap Text
Series
Noncontiguous Range
Contiguous Range
28
Specific keyboard keys that you press together or in sequence to execute commands or apply settings.
Key Tips
Keyboard Shortcuts
Default Column Width
Fill Handle
29
A Windows feature that holds data or graphics you cut or copy prior to pasting to another location.
Order Of Precedence
Clipboard
Absolute Reference
SUM Function
30
The default number of characters that display in a column based on the default font.
Default Column Width
Keyboard Shortcuts
Fill Handle
Key Tips
31
A cell address in a formula that will not change when you copy the formula to another location.
Clipboard
SUM Function
Order Of Precedence
Absolute Reference
32
To apply attributes to cell data change the appearance of the worksheet.
Merge and Center
Live View
Format
Number Format
33
The command used to place data from the Clipboard to a location on the worksheet.
Paste
Relative Reference
Copy
Format Painter
34
Symbols used in mathematical operations: + for addition, - for subtraction, * for multiplication, / for division, and ^
Formula
Range
Collapse Dialog Button
Arithmetic (mathematical) Operator
35
A style that displays decimal numbers as a percentage.
Date
Percent Format
Auto Fill
Theme