NEW
Font size
WorksheetsExcel Unit 3 & 4 Study Guide
Total questions: 39
Worksheet time: 20mins
Anything that appears on the screen that you can select and work with as a whole, such as a shape, picture, or chart is known as a(n):
object
graphic
illustration
chart
In the picture below, what type of tab is the arrow pointing to?
main tab
drawing menu
format menu
contextual tab
A contextual tab only appears on the Ribbon when you select certain items in a file, and contain commands related to that item.
True
False
A graphical representation of data that makes the data in a worksheet easier to understand is known as a(n):
chart
clip art
cell
picture
Which type of chart uses bars of varying heights to illustrate values in a worksheet, and is useful for showing relationships among categories of data?
scatter chart
pie chart
line chart
column chart
The data upon which the chart is based is called the
data series
data source
labels
chart type
A group of related information in a column or row of a worksheet that is plotted on the chart is known as the:
chart type
data source
data series
chart label
When you update the data that is used in the data source for a chart, the chart will NOT automatically update to reflect the new data.
True
False
How can you rename a worksheet tab?
Worksheet tabs cannot be renamed.
Click on the tab, wait a second, then click again to rename it.
Double- click on the sheet tab name, then type the new name.
Right-click on the tab and choose change from the menu.
The color of a worksheet tab cannot be changed, and must follow the color scheme of the workbook theme.
True
False
In the picture below, which part of the chart is number 1 pointing to?
vertical axis title
chart title
legend
horizontal axis title
In the picture below, which part of the chart is number 2 pointing to?
chart title
vertical axis
horizontal axis title
plot area
In the picture below, which part of the chart is number 3 pointing to?
chart title
vertical axis
horizontal axis title
plot area
In the picture below, which part of the chart is number 4 pointing to?
chart area
data marker
plot area
data series
In the picture below, which part of the chart is number 5 pointing to?
legend
chart title
data markers
data series
In the picture below, which part of the chart is number 6 pointing to?
vertical axis
vertical axis title
horizontal axis
horizontal axis title
In the picture below, which part of the chart is number 7 pointing to?
data series
plot area
data marker
legend
Using the chart below what was the approximate sale price of the Fuji camera?
$300
$245
$260
$250
Using the chart below what is the horizontal axis title?
Camera Models
Camera Sales
Price in Dollars
List versus Sale Price
An equation used to calculate values in a cell of a worksheet is known as a:
constant
formula
function
operator
Which of the following is the correct format for a FORMULA in a worksheet?
+(B3*C4)/D4
(B3*C4)/D4
=(B3*C4)/D4
#(B3*C4)/D4
Each formula or function in a worksheet begins with an equal (=) sign.
True
False
What will appear in the worksheet cell in which the formula is entered if the formula is entered correctly?
The formula itself
########
The results of the calculation
#NAME?
When you enter a formula or function in the cell of a worksheet, what will appear in the formula bar?
The formula itself
The results of the calculation
#?NAME?
#FORMULA
The sequence used to calculate the value of a formula when there is more than one operand is called the:
mathematical calculation
order of evaluation
order of operands
evaluation technique
A shorthand way to write an equation that performs a calculation is known as a:
function
formula
average
sum
Which of the following functions would you use to add the range of cells highlighted in blue below?
=SUM(B7+B9)
=ADD(B7...B9)
=SUM(B7...B9)
=SUM(B7:B9)
In the picture below what which of the following functions would be correct to show the result you see in cell F12?
=SUM(F5:F10)
=SUM(F7:F11)
+SUM(F7:F11)
SUM(F7:F11)
Using the worksheet below, what would be the correct formula to find the average discount of the digital cameras on sale?
AVERAGE(C7:C11)
+AVERAGE(C7:C11)
AVERAGE(C7...C11)
=AVERAGE(D7:D11)
=AVERAGE(C7:C11)
Using the information in the worksheet below, which would be the best formula to give me the highest final price ?
=MIN(F7:F12)
=MIN(F7:F11)
=MAX(F7:F12)
=MAX(F7:F11)
This function returns the smallest number in a selected range of cells.
MAX
AVERAGE
MIN
COUNT
Using the information in the worksheet below, which would be the best formula to give me the total number of digital cameras on sale?
=COUNT(A7:A11)
=COUNT(B7...B11)
=COUNT(B7:B11)
=COUNT(A7...A11)
This function will return the number of cells in a selected range that contain numbers.
MAX
COUNT
AVERAGE
NUMBER
The arrow in the picture below is pointing to which part of a formula?
equal sign
function name
argument
The arrow in the picture below is pointing to which part of a formula?
function name
argument
equal sign
Using the information in the worksheet below, which would be the best formula to give me the price of the camera with the lowest sale price?
=MINIMUM(D7:D10)
=MIN(D7:D11)
=MIN(E7:E11)
=MINIMUM(E7..D11)
Using the information in the worksheet below, which of the following formulas would you most likely use to find the sale price of the Kodak digital camera?
=B10-C10
=C10-B10
=C10+D10
=B8*D8
=SUM(B10:C10)
Which statement is true about using the fill handle on a worksheet in Excel?
The fill handle is used to copy formatting only from one cell to another in the same worksheet.
The fill handle changes to a red cross when you are unable to copy the contents of the cell to an adjacent cell.
The fill handle can be used to copy a cells contents and/or formatting to an adjacent cell.
The fill handle cannot copy formulas, only values, into adjacent cells.
Which of the following is NOT a part of a function?
=
function
argument
Fx
