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