stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Spreadsheets Flashcards | StudBud
Explore
/
Spreadsheets
Spreadsheets
19 terms
·
StudBud Administration
·
271 plays
Imported from external platform
Flashcards
19 cards
F
Practice quiz
P
Host live
L
Questions
19
Answers
1
Who uses spreadsheets?
Teachers, Accountants,Sales people
All of the above
Banks, Insurance Companies, Farmers
Mortgage Advisers, Scientists, Market researchers, Engineers
2
You can format cells?
False
True
3
Filling down or filling across cells in a worksheet is called .......
Filing
Phishing
Download
Autofill
4
What is
= 6+2*3
A Function
A Formula
5
A label is?
A number
A logo
A brand
A descriptive text entry
6
+
,
-
,
*,
/
,
^ are examples of
Symbols
Operators
7
All formulas begin with
A plus sign
All of the above
An Operator
An equal sign
8
Identify the function
+A +B +C
=C2*K9
=SUM(B3:B10)
= 6+2*3
9
Check ALL the answers that are suitable uses for spreadsheets
Timetables, wage calculation, financial calculations
None of the above
Keeping track of sales and returns and create charts
Record exam results, school attendance records
10
A function performs a specific set of operations on cell values to yield a single output value
True
False
11
A row is......
1,048,576 rows
Made up of horizontal cells and are referenced by numbers
Made up of horizontal cells and referenced by letters
Referenced by column label first and then row label
12
What is a value?
A label
Values are numbers that sit in a cell that can be calculated
Currency
A workbook
13
How do you identify an active cell?
Break for the border
It has a black or blue border around it
Broken Border
It has a green border around the cell
14
A Column is...
Made up of vertical cells and are referenced by letters
Cells that make a grid
Made up by horizontal cells and referenced by letters
Made up of horizontal cells and are referenced by numbers
15
Identify a formula
=H2O
=SUM(B3:B10)
E2:E5
=A1+A2+A3
16
A formula is an expression that informs the computer what mathematical operation to perform
False
True
17
What does this function do =sum(B2:B5)?
Averages cells B2 to B5
Adds values contained in cells B2 to cell B5
Nothing
Sums up
18
What is a cell?
An area on a workbook where you can perform calculations
A vertical area on a workbook
A cell is an area on a worksheet where you can enter data
Excel
19
Spreadsheets can be used to ......
Perform calculations
Create a chart
Create lists
All of the above
