stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Introducing Spreadsheet Flashcards | StudBud
Explore
/
Introducing Spreadsheet
Introducing Spreadsheet
40 terms
·
StudBud Administration
·
34 plays
Students will answer questions pertaining to Spreadsheet.
Flashcards
40 cards
F
Practice quiz
P
Host live
L
Questions
40
Answers
1
To calculate how much you pay for monthly payments, what mathematical operator do you use?
Addition
Division
Subtraction
Multiplication
2
On most charts, the horizontal (bottom) edge of the plot area is called
X axis
Z axis
A axis
Y axis
3
To add information at the top of a worksheet is a
title
forefront
header
top
4
If you need to average grades for students, what two mathematical operators will you use?
addition and division
addition and subtraction
addition
multiplication and addition
5
What is a way of presenting and comparing spreadsheet data in a visual format?
Selecting
Charting
Plotting
Revising
6
Which is
NOT
an example of a value?
455
$789.33
455-88-6933 (Social Security #)
4%
7
The first step in creating a chart/graph is
Select the data that will be placed in the chart
Change the format of spreadsheet and then highlight data
Select preview to see graph
Choose the chart wizard to help
8
Numerical data that can be used in calculations entered into a spreadsheet
Range
Label
Value
Cell
9
Vertical sections of a spreadsheet; identified by letters
column
copy
cell address
cell
10
Built in formulas used with a range to perform calculations
formula
equation
function
operators
11
The contents in cells A1 through A6 are 6, 3, 4, 7, 9, 2. What function would return 2?
=min(A1:A6)
=sum(A1:A6)
=max(A1:A6)
=avg(A1:A6)
12
Statement that performs a calculation
operators
equation
formula
function
13
To combine several cells together, what option do you choose
Word Text
Center Alignment
Word Wrap
Merge and Center
14
What function would return the same answer as the formula =B2+B3+B4+B5+B6+B7
=SUM(B2:B7)
=SUM(B2/B7)
=SUM((B2:B7))
=SUM(B2+B7)
15
Birthdate 10/20/1982 is an example of a
value
label
function
formula
16
Implementing order of operations, what is the answer to the equation?
10+5*8
55
50
60
65
17
An advantage of computerized spreadsheets is
to create newsletters
to calculate numbers
to check grammar
to search for data
18
What changes occur when formatted as currency?
The numbers format with a # and two decimal places.
The numbers format with a % and two decimal places.
The numbers format with a $ and two decimal places.
The numbers format with a ^ and two decimal places.
19
A row and column arrangement of data used to enter, calculate, and analyze numbers is a
database
spreadsheet
desktop publishing
word
20
On most charts, the vertical (left) edge of the plot area is called
Z axis
Y axis
X axis
A axis
21
B5:B13 is an example of a
Group
Range
Cell
Active Cell
22
The cell in which you are currently working
cell
cell range
active cell
cell reference
23
Tony needs to calculate the total of his sales in columns B, C, D, and E on row 5. Formula is
=B5+C5*D5+E5
=B5+C5+D5+E5
=(B5+C5) + (D5+E5)
=B5 + C5 + D5 + E5
24
Which formula is correct based on this statement: Subtract F10 from the sum of range A1:A12
=SUM(A1:A12)-F10
=SUM((A1:A12))-F10
=SUM(A1:A12)-F10)
=SUM-F10(A1:A12)
25
To calculate Quantity and the Price, what is the formula?
=Quantity+Price
=Quantity-Price
=Quantity*Price
=Quantity/Price
26
To calculate students' grades, the _____ function must be utilized.
MIN
AVG
MAX
SUM
27
A group of cells closely related
cell range
cell adjacent
cell operators
cell address
28
Looking at the diagram, what cell address is the active cell?
D10
D7
D8
D9
29
To total a column/row, the ____ function must be utilized.
SUM
MAX
AVG
MIN
30
The point at which a column and a row intersect or meet
Active Cell
Cell
Cell Range
Cell Address
31
B10 is an example of a
cell reference
cell location
cell address
all are correct
32
To use numbers as labels, you must use an ________ for it to display it as a label.
ampersand
alt
apostrophe
asterisk
33
The prominent types of graphs are the
Bar, Line, and Pie
Pie, Bar, and Area
Radar, Bar, and Line
Bar, Line, and X Y Scatter
34
If contents in D2 through D6 are 25, 15, 4, 11, 3. What function would return 25.
=MAX(D2:D6)
=SUM(D2:D6)
=AVG(D2:D6)
=MIN(D2:D6)
35
What is the best way to format cells C9 through C19?
Format each cell individually
Highlight desired cells all at once
Highlight the entire spreadsheet
Format two cells at a time
36
To create a formula to calculate sales tax 2% of price in (C3), which formula is correct?
=C3+2%
=C3-2%
=C3/2%
=C3*2%
37
The total is $15,234 (D3) and total of months is 60 in E3. The formula for monthly payments is
=D3*E3
=D3/E3
=D3-E3
=D3+E3
38
=AVG(A2:A6) is an example of a
formula
calculation
function
equation
39
This bar shows what is typed in each cell.
tool bar
menu bar
formula bar
status bar
40
Horizontal sections in a spreadsheet; identified by numbers
rows
formulas
cells
columns
