Module 1
where can I customize workbook views?
the view tab
How do you save the file as a PDF
Go to the file tab, then export, then create PDF
True or False: You can customize the tabs
true
Ctrl+End
It takes you to the end of your work (bottom right corner)
The file tab is also considered the.......
Backstage view
How can you open a workbook in progress
go to the backstage view then the browse section
How do you adjust column width?
Either double-click on the column line OR drag the line to how long you would like the column
True or False: You can print from inside the workbook
True
Ctrl+Home
It takes you to the very beginning of your worksheet (top left)
what do screen tips tell you?
it tells you what each of the commands do.
How to customize the Quick Access toolbar
You can either right-click on a command and choose to add it to the Quick Access toolbar OR you can select the drop-down box and select or unselect commands
What are the short cuts for copy, paste, and cut
Ctrl+ C, Ctrl+ V, Ctrl+ X
Can you set a specific print area
yes
Ctrl+ N
Opens a whole new workbook
what does auto-fill do
it automatically fills the cells
True or False: You can not open a workbook if you already have one open
False
Where can you find the document properties?
FIle tab, then info section
What tab do you go to be able to print
file OR page layout
Ctrl+ Right Arrow
takes you to the last column, but if you have data it takes you to the last column with data.
what does the name box help with
navigating to different cells
True or False: The active cell is the row that is selected
false, it's the cell that's selected
What is the move pointer
allows you to move cells
How do you print a section
Select the cells you would like to print, then go to the printing area and select print section under settings
Ctrl+ Down Arrow
Takes you to the last row if there is no data, but if there is data it takes you to the last row of data
When you copy something, where does it go?
The clip board