Font size
WorksheetsICT REVISION (WORD & EXCEL)
Total questions: 106
Worksheet time: 1hrs 7mins
Font Color
Bold
Underline
Text Highlight Color
Font Color
Italic
Bold
Underline
Font Color
Italic
Bold
Underline
Font Color
Italic
Bold
Underline
Font Color
Bold
Underline
Text Highlight Color
subscript
superscript
strikethrough
Text Effects and Typography
subscript
superscript
strikethrough
Text Effects and Typography
subscript
superscript
strikethrough
Text Effects and Typography
Font Color
Bold
Underline
Text Effects and Typography
Font Color
Font
Font Size
Text Highlight Color
Font Color
Font
Font Size
Text Highlight Color
What is this a picture of?
Smart Art
Backstage View
GROUP
Contextual Tab
What is circled in Red?
TABS
GROUPS
Backstage View
Word Art
What is circled in Red?
TABS
GROUPS
Backstage View
Contextual Tab
What is this a picture of?
Group
Chart
Table
SmartArt
These graphics range from graphical lists and process diagrams to more complex graphics, such as Venn diagrams and organization charts.
Hyperlink
Table
SmartArt
WordArt
This is the area where files and data about them is managed - creating, saving, printing, sending to others, inspecting for hidden metadata or personal information, and setting options. You can also change a document's subject, status, comments, and author here.
Dialog Box Launcher
View Tab
Insert Tab
Backstage View
What is circled in Red?
GROUPS
TABS
Dialog Box Launcher
SmartArt
What is this a picture of?
SmartArt
Chart
Table
WordArt
What is this a picture of?
Table
Chart
SmartArt
WordArt
This tab allows you to add a picture, shape, table, chart, or hyperlink to the document.
File Tab
Insert Tab
Design Tab
Layout Tab
This allows you to create a link in your document for quick access to webpages and files. They can also take you to places in your document, such as headings and bookmarks.
Hyperlink
Bookmark
Cross-reference
Comment
What is this a picture of?
Group
Contextual Tab
Backstage View
Dialog Box Launcher
This tab allows you to look at the document in Read Mode, Print Layout, or Web Layout.
File Tab
Home Tab
View Tab
Design Tab
When you select File - New, you are able to view
Backstage View
Templates
Read Mode
Layout Mode
Add some artistic flair to your document using this text box.
WordArt
Styles
Table
Chart
This tab allows you to complete spelling & grammar checks, word count, and add comments.
File Tab
Home Tab
Design Tab
Review Tab
This tab allows you to change the document theme, document formatting, and document color. It also allows you to add a watermark and page border.
File Tab
Home Tab
Insert Tab
Design Tab
This tab allows you to change the margins, orientation, and size of the document.
Home Tab
View Tab
Layout Tab
Design Tab
This tab allows you to insert a Table of Contents, Insert Footnote & Endnote, and Insert Citation.
View Tab
References Tab
Home Tab
Insert Tab
These help you to repeat content at the top of every page. They're useful for showcasing information, like title, author, and page number.
Header
Footer
WordArt
Textbox
These help you repeat content at the bottom of every page. They're useful for showcasing information, like title, author, and page number.
Page Break
Footer
Header
Table
Microsoft Word is a
Presentation program
Word Processing program
Spreadsheet program
None of these
Which can be used for quick access to commonly used commands and tools?
Status bar
Tool bar
Menu bar
Title bar
The best way to create a heading in a document is to:
Apply a larger font size to it than the body text.
Add bold formatting by clicking the Bold button on the Formatting toolbar.
Apply a heading style.
What's a good reason to use a header or footer in your document?
To look impressive.
To add a title to the start of the document.
To include the document title and page numbers.
In order to save an existing document with a different name you need to:
Retype the document and give it a different name.
Use the Save as... command.
Copy and paste the original document to a new document and then save.
Use Windows Explorer to copy the document to a different location and then rename it.
Which tool do you use to make the text flow all the way around a picture?
Crop
Track Changes
Wrap Text
Align
The process of removing unwanted part of an image is called:
Hiding
Bordering
Cropping
Cutting
A number of letter that appears little above the normal text is called:
Superscript
Subscript
Supertext
Toptext
We can insert a page number at
Header
Footer
Both A and B
None
We can remove / hide border of a shape by selecting:
No Line
No Outline
White Line
No Border
How many margins are on a page?
Two (header and footer).
Four (top, bottom, right, left).
Two (landscape and Portrait).
Two (top and bottom)
We can change the thickness of a line from ___
Line Width
Line Height
Line Thick
Line Style
Color and pattern used to fill a closed shape is called:
Fill style
WordArt
Shape
Fill Back
The default alignment for paragraphs is:
Right-aligned
Left-aligned
Centered
Justified
A _____ is a collection of predefined design elements and color schemes.
Feature
Hyperlink
Palette
Theme
The ____ defines the appearance and shape of letters, numbers, and special characters.
Font
Font size
Point
Paragraph formatting
Allows you to sort text from Z to A or largest to smallest
Split Sort
Ascending sort
Merge Sort
Descending Sort
The feature that combines or joins cells together in a table:
Split cells
Merge cells
Distribute rows
Distribute columns
What does a red underline on a word indicate?
Grammar mistake
Synonym
Spelling mistake
Word has been entered multiples times
Which type of list is best suited for items that do not go in any specific order?
Numbered
Connected
Bulleted
Multilevel
What do you call the blank boxes on a spreadsheet?
places
cells
squares
info
How can you use Excel to help in your everyday life?
Address List
Create a schedule
Create a budget
Create a gradebook
All of the above
A _____________ is known as an Excel file.
workbook
worksheets
spreadsheets
Spreadsheets are made up boxes called_____________
box
cells
When you enter something into excel that WILL be used in calculation, it is considered a............
value
label
word
equal sign
Which symbol must all formulas begin with?
=
+
(
@
What is the green bar at the top of Excel referred to as?
the data bar
the function bar
the ribbon
the row
What is a range in Excel?
An individual space
A group of cells
A graph
A formula
What is the file extension for Excel worksheets?
.png
.pptx
.xlsx
.docx
Which of the following is not an arithmetic operator?
=
+
s
^
Why do you start a formula with an = sign?
to tell Excel you are entering a formula
just because
you are entering text
Where does Excel return the result of a formula
the same cell where the formula is entered
A1
in your head
What is the answer to the following formula: =2^4 + 7
13
71
23
123
What is the answer to the following formula: =25% * 40
140
25
75
10
In the following formula, what gets done first: =6+2*(6-2)
6+2
2*6
2*(6+2)
(6+2)
Which arithmetic operator is being used in the following formula: =T75- AA45
addition
multiplication
subtraction
format
What is the answer if the value in cell A5 is 75; C10 is 20; B23 is 15; E15 is 100; G20 is 5 and the formula is: =C10 + (A5 * G20)/ B23
43
55
49.6
45
What is the answer to the following formula: -(P45/Q14) where the value in cell P45 is 25, and in cell Q14 is 5?
5
15
-30
-5
Does Excel allow the use of numbers in formulas?
yes
no
What order does the order of operations follow?
right to left
left to right
up to dow
middle outwards
List the following in order of operations: addition (+), division (/), multiplication (*), subtraction (-).
/,+,-,*
*,/,+,-
^,s,r,t
Using exponentiation, what does = 3^4 do?
raises 3 to the fourth power
3 times 4
nothing
Do you need an = sign to start a formula?
no
yes
never
What is the next school break?
Easter break
summer break
spring break
labor day
