NEW
Font size
WorksheetsComputer Apps Final Exam
Total questions: 41
Worksheet time: 21mins
__________ is a tool that reveals symbols for certain formatting commands that could not otherwise be seen that can help users edit documents.
Show/Hide symbols
Non-printing symbols
Open punctuation
Ribbons
A sans serif font is a font that __________.
has no feet.
has decorative strokes.
is always bold.
is only used in logos.
Which is NOT an alignment option in Word?
Left-align
Read-align
Justify
Center
When information is arranged in ascending order __________.
it is arranged from shortest to longest.
it is arranged from longest to shortest.
it is arranged from A to Z.
it is arranged from Z to A.
Which of the following is NOT a way to change character attributes in Microsoft Word/Excel?
Home Ribbon in the font group
Quick strokes
Mini toolbar
Right click menu
How many cells are in the range A2:D4?
6
8
9
12
How many options are there for positioning text within a cell?
3
6
9
12
What is the default line spacing in Microsoft Word?
1
1.15
1.5
1.08
A hyperlink can take you to all of the following places EXCEPT _________.
an email address
a website
a foreign country
another document
Which of the following keystrokes would NOT appear when using show/hide symbols?
shift
tab
space
non-breaking space
Which of the following statements is true?
Rows are identified in Excel with letters.
Columns are identified in Excel with numbers.
Excel worksheets can be renamed.
There are four sheets in a workbook by default.
All of the following are common ways to format Excel cells EXCEPT:
date
accounting
currency
formula
If I wanted to narrow down possible data, which tool in Excel would help you do that?
Sort
Filter
Remove Duplicates
Find/Replace
Merge and Center allows an Excel user to customize the number of cells in a heading/title.
True
False
What elements are NOT commonly inserted into Microsoft Word?
Pictures
SmartArt
Password Access Options
Hyperlinks
Many of the ribbons and toolbars are the same or very similar in the Microsoft Office suite (Word, Excel, PowerPoint, etc).
True
False
If you don't like working with Excel, you can just insert an extremely large table in Word. Word has all of the capabilities as Excel to manipulate tables.
True
False
An orphan goes on to the next page alone.
True
False
The COUNTA formula is used to find averages in Excel.
True
False
Saving as a PDF used to block the ability of the text to be copy/pasted.
True
False
A widow goes on to the next page alone.
True
False
AutoSum adds all of the numbers on an Excel spreadsheet by default.
True
False
When a hyperlink turns purple it means that link is corrupt and needs to be replaced.
True
False
A bulleted list and a numbered list are used for the same reasons.
True
False
Quick styles can be applied in both Word and Excel.
True
False
If you are asked to type a grocery list, it would be best formatted with a numbered list.
True
False
Horizontal alignment refers to how text is positioned between the top and bottom borders.
True
False
Ribbons are commonly known as Tabs in the Microsoft Suite.
True
False
Reports and letters are formatted in landscape orientation.
True
False
When formatting a report it is common to enable widow/orphan controls.
True
False
Times New Roman is an example of a sans serif font.
True
False
Once a cell is merged, there is no way to un-merge it.
True
False
It is not possible to copy a selection from Word and paste it in Excel.
True
False
Keywords can be added to a document's properties to help you locate the document in the future.
True
False
A header and document properties serve the same purpose.
True
False
In Excel, the fill handle attempts to identify a natural series (for example, days of the week, months of the year, etc.).
True
False
Conditional formatting makes it difficult to visual interpret data quickly.
True
False
Using a filter in Excel permanently deletes some data.
True
False
Excel is a tool used best to collecting data, Word is a tool used best to report on the data collected.
True
False
Opening an Excel file in Google Sheets will allow you to do ALL of the same things.
True
False
Newspapers and magazines use columns to format and organize their stories.
True
False
