stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
A Few Excel Terms Flashcards | StudBud
Explore
/
A Few Excel Terms
A Few Excel Terms
33 terms
ยท
StudBud Administration
ยท
26 plays
A #Excel #Terms Quiz
Flashcards
33 cards
F
Practice quiz
P
Host live
L
Questions
33
Answers
1
What is this?
food
organized
columns
sort
2
(=(A1+B2)*G3/F5 is an example of what?
Complex formula
A formula that is not complex
Impressive geometry
A massive jar of mayonnaise.
3
What is
Not
in the
Standard Tool Bar
?
Research
Share
Chart Wizard
Print Preview
4
What is the
definition
of Column Label?
a vertical series of cells in a chart or spreadsheet
A program in the Microsoft Office suite of applications
Defines the data in column
Column Headers
5
what can you do with the title bar?
Label the worksheet
Move the window
Weep Bitterly
Move the cell
6
What is the
Definition
of Range?
Data contained in different areas of a worksheet
the range is a group of cells within a row or column
finds the values that you want that formula to calculate
=sum(A1:A10)
7
what shows you only the information you need?
Range
Filter
Sort
Format
8
what does the clipboard do?
cuts, copies, and pastes
clips, snips, and sticks
x, c, v
makes only the data you want appear
9
What is the symbol for a function?
ฮฃ
ยถ
f๐
โฎ
10
What Is This Image?
Box with Numbers
Autofill
Format Painter
Range
11
if the formula was moved down and it was relative what would it look like?
=(B4-B3)/B3
=(B2-B1)/B1
=(B3-B2)/B2
=(B2-B1)/B2
12
What is this?
Format
Formula Bar
Formula
Filter
13
What is the correct order of precedence?
=,(), ^, *, /, +, -
(), /, -, +, ^, *, =
+, =, ^, *, /, -, ()
=, (),-, ^, +
14
What is the
definition
of cell address?
A selected cell and the location of what is being modified
A place where a cell lives
intersection between a row and column starting with cell A1
illustrated example of a highlighted cell in Microsoft Excel
15
Which is the Arithmetic operator?
+
&
%
!
16
what is the
Definition
of Formula?
a fixed form of words
=SUM(A1:A3)
a mathematical relationship or rule expressed in symbols.
calculates, get totals of multiple cells, rows, or columns
17
The___ becomes active when you type the enter button the cancel button or the function button.
formula bar
format
formula
function
18
what is the sum?
3
โ
2
4
19
Which Is Not A Complex Formula?
4.53*8.21*0.23
(4*5-6.7)/3
723^6
458-52/3
20
What is the symbol for autosum?
ฮ
ฮฃ
E
ฮพ
21
What does Formatting a spreadsheet do?
Changes the look of a number w/o changing the number itself.
(0.8, $0.80, 80%,)
=(A3*B3)*(D4*G4)*A5 F4
BOLD
22
What buttons are in the formula bar?
[โ] [ฯ] [ฦ๐]
[โ] [โ] [ฦ๐]
[x] [โ] [Formulas]
[x] [โ] [ฦ๐]
23
what do row labels do?
allows you to place borders
allow you to insert text
allow you to paint the title bar
allow you to choose the most important columns in a table.
24
what is cell?
stuff your body is made of
Where you change the format
a box in which you can enter a single piece of data.
25
What is the
definition
of Auto fit
to make the letters and numbers in a cell smaller or bigger
A feature in Excel that changes the size of the file
Double click the line in-between a cell
a feature that adjusts the width of a column or cell
26
What is this image of?
Row Label
Title Bar
Legend
Menu Bar
27
Which page is in portrait?
1.
2.
28
Where is the fill handle for autofill?
here
here
here
here
29
what is the format painter?
paint the background
painting format sheets
when you want to copy formatting from one item to another.
30
what is fill color?
the color of the background in a cell
the color of the background
rainbow colors
paint
31
which cell reference is absolute?
A:1
1:A
$Q:$5
$1:$A
32
what is the menu bar?
a horizontal bar below the title bar
a horizontal bar below the title bar
33
which page is in landscape?
2.
1.
