Font size
WorksheetsICT Semester Test Review
Total questions: 77
Worksheet time: 46mins
What is Microsoft Excel?
A graphical word processing program that users can type with. It is made by the computer company Microsoft. Its purpose is to allow users to type and save documents. Similar to other word processors, it has helpful tools to make documents.
An information management tool, or relational database, that helps you store information for reference, reporting and analysis.
A software program produced by Microsoft that allows users to organize, format and calculate data with formulas using a spreadsheet system.
A powerful slide show presentation program.
Which of the following is not a reason to use Microsoft Excel?
To analyze and store data
Utilize mathematical formulas to make the process easier.
Managing expenses
To create a power point presentation containing a lot of pictures for my Religion class.
What is a work book ?
A collection of one or more spreadsheets, also called worksheets, in a single file.
A collection of cells organized in rows and columns. It is the working surface you interact with to enter data.
An intersection of a column and row.
Shows the address of the current selection or active cell.
What is the Title Bar in Microsoft Excel?
Shows the address of the current selection or active cell.
Displays information entered—or being entered as you type—in the current or active cell.
Displays both the name of the application and the name of the spreadsheet.
A collection of icons that provides a shortcut to using a drop-down menu.
Toolbars offer quick shortcuts to commonly used commands and can be moved and repositioned.
True
False
The columns in an Excel sheet are named through the use of letters or combination of letters
True
False
Each row is named by a number.
True
False
Which of the following shows the address of the current selection or active cell.
Formula Bar
Tool Bar
Name Box
Cell
Which of the following displays information entered—or being entered as you type—in the current or active cell. The contents of a cell can also be edited in the formula bar.
Formula Bar
Tool Bar
Name Box
Cell
The __________ cell is the cell that receives data and commands you give it.
Passive
Active
Intersected
Pointed
To scroll through the worksheet you can only use your Keyboard arrows.
True
False
Each Excel worksheet is made up of more Excel Worksheets.
True
False
What is the shortcut for copying data in Excel?
Ctrl + X
Ctrl + C
Ctrl + V
Ctrl + Z
How can you correct a misspelled name in Excel without deleting other content?
Click on the cell once
Double-click the cell
Use the delete key
Use the backspace key
What happens when you press Enter after typing in a cell?
The active cell moves down
The active cell moves up
The cell content is deleted
The cell color changes
What is the first step before entering data into a cell in Excel?
Press Enter
Double-click the cell
Select the cell
Type the data immediately
What does the autofill handle in Excel help with?
Changing cell color
Extending patterns
Creating charts
Deleting data
How can you insert a new column to the left of column A?
Use the insert function in the Home tab
Drag column A to the left
Right-click column A and select insert
Double-click the column header
How can you extend the same number down multiple cells quickly?
Type the number in each cell
Use the fill handle
Copy and paste manually
Use the formula bar
How can you quickly adjust a column's width to fit its content?
Right-click and select 'Fit'
Drag the column border
Use the format menu
Double-click the column border
The first part is the sender's address - true or false?
True
False
The second part of the business letter is the date. Which date is written correctly?
Jan. 1 2021
Jan, 1 2021
Jan. 1, 2021
Jan12021
We use a business letter format to look professional.
True
False
Which of these should you NOT use for a business letter?
Contractions
12 point font
Creative fonts
Informal language
Formal language
In most word-processing programs, what should you select in order to add a table to a document?
File/print
insert /table
format/lists
view/ print layout
Which keyboard key will allow you to increase or decrease the indentation levels of the text?
TAB
CTRL
SHIFT
ENTER
Which table element runs vertically (up and down)?
Property
Column
Row
Cell
Which table element runs horizontally (left to right)?
Cell
Row
Column
Property
Each rectangular box in a table is called:
a spreadsheet.
a column.
a row
a cell
What should you select in order to access additional options for formatting a table?
Table
preferences
Table properties
paragraph styles
When you resize the width of a column using your mouse, your pointer changes. How does your pointer’s appearance change?
The pointer changes to a four-sided arrow.
The pointer changes to a large plus symbol.
The pointer changes to a parallel lines with a double-sided arrow.
The pointer changes to a large white arrow.
What keys are used to decrease an indent in a list?
CTRL+TAB
SHIFT+TAB
ALT+TAB
TAB+Left Arrow
What keystroke will insert a new row at the end of a table?
Backspace
Enter
Tab
insert
What is “cell padding”?
The border between cells in a table.
The space between each row of the table.
The space between the borders of the cell and the inside text.
The space around the outside of the cell
How do you remove a table from your document?
Select the table and press the Delete key.
Select the table and press the Enter key.
Select a cell, right-click and choose Delete Row.
Select the table, right-click and choose Delete Table.
What is another name for a numbered list?
Bulleted list
Ordered list
Lettered list
Multi-level list
The line that surrounds every cell in your table is called
A border
Divider
marker
grid
You can align the text in a cell to the left, center or right. You can also align it:
top
justified
vertically
horizontal
A table can only be aligned:
Vertically
left
horizontally
center
How do lists and tables improve a document?
They list information in a specific order to outline all of the document’s content.
They break up the design and layout of the document to make it more visually appealing.
They present your text in ways that make it easier for your audience to read and understand quickly.
They divide your document into smaller sections for easy formatting.
In most word-processing programs, what should you select in order to add a table to a document?
File/print
insert /table
format/lists
view/ print layout
Which keyboard key will allow you to increase or decrease the indentation levels of the text?
TAB
CTRL
SHIFT
ENTER
Which table element runs vertically (up and down)?
Property
Column
Row
Cell
Which table element runs horizontally (left to right)?
Cell
Row
Column
Property
Each rectangular box in a table is called:
a spreadsheet.
a column.
a row
a cell
What should you select in order to access additional options for formatting a table?
Table
preferences
Table properties
paragraph styles
When you resize the width of a column using your mouse, your pointer changes. How does your pointer’s appearance change?
The pointer changes to a four-sided arrow.
The pointer changes to a large plus symbol.
The pointer changes to a parallel lines with a double-sided arrow.
The pointer changes to a large white arrow.
What keys are used to decrease an indent in a list?
CTRL+TAB
SHIFT+TAB
ALT+TAB
TAB+Left Arrow
What keystroke will insert a new row at the end of a table?
Backspace
Enter
Tab
insert
What is “cell padding”?
The border between cells in a table.
The space between each row of the table.
The space between the borders of the cell and the inside text.
The space around the outside of the cell
How do you remove a table from your document?
Select the table and press the Delete key.
Select the table and press the Enter key.
Select a cell, right-click and choose Delete Row.
Select the table, right-click and choose Delete Table.
What is another name for a numbered list?
Bulleted list
Ordered list
Lettered list
Multi-level list
The line that surrounds every cell in your table is called
A border
Divider
marker
grid
You can align the text in a cell to the left, center or right. You can also align it:
top
justified
vertically
horizontal
A table can only be aligned:
Vertically
left
horizontally
center
How do lists and tables improve a document?
They list information in a specific order to outline all of the document’s content.
They break up the design and layout of the document to make it more visually appealing.
They present your text in ways that make it easier for your audience to read and understand quickly.
They divide your document into smaller sections for easy formatting.
In online collaboration, how do users differentiate each document?
By a unique file name
By a unique web address
By a unique folder
By a unique document ID number
Which term means that multiple users can work on the same document at the same time?
saving
Editing
Formatting
Collaboration
Which term means that you allow access to your document only by the people or groups you choose, and that you can allow either editing or read-only access?
Editing documents
granting permission
Formatting tools
saving files
When working in Google Drive or One Drive, what feature is available to preserve all changes to the document without using the Save command?
view
translate
Autosave
Which type of sharing option allows you to revise another user’s document?
can comment
can view
can save
can edit
Which type of sharing option allows you to read another user’s document but not modify it in any way?
can edit
can save
can view
can comment
When working in Google Drive or One Drive, what command allows you to make a copy of document and store it locally on your computer?
Download
publish on website
email collaborators
E-mail as attachment
What command will display a list of changes made to the document, including the date the changes were made and the identity of the person who made the changes?
share
download
details
Revision/Version History
What does the term "real-time collaboration" mean?
Working on a document with multiple users at the same time
Sending a document as an attachment to an e-mail message
Publishing a document to the Web
printing a document
What command can recreate your document in another language?
Language
Translate document
save as
research
What tool enables you to include feedback regarding the document content without changing any content?
Footnote
track changes
comments
Suggesting mode
When in Google Docs Suggesting Mode or if Track Changes is turned on in your Microsoft Word document, deleted text displays as:
blue text
red text
strike-through
italics
When in Google Docs Suggesting Mode or if Track Changes is turned on in your Microsoft Word document, if a change was made to your document by another collaborator and you do not want the revision incorporated, what do you do?
reject it
accept it
Delete it
Comment on it
When working in Google Drive or One Drive, what command allows you to bring back a prior version of your document?
save as
Revision or Version History
Redo
Restore
When collaborating with others in a single document, what formatting feature is used to uniquely identify each collaborator’s revisions?
Font size
Font color
Highlight
Strike-through
How many collaborators can be working simultaneously in an online document?
200
50
100
75
When working in Google Drive or One Drive, what command allows you generate and share a copy of the document with someone outside of your collaboration circle?
Download
Publish on the web
E-mail collaborators
E-mail as attachment
Where are the shared Google Drive and One Drive storage spaces located?
My computer
The internet cloud
My schools network
An external hard drive
Working in Suggesting Mode or with Track Changes enabled, a collaborator has added a paragraph of text to your document. It is a good revision and you want to make it a permanent part of your document. What do you do?
Accepted the change
Reject the change
Comment on the change
Delete the change
Using Google Drive and One Drive, real-time collaboration can occur:
using only your computer and an internet connection.
using only your computer and your phone with an internet connection.
using only your phone.
using your phone, tablet and computer with an internet connection.
