Amazing
When you enter data in a worksheet, the data also appears in the
formula bar
What is the fill handle used for
to copy data and create series of information
What does the cell address C15 refer to?
column C row 15
The content appearing at the bottom of each printed page is called a:
footer
A range can be entered by typing the beginning cell reference, a ____________, and the ending cell reference.
colon
To return to cell A1 from any cell in the worksheet, which key combination is correct?
Ctrl+Home
Which operation allows you to move data from one place to another without removing it from the source?
copy and paste
The content appearing at the bottom of each printed page is called a:
footer
A mathematical function that contains cell addresses and mathematical operators is called a:
formula
Which tool allows you to combine a range of cells into one cell?
Merge and Center
Which command is used to protect a worksheet or workbook?
Format
Indicate which sign alerts the application that a formula or function is being entered in a cell?
=
Which function provides a convenient means to add the amount of cells in a range that includes both numbers and text?
count
Row headings are letters used to identify each row
false
Which formula function can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
sum
Adding the sum within a range is
=Sum (A6:A30)
The formula that generates the maximum figure in the range A2 to A10 is most likely to be
=max(A2:A10)
Copy, paste, merge, and center are all commands in the _________ tab.
Home
The function ______ will add all the values in the cells B6 to B9.
=SUM(B6:B9)
The "Go to" command can be found by going to the Home tab and selecting the ________ command.
Find and Select
Shortcut keys, CTRL+V, CTRL+S, CTRL+X, CTRL+C mean:
paste, save, cut, copy
A user wishes to remove a worksheet from a workbook. Which is the correct sequence of events to do this?
right click on the sheet tab and select Delete
Excel calculates formula based on the following order of operations: parenthesis; exponential calculations; multiply and divide whichever comes first; addition and subtraction whichever comes first
true
To shrink, wrap and merge, one may go to Format Cells, then _________ tab.
alignment
________ provides instructional text for a cell that lets the user know the content of a cell.
Cell comment