Quiz
Excel basics introduction quiz
This quiz has question types that open in the usual player.
Questions in this quiz (20)
1What software would you use to make a gif for sending to your mates on instagram?
- APowerPoint
- BExcel
- CWord
- DCV Superstar
2What software would you use to make flyers for a local DJ event?
- APowerPoint
- BExcel
- CWord
- DCV Superstar
3If you had to make up a report with a financial summary of your outgoings for a mortgage application what software would you choose?
- APowerPoint
- BExcel
- CWord
- DBarclays Premier
4What is the best software for writing a letter to get a job
- APowerPoint
- BExcel
- CWord
- DCV Superstar
5Add these labels to the image of a typical excel sheet
Zoom control, sheet name,row labels,column labels, menus
- ASheet name
- BRow Labels
- CColumn labels
- DMenus
- EZoom control
6What software would you use to set up a list of birthdays for your family?
- APowerPoint
- BExcel
- CWord
- DCV Superstar
7A workbook is the name for a group of pages in PowerPoint
- ATrue
- BFalse
8which of the following can you add to a cell in Excel?
- Apicture
- Bwords
- Cnames
- Ddates
- Ephone numbers
9What 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
- A13
- B12
- C14
- D6
10A group of cells selected together is called a
- Aselection
- Brange
- Cbunch
- Dcolumn
11A named area on the sheet which may be coloured and sorted is called a
- Achair
- Barea
- Ctable
- Dzone
12Excel 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.
- Ainformation
- Bnews
- Cmoney
- Dcolours
- Etabulating
- Finserting
- Glining up
- Hlosing
- Idelete
- Jinform
- Kmanipulate
13excel was first used by the americans to work on the moon landings
- ATrue
- BFalse
14Tables from Excel can be dropped into PowerPoint and word documents
- ATrue
- BFalse
15A header row is ....
- AThe toolbar that is on the top of any microsoft software
- BMessi's all time record season stats
- CA row of titles for data in a sheet
- DThe bar that displays function in a cell
16Make 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.
- Apresentation
- Bworkbook
- Ccalendar
- Dspin
- Edrag
- Fscroll
- Gimportant
- Htotal
- Ilost
- Jfixed time
- Kspecific task
- Lspecific day
17Autosum is a fast way of
- Aadding up complete rows or columns of numbers
- Bmaking a series of numbers from 1 to 100
- Ccalculating averages of numbers on a page
- Dadding up ranges of numbers arrange in rows or columns
18Select the ways that exel can format numbers
- Ageneral
- Bnumber
- Ccurrency
- Ddate
- Etext
19Excel has a hidden programming language called visual basic for applications VBA
- ATrue
- BFalse
20Excel has an autosave function that needs to be connected to the internet to work
- ATrue
- BFalse
Information
- Description
- This quiz is an introduction/basic quiz on how excel functions
- Author
- tony thompson
- Language
- English
- Views
- 84
- History
- Created on 14 Jul 2020 · updated on 14 Jul 2020
- Tags
- Rating
- No ratings yet Rate this quiz