Common Office Features
A series of tabs that display various buttons, dropdown lists, and galleries of options to choose from
What is a Ribbon
There are two types of page orientation.
What is Landscape?
What is Portrait?
A __________ is an individual spreadsheet within a workbook.
Worksheet
Also called typeface or __________refers to a character set that is designed with a particular appearance.
What is Font ?
These two functions count the nonblank and blank cells in a range, respectively.
What is Countblank?
what is CountA?
It appears above the ribbon on the left.
What is Quick Access Tool bar
A_________ is the amount of space between the text and the edge of a document.
What is a margin?
_______ a worksheet by right-clicking its tab and clicking Move or Copy.
What is Duplicate?
___________ can be added to a cell to help visually separate data.
What is Borders?
This function returns the number of characters in a string.
What is LEN?
This hides the ribbon and displays several tabs that let you perform actions on the entire document.
What is backstage view?
By setting a ________, you can define what part of a worksheet gets printed by default.
What is a print area?
In the File tab, click New > Blank Workbook to create a new __________.
What is blank workbook?
These three buttons determine the __________________ of text within a cell.
What is vertical alignment?
This dialog box is especially useful when entering complicated functions with multiple arguments.
What is Function Argument Dialog Box
You open a ____ by clicking a dialog box launcher from a ribbon group or by clicking an advanced option on a menu.
What is a Dialog Box?
This menu lets you choose how much information is printed on a single page.
What is Print Scaling?
From _________ imports files from various formats and sources.
What is Text/CSV?
By default, text typed into a single cell will continue on the same line.
What is Wrap Text?
The __________ shows the underlying formulas of the selected cell.
What is Formula Bar?
_________ appear on the screen when you right-click.
What is a Shortcut Menu?
This menu switches between printing slides or handouts in color, grayscale, and pure black-and-white.
What is Color Options?
____________ imports a table or query from a database such as an Access or SQL server database.
What is Get Data > From Database?
The _____________ Format button automatically formats the selected cells as currency.
What is Accounting Number?
________finds the arithmetic mean of a range of cells.
What is AVERAGE?