Excel basics introduction quiz

Descripción

This quiz is an introduction/basic quiz on how excel functions
tony thompson
Test por tony thompson, actualizado hace más de 1 año
tony thompson
Creado por tony thompson hace más de 4 años
19
0

Resumen del Recurso

Pregunta 1

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

Pregunta 2

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

Pregunta 3

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

Pregunta 4

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

Pregunta 5

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

Pregunta 6

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

Pregunta 7

Pregunta
A workbook is the name for a group of pages in PowerPoint
Respuesta
  • True
  • False

Pregunta 8

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

Pregunta 9

Pregunta
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
Respuesta
  • 13
  • 12
  • 14
  • 6

Pregunta 10

Pregunta
A group of cells selected together is called a
Respuesta
  • selection
  • range
  • bunch
  • column

Pregunta 11

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

Pregunta 12

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

Pregunta 13

Pregunta
excel was first used by the americans to work on the moon landings
Respuesta
  • True
  • False

Pregunta 14

Pregunta
Tables from Excel can be dropped into PowerPoint and word documents
Respuesta
  • True
  • False

Pregunta 15

Pregunta
A header row is ....
Respuesta
  • 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

Pregunta 16

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

Pregunta 17

Pregunta
Autosum is a fast way of
Respuesta
  • 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

Pregunta 18

Pregunta
Select the ways that exel can format numbers
Respuesta
  • general
  • number
  • currency
  • date
  • text

Pregunta 19

Pregunta
Excel has a hidden programming language called visual basic for applications VBA
Respuesta
  • True
  • False

Pregunta 20

Pregunta
Excel has an autosave function that needs to be connected to the internet to work
Respuesta
  • True
  • False
Mostrar resumen completo Ocultar resumen completo

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