Vocab
What does a Spreadsheet Program do?
Stores, analyzes, and organizes information.
How do you change workbook views?
View tab, Workbook Views group, and select a view.
How do you open a new workbook while in another one?
How do you print an entire workbook?
File tab, select Print, under Settings click Print Entire Workbook and then Print.
What is the shortcut to access the backstage view?
Alt+F
The selected cell that is outlined by a bold rectangle is called what?
Active Cell
How do you name a cell?
Select the cell and type a new name into the Name Box, click Enter to save.
What key moves to the next column?
Tab
True or False: The Ribbon can not be customized.
False
What does Ctrl+End do?
Moves to the end of the worksheet.
Located between the ribbon and worksheet, displays the text of the active cell. What is it?
Formula Bar
What command do you use to find a cell with certain criteria?
Find & Select command
How do you adjust column width? (2 answers)
Manually drag the column marker to desired width.
Double click on the column marker to expand it.
How do you set a Print Area?
Select the cells, go to the Page Layout tab, Page Setup group, click the Print Area drop-down and then click Set Print Area.
True or False: Ctrl+Home moves to the beginning of the worksheet.
True
Formatted series of text or numbers that are in normal sequences such as months, weekdays, or times are called what?
Natural Series
How do you change the Window View?
View tab, Window group, select Split.
True or False: Dates are considered serial numbers.
True
Where in the File tab do you go to Customize the Quick Access Toolbar?
Options
What does Ctrl+X do?
Cut
What are default settings?
Pre-set options that determine how Excel will behave when performing an action.
What is a workbook with pre-determined formatting?
Template
What feature automatically fills cells with data and/or formatting?
Auto Fill
True or False: You can add a tab to the Quick Access Toolbar.
False
What does Ctrl+Z do?
Undoes the last change.