stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Chapter 20: Data Analysis Flashcards | StudBud
Explore
/
Chapter 20: Data Analysis
Chapter 20: Data Analysis
20 terms
·
StudBud Administration
·
5 plays
A#quiz#about#spreadsheets
Flashcards
20 cards
F
Practice quiz
P
Host live
L
Questions
20
Answers
1
When sorting, column headers of the data should be selected first.
False
True
2
Data not created for test purposes.
Extreme data
Live data
Normal data
Abnormal data
3
Selected a nested formulae below.
=IF(A1=5"Discount","No discount")
=SUM((COUNT,A1:A5)+(COUNT,B1:B3))
4
In a cell reference, for example A1, what does the letter refer to?
The column the cell is in
The row the cell is in
The worksheet the cell is in
5
Enables you to refer to a group of cells without having to lookup cell references.
Cell
Named range
Range
6
What word is used to describe re-organising the order of data?
Search
Sort
Fill
7
Which formulae is correct?
=VLOOKUP(B3,Pay,,0)
=VLOOKUP(B3,Pay,2,0)
VLOOKUP(B3,Pay,2,0)
8
The software can help guide us through the process of creating a chart. This is called a...?
Help
Wizard
Magician
Witch
9
What is defined manually by the user to calculate values?
Function
Expression
Condition
Formula
10
Data that would not be accepted when testing.
Abnormal
Normal
Extreme
11
What term describes changing the horizontal or vertical position of text?
Font
Alignment
Format
12
Which tool is best used to duplicate information from cell to cell?
Fill handle
Autosum
Filter
13
=COUNTIF(B3:B,>2000) - Will this function work in Excel?
Maybe
Yes
No
14
Why might charts and graphs be a way of making the data in a spreadsheet easier to understand?
Because primary school children can use bar charts.
Because the data is presented in a more visual way.
Because they don't require you to enter any formula.
15
Wrap text is an option which can be applied to cells in order to do what?
Put a background on a cell containing text
Put a border around a cell containing text
Resize a cell to fit the text inside
16
Formulae must always start with which symbol?
Equals
Brackets
Add
17
What is the order of performing mathematical operations in Excel?
PEMDAS
PEDMAS
EMDAS
PDMASE
18
Which of the following tasks would a spreadsheet be best used for?
Manage the details of members at a gym
Present information about a new television channel
Keep track of money raised at a charity event
19
Which of the following is NOT capable of producing a spreadsheet?
Microsoft Office Word
Open Office Calc
Microsoft Office Excel
20
Which of the following is not an Excel function?
SUMA
AVERAGE
COUNTIF
COUNTA
