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