Font size
WorksheetsBOS CTE Final Review With The Paper
Total questions: 86
Worksheet time: 44mins
To assign a floating dollar sign rather than a fixed dollar sign to a number in a cell, choose the Accounting format in the Number text box.
True
False
If a reference in a formula in Excel gets deleted, Excel will not adjust the cell references; the formula will need to be rewritten.
True
False
In Excel, using the Delete key will clear data from cells, but the cells remain in the worksheet.
True
False
What is the term used to describe a setting in software that is predetermined? For example, when you open a Word document, 1-inch margins are predetermined.
System
Factory Determined
Default
Fixed
What is the feature in Word that converts text to a graphic?
Insert Picture
WordArt
WordGraphic
Conversion
In Excel, what is the name of the feature that allows the user to copy formulas as well as create a series of numbers, dates, or month names in a range of cells? It is the black square in the bottom right-hand corner of the active cell.
Series handle
Fill handle
Formula handle
Copy handle
What is the term used to describe an adjacent group of cells in a worksheet? For example: H4:H10.
Active
Function
Group
Range
In Excel, what are the horizontal group of cells called that are labeled by number down the left side of the sheet?
Row
Active
Range
Column
In Excel, what are the horizontal group of cells called that are labeled by number down the left side of the sheet?
Row
Active
Range
Column
In Excel, which feature below would be best to use if you wanted to view opposite Columns in a worksheet?
Freeze Panes
Split Panes
In Excel, what key combination is used to wrap text to the next line in a cell?
Alt + Enter
Ctrl + Space Bar
Ctrl + Enter
Alt + Space Bar
Which of the expressions below show the correct form of a function in Excel?
SUM(A1:J1)
=SUM(A1:J1)
=SUMA1:J1
=(SUM)A1:J1
In Excel, what happens to the contents of the cells in a column if you decrease the column width zero?
Cell contents are deleted
Column is hidden
In Excel, commonly used functions like SUM, AVERAGE, MAX, and MIN can be quickly found using which drop-down menu?
AutoSum
Sum
Calculate
QuickSum
In Excel, if the active cell is K26 and the Home key is pressed, which cell becomes the active cell?
A1
ZZ100
K1
A26
In Excel, what is the feature called that applies formatting when the cell content meets certain criteria?
Text formatting
Conditional formatting
Auto formatting
Style formatting
What appears horizontally at bottom of an open Windows application and displays information about the current state of the document?
Task pane
Menu bar
Title bar
Status bar
In Word, which text wrapping option was used to achieve this result around this graphic?
In line with text
Tight
Square
Behind
In Word, which text wrapping option was used to achieve this result around this graphic?
Square
Behind
Tight
In line with text
In Microsoft products, what is the name of the option that provides access to commonly used commands?
Quick access toolbar
Shortcut access
Status toolbar
Preview pane
Which cell reference below correctly expresses an absolute cell reference in an Excel formula?
$B$2
$B2
&B&2
@B@B
In Excel, what is the name of the feature used to create the two-line heading as pictured below?
Vertical alignment
Line wrap
Word wrap
Wrap text
What is the name of the view option that allows you to see the document as it will be printed including headers, footers, and page numbers?
Actual view
Outline view
Zoom
Print preview
Which document(s) listed below would most commonly be formatted using columns? Choose all that apply.
Business letters
Magazines
Newspapers
Distribution list
Reports
Refer to the Excel window labels below. Besides the active cell, where else does text display as you type?
A - Name box
B - Formula bar
E - Worksheet tab
In Word, which option below describes where the standard text and the merged field codes appear?
Letter wizard
Data field
Data source
Mail merge
Main form document
When a document contains personalized data, what Word feature was probably used to create it?
Letter wizard
Data field
Data source
Mail merge
Main form document
When doing a merge, what is a complete set of information for an individual called?
Letter wizard
Data field
Data record
Mail merge
Main form document
What is the term used to identify one category of information in a data source file?
Letter wizard
Data field
Data record
Mail merge
Main form document
What is the collection of data records called?
Letter wizard
Data field
Data source file
Mail merge
Main form document
In a Word merge document, what is a field?
A wizard
A specific piece of information
A data source file
A record
What is the feature called that allows you to quickly create a merged letter in Word?
Wizard
Data creation
Copy/paste
Wildcard
What is a saved collection of formatting characteristics that can be applied to items within a document?
Look
Style
Theme
Structure
In Excel, when the boundaries are removed between two or more cells, what is this called?
Combined
Split
Merged
Justified
Endnotes are placed at the end of the document and footnotes are placed at the bottom of the page, so what is the only real difference between them?
Corder
Formatting
Placement
Information included
In Word, what feature is used to align text at the same place on each line?
Alignment
Insertion point
Spaces
Tabs
What needs to be selected to designates which row/column will print on every page of an Excel worksheet?
Print area
Header
Print title
Print cells
The table below was sorted. Which column in the table controlled the sort?
Standard 2
Standard 8
Score
Standard 7
What type of sort was used to sort the Score column in the table below?
Ascending
Descending
What key combination is used to display formulas in a worksheet?
ctrl + '
ctrl + @
ctrl + #
ctrl + !
What function is used to find the smallest value in a range of cells?
COUNT
LOOKUP
MIN
MAX
What function is used to find the largest value in a range of cells?
COUNT
LOOKUP
MIN
MAX
What function is used to find the largest value in a range of cells?Which Excel function returns one of two values based on a logical test?
COUNT
LOOKUP
MIN
IF
What is the function used to find a specific value from a table based on a cell's value?
COUNT
IF
LOOKUP
MIN
Which page layout option enables an Excel worksheet to be printed on a certain number of pages?
orientation
scaling
percentage
horizontal
What must a data range have before subtotals can be inserted?
Sorted data
Cells
Enough information to show subtotals
Grand totals
What feature is used to temporarily hide information that does not meet a specific criteria?
Sort
Filter
Sum
Lookup
In PowerPoint what button can be created to allow a user to perform tasks like going to a specific slide?
Action button
Start button
Go forward button
Transition
What is the smallest font size that should be used in a PowerPoint presentation?
72 point
24 point
16 point
48 point
What button is used to view a PowerPoint presentation in full screen?
Slide show
Slide master
Slide sorter
Normal slide
What button is used to view multiple slides on a page in PowerPoint?
Normal slide
Slide master
Side show
Slide sorter
What feature is used in PowerPoint to control styles, design/themes, objects, text, etc. that appears on all slides of the same type.
Slide
Page setup
Slide master
Slide sorter
What feature is used so the slide show will advance at a predetermined rate?
Automatic progression
Placeholder
Automatic timing
Animation
What feature is used in PowerPoint to add information to a presentation that the audience won't see?
Normal view
Slide pane
Task pane
Notes pane
In PowerPoint, what is used to link to other places including other slides, a file, or web sites?
Jumping
Transitions
Merge
Hyperlink
In PowerPoint, what is used in a slide layout that arranges text or content in various configurations?
Placeholders
Images
Objects
Orientation
What feature is used to quickly apply existing formatting to multiple pieces of texts or shapes.
Search
Format painter
Exclamation
Quick copy
What is lightly shaded words or pictures that prints behind text called?
Watermark
Page border
Screenshot
Hyperlink
In an Excel worksheet, what feature is used to allow rows and/or columns to display even while scrolling to the right or down?
Freeze panes
Lock panes
Divide panes
Split panes
In an Excel worksheet, what is used that makes formulas easier to understand and maintain?
Absolute cell references
Mixed cell references
Named ranges
Mixed ranges
In Word, what is inserted to end a paragraph in one column and start a new paragraph at the top of the next column?
Non-standard column break
Column break
Continuous break
Blank page break
In Word, what command is used to insert a section break and start the new section on the same page?
Blank page break
Column break
Continuous break
Standard page break
In Word, which type of break is used to end the current page and move to the next page?
Continuous break
Page break
Column break
Standard break
What type of cell alignment was applied to the column headings in the first row of the worksheet below?
Horizontal Left / Vertical Bottom
Horizontal Justify / Vertical Center
Horizontal Center / Vertical Bottom
Horizontal Right / Vertical Top
Which of the following is a correct design principle when creating a presentation? Choose all that apply.
Be brief and keep to the point
Adhere to copyright laws
Use animation and slide transitions sparingly
Use complementary colors
Use at least a 24 point font
What is Icon " a "
Move Image
Paste
Decrease Indent
Resize a column or row
What is Icon " b "
Move Image
Paste
Rotate image
Resize a column or row
What is Icon " c "
Move Image
Paste
Rotate image
Resize a column or row
What is Icon " d "
Move Image
Select a range of cells
Rotate image
Resize a column or row
What is Icon " e "
Merge and Center cells
Select a range of cells
Rotate image
Resize a column or row
What is Icon " g "
Insert Function
Select a range of cells
Rotate image
Increase decimal
What is Icon " h "
Insert Function
Paste
Rotate image
Increase decimal
What is Icon " i "
Insert Function
Paste
Rotate image
Format Painter
What is Icon " j "
Insert Function
Paste
Decrease Indent
Sum function/ AutoSum
What is Icon " k "
Insert Function
Accounting Number Format
Decrease Indent
Sum function/ AutoSum
What is Icon " l "
Insert Function
Accounting Number Format
Decrease Indent
Sum function/ AutoSum
What is Icon " m "
Fill Color
Accounting Number Format
Decrease Indent
Sum function/ AutoSum
What is Icon " n "
Fill Color
Accounting Number Format
Font color
Sum function/ AutoSum
What is " A "
Active cell
Insert function
Sheet tabs
Name box
What is " B "
Active cell
Insert function
Sheet tabs
Name box
What is " C "
Active cell
Insert function
Sheet tabs
Name box
What is " D "
Active cell
Insert function
Sheet tabs
Name box
In Excel, if $1234.5 is typed in the formula bar, what displays in the cell?
$1,234.50
$1234.5
$1,234.5
$1234.50
In Excel, what function enters a date and time that automatically updates?
TIME
DAYS360
DATE
NOW
In Excel ...
Cell B4 contains value 100
Cell D5 contains value 90
Cell E7 contains function =IF(B4>D5, 80, 70)
What value will display in E7?
70
80
100
90
Which of the following cell references would remain the same when copied?
$B16
B$16
B16
$B$16
