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