Office Applications II Unit 1 Quiz 3
Width
If a worksheet has only a few columns that will print on a second page, change the Scale to Fit __________________ command to 1 Page. Height Width Percentage Print Smaller
255
Microsoft Excel file names can be ______ characters long. 255 250 8 50
two
Protecting a worksheet for data entry is a __________-step process. two three four five
margins
The white space around the top, bottom, left and right edges of a printed page are knows as the __________________________. white spaces cyberspaces margins footers
document properties
These are the details about a file. document details document properties file properties file information
Edit Shape
To change the shape of a comment, you must add the _______________________________________ tool to the Quick Access Toolbar. Change Shape Edit Shape Reform Shape Reshape Object
border
To display the Format Comment dialog box, you must right-click on the ____________________ of the comment. text middle center border
Show All Comments
To keep all comments on a worksheet visible, click on _______________________________________________________________________________ on the Review tab. Show All Comments Display All Comments Show Comments Display Comments
Print Selection
To print only the cells that you have selected, use the _____________________________________________________________ command on the Print tab. Print Active Sheets Print Entire Workbook Print Selection Print Cells
Advanced Document Properties
To set custom document properties, open the _________________________________________________________________________________________________________. Advanced Document Properties Custom Document Properties Added Document Properties Document Settings View
Save As
Use the ___________________________ command to save a copy of a file. Save Save As Copy As Save File As
Center on Page
Use the ________________________________________________________ command to center worksheets vertically and/or horizontally on a page. Center Pages Center Worksheets Center on Page Center Entire Workbook
red indicator triangle
What indicator displays in a cell that contains a comment? red indicator triangle blue indicator triangle green triangle red square
.xlsx
What is the file extension for a Microsoft Excel 2010 file? .docx .xls .xlsx .xltx
.xltx
What is the file extension for a Microsoft Excel 2013 template file? .docx .xls .xlsx .xltx
- _
What two symbols are safe to use in Microsoft Excel file names? * / / \ - _ + -
when opening the workbook
When a workbook is encrypted with a password, when are you required to enter the password? when saving the workbook when opening the workbook when printing the workbook when closing the workbook
Insert Comment
When inserting a comment in a cell, the command on the Review tab is New Comment, but if you right-click in the cell, what command would you choose from the shortcut menu? New Comment Insert Comment Review Comment Add Comment
Print Titles
When printing large worksheets with lots of rows, it's difficult to tell what the data represents on pages 2 and higher. Use the _________________________________________________ command to set the row(s) that contain the column headings to print at the top of each page. Titles Print Titles Print Rows Print Columns
copying a workbook file
When you protect the structure of a workbook with the Protect Workbook command, which of the following is not something that is protected? adding worksheets moving worksheets copying worksheets copying a workbook file
network drives
Which location for shared workbooks uses File Explorer to access the files? network drives Microsoft SharePoint locations OneDrive Outlook
Share Workbook
Which tool is used to set up a workbook to be used by multiple people at the same time? Share Workbook Share Worksheet Protect Workbook Protect Worksheet
A template
________________________________________ is used to create new files for files that you need to create over and over again. A CSV A PDF A template An export
Document properties
_______________________________________________________________________________ are also known as metadata. Document properties Meta files Files Data properties
CSV
a file format that separates data with commas
template
a file format used to create new files that contain the same data as the template
a file format used to display a file as it will look when it prints
file name
a file name is given to each Microsoft Excel workbook you create to identify the file
Windows OneDrive
a free cloud computing service from Microsoft for storing and sharing computer files that is accessed through Live, Hotmail®, Messenger®, or Xbox LIVE®
share workbook
allows multiple people to open and edit a workbook at the same time
encrypt with password
applies a password to the workbook that must be entered when opening the workbook
inspect document
checks a workbook file for any personally identifying and confidential information
red indicator triangle
displays in a cell to indicate that it contains a comment
network drive
location at a workplace for storing computer files
Microsoft SharePoint location
location for shared computer files that is accessed through Web pages
comments
notes that can be attached to cells to add additional information that is not printed on the worksheet
workbook protection
protects the structure of a workbook by not allowing worksheets to be moved, copied, deleted, or added
save as
the act of saving a copy of a computer file with a different name
save
the act of storing a computer file
backstage view
the area in Microsoft® Excel® that is used to manage files
document properties
the details about a file
document panel
the panel that can be displayed above a document to add and change the document properties
protecting a worksheet for data entry
unlocking cells that can be changed in a worksheet and protecting all of the other cells
advanced document properties
used to set all of the Document Properties in one place
False
After inserting a comment in a cell, the comment displays even after clicking on a different cell. True False
locked
By default, all of the cells in a worksheet are _________________________. unlocked locked protected unprotected
False
By default, comments print when a worksheet or workbook is printed. True False
backstage view
Clicking on the File tab displays the ______________________________________________________________________. file view backstage view file commands view layout view
8.5" x 11"
Common letter-sized paper used in the United States has what dimensions? 8.27" x 11.69" 8.5" x 14" 8.5" x 11" 8" x 11.5"
text file
A CSV file is a ________________________________. shared file text file Rich Text file graphic file
export
A CSV file is used to _______________________ data from Microsoft Excel files. import receive export calculate
printed
A PDF file is used to display a file as it will look when _________________________. printed exported extracted displayed
footers
Text and graphics inserted in this area print at the bottom of every page. headers footers header margins footer margins
headers
Text and graphics inserted in this area print at the top of every page. headers footers header margins footer margins
Quick Access Toolbar
The Save command is found on the File tab. Another place to find the Save command is the _____________________________________________________________________________. Save toolbar View tab Quick Access Toolbar File toolbar
backstage view
The ___________________________________________________________________________ is the area in Microsoft Excel where you can perform file commands such as Save, Open, and Print. backstage view file view file commands view layout view
True
The automatically updated properties cannot be changed by a user. True False
False
The default page orientation in a Microsoft Excel worksheet is landscape True False
above
The document panel displays _________________ the document. below to the left of to the right of above
Shift+F2
The keyboard shortcut to insert a comment is ______________________________. Alt+F2 Shift+F2 Ctrl+F2 Ctrl+Shift+F2
Ctrl-S
The keyboard shortcut to save a file is _____________________________. Ctrl-C Ctrl-S Ctrl-Shift-S Ctrl-Shift-C
protect the sheet with the Protect Sheet command
The second step in protecting a worksheet for data entry is to _____________________________________________________________________________________________________. unlock the cells that can be edited lock the cells that cannot be edited protect the sheet with the Protect Sheet command unprotect the sheet with the Unprotect Sheet command
