a number you type into a spreadsheet

What is a spreadsheet?

Software used for calculations, graphs and charts

How can a spreadsheet work out predictions?

Modelling data using What If statements

How can a shop manager use a spreadsheet?

keeping tracks of stocks and budget of the business

What does formatting mean in a spreadsheet?

changing the appearance of the spreadsheet

what is the SUM of numbers?

add values in the selected cells

how can you format a cell?

changing the color of text and adding borders

what does the COUNT function do?

count how many of the selected cells

text you add to a spreadsheet to help describe the numbers

studbud

SpreadsheetsYr8

20 termsStudBud Administration189 plays

#spreadsheets

Flashcards20 cardsFPractice quizPHost liveL

Questions 20

Answers

1
In a spreadsheet, what makes each cell unique?
Rows number
Cell reference
Columns letter
Text inside it
2
what is a value?
a number you type on a document
a number you type into a spreadsheet
a letter you type into a spreadsheet
a symbol you type into a spreadsheet
3
What is a cell reference made up of?
Rows number and Columns letter
Signs and symbols
Time and date
Tables and graphs
4
what symbol do all formulae start with?
multiply sign
subtract sign
add sign
equal sign
5
Which of the following formulae are INCORRECT
=min(A1:A10)
=sum(A1A10)
=max(A1:A10)
=average(A1:A10)
6
What is a spreadsheet?
Used for making snappy images
Software used to store data and information
Software used for calculations, graphs and charts
Used for calculating probability and statistics
7
what is a spreadsheet used for?
making predictions
analyzing data and information
calculating data
all of the mentioned
8
Which of the following formulae are showing the lowest value in a list?
=sum(A1:A10)
=max(A1:A10)
=min(A1:A10)
=average(A1:A10)
9
What type of graph can be used to work out proportions?
Scatter
Line
Pie
Bar
10
How can a spreadsheet work out predictions?
Drawing pie charts
Calculating results
Modelling data using What If statements
Creating graphs
11
How can a shop manager use a spreadsheet?
sorting employee uniforms
keeping tracks of stocks and budget of the business
monitor the behavior the customers
household expenses
12
What does formatting mean in a spreadsheet?
changing the appearance of the spreadsheet
changes to the values entered
changing the formula
changing nothing
13
what is the SUM of numbers?
add values in the selected cells
finding the smallest value
finding the biggest value
finding the median
14
how can you format a cell?
Make no changes
changing the color of text and adding borders
Including more values in a range
Changing the name of a file
15
what does the COUNT function do?
Finds the highest value
Works out the average
count how many of the selected cells
Subtracts values
16
What does the * sign represent?
Divide
Add
Multiply
Subtract
17
Where can formulae be viewed and edited on?
Formula bar
Tool bar
Column bar
Menu bar
18
Which of the below are a type of graph?
evaluation
Cake chart
drent graph
bar chart
19
Which of the formulae below are used to work out the average?
=averag(A1:A10)
=average(A1:A10)
=average(A1-A10
=SUM(A1:A10)
20
what is a label?
a worksheet that does calculations
a number you type into a spreadsheet
text you add to a spreadsheet to help describe the numbers
formula

SpreadsheetsYr8 Flashcards | StudBud