Introduction to Excel
Which function would you use to find the average of totals in cells C1 through C5?
=AVERAGE(C1:C5)
Which of the following is an example of a cell reference?
C6
You would like to remove conditional formatting from a range of cells. After selecting the range, you should press _______ to open the Formatting tab and remove the conditional formatting.
CTRL + Q
Selecting _______ allows you to remove a hyperlink from a cell while maintaining the cell formatting.
Clear Hyperlinks
a ___ is used to analyze and summarize your data without graphical support.
PivotTable
What's the default Total Row function?
SUBTOTAL
To give a table a new name, select the table and perform the following steps:
Table Tools > Design > Properties > Table Name
To add exponentiation to a formula, use the _______ symbol.
^
You would like the cell reference in a formula to remain the same when you copy it from cell A9 to cell B9. This is called a/an _______ cell reference.
absolute
Misspelled words in Excel
aren't automatically flagged
You've just started Excel and would like to open a new spreadsheet. What should you select?
blank workbook
On a spreadsheet, what runs vertically and is identified with letters?
columns
a table can be changed back to cell data by selecting the ___ button.
convert to range
which key removes all data from an active cell with one click?
delete
Your pointer becomes a/an _______ when you point to a column boundary.
double-headed arrow
the mathematical order of operations is used in Excel when formulas are evaluated. This order of operations states the order to be
exponentiation, multiplication and division, addition and subtraction
You should select the Chart _______ button to remove a series title from a chart.
filters
what does it mean when #DIV/0!. is displayed and a green triangle is added to the upper-left corner of a cell?
found in calculating values with formulas and functions
you can create a cell reference in a formula by typing in the cell name or
found in calculating values with formulas and functions
to add a data series to a chart from the Chart Tools contextual tab, perform the following steps:
found in: illustrating data with charts
you can ___ to keep one area of a worksheet static while you scroll to a different area within the same worksheet.
freeze panes
CTRL + ____ selects the last cell with data.
getting started in Excel
when planning the structure of a spreadsheet, columns are for ____ items, and rows are ___ items.
group; single
a ___ is included within a cell to perform a particular action when selected, such as starting an email or navigating to a web page.
hyperlink
With Quick Sort you can sort the data in a range by
individual column.
what's the text that's entered in a cell used to identify the purpose of purpose of the worksheet, column, and rows?
label
Which type of chart would you use to quickly show a connection between sales growth over a five-year period?
line
on the excel ribbon, select the Data tab in the Sort & Filter Group, and then Select the Sort button to conduct a ___ sort.
multiple column
You would like to add an additional spreadsheet to your workbook. Which button should you select?
new sheet
you can apply several different worksheet themes from which tab?
page layout
Which contextual tab appears when you select an image that has been added to a worksheet?
picture tools format
The ___ button automatically displays next to the data when you select a range of numeric data, which is available option for creating a chart.
quick analysis
To quickly create a chart from a selected range of numeric data, you can select
quick analysis
which feature of Excel allows you to automatically calculate common formulas with selected data?
quick analysis
To make your spreadsheet data easier to read, numbers should be
right-aligned
You would like to print all the contents of a worksheet on two pages. Selecting _______ allows you to select the number of pages you want your worksheet to print on.
scale to fit
what should be a situation in which you should use an Excel chart to present your data?
showing the percentage of customers who purchase three different products
small charts within cells are useful for displaying data trends are
sparklines
the most efficient way to perform data entry is to keep your hands on the keyboard, and press ___ to move to the next cell in the row or press ___ to move the next cell in the column.
tab; enter
what's entered into a cell that's typically numeric and can be used for calculations?
value
