Font size
Worksheetscc quiz rev
Total questions: 133
Worksheet time: 1hrs 7mins
If your cursor is placed before a word, and you want to delete that word, which key should you press?
DELETE
BACKSPACE
ENTER
CTRL
If your cursor is placed after a word, and you want to delete that word, which key should you press?
BACKSPACE
ENTER
DELETE
CTRL
If you want to save your file as a different file type, which option do you use?
Save as
Open
Save
File Name
What is the correct extension when saving as Rich Text Format?
.rtf
.pot
.ppt
.emf
What is the default file extension for all Word documents?
DOCX
WRD
TXT
Which key moves your cursor from one cell to the next in a table?
Tab
Shift
Ctrl+Enter
If the spell check suggests that a word is spelt wrong, when you know it is spelt correctly e.g., a company name, which button would you click?
Ignore
Change
Suggest
Change All
Which keyboard shortcut would you use to begin a spell check?
ALT + S
F9
F7
CTRL + S
Where would you locate the option to change the page orientation to portrait?
Notes page
Print Preview
Page setup
Formatting toolbar
Setting the orientation of the page to landscape means
Making the width of the page longer than the height of the page
Making the width of the page shorter than the height of the page
Making the width of the page the same as the height of the page
Setting the orientation of the page to portrait means
Making the width of the page longer than the height of the page
Making the width of the page shorter than the height of the page
Making the width of the page the same as the height of the page
How do you select the text in an entire document using keyboard shortcut?
CTRL + B
CTRL + A
CTRL + E
How do you select all the text in an entire document using the mouse?
Single click in the margin
Double click in the margin
Triple click in the margin
How do you select the text of a paragraph from a document using the mouse?
Single click in the margin next to that paragraph
Double click in the margin next to that paragraph
Triple click in the margin next to that paragraph
What is the shortcut key to open the Print options?
ALT + P
SHIFT + P
CTRL + P
If you wanted to print just the odd pages of a five-page document, what would you type in the Print options Page range box?
1-5
1.3.5,
1;3;5
1, 3, 5
Which key is the equivalent of using the Indent button?
CTRL
ENTER
SHIFT
TAB
To quickly copy an area of text, which of the following keyboard shortcuts would you use?
SHIFT + Y
ALT + C
CTRL + Y
CTRL + C
What is the keyboard shortcut for cutting a piece of text?
CTRL + X
CTRL + C
SHIFT + C
CTRL + ALT + DELETE
What do Indentation Options allow you to do?
Design a table
Select type and distance for indents
Insert a Blank Page
To move a highlighted drawing object within a document you can:
Use the arrow keys to move it into position
Cut and paste the object into position
Drag and drop the object into position
All answers are correct
Which of the following options can be used to move a drawing?
Right click and select Move from the menu
Pressing CTRL + X
Pressing Enter to move down the page
Using the cursor keys
How many different documents can you have open at one time?
Only one
As many as your computer memory will hold
Not more than your Taskbar can display
How many times do you have to click to select a single line of text from the margin?
Three Times.
Four Times.
One Time.
Two Times.
To select a line of text, press SHIFT + _____ (select the missing key from the options below)
END
ALT
CTRL
Which function does the shortcut keys CTRL + E perform to a highlighted paragraph?
Align Right.
Align Left.
Centre
Justify.
What is the keyboard shortcut to open the Find and Replace box?
CTRL + R
CTRL + F
CTRL + ALT + F
CTRL + S
If the spell check highlights a word which it does not recognize but is spelt correctly, what should you do?
Delete it
Select an alternative word from the suggestion list
Add it to the dictionary
How can you highlight text without using the mouse?
Use the arrow keys while holding down a Ctrl key
Use the arrow keys while holding down a Shift key
Use the F5 key
Which set of keystrokes will take you to the beginning and to the end of a long document?
Ctrl+PageUp and Ctrl+PageDown
Ctrl+Home and Ctrl+End
The only way is by using the right scroll bar
A document in portrait prints:
More characters per line than the same document in landscape
The same characters per line with the same document in landscape
Less characters per line than the same document in landscape
Which button will update the misspelled word once?
Replace All
Replace
Find Next
What is the keyboard shortcut for underlining text?
CTRL + U
ALT + U
SHIFT + U
Can you create a custom page size in Microsoft Word?
False
True
Page header or footer automatically applied to every page in that document when created?
True
False
Can you use drag and drop when changing Margins?
No
Yes
A feature in Microsoft Word that can reverse a change.
Paint Brush
Go to
Undo
Redo
Can you use drag and drop when changing Margins?
No
Yes
A feature in Microsoft Word that can reverse a change.
Paint Brush
Go to
Undo
Redo
A feature in Microsoft Word that can reverse back an Undo.
Paint Brush
Go to
Undo
Redo
The top part of every page is called:
Header
Footer
Margin
Slide
The bottom part of every page is called:
Header
Footer
Margin
Slide
To ensure that commonly used functions are always visible, we can add it to which toolbar?
The mini toolbar
The quick access toolbar
The menu bar
Functions used to do text formatting such as bold, italics, and underline can be found in which group?
Clipboard
Font
Paragraph
Styles
Functions used to do text alignment such as center, left, right and justify can be found in which group?
Clipboard
Font
Paragraph
Styles
Functions used to cut, copy, and paste text can be found in which group?
Clipboard
Font
Paragraph
Styles
Functions used to insert pictures or shapes within a document can be found in which group?
Illustrations
Font
Paragraph
Styles
Which button below you would use to open an existing presentation?
File Open
File Save
EXIT
What key do you press to close a Slide Show?
Escape
Backspace
CTRL
Enter
Which of the following button below you would use to go to Slide Show view.
Slide show
start
present
What does 'fixed date' mean?
The date will not change position on the slide
The date will not be shown on the presentation
The date will not update each time the file is opened
The date will update each time file is opened
You can right click anywhere on the slide to bring up the toolbar menu.
False
True
To delete a slide what should you do?
Press Delete key.
Select the Exit command.
Select the Removal command, type the slide number in the dialog box, and then select OK.
Press the Backspace command.
Shortcut key to start a slideshow is:
Windows Key
F5
F12
F10
The notes pane in PowerPoint is for:
Does not serve any purpose.
To display additional information in the presentation.
Not used anymore
To write notes for the speaker.
What is Microsoft PowerPoint used for?
Database
Drawing
Presentation
Desktop Publishing
You can insert the following in Microsoft PowerPoint:
Shapes
All answers are correct
Text
SmartArt
During the Slideshow you press Esc key to:
To go to the last slide
Display the previous slide
Stop the presentation
To go to the first slide
Animations can be applied to:
Shape
Image
Text
All answers are correct
Transitions can be applied to:
Image
Text
Shape
Slide
A slide Header and Footer can have:
Date and Time
All answers are correct
Slide Number
The placeholders in Microsoft PowerPoint allows:
To enter text, shapes, and images
Slides
Animations
Enter filename
_________ shows when you go to next slide
Animation
Transition
Movement
Design
_______ shows when you go to the next object in PowerPoint
Animation
Transition
Movement
Design
To access the slide master in PowerPoint, which menu option should be used?
Insert
Draw
Review
View
What is the purpose of the slide master in PowerPoint?
controls all information about the theme, layout, background, color, fonts, and positioning of all slides
controls all information about the theme, layout, background, color, fonts, and positioning of slide 1 only
it does not have any effect on other slides
What are the advantages of using the slide master in PowerPoint?
custom templates
consistency made easy
save templates for future use
all answers are correct
To apply a design layout to a slide, you need to do the following
Select Home tab then Layout
Select Insert tab then Layout
Select Draw tab then Layout
Select Design tab then Layout
How many types of layouts are in the PowerPoint?
7
8
9
10
Normal View is one of the presentation view modes
True
False
Slide Show View is one of the presentation view modes
True
False
Edit View is one of the presentation view modes
True
False
To hide toolbars in PowerPoint, you must do the following
right-click any of the ribbon tabs, and then select Collapse the ribbon
click the Ribbon Display Option buttons, and then select Auto-hide Ribbon
both options will work
To display toolbars in PowerPoint, you must do the following
right-click any of the ribbon tabs, and then select Show Tabs and Commands
click the Ribbon Display Options button, and then select Show Tabs and Commands
both options will work
The PowerPoint application allows for the printing of multiple slides on one page
True
False
To insert a picture in a slide in PowerPoint, you need to do the following
Select Insert tab then Illustrations group
Select Insert tab then Image group
Select Draw tab then Image group
Select Design tab then Illustrations group
What is the purpose of adding notes to slides in PowerPoint
helps the speaker to remember what to say when presenting
helps the audience to better understand the presentation
all the answers are correct
When using numbering in PowerPoint slides, there is no option but to display the numbers on all slides
True
False
To set the way you want PowerPoint to do proofing (corrects and formats your text), you must do the following
Select Home tab, Option then Proofing
Select File tab, Option then Proofing
Select Review tab, Option then Proofing
Select View tab, Option then Proofing
What is the keyboard shortcut for spell check in PowerPoint
F5
F6
F7
F8
The Header and Footer option in PowerPoint can be accessed from which tab?
Home tab
Insert tab
File tab
Design tab
What is the file extension for PowerPoint files?
.pptx
.ptt
.pptt
To delete an unwanted column, it must:
Have three rows
Have content
Be highlighted
Not to be highlighted
If you wanted to move to the cell to the right of your current cell, which key would you press?
Enter
Backspace
CTRL
Tab
How do you select a column in a table?
Click directly above the column you want selected
Hold CTRL and click inside the column you want selected
Drag the cursor over the column you want selected
Use the highlight function in the toolbar
Which of the button below you would use to close an individual worksheet?
b
a
You can clear content from a cell by right clicking it and selecting clear content.
False
True
You can clear content from a cell by right clicking it and selecting clear content.
False
True
If you have already merged some cells containing a title, but decided you want to change it back to individual cells, which button should you click?
Merge and Center
Center
Align Left
Borders
Which character represents the division arithmetic operator?
\
/
*
!
If B6 has the value 5, and C6 has the value 4 in the Formula bar, what will the result of the formula be?
9
20
36
1.25
For the formula ' =IF(C9<25,”Buy”,”Sell”) ', which is the true value?
C9
Buy
Sell
25
For the formula ' =IF(C9<25,”Buy”,”Sell”) ', which is the false value?
C9
Buy
Sell
25
Which formula is correct if you want to get the total of cells B1, B5, and B8?
= SUM(B1,B5,B8)
=SUM(B1;B5)
=SUM(B1:B8)
Which function calculates the smallest value in a set of numbers?
Smallest
Max
Min
Which function will get the total numbers of numeric values in a given cell range?
Sum
Count
Total
If you want to edit the cell contents directly in the cell, what must you do?
Double-click the cell
Click the cell
CTRL + click the cell
SHIFT + click the cell
What keyboard shortcut would you use for pasting a cell?
ALT + X
CTRL + X
CTRL + V
SHIFT + P
Which key will move you down to the cell below your currently selected cell?
Backspace
Down cursor
Tab
Which button on the toolbar below you would use to Merge and Center cells?
a
b
c
Which tool would you use to copy format of a selected cell?
Copy Handle
Copy
Format Painter
Paste
To switch between worksheets:
Press SHIFT + arrow key for the direction of the worksheet
Click on the worksheet tab
Press ALT + TAB
Press CTRL + TAB
It is good practice to enter the cell reference '(for example =D4-C4)' rather than cell values '(for example =9-3)' into formulas because
If the cell value changes, the result will be automatically updated
Formulas only work with cell references
It is more accurate
It the cell name changes, the result will be automatically updated
Which function would you use to count the number of non-numerical items in the list?
COUNTA
AUTOSUM
SUM
COUNT
What character is used to separate cell references when adding a series of cells to a formula?
: (colon)
; (semi-colon)
! (exclamation mark)
? (question mark)
To resize a chart, what must you click?
Copy
Delete
Cut
A sizing handle
After selecting the chart area click the mouse ______ to display the Format Chart Area window.
Once
Three times
Twice
Which of the following are Worksheet Orientation?
Portrait and Landscape
Diagram and Object
Forms and Tables
Is it possible to downsize the page content to make fit on one page?
Yes
No
“The default page orientation of Microsoft Excel is Landscape.”
False
True
Gridlines and row/column heading are only visible in Print Preview, they will not be printed.
True
False
The settings you change for gridlines and row/column headings affect all the sheets in your workbook.
False
True
When printing one or a range of cells you use the option 'Selection'.
True
False
Selecting the entire workbook option will print all worksheets.
False
True
Which key must be held down when selecting multiple non-adjacent cells?
SHIFT
ALT
TAB
CTRL
The Zoom tool is used to minimize your spreadsheets.
False
True
What is quick way of inserting a new row into a spreadsheet?
Right click on the row heading
Double click on the row heading
CTRL + clicking on the row heading
If you want to use Format Painter to copy the format across several ranges of cells, what must you do?
Click the Format Painter
Click each cell
CTRL + click Format Painter
Double click Format Painter
How do you select individual columns/rows at the same time?
Hold SHIFT and click the columns/rows you want selected
Hold CTRL and click the columns/rows you want selected
Click on the cells/rows you want selected
To auto-adjust several rows or columns what must you do first?
Highlight them all
Click Format
Drag them to the correct position
Right click on them
To copy a worksheet, you need to Select
Right click the worksheet tab and select Move or Copy
Press the copy button in the Standard Toolbar
All answers are correct
Press CTRL + C
It is good practice to click on the cell you need to include in the formula because ____
It reduces the risk of making a typing mistake in the formula
It ensures the values in the cells are automatically updated
Arithmetic operators work only when cells are referenced by a mouse click
It is more efficient as you can enter multiple cells at once
The #REF! error will occur if ____________
You divide a cell value by an empty cell value or cell value set to zero
You include a cell reference to a text value rather than a numeric value
You refer to a row, cell, or worksheet that has been deleted
The cell reference cannot be found
When creating a formula, Excel uses relative referencing by default.
False
True
The AutoSum function automatically adds the following to the Formula bar
=MIN( , )
=AUTOSUM( , )
=MAX( , )
=SUM( , )
In which category would you find the IF function?
Text
Math & Trig
Logical
Statistical
To resize a chart and maintain its proportions, which key can you press whilst dragging a corner sizing handle
ENTER
CTRL
SHIFT
ALT
You can rename an Excel sheet
True
False
To perform a logical test with a condition ____ function should be used
Sum
Average
Count
IF
Microsoft Excel is a:
Word Processor Software
Spreadsheet program
Presentation program
None of the above
Formulas in Excel starts with:
=
%
==
+
To add borders to worksheet in Excel, you must do the following
Select the required cells, go to File tab, then click on Border from the Font group
Select the required cells, go to Home tab, then click on Border from the Font group
Select the required cells, go to Insert tab, then click on Border from the Font group
To create charts or graphs in Excel, you must do the following
Select the required cells, go to File tab, then click on any chart type from the Charts group
Select the required cells, go to Home tab, then click on any chart type from the Charts group
Select the required cells, go to Insert tab, then click on any chart type from the Charts group
