Excel
Using the mouse to move or copy cells is called ____.
drag and drop
The default view in Excel is called ____ view.
normal
pressing the ____ key to complete an entry activates the adjacent cell to the right
right arrow
Which of the following is not a formatting symbols
Pound sign
The ____ button lists error-checking options following the assignment of an invalid formula to a cell.
Trace Error
The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.
formula
The ____ function is useful when you want to assign a value to a cell based on a logical test .
if
When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.
true
The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.
two
When working with a large worksheet, you can split the window into ____ panes.
two or four
How many chart types does excel offer
15
All of the following are valid Excel arithmetic operators EXCEPT ____.
>
Which of the following Option buttons gives options for filling cells following a fill operation?
Auto Fill Options
The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it.
False
The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.
Fill Formatting Only
Which of the following Auto Fill Options menu options is the same as the Fill Series option?
Fill Months
The ____ function displays the highest value in a range.
Max
To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.
Print Selection
A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.
True
the ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formating
auto fill options
the ____ area on the status bar include six commands as well as the result of the associated calculation on the right side of the menu
autocalculate
the ___ feature works behind the scenes, fixing common typing or spelling mistake when you complete a text entry
autocorrect
The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.
average
A pie chart with one or more slices offset is referred to as an ___ pie chart
exploded
The path to the Format Painter button is ____.
(HOME tab | Clipboard group)
Excel remembers the last ____ actions you have completed.
100
The ____ button assigns a fixed dollar sign to the numbers 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
A cell reference with only one dollar sign before either the column or the row is called an absolute reference.
False
You can use the ____ to check which cells are referenced in the formula assigned to the active cell.
Range Finder
A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.
Sparkline
The equal sign (=) precedes a formula.
True
to enter data in a cell, you must first select the
cell
A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.
indirect
The first step in creating an effective worksheet is to make sure you ____.
understand what is required
An Excel ____ allows data to be summarized and charted easily.
worksheet
write steps to Sum a column of numbers
select cell home tab editing autosum enter
Which of the following is an extension of the fill pattern Sunday, Tuesday?
Thursday, Saturday, Monday
The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer's memory.
Clipboard
to erase an entire entry in a cell and then reenter the data from the beginning, press the _____ key
ESC
In the context of copying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to press the ____ key.
Enter
Which of the following happens when you enter the formula =G15 into a cell?
Excel assigns the value in cell G15 to the active cell
An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.
False
Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees.
False
A date stamp shows the date a workbook, report, or other document was created or the time period it represents.
True
you use ____ to view an XPS file
XPS viewer
A ____ is text and graphics that print at the top of each page.
header
which of the following is the ribbon path to the cell style button
home tab styles group
Which of the following is not a valid formula? =3^4 =H3/H11 22-F15 =11+9
22-F15
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.
26
Which of the following is not a valid format symbol? , $ % ;
;
Which comparison operator means "not equal to"?
<>
Write absolute formula for addition of : B1 , C1 , D1 and E1
=$B$1+$C$1+$D$1+$E$1
Which of the following formulas contains an absolute cell reference?
=$B$4
Which of the following calculations multiplies 23 by 0.01?
=23%
If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message.
#REF!
You can click the ____ button to undo an automatic correction.
AutoCorrect Options
press ____ to select the entire worksheet
CRTL+A
You can apply the Bold font style by pressing the ____ keyboard shortcut keys.
CRTL+B
pressing the ___ keyboard shortcut key select cell A1
CRTL+HOME
You can press the ____ keys to open the Format Cells dialog box.
CTRL+1
The ____ Option button lists formatting options following an insertion of cells, rows, or columns.
Insert
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.
Operations
____ view allows you to create or modify a worksheet while viewing how it will look in printed format.
Page Layout
Write steps to rotate Text in Cell.
Select cell go to home tab and go to alignment click on drop down menu and click on "ab with an arrow increasing" click on drop down menu and select format you want
Write steps to apply Accounting Number Format.
Select cells that need to be formatted go to home tab, click on number group click on dropdown menu and find accounting option
Write steps to apply Conditional Formating.
Select cells you want to format go to home tab, go to styles group click on conditional formatting and drop down menu will appear click on specific format
Write steps to change Row height.
Select row you want to change height of go to home tab, go to cells group, click on drop down menu select format drop down menu select row height add specific height and click ok
The AutoCorrect feature can automatically capitalize the first letter in the names of days.
True
Charts can either be embedded in a worksheet or placed in a separate ____.
chart sheet
A formula in a cell that contains a reference back to itself is called a(n) _________ reference.
circular
write steps to change a cell style
click on cell home tab styles group cell styles change cells
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.
colon
The range of cells receiving the content of copied cells is called the ____
destination area
what effects does the accounting number format have on the selected cells
displays cell content with two decimal places that align vertically
what effects does the comma style format have on the selected cells
displays cells content with two decimals places and commas as thousands separators
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
format
A ____ is a prewritten formula that is built into Excel.
function
Write steps to create a series of Month Names
key in the name of January in the first cell hover the mouse over the bottom right corner of the cell until you see a "+" press on the + and drag to the right until you are done with naming the months
Combining two or more selected cells into one cell is called ____ cells.
merging
The ____ function determines the lowest number in a range.
min
A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.
nested
When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.
now
The range of cells receiving copied content is called the ____ area.
paste
A ____ reference is an adjusted cell reference in a copied and pasted formula
relative
The adjusted cell references in a copied and pasted formula are called ____ cell references.
relative
Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
right parenthesis
write steps to add a 3D pie chart
select all data insert tab chart group circle image button drop down menu 3D chart
Write steps to Split a window into Panes in Excel 2016.
select area you want to split go to view tab and go to window group go to image that is a square with blue header and red line in the middle click on it and worksheet will split
Write steps to add a Sparkline Chart to the worksheet.
select cell you want chart to appear go to insert tab and then go to spark lines group click on drop down menu and select either lines, column, or win/loss select cells you want to include and the cell you want to put the chart in press ok
write steps to change the sheet tab name
sheet tab on bottom of worksheet double click rename