BSM 140: Introduction to Spreadsheets
Weekly Objective Quiz 3
Question 1
A translucent background design that prints behind your data is called a ____.
Select one:
a.
transparency
b.
bitmap
c.
watermark
d.
logo
Question 2
What will you select as X in the following series of clicks/entries/selections to apply a table style: Select cell to format as table > X > Format as table > Desired table style?
Select one:
a.
Data tab
b.
Insert tab
c.
Home tab
d.
Review tab
Question 3
A worksheet displayed in its own window is called a(n) ____.
Select one:
a.
workspace
b.
instance
c.
workbook
d.
group
Question 4
The coding format used for all web documents is called ____.
Select one:
a.
HTML
b.
XML
c.
MHTML
d.
JAVA
Question 5
To ensure that a workbook displays the same way on different computers, publish it in _____ format.
Select one:
a.
pdf
b.
ods
c.
xps
d.
xltm
Question 6
To hold headers in place as you scroll through a worksheet, _____ the panes.
Select one:
a.
hide
b.
bookmark
c.
split
d.
freeze
Question 7
What appears in the title bar when you mark a workbook as final?
Select one:
a.
[Compatibility Mode]
b.
[Final]
c.
[Read-Only]
d.
[Enable Content]
Question 8
When you save an Excel workbook as an earlier version of Excel, what appears in the title bar when you open the file?
Select one:
a.
Enable Worksheet
b.
[Protected]
c.
[Compatibility Mode]
d.
The version number of Excel
Question 9
____ help users locate, identify and understand a file.
Select one:
a.
Targets
b.
Properties
c.
Names
d.
Hyperlinks
Question 10
A hyperlink jumps to a ____.
Select one:
a.
source
b.
target
c.
webpage
d.
dialog box
Question 11
When a workbook is marked as final, a yellow bar appears below the tabs with a(n) _____ button.
Select one:
a.
Reverse Final
b.
Edit Anyway
c.
Review
d.
Update
Question 12
Which button do you click to add information about a hyperlink?
Select one:
a.
ScreenTip
b.
Caption
c.
Info
d.
Insert
Question 13
Which of the following can users search for to help them locate a workbook?
Select one:
a.
groups
b.
folder names
c.
keywords
d.
links
Question 14
Which of the following keys will you press when the cell cursor is in the last cell of the last record (row) to add new data for the next record?
Select one:
a.
Esc
b.
Ctrl
c.
Tab
d.
Shift
Question 15
Bill wants to insert a row in a table created in MS Excel to add enter some new data. What should he do?
Select one:
a.
Double click on the selected row and press the Tab key
b.
Right-click the row number, and then select Insert
c.
Tab
d.
Left click on the selected row and press the Esc key
Question 16
Haley wants to delete a column in a table created in MS Excel to get rid of some unwanted data. What should she do after selecting the column?
Select one:
a.
Left click on the selected column and press the Esc key.
b.
Right click on the selected column and press the Delete key.
c.
Double click on the selected column and press the Tab key.
d.
Right click on the selected column and press Ctrl + Z key.
Question 17
Which of the following will you select as X in the following series of clicks to format a range as a table: Home tab > Styles group > X > Table Styles?
Select one:
a.
Cell Style
b.
Cell Effects
c.
Format as Table
d.
Conditional Formatting
Question 18
Adele wants to extract a list of unique items in a database. Which of the following will she select in the series of clicks to do so: Select cell > Data tab > Advanced > Select option under Action (X) > Specify List range > Select a starting cell for copying to location > Check box beside Unique records only > OK?
Select one:
a.
Filter the list, in place
b.
Copy to another location
c.
Filter unique records
d.
Copy unique records
Question 19
Which of the following will you do to manually turn off autofilter in a table between the steps: Clicking any cell in the filtered range and clicking the Filter button?
Select one:
a.
Clicking the Data tab on the Excel Ribbon
b.
Clicking the Insert tab on the Excel Ribbon
c.
Clicking the Review tab on the Excel Ribbon
d.
Clicking the Formulas tab on the Excel Ribbon
Question 20
Which dialog box opens after selecting a cell in the list of prepared data, clicking the Insert tab on Ribbon and then clicking the Table command in the Tables group?
Select one:
a.
New Table
b.
Insert Table
c.
Create Table
d.
Include Table
