stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Apps 2 Obj 6.0 Flashcards | StudBud
Explore
/
Apps 2 Obj 6.0
Apps 2 Obj 6.0
30 terms
·
StudBud Administration
·
127 plays
Imported from external platform
Flashcards
30 cards
F
Practice quiz
P
Host live
L
Questions
30
Answers
1
Which function would be used to add a range of cells in a spreadsheet?
AVG
MAX
SORT
SUM
2
What function would return the same answer as the formula =B2+B3+B4+B5+B6+B7?
=SUM(B2+B7)
=SUM(B2*B7)
=SUM(B2:B7)
=SUM(B2/B7)
3
There are 4 types of cell data: labels, values, formulas and functions.
-
-
false
true
4
Which function will count the number of cells in a range?
AUTOSUM
COUNT
IF
RANGE
5
Columns are identified by numbers.
False
True
6
$ is also used in a mixed cell.
True
-
False
-
7
Values are numerical data used in calculations.
False
True
8
Which function would be used to return the smallest value in a range of spreadsheet cells?
MAX
COUNT
MIN
SUM
9
The Order of Operations should be followed to complete calculations.
True
False
10
Values are numerical data used in calculations.
false
-
-
true
11
Your school has 20computers in your computer lab they are connectedby using cables
Virtual
Local area network (LAN)
Satellite
Wide area network (WAN)
12
How is spreadsheet software used for personal use?
organizing baseball cards
keying a personal business letter
organize and predict entertainment expense
doing language art homework
13
An active cell is indicated by a blinking boarder.
True
False
14
A cell is an intersection of 2 rows.
True
False
15
In a spreadsheet formula, the asterisk and diagonal stand for what mathematical symbols?
Multiplication and division
Multiplication and subtraction
Addition and subtraction
Subtraction and multiplication
16
A cell address is also call a cell reference.
False
True
17
Which function would be used to return the largest value in a range of spreadsheet cells?
AUTOSUM
MIN
SUM
MAX
18
Labels are alphabetical text.
-
-
false
true
19
How is spreadsheet software used for personal use?
Organize and predict entertainment expenses
Keying a personal business letter
Doing language art homework
Organizing a baseball card collection
20
A cell range is a group or block of cells.
False
True
-
-
21
Which of the following devices can you share with other computers on the network?
Mouse
Microphone
Printer
Headphones
22
Active cell are ready to recieve data.
True
False
23
There are 4 types of cell data: labels, values, formulas and functions.
True
False
24
Cell references of cells names that need to remain the same when copied are called what?
absolute
automation
relative
relational
25
Cell references of cells names that need to remain the same when copied are called what?
Relational
Absolute
Automation
Relative
26
The Order of Operations should be followed to complete calculations.
-
-
true
False
27
Cell references or cell names that automatically change when copied are called what?
Absolute
Automation
Relational
Relative
28
A cell range is a group or block of cells.
False
True
29
To record data to show the change in temperature over a two-week time Which software do we use
Word processing
Desktop publishing
Spreadsheets
Telecommunication
30
Cell references or cell names that automatically change when copied are called what?
Automation
Relational
Absolute
Relative