WorksheetsComputer Application - Pre Quiz
Total questions: 61
Worksheet time: 1hrs 1mins
What Microsoft programme would you use for writing documents
Microsoft Word
Microsoft Excel
Microsoft PowerPoint
Microsoft Access
To proof read what you have written in Microsoft Word, you will use s (a) check
Which of the following features can you use to enhance text?
Bold
Underline
Italics
All of them
When you want to right, left, centre or justify text, this is called a (a)
What technology from the 1800’s preceded and defined most of the functionality in a word processor?
Printing Press
Phonograph
Typewriter
Notebook
Which command allows you to change the document file type?
Copy
Save As
Open
Allows you to type info below the bottom margin on each page.
header
footer
margin
Word
How would you best define the term "margin"?
The boundaries within which we type
The edges of a page
The beginning of a paragraph
The area where we do not type
Left, Center, Right, and Justify are options for which tool located on the toolbar or ribbon?
Zoom
Line Spacing
Bulleted Lists
Text Alignment
find & replace
An area across the top of the screen that makes almost all the capabilities of Word available in a single area.
Ribbons
Tabs
Title Bar
View toolbar
What keys do you use to copy and paste a text to another file?
Ctrl + C, Ctrl + V
Ctrl + C, Ctrl + B
Ctrl + F, Ctrl + C
Ctrl + V, Ctrl + F
The process of removing unwanted part of an image is called
Hiding
Bordering
Cropping
Cutting
Which icon is this?
Bolder
Bold
Bright
Bluetooth
Select the font colour icon.
To change the contents of a document.
Rewrite
Delete
Overwrite
Edit
A horizontal bar that displays the name and type of document
Status bar
Scroll bar
Title bar
Ribbon bar
If I want to add a certain part like <<First Name>> or <<Last Name>> where would I need to click?
Insert Merge Field
Click Greeting Line and add First Name to the block
Click Finish and Merge
Click the Start mail merge and click add and then click your desired choice
What type of chart is this?
Donut
Radar
Bar
Pie
If you copy the formula =$B38 into another cell, the result will be:
The column part will remain the same
The row part will remain the same
Both the column and row will remain the same
Both will change
Which of the following cursor allows you to select a range of cells
###### means:
You've entered a number wrong.
You've misspelled something.
The cell is not wide enough.
What is the difference between a worksheet and a workbook?
A worksheet is a workbook within a workbook
A worksheet is a sheet within a workbook
A worksheet has to be inserted into a workbook
A worksheet is part of the cells in a workbook
Which formula should be written in cell B3 to calculate the sale price?
=B1 + B2
=B1 - B2
=B3 - B1
=B2 * B1
What number would the spreadsheet show in cell A5 if you typed the formula below?
=A3/A1
3
4
8
12
What number would the spreadsheet show in cell A5 if you typed the formula below?
=A2*B3
15
18
20
50
Which cell contains the HIGHEST number?
A1
A2
A3
B1
B2
Rows on a spreadsheet are identified by a ...
number
letter
symbol
smiley face
The selected or highlighted cell in a spreadsheet is called ______________
CELL
SELECTED RANGE
ACTIVE CELL
NONE
What does the function =SUM() do?
Adds up Cells
Sells Cells
Multiplies Cells
Divides Cells
What does the function =MAX() do?
Finds the smallest number
Finds the biggest number
Finds the right number
Finds the left number
What kind of referencing uses $ to keep the cell the same?
Relative
Absolute
Magic
Heart
What type of graph is this?
Bar
Line
Pie
Scatter
What feature of a spreadsheet allows text to fill a cell up?
Wrapped Text
Format Text
Merged Text
Trapped Text
The highlighted section above signifies a
Cell
Row
Grid
Range
Which of the following is not a spreadsheet software package?
Microsoft – Excel
Google Sheets
Lotus 123
Quantum Pro
It shows a fraction as an amount out of 100.
Percentage
Equal sign
Fraction
Values
Which tool is used to make the borders darker?
Special effects used to introduce slides in a presentation are called
effects
custom animations
transitions
present animations
What type of software is MS-PowerPoint considered to be?
Word Processing
Spreadsheet
Database
Presentation
Ronnie wants to make sure that his presentation is organized in the best arrangement. He needs to see as many slides as possible in one view. Which feature of PowerPoint should Ronnie use?
Handouts
Slide sorter
Normal
Presenter
Select ALL the elements that can be animated in a PowerPoint.
Audio/Music
Fonts/Words
Images/Pictures
Shapes
True or false: The creator can reorder how animations appear on a slide.
True
False
