Excel basics introduction quiz

Description

This quiz is an introduction/basic quiz on how excel functions
jeniffer mina
Quiz by jeniffer mina, updated more than 1 year ago More Less
tony thompson
Created by tony thompson over 4 years ago
jeniffer mina
Copied by jeniffer mina almost 3 years ago
4
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

Diapositivas de Topología de Redes
lisi_98
Elementos que conforman a google chrome
juan carlos hernandez morales
INFORMÁTICA 22
daniel flores
Construcción de software
CRHISTIAN SUAREZ
Sistema de Gestor de Base de Datos MongoDB
Edwin Herlop
TRABAJO DE TOPOLOGÍA DE REDES
lisi_98
Línea del tiempo Evolución histórica del software SPSS
SANDRA LAME
Arquitecturas de Sistemas Distribuidos
Edisson Reinozo
Cloud Data Integration Specialist Certification
James McLean
INFORMÁTICA - Periféricos de entrada y salida
Serna Izaoly
JC Science: Force, Work and Power
Bubble_02