The Ribbon
What group is Borders located in?
The Font group
what keyboard shortcut can you use to insert a table?
Ctrl+T
what does Wrap Text do?
Forces text to multiple lines within the cell when needed
What keyboard shortcut can you use to insert a table?
Ctrl+T
What is the answer to the following calculation: (4+6)*2-10/2 ?
15
The box directly under the ribbon, on the left side of the screen, is known as the ____ box
Name
The adjusted cell references in a copied and pasted formula are called _____ cell references.
Relative
What happens when you use Orientation
Rotates the cell contents by a number of degrees
Which ribbon tab contextually appears when a cell in a table is selected?
Design
Which of the following operators is used to start a formula in Excel?
equals sign (=)
How many tabs are in the Ribbon?
9 Tabs
To delete a column in a worksheet, you can select the column header and use which of the following shortcut keys?
Ctrl+Hyphen (-)
What is the use of Decrease Indent, Increase Indent
Move the content closer to or further from the cell border
A table can be converted to which of the following?
Data range
The number of digits is one of the arguments in the ROUND function. (True or False)
True
What commands can be found in the File Tab?
New, Open Save, Save as, Print, Share, and Export
Q:which command on the “HOME RIBBON” allows data to be moved from one worksheet location to another?
Cut
How to use Merge and Center
Three options to merge cells into a new larger cell and one option to separate cells
What option is a unique combination of borders and shading to change the appearance of the table?
Styles
A range that spans two or more worksheets in a workbook is called ___ range.
3-D
What appears in the name box in excel?
the address of the active cell
The ___ button assigns a Fixed dollar sign to the number in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.
Accounting number format
What happens when you use Merge cells
Combines selected cells into one larger cell
A table name can have up to ______ characters
255
As you link workbooks, the cell reference inserted by Excel each time you click a cell in a workbook results in a(n) _____ cell reference.
Absolute