WorksheetsEXCEL Lessons 4-5
Total questions: 33
Worksheet time: 19mins
Each cell on a worksheet is assigned a formal name which consists of the _____________.
worksheet name and row number
file name and cell name
user name and cell reference
worksheet name and cell reference
An absolute cell reference such as ________ is a locked cell reference.
$A$5
*A*5
A5
#A#5
__________ applies formatting to cells that meet a specified condition such as filling a cell with color when it is greater than a given number.
Combination filtering
Conditional formatting
Hierarchical sorting
Data validation
A _______ is a technical term for a row in a table that contains data.
row
field
record
cell
A table can be __________ to display only data that matches specific criteria.
filtered
added
expanded
sorted
A ________ is a layout organizing data using headers at the tops of columns that hold data in rows.
graph
worksheet
table
chart
The formal name for cell M7 on the Budget worksheet is ________.
Budget!7M
M7!Budget
M7
Budget!M7
__________ can check if the value entered is of the correct size or if you entered a letter instead of a number in order to eliminate input errors.
Data entry
Data validation
Data tools
Conditional formatting
The ________ name can be used when making references within the same worksheet; however, the _______ name must be used when referencing cells on different worksheets.
informal; formal
cell; worksheet
formal; informal
worksheet; cell
The formula = 8 + 3 * 2 - 4 / 2 is entered in an excel worksheet. What answer will Excel display in the cell?
6
12
8
10
The formula = (1 + 2) * 4 - 2 / 2 is entered in an excel worksheet. What answer will Excel display in the cell?
11
12
8
10
Columns that do not have value to the reader but cannot be deleted without breaking necessary formulas in the worksheet can be _________.
formatted
added
hidden
deleted
A formula that performs a logical test and then places a value if true or another value if false is called a(n) ____________ function.
true-false
value test
Logical test
If-Then-Else
A table can be ________by clicking the small triangle in the bottom-right corner of the table.
filtered
expanded or reduced
sorted and filtered
sorted or filtered
The command called ________ could be used to search for specific items such as comments, conditional formatting rules, formulas and other special features.
File search
Worksheet search
Find & Select
Item Finder
The informal name for cell R7 on the Summary worksheet is ______.
Summary!R7
7R
R7
R7!Summary
A small red triangle in the top-right corner of the cell means that the cell contains ____.
an error
a formula
a red triangle
a comment
=IF([@Roses]>=[@Daisies],"Roses","Daisies")
In the formula above, what will be displayed if the Roses are greater than Daisies?
greater than
Daisies
Roses
less than
Which function will count the number of cells in a range that meet a given condition?
AVERAGE
IF
COUNTIF
COUNT
A small green triangle in the top-left corner of the cells (see image below), means that the cells may contain ____.
an error
a formula
a green triangle
a comment
When a comment box is added to the spreadsheet, the comment box displays the _____.
date the comment was created
name of the user who created the comment
name of the file
name of the person reading the comment
Excel has the formulas shown above in each of these cells.
Which CELL will display a result of 8?
A1
A3
C1
C3
=IF([@Roses]>=[@Daisies],"Roses","Daisies")
In the formula above, what will be displayed if the Roses are greater than Daisies?
greater than
less than
Roses
Daisies
=IF([@Roses]>=[@Daisies],"Roses","Daisies")
When reading the formula above, what word does the FIRST comma represent?
COMMA
IF
THEN
ELSE
=IF([@Roses]>=[@Daisies],"Roses","Daisies")
When reading the formula above, what word does the SECOND comma represent?
COMMA
IF
THEN
ELSE
You are asked to create a formula that compares the number of Cakes to the number of Pies available at the Bake Sale and displays Cakes when cakes are greater than pies.
Which formula should you use?
=IF([Cakes]>[Pies], “Pies”, “Cakes”)
=IF([Cakes]>[Pies], “Cakes”, “Pies”)
=IF([Pies]>[Cakes], “Cakes”, “Pies”)
=IF([Pies]>[Cakes], “Pies”, “Cakes”)
Which formula is read as:
If the value in the Total column is greater than or equal to the value in the Average column, THEN display the value 1 ELSE display the value 0.
=IF([@Total]>[@Average],1,0)
=IF([@Total]>=[@Average],0,1)
=IF([@Total]>=[@Average],1,0)
=IF([@Average]>=[@Total],1,0)
Sheet names cannot be changed on an Excel workbook.
TRUE
FALSE
The headers in a table help organize and identify the data.
TRUE
FALSE
Tables can have either column headers or row headers but not both.
TRUE
FALSE
Data can be sorted by only three criterion in Excel.
TRUE
FALSE
A(n) exclamation point (!) separates the worksheet reference from the cell reference.
TRUE
FALSE
Cell references from a worksheet can be used in formulas on another worksheet within an Excel workbook.
TRUE
FALSE
