Excel basics introduction quiz

Descrição

This quiz is an introduction/basic quiz on how excel functions
tony thompson
Quiz por tony thompson, atualizado more than 1 year ago
tony thompson
Criado por tony thompson mais de 4 anos atrás
20
0

Resumo de Recurso

Questão 1

Questão
What software would you use to make a gif for sending to your mates on instagram?
Responda
  • PowerPoint
  • Excel
  • Word
  • CV Superstar

Questão 2

Questão
What software would you use to make flyers for a local DJ event?
Responda
  • PowerPoint
  • Excel
  • Word
  • CV Superstar

Questão 3

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

Questão 4

Questão
What is the best software for writing a letter to get a job
Responda
  • PowerPoint
  • Excel
  • Word
  • CV Superstar

Questão 5

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

Questão 6

Questão
What software would you use to set up a list of birthdays for your family?
Responda
  • PowerPoint
  • Excel
  • Word
  • CV Superstar

Questão 7

Questão
A workbook is the name for a group of pages in PowerPoint
Responda
  • True
  • False

Questão 8

Questão
which of the following can you add to a cell in Excel?
Responda
  • picture
  • words
  • names
  • dates
  • phone numbers

Questão 9

Questão
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
Responda
  • 13
  • 12
  • 14
  • 6

Questão 10

Questão
A group of cells selected together is called a
Responda
  • selection
  • range
  • bunch
  • column

Questão 11

Questão
A named area on the sheet which may be coloured and sorted is called a
Responda
  • chair
  • area
  • table
  • zone

Questão 12

Questão
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.
Responda
  • information
  • news
  • money
  • colours
  • tabulating
  • inserting
  • lining up
  • losing
  • delete
  • inform
  • manipulate

Questão 13

Questão
excel was first used by the americans to work on the moon landings
Responda
  • True
  • False

Questão 14

Questão
Tables from Excel can be dropped into PowerPoint and word documents
Responda
  • True
  • False

Questão 15

Questão
A header row is ....
Responda
  • 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

Questão 16

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

Questão 17

Questão
Autosum is a fast way of
Responda
  • 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

Questão 18

Questão
Select the ways that exel can format numbers
Responda
  • general
  • number
  • currency
  • date
  • text

Questão 19

Questão
Excel has a hidden programming language called visual basic for applications VBA
Responda
  • True
  • False

Questão 20

Questão
Excel has an autosave function that needs to be connected to the internet to work
Responda
  • True
  • False

Semelhante

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
GCSE Computing - 4 - Representation of data in computer systems
lilymate