Functions
Which function inserts the total of a range?
SUM
To copy a cell's formatting to another cell, what command can you use?
Format Painter
You want to delete a worksheet column, you need to first select it by ....
a. clicking the column heading
b. double-clicking the column heading
c. clicking anywhere in the column
d. double-clicking anywhere in the column
a. clicking the column heading
=B6*$B$2
What best describes $B$2?
a. Function
b. Average
c. Absolute Cell reference
d. Relative Cell reference
c. Absolute Cell reference
series of 2 or more adjacent cells in a column, row or rectangular group of cells
Range
To have Excel enter the lowest price from a range of prices, which function would you use?
MIN
To illustrate different data levels using small graphics representing values, which can you use?
a. color scales
b. Highlight Cell Rules
c. data bars
d. icon sets
Which view would you use to edit a worksheet footer?
Page Layout
You worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in formulas?
$A$5
Cells that automatically change to reflect the new location when the formulas are copied or moved
Relative Cell Reference
What feature inserts a function that totals the cells above or to the left of the selected cell?
AutoSum Button
To format a cell range so that values between 100 and 500 appear in red, which would you use?
a. Top/Bottom Rules
b. Highlight Cell Rules
c. themes
d. icon sets
b. Highlight Cell Rules
What will you do to explode a pie chart slice?
a. Right-click the pie chart, click on Format Data Series, then enter a number in the % box
b. Right-click the pie-chart, click Change Series Chart Type, click Pie, then click Bar of Pie
c. Click pie chart, double-click the slice you want to explode, drag it away from the center of the chart.
d. Right-click the pie-chart, click Change Series Chart Type, click Pie, then click Pie of Pie
=A8*$A$1
Which describes A8?
a. AutoSum
b. Function
c. Absolute Cell Reference
d. Relative Cell Reference
d. Relative Cell Reference
Column or row in a datasheet and also the set of values represented in a chart
Data Series
Which function would you use to calculate the arithmetic mean of a price list?
AVERAGE
To combine multiple cells into one combined cell and center align the contents, what command do you use?
Merge & Center
To align currency symbols and decimal points in a column of numbers, you need to apply the _____number format.
Accounting
When you want to preserve the relationship to the formula location, you would use what type of cell reference?
Relative Cell references
Special formatting applied if cell values meet specified criteria
Conditional Formatting
Special, predefined formula that provides a shortcut for a commonly used calculation
Function
If you see a cell with blue fill of varying lengths representing the values, the cells most likely have _______ applied to them.
a. Data Bars
b. Cell Styles
c. Themes
d. Icon Sets
a. Data Bars
In a complex formula, how does Excel determine which calculation to perform first?
a. It calculates the functions first
b. It calculates the leftmost formulas first
c. It calculates operations outside parenthesis first
d. It follows the order of operations
d. It follows the order of operations
You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros...Find the problem by checking for what in your original formula?
a. If the column needs to be wider.
b. If it needs landscape orientation
c. If it needs an absolute cell reference
d. If it needs a relative cell reference
c. If it needs an absolute cell reference
Looks for patterns in the data and auto fills or formats data in remaining cells based on those patterns
Flash Fill