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