computing revision summer term

Description

Flashcards on computing revision summer term, created by n o on 16/05/2018.
n o
Flashcards by n o, updated more than 1 year ago
n o
Created by n o over 6 years ago
35
1

Resource summary

Question Answer
Name all the simple formulas (the cells are A1 and A2) =A1+A2 =A1*A2 =A1/A2 =A1-A2
Name all function formulas (the cells are A1 and A2) =average(A1:A2) =max(A1:A2) =min(A1:A2) =sum(A1:A2)
What are the definitions of a column, row, labels, values, and formula? FORMULA - A calculation set up in the spreadsheet COLUMN - Vertical line down the spreadsheet - uses numbers as its reference ROW - The horizontal line across the spreadsheet - uses letters as its reference VALUE - Anything on the spreadsheet that uses number or currency LABELS - Usually a text label describing information on a spreadsheet e.g Title, description label
What is B12? (for example) A cell
What is a cell? An individual box on a spreadsheet
What is an active cell? Where you are on the spreadsheet at any given time - has a bold box around it
What is a cell reference? It is an address where the row meets the column e.g A1
True or False? You start a formula or a function with an = sign? True
Say you are dividing something by a cell, and in that cell there is a 2 why is the formula =B12/2 bad? Because if you change the number you are dividing by to 3 in the cell the answer will not change as well
Why could you use the formula =B12*$B$4 ever? Because this means that if you have a lot of cells you want to multiply by cell B4 and you want to drag it down, it will always multiply by the cell B4
What is Absolute reference? when you use the dollar sign ($) in a function or a formula (the previous flash card is an example)
if you have been working on spreadsheet and you want to save it quickly what would you do? Click the blue floppy disk icon at the top of the screen
What is the add, subtract, multiply and divide cymbal for a spreadsheet? + is the add cymbal - is the subtract cymbal * is the multiply cymbal / is the divide cymbal
turn the card for an example of the IF function If a customer's total bill is over £100, deduct 10% from their bill then, the formula in Excel would be (and example of the cell with the customer'sbill in it is A10) IF(A10>100,"Deduct 10%","No discount)
What are column AND bar charts good for? a - good for nothing b - comparing different groups of data c - comparing similar data with each other b - comparing different groups of data
What are pie charts good for? a - comparing data proportionally against one b - comparing similar data with each other c - comparing the correlation between sets of data a - comparing data proportionally against one
what are line graphs good for? a - good for nothing b - comparing changes over time c - comparing the correlation between sets of data b - comparing changes over time
What are scatter graphs good for? a - comparing data proportionally against one b - comparing similar data with each other c - comparing the correlation between sets of data c - comparing the correlation between sets of data
What are radar graphs good for? a - comparing similar data with each other b - comparing data proportionally c - comparing different groups of data a - comparing similar data with each other
Show full summary Hide full summary

Similar

Business Studies Unit 2
tara.springate
Flashcards de Inglês - Vocabulário Intermédio
miminoma
A Christmas Carol Quotes
0serenityrose0
B2, C2, P2
George Moores
ENG LIT TECHNIQUES
Heloise Tudor
Key Biology Definitions/Terms
courtneypitt4119
Using GoConqr to study Economics
Sarah Egan
Navegacion
Adriana Forero
2PR101 1.test - 1. část
Nikola Truong
Repaso prueba Revalida Enfermeria 2016 Parte:2
Rodrigo Lopez
The GoConqr Guide to End of Term Exams
Sarah Egan