Introduction to Microsoft
how can you access the backstage view?
File tab
What is the shortcut to inserting and deleting a column?
What is Ctrl + Plus sign (+), Ctrl + Hyphen (-)?
What tab and group will you find ”Cell Styles”?
Home Tab, Styles Group
The ____ allows you to scroll through your document left and right.
Horizontal Scroll Bar
What operator is used a the beginning of a formula?
=
By default, when you select Enter to complete a cell entry, where will the active cell be?
in the row below
When deleting multiple columns and rows what can you not do?
What is you cannot delete columns and rows simultaneously?
What command do you use to change the color of a cell background?
Background Color
What keyboard shortcut can you use to insert a table?
Ctrl+T
What symbol is used to multiply in Excel?
*
If cell A1 contained the number 1 and you used AutoFill to fill the cells automatically
down to A20, what number would be in cell A20?
20
What provides the most paste options?
What is the Paste Special Dialog Box?
To display text turned on its side or on an angle, you change the _________.
Orientation
The intersection of the row and the column is called a _____.
Cell
A valid named range can have a space in between words (True or False?)
False
The ___ feature works behind the scenes, fixing typing or spelling mistakes when you complete a text entry
Auto correct
When selecting all the columns in a worksheet and double-clicking on a column divider this is known as?
What is Autofit?
What formatting feature for alignment will put the text in a cell on multiple lines within the same cell?
Wrap Text
What command creates a table and simultaneously applies a table style?
Format as Table
What symbol specifies an absolute reference in excel?
$
You can enter the correct range in a function by typing the beginning and ending cell references separated by a
Colon
What is paste special?
What is a feature that allows you to paste copied items in Various ways?
To position text equally between the top and bottom of a cell, which alignment setting would you use?
Vertical Alignment
What keyboard shortcut can you use to turn on or turn off a Total Row at the end of the table?
Shift+Space to select an entire row.
The formula =6*2/3 produces the same result as =6*(2/3) (True or False?)
True