Question 1
Question
What software would you use to make a gif for sending to your mates on instagram?
Answer
-
PowerPoint
-
Excel
-
Word
-
CV Superstar
Question 2
Question
What software would you use to make flyers for a local DJ event?
Answer
-
PowerPoint
-
Excel
-
Word
-
CV Superstar
Question 3
Question
If you had to make up a report with a financial summary of your outgoings for a mortgage application what software would you choose?
Answer
-
PowerPoint
-
Excel
-
Word
-
Barclays Premier
Question 4
Question
What is the best software for writing a letter to get a job
Answer
-
PowerPoint
-
Excel
-
Word
-
CV Superstar
Question 5
Question
Add these labels to the image of a typical excel sheet
Zoom control, sheet name,row labels,column labels, menus
Answer
-
Sheet name
-
Row Labels
-
Column labels
-
Menus
-
Zoom control
Question 6
Question
What software would you use to set up a list of birthdays for your family?
Answer
-
PowerPoint
-
Excel
-
Word
-
CV Superstar
Question 7
Question
A workbook is the name for a group of pages in PowerPoint
Question 8
Question
which of the following can you add to a cell in Excel?
Answer
-
picture
-
words
-
names
-
dates
-
phone numbers
Question 9
Question
What will be the anwer to this sum in excel if A3=10 and B3=5 and the formula for Cell C3 is =A3/10+B3/5*A3/B3*6
Question 10
Question
A group of cells selected together is called a
Answer
-
selection
-
range
-
bunch
-
column
Question 11
Question
A named area on the sheet which may be coloured and sorted is called a
Question 12
Question
Excel is great for [blank_start]tabulating[blank_end] and sorting [blank_start]information[blank_end] but comes into its own when we want to [blank_start]manipulate[blank_end] large amounts of data.
Answer
-
information
-
news
-
money
-
colours
-
tabulating
-
inserting
-
lining up
-
losing
-
delete
-
inform
-
manipulate
Question 13
Question
excel was first used by the americans to work on the moon landings
Question 14
Question
Tables from Excel can be dropped into PowerPoint and word documents
Question 15
Question
A header row is ....
Answer
-
The toolbar that is on the top of any microsoft software
-
Messi's all time record season stats
-
A row of titles for data in a sheet
-
The bar that displays function in a cell
Question 16
Question
Make sure that each sheet in a [blank_start]workbook[blank_end] is for a [blank_start]specific task[blank_end] to make it easy to work with. There is nothing worse than having to [blank_start]scroll[blank_end] across and down sheets to find [blank_start]important[blank_end] information. To help it is good practice to name sheets.
Answer
-
presentation
-
workbook
-
calendar
-
spin
-
drag
-
scroll
-
important
-
total
-
lost
-
fixed time
-
specific task
-
specific day
Question 17
Question
Autosum is a fast way of
Answer
-
adding up complete rows or columns of numbers
-
making a series of numbers from 1 to 100
-
calculating averages of numbers on a page
-
adding up ranges of numbers arrange in rows or columns
Question 18
Question
Select the ways that exel can format numbers
Answer
-
general
-
number
-
currency
-
date
-
text
Question 19
Question
Excel has a hidden programming language called visual basic for applications VBA
Question 20
Question
Excel has an autosave function that needs to be connected to the internet to work