NEW
Font size
Worksheets2019 Survey of Business Fall Semester Test Review
Total questions: 45
Worksheet time: 23mins
Which AutoFit option is used to automatically adjust column width based on the data in the cells?
Autofit Column Width
Autofit Window
Fixed Column Width
What page orientation has more room up and down the page?
Portrait
Landscape
What do you insert when you want the next line of text to start on a new page?
Page Break
Heading
Numbered List
Footer
What do we call the files we create and work on in Microsoft Word?
Spreadsheets
Presentations
Documents
Databases
Italics, Underline and Bold are _______.
Font Styles
Microsoft Word Views
Dialog Boxes
In a document, what is the vertical blinking line where text will appear when you type called?
Cursor
Mouse
Insertion point
What is the small picture or icon on the screen whose location is controlled by the mouse?
Cursor
Insertion point
Mouse
When a spelling error is indicated, what is a quick way to show a list of possible corrections?
Cut the spelling error.
Highlight the spelling error.
Left-click on the spelling error
Right-click on the spelling error.
Which word processing tool can help you find synonyms to improve your word choice?
Text selection
Find and Replace
Spelling and Grammar checker
Thesaurus
Which of these methods moves text from one place to another?
Delete and paste
Cut and copy
Copy and paste
Cut and paste
What can you do if the spelling and grammar checker finds an error that is not really an error?
Restart the spell checker.
Ignore the error.
Assume the checker is correct and accept any change.
Close the checker and do not use it again.
You want to substitute the word "first" with "initial" throughout your document. What tool(s) should you use?
Find tool
Cut and Paste tools
Replace tool
Copy and cut tools
What is the outlined area called?
Ribbon
Document Area
Mini Toolbar
Dialog Box
What is the outlined area called?
Ribbon
Document Area
Scroll Bar
Dialog Box
What would you click to open the Paragraph dialog box?
A
B
C
D
What is the outlined area called?
Ribbon
Document Area
Scroll Bar
Dialog Box
What is the block of text at the top of the page called?
Footer
Ribbon
Document Area
Header
What is the block of text at the bottom of the page called?
Header
Document Area
Ribbon
Footer
Where should the Works Cited page appear in the document?
At the beginning of the document, before any other information
At the end of the document, on a separate page
At the end of the document, right after the last sentence
At the beginning of the document, after the document title
Which font size should you use when writing a report for an English class?
48
24
10
12
Where would you click to see the list of Microsoft Word Styles?
A
B
C
D
Where would you click to change the paragraph alignment to centered?
A
B
C
D
In the table, identify the row title(s).
A
B
C
D
In the table, identify the table title.
A
B
C
D
E
In the table, identify the column header(s).
A
B
C
D
E
Define the following operator: /
Subtraction
Multiplication
Addition
Division
Which key should you press to select the cells shown in the image?
Enter
Shift
Del
Ctrl
Which letter on the image is a Cell?
A
B
C
D
Which letter on the image is a Column?
A
B
C
D
What is the best formula for finding the total value for cells B2 through B5?
=13.5+6.08+7.53+45.1
=SUM(B2:B5)
=B2+B3+B4+B5
=B1++B5
Where is the Formula Bar?
A
B
C
D
E
What tab group would you use to change the format of cell A2 to match cell A3?
Styles
Alignment
Cells
Number
Font
You want to enter a series of dates down a column. What would be the best tool for the job?
Spelling Checker
Cut and Paste
AutoFill
Find and Replace
Which of these formulas uses absolute cell references?
=5*10+20
=$A$10/100
=F18+F19/2
=D5+F3
What symbol is used to designate an absolute cell reference?
%
$
!
#
Which type of cell references are locked and NOT automatically updated when copied?
Formula
Worksheet
Relative
Absolute
Which type of cell references are automatically updated when copied?
Relative
Worksheet
Absolute
Formula
Why would you want to change the column width?
To draw attention to the data in those cells.
To make sure the column headings are always visible when scrolling.
To make sure all of the information in the column is visible.
Microsoft Excel can use Headers and Footers, just like Microsoft Word.
true
false
Which of these number formats would you want to apply to a cell showing the total sales for the month?
General
Text
Date
Currency
What does it mean to merge cells?
Center the contents of the cells.
Apply a border around a set of cells.
Combine 2 or more cells into a single cell.
Split a single cell into 2 or more cells.
What function would you use to find the least expensive item?
=MAX(B3:B7)
=MIN(B3:B7)
=SUM(B3:B7)
=AVERAGE(B3:B7)
What function should be entered to calculate the TOTAL budget?
=SUM(B3:B6)
=CALCULATE(B3:B6)
=TOTAL(B3:B6)
=AVERAGE(B3:B6)
Where would you click to sort in ascending order?
A
B
C
D
E
What term refers to mathematical equations used in Excel to perform calculations?
Formulas
Cell
Summations
Format
