Excel basics introduction quiz

Beschreibung

This quiz is an introduction/basic quiz on how excel functions
tony thompson
Quiz von tony thompson, aktualisiert more than 1 year ago
tony thompson
Erstellt von tony thompson vor mehr als 4 Jahre
19
0

Zusammenfassung der Ressource

Frage 1

Frage
What software would you use to make a gif for sending to your mates on instagram?
Antworten
  • PowerPoint
  • Excel
  • Word
  • CV Superstar

Frage 2

Frage
What software would you use to make flyers for a local DJ event?
Antworten
  • PowerPoint
  • Excel
  • Word
  • CV Superstar

Frage 3

Frage
If you had to make up a report with a financial summary of your outgoings for a mortgage application what software would you choose?
Antworten
  • PowerPoint
  • Excel
  • Word
  • Barclays Premier

Frage 4

Frage
What is the best software for writing a letter to get a job
Antworten
  • PowerPoint
  • Excel
  • Word
  • CV Superstar

Frage 5

Frage
Add these labels to the image of a typical excel sheet Zoom control, sheet name,row labels,column labels, menus
Antworten
  • Sheet name
  • Row Labels
  • Column labels
  • Menus
  • Zoom control

Frage 6

Frage
What software would you use to set up a list of birthdays for your family?
Antworten
  • PowerPoint
  • Excel
  • Word
  • CV Superstar

Frage 7

Frage
A workbook is the name for a group of pages in PowerPoint
Antworten
  • True
  • False

Frage 8

Frage
which of the following can you add to a cell in Excel?
Antworten
  • picture
  • words
  • names
  • dates
  • phone numbers

Frage 9

Frage
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
Antworten
  • 13
  • 12
  • 14
  • 6

Frage 10

Frage
A group of cells selected together is called a
Antworten
  • selection
  • range
  • bunch
  • column

Frage 11

Frage
A named area on the sheet which may be coloured and sorted is called a
Antworten
  • chair
  • area
  • table
  • zone

Frage 12

Frage
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.
Antworten
  • information
  • news
  • money
  • colours
  • tabulating
  • inserting
  • lining up
  • losing
  • delete
  • inform
  • manipulate

Frage 13

Frage
excel was first used by the americans to work on the moon landings
Antworten
  • True
  • False

Frage 14

Frage
Tables from Excel can be dropped into PowerPoint and word documents
Antworten
  • True
  • False

Frage 15

Frage
A header row is ....
Antworten
  • 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

Frage 16

Frage
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.
Antworten
  • presentation
  • workbook
  • calendar
  • spin
  • drag
  • scroll
  • important
  • total
  • lost
  • fixed time
  • specific task
  • specific day

Frage 17

Frage
Autosum is a fast way of
Antworten
  • 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

Frage 18

Frage
Select the ways that exel can format numbers
Antworten
  • general
  • number
  • currency
  • date
  • text

Frage 19

Frage
Excel has a hidden programming language called visual basic for applications VBA
Antworten
  • True
  • False

Frage 20

Frage
Excel has an autosave function that needs to be connected to the internet to work
Antworten
  • True
  • False
Zusammenfassung anzeigen Zusammenfassung ausblenden

ähnlicher Inhalt

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