Excel basics introduction quiz

Description

This quiz is an introduction/basic quiz on how excel functions
tony thompson
Quiz by tony thompson, updated more than 1 year ago
tony thompson
Created by tony thompson over 4 years ago
19
0

Resource summary

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
Answer
  • True
  • False

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
Answer
  • 13
  • 12
  • 14
  • 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
Answer
  • chair
  • area
  • table
  • zone

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
Answer
  • True
  • False

Question 14

Question
Tables from Excel can be dropped into PowerPoint and word documents
Answer
  • True
  • False

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
Answer
  • True
  • False

Question 20

Question
Excel has an autosave function that needs to be connected to the internet to work
Answer
  • True
  • False
Show full summary Hide full summary

Similar

A level Computing Quiz
Zacchaeus Snape
Types and Components of Computer Systems
Jess Peason
Input Devices
Jess Peason
Output Devices
Jess Peason
Computing
Kwame Oteng-Adusei
Pack of playing cards answer
Karl Taylor
Code Challenge Flow Chart
Charlotte Hilton
Computing Hardware - CPU and Memory
ollietablet123
Computer Systems
lisawinkler10
Computer science quiz
Ryan Barton
Input, output and storage devices
Mr A Esch