stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Spreadsheets 1 Flashcards | StudBud
Explore
/
Spreadsheets 1
Spreadsheets 1
20 terms
·
StudBud Administration
·
95 plays
Imported from external platform
Flashcards
20 cards
F
Practice quiz
P
Host live
L
Questions
20
Answers
1
A function performs a specific set of operations on cell values to yield a single output value
I know this is not right.
I believe this is correct.
2
+ -
*
/ ^
These are examples of _____ .
Math Operators
Math Symbols
3
You can
Format
cells?
This is verified by what I know.
I know this is not true.
4
Identify the correctly formatted
Formula
.
=H2O
=SUM(B3:B10)
=A1+A2*A3/5
E2:E5
5
A row is . . .
1,048,576 rows.
made up of horizontal cells and are referenced by numbers.
referenced by column label first and then row label.
made up of horizontal cells and referenced by letters.
6
In a spreadsheet, what is a
value
?
It is a Label or Character Data.
it is Currency or Money.
It is a Workbook.
It is a Number or Numerical Data.
7
Identify the correctly formatted
Function
.
+A +B +C
= 6+2*3
=SUM(B3:B10)
=C2*K9
8
Filling down a column or filling across a row of cells in a worksheet is called _____ .
filing
download
autofill
phishing
9
A formula is an expression that informs the computer what mathematical operation to perform.
There is evidence of this being correct.
There is no truth to this statement.
10
Who uses spreadsheets?
They are used by Mortgage Advisers, Scientists, Market Researchers
They are used by Teachers, Accountants, Sales People.
They are used by Banks, Insurance Companies, Farmers.
All of the above
11
In a spreadsheet, a
label
is _____ .
a number
a descriptive text entry
a brand
a logo
12
All
formulas
begin with _____ .
All of the above
a plus sign.
an operator.
an equal sign.
13
What is a workbook?
It is the default file of Microsoft Excel or Google Sheets.
A place where users enter text or numbers in cells & perform calculations.
It is a column.
It is a row.
14
Spreadsheets can be used to _____ .
create lists
All of the above
perform calculations
create a chart
15
What is this?
= 6 + 2 * 3
It is a Function.
It is a Formula.
16
What is a cell?
An area on a workbook where you can perform calculations.
A cell is a vertical area on a workbook.
A cell is an area on a worksheet where you can enter data.
The Microsoft Excel Program
17
What does this function do
=sum(B2:B5)
?
It averages the cells B2 to B5.
It sums up the cells in column E.
It does nothing.
It adds the values contained in cells B2 to cell B5.
18
How do you identify an active cell?
It has a dashed border around it.
It has a line through the cell.
It has a border around the cell.
The cell is filled with color.
19
List suitable or good uses for spreadsheets.
None of the above are good uses..
Spreadsheets can be used to record exam grades and school attendance.
kSpreadsheets can be used for keeping track of sales and returns.
Spreadsheets can be used for timetables, wage calculations.
20
A Column is . . .
made up by horizontal cells and referenced by letters.
made up of vertical cells and are referenced to by letters.
made up of horizontal cells and are referenced by numbers.
cells that make a grid.
