MGSC 290 Exam 1
Fill Handle - ✔✔Allows you to quickly complete data in a series, such as days of the week,
months in a year
Format Painter - ✔✔Allows you to copy formatting and styles from one cell to another cell or
...
MGSC 290 Exam 1
Fill Handle - ✔✔Allows you to quickly complete data in a series, such as days of the week,
months in a year
Format Painter - ✔✔Allows you to copy formatting and styles from one cell to another cell or
group of cells
The ________ command combines two or more selected cells and center aligns the text -
✔✔Merge and Center
You can select single cells or a group of cells, called a _________. - ✔✔range
Each workbook contains ______, which are similar to pages in a microsoft word document. -
✔✔worksheets
Labels - ✔✔help the user understand what each set of data is and are not included in calculations
in worksheets.
You can _____ columns and rows to resize the column width or row height to accommodate the
width or height of the largest entry by double clicking the border of the column or row heading. -
✔✔auto-fit
Cells have a ______ which includes the intersection of column and row. - ✔✔cell reference
You can ______ _______ so that column and row headings display whether you are at the top,
bottom, left, or right of the spreadsheet. - ✔✔Freeze panes
A cloud storage area that keeps files on Microsoft's servers, which allow you to access your files
from anywhere without being tied to the specific computer they were created on. - ✔✔Sky Drive
A window that opens on your desktop that allows you to browse for files. It includes libraries
and folders on the left side and its associated contents on the right side. - ✔✔File Explorer
A small square in the bottom right of some groups on tabs that opens dialog boxes or task panes.
- ✔✔Dialogue Box
You can use the ________ to increase or decrease the display size of your life. - ✔✔Zoom
The ________ stores cut or copied data from Excel or other Office apps, and the data is available
to Excel or other apps and can hold up to 24 items. - ✔✔Clipboard
A cell displays the result of the formula and the _____ displays the formula - ✔✔Formula Bar
Styles - ✔✔a set of predefined formatting you can apply to titles, subtitles, column headings,
row totals, and other areas of your worksheet
Wrap text - ✔✔enables you to display the contents of a cell on multiple lines within the cell
By default, what file extension is given to excel workbook files? - ✔✔.xlsx
In the blank write a formula with the correct syntax to divide the value in cell C7 with the value
in G2 - ✔✔=C7/G2
____________ displays all cells referenced in a formula - ✔✔trace precedents
____________ indicates which formulas reference a particular cell - ✔✔trace dependents
The ___________ tool reviews each part of a formula in sequence to determine where the error
is. - ✔✔evaluate formula
In the blanks, write the three types of cell references? - ✔✔relative, absolute, mixed
Range names - ✔✔describe the cell or purpose of a group of cells and makes it easier to interpret
a formula
When more than one operator appears in the formula, Excel performs each operation by applying
the _________________. - ✔✔Mathematical order of operations
[Show More]
.png)
.png)
