CIS Exam
What is the error message when you attempt to use a cell in a formula that has been deleted as a function argument?
#REF!
What is the error message when you calculate the following in cell A1: 2756 ÷ 0?
#REF!
Excel's AVERAGE function returns the mean of a set of numbers.
True
Excel's DAY function returns the day of the month
True
Excel's WEEKDAY function returns a number from 1-7 or 0-6
True
Keyboard shortcuts allow rapid navigation in a worksheet without having to use the mouse. True or False
True
The Ctrl + S shortcut quickly saves your file to the same location as the last save. True or False
True
The active worksheet has a white tab with bold letters and a thick bottom border. True or False
True
The result of =LEFT("Washington",4) is Wash
True
The result of =ROUNDDOWN(98.765,0) is 98.
True
To hide gridlines, check the Gridlines box in the Show group on the View tab. (1 point) True False
True
The inputs used by an Excel function to calculate a result are called _______
arguments
Optional arguments in a function are enclosed within _____
brackets [ ]
When applying a ________, it is best practice to use muted or pastel colors. (1 point) a.table style b.theme c.built-in cell style d.fill color
fill color
The result of =FIND("is", "Mississippi",3) is ___
5
The worksheet that is visible in the Excel application window is the _______ worksheet
Active
Identified by the thick green border
Active Cell
Tab has a white background with bold letters and a thick bottom border
Active Worksheet
Cells in a worksheet that have been selected
Cell Range
A reference within a formula or function instead of a value
Cell reference
To change the width of a column, you click Column Width in the ________ tab.
Cells group on the Home tab
________ data is formatted as a serial number.
Date
Stored as a serial number
Date data
To display the Create Names from Selection dialog box, you click Create From Selection in the ________ tab.
Defined Names group on the Formulas
To modify a named range, you select its name in the Name Box, then click Name Manager in the ________ tab
Defined Names group on the Formulas
he cell that receives the result of an operation
Destination Cell
Which of the following is NOT an Excel function category?
Educational
_______ is the keyboard shortcut to display a list of named ranges
F3
=$B$2 - C5 is an example of mixed cell referencing
False
If you mistakenly delete a worksheet, you can recover it by pressing Undo. True or False
False
The TODAY and NOW functions return the same result
False
The dollar sign ($) and comma (,) are stored as part of a numeric cell value. True or False
False
The result of =DATEDIF("12/21/2014","11/02/2019","Y") is 2.
False
The result of =LEN("54") is 9.
False
To move up one screen, you use the Ctrl + PgUp keyboard shortcut. True or False
False
When cell A3 containing the formula =$A$5+$B$6 is copied to cell G7, the formula in cell G7 is =$G$9+$H$10.
False
An item of information in a worksheet column that is associated with something of interest
Field
_________ combines selected cells into a single cell and then centers the text within that single cell.
Merge and Center
A function is a built-in program that performs operations on data. (1 point) True False
true
Documentation is an important part of building a good worksheet. (1 point) True False
true
When a cell is formatted as Currency, zero values are displayed as 0 with zeroes in each decimal place. (1 point) True False
true
In Excel, there are ________ ways to use the AutoSum function. (1 point) a.four b.three c.five d.two
two
A comment is added to an individual cell. True or False
True
If a numerical value is too narrow to be displayed in a cell, a series of ________ characters is displayed.
#
The YEAR function returns the year in the range ____
1900-9999
The Merge & Center button is located in the ________ tab.
Alignment group on the Home
The process of removing unwanted characters, rearranging data in a cell, or correcting erroneous data in text is called _____
Cleansing
A temporary storage location
Clipboard
A vertical set of cells that encompasses all the rows in a worksheet
Column
A text box, like to a sticky note, that is attached to a cell
Comment
The result of =LEFT("Dallas, Texas", 9) is ____
Dallas, T
The base date for serial date and time data in Excel 2019 is _______
January 1, 1900
Eliminates the need to use a mouse
Keyboard Short cut
All the categories of data that are formatted as a row in a worksheet
Record
Which of the following is NOT a type of data that can be contained in a cell?
Recordings
A horizontal set of cells that encompasses all the columns in a worksheet
Row
The ________ function runs calculations only on the data that is in the subset when a filter is applied. (1 point) a.MAX b.AVERAGE c.SUM d.SUBTOTAL
SUBTOTAL
In a worksheet, the keyboard shortcut to move one column to the left is ________.
Shift + Tab
To hide gridlines, uncheck the Gridlines box in the ________ tab. (1 point) a.Format group on the View b.Show group on the View c.Show group on the Home d.Format group on the Home
Show group on the View
A two-dimensional grid that can be used to model quantitative data
Spreadsheet
When cell B3 containing the formula =$B4-C$5 is copied to cell D6, the formula in cell D6 is =$B7-E$5.
True
When collecting data in a spreadsheet, each row contains a record. True or False
True
Blank areas of a worksheet that do not contain data or documentation are called ___________
White Space
An Excel file that contains one or more worksheets
Workbook
The cell that receives an action, such as a click, calculation, or paste is the _________ cell
active
$C$8 is an example of a(n) ________ cell reference
absolute
Which of the following is NOT true about the Accounting Number format? (1 point) a.The currency symbol is aligned to the left side of the cell. b.Zero values are displayed as 0 with zeroes in each decimal place. c.Negative numbers are enclosed in parentheses. d. The decimal place is aligned.
b.Zero values are displayed as 0 with zeroes in each decimal place.
is alternating the background color of rows and/or columns to assist in visually tracking information.
banding
The intersection of a row and column is called a ________
cell
The intersection of each row and column is called a
cell
When collecting data in a spreadsheet, each _______ is a field in a record
column
Excel stores time values as decimal portions of one ________. (1 point) a.hour b.day c.minute d.second
day
Default view in Excel
normal view
A _______ is a horizontal set of cells that encompasses all the columns in a worksheet.
row
If you want to total a specified range, list of numbers, list of cells, or any combination, you would use the ________ function. (1 point) a.COUNT b.AVERAGE c.SUM d.SUBTOTAL
sum
One of the useful features of a ________ is the ability to "band" rows and columns. (1 point) a.built-in function b.table style c.built-in cell style d.fill color
table style
________ can set the font, font size and color, number format, background color, borders, and alignment. (1 point) a.Banding b.A built-in cell style c.The fill color d.A built-in function
A built-in cell style
An example of a range of cells is ______
A1:A3
Which of the following is NOT a financial function?
APR
The currency symbol is aligned to the left side of the cell in the ________ format. (1 point) a.Accounting Number b.Currency c.Number d.General
Accounting Number
To insert a line break or hard return in a cell, you would press _______
Alt + Enter
In a worksheet, to move right one screen you would use the keyboard shortcut ________.
Alt + PgDn
Which of the following is NOT a guideline to follow when building formulas and functions?
Always put quotation marks around numeric values.
Which of the following is NOT true about formatting worksheets? (1 point) a.Use color only to assist in readability, categorization, or identification purposes. b.Format for a reason, not just for appearances. c.Special characters such as the dollar sign should be applied only as necessary. d.Background colors should be bright colors.
Background colors should be bright colors.
If you wanted to determine how many cells in a range are not empty, you would use the ________ function.
COUNTA
If you want to know the total number of employees who have worked for you at least 5 years and are not managers you would use the ________ function.
COUNTIFS
The intersection of a row and a column in a table or worksheet
Cell
To AutoFit the width of a column, you click Format and then click AutoFit Column Width in the ________ tab.
Cells group on the Home
Match the following format names with their example. (5 points) Comma ($1,234.00) Currency ($1,234.00) Number -1234.00 Accounting $ (1,234.00) General (1,234.00)
Comma (1,234.00) Currency ($1,234.00) Number -1234.00 Accounting $ (1,234.00) general ($1,234.00)
To insert a comment into a cell, you click New Comment in the ________ tab.
Comments group on the Review
____ is the interest charged on both the principal and the interest that accumulates on a loan.
Compound interest
________ formatting is a way to dynamically change the visual presentation of information in a manner that adds information to the worksheet. (1 point) a.Default b.Tabular c.Conditional d.Graphical
Conditional
The keyboard shortcut for the Comma format is ________. (1 point) a.Ctrl + Shift + ! b.Ctrl + Shift + # c.Ctrl + Shift + C d.Ctrl + Shift + @
Ctrl + Shift + !
The keyboard shortcut for the Short Date format is ________. (1 point) a.Ctrl + Shift + - b.Ctrl + Shift + # c.Ctrl + Shift + @ d.Ctrl + Shift + %
Ctrl + Shift + #
he keyboard shortcut for the Time format is ________. (1 point) a.Ctrl + Shift + # b.Ctrl + Shift + % c.Ctrl + Shift + - d.Ctrl + Shift + @
Ctrl + Shift + @
The keyboard shortcut for Undo is _______
Ctrl + Z
When there are multiple worksheets, you can use the keyboard shortcut Ctrl + ________ to move one worksheet to right.
Ctrl +pg down
If you want to find the time between two dates, you would use the ________ function.
DATEDIF
Which of the following is NOT an example of worksheet documentation?
Descriptive drop-down documentation menus
Instead of typing the $ symbol in a cell reference, you can press the ________ key.
F4
If the value in B4 = 40, what is the result of =IF( B4>65, "Passing", "Failing")?
Failing
A cell reference is a combination of a row number followed by a column letter such as 12C. True or False
False
A comment is a temporary storage location where information that was cut or copied is stored until you paste, move, or clear the information. True or False
False
A contiguous cell range consists of multiple cells where at least one cell is not directly adjacent to other cells. True or False
False
A formula is a built-in program that would be used to find the average of a series of numbers. True or False
False
A function is an equation that produces a result and may contain numbers, operators, text, and/or functions. True or False
False
A noncontiguous cell range consists of multiple cells where all cells are directly adjacent to each other. True or False
False
A worksheet is a file containing at least one workbook. True or False
False
Absolute cell referencing uses the # symbol.
False
By default, text data is center-aligned in a cell. True or False
False
Excel's MAXIMUM function returns the largest number from a set of numbers.
False
Excel's RANDBETWEEN function returns a random number from 0 to less than 1.
False
Excel's TEXT function can be used to change the appearance of data
False
Excel's TIME function returns the number of minutes in the range 1 to 60
False
Merge & Center can only be applied to horizontal cell ranges. True or False
False
Semantics is the structure and order of the function and the arguments used by Excel to perform a calculation.
False
The AutoFill property adjusts the height of a row so that its cell contents fit in the row. True or False
False
The name of a range can begin with the / symbol.
False
When cell D3 containing the formula =C4*B4 is copied to cell F2, the formula in cell F2 is =C4*B4.
False
When using a touch screen, the Excel 2019 commands on the ribbon and in shortcut menus are in a different order to accommodate the use of a fingertip. True or False
False
Which of the following is NOT true about using fill colors? (1 point) a.Fill color can be used to categorize information. b.Fill color can be used to highlight values. c.Fill color refers to the border color and style of a cell. d.Fill color can be used to band rows or columns as a means of assisting the reader to follow information across or down a worksheet.
Fill color refers to the border color and style of a cell.
copies information from one cell or a series in contiguous cells into contiguous cells.
Fill handle?
To modify the border of a cell or cells, click the Borders button in the ________ group of the Home tab. (1 point) a.Styles b.Font c.Paragraph d.Editing
Font
The ________ function returns the number of workdays between to dates.
NETWORKDAYS
A(n) _____________ cell range consists of multiple selected cells with at least one cell not directly adjacent to other cells.
Noncontiguous
A range consisting of multiple selected cells, at least one of which is not directly adjacent to other cells
Noncontiguous cell range
Data that contains only the digits 0-9 and possibly a period (.)
Numeric data
__________ data consists of numbers in any form NOT combined with letters and special characters.
Numerical
Layout of how the workbook will print on paper
Orientation
_______ is a file type that preserves most formatting attributes of a source document regardless of the software in which the document was created.
The order of operations that is used in Excel spells ________. (1 point) a.DEMAPS b.SPAMED c.PEMDAS d.EPDMSA
PEMDAS
Does not show page margins, headers, or footers
Page Break Preview
Shows page margins, print headers and footers, and page breaks
Page Layout View
The file extension PDF stands for ______
Portable Document Format
When using _________ orientation, the vertical dimension of the paper is longer.
Portrait
The default print range in Excel is ______
Print Active Sheets
The Backstage View of a workbook
Print Preview
When using a text string in an argument, enclose the string in ________ so Excel will recognize it as a text string rather than a named range.
Quotes " "
Given a student's numerical average and a table that lists the grades and percent needed to obtain the grades in column format, which Excel function would be used to determine the student's letter grade?
VLOOKUP
Allows you to examine the outcome of the changes to values in a worksheet
What-if analysis
______ allows you to examine the outcome of the changes to values in a worksheet.
What-if analysis
Each instance of a spreadsheet
Worksheet
The Comma Style is the ________ format without a monetary symbol. (1 point) a.Number b.Currency c.General d.Accounting Number
accounting number
Which of the following is typically NOT contained in a separate documentation worksheet?
charts
You can copy a worksheet within a workbook, by ________, and then dragging a copy of the worksheet to its new location.
clicking on the worksheet tab, pressing and holding ctrl
A red triangle in the upper-right corner of a cell indicates the existence of a ________
comment
A(n) ____________ cell range consists of cells directly adjacent to one another.
contiguous
If you want to see how many cells in a specified range contain numbers, you would use the ________ function. (1 point) a.COUNT b.SUM c.SUBTOTAL d.AVERAGE
count
In a worksheet, the keyboard shortcut to move to cell A1 is _____
ctrl+home
Time data is represented as a(n) ________ value.
decimal
A ________ cell is the cell that receive the result of an operation such as Paste or an AutoSum function. (1 point) a.source b.destination c.adjacent d.active
destination
An important part of building a good worksheet is using ________. (1 point) a.conditional formatting b.styles c.calculations d.documentation
documentation
An absolute cell reference is denoted by a(n) ___
dollar sign ($)
You can rename a worksheet by ________ its tab and then typing the new name.
double-clicking
62) The COUNT function returns the total number of cells in a cell range that are blank. (1 point) True False
false
Approximately 6% to 10% of men of Asian descent are color-blind. (1 point) True False
false
Cell banding allows cell content to be arranged horizontally as well as vertically. (1 point) True False
false
Formatting will change the value stored in a cell, as well as add information value. (1 point) True False
false
On a worksheet, rows and columns can be hidden as long as they do not have functions in any of the cells. (1 point) True False
false
Only one style can be applied to a cell. (1 point) True False
false
Standard cell formatting is always in place unless another format is specified. (1 point) True False
false
The Accounting Number Format is formatted so the currency symbol is placed directly left of the value. (1 point) True False
false
The Comma style is formatted as the Currency style without a monetary symbol. (1 point) True False
false
The default theme for a workbook is the Excel theme. (1 point) True False
false
When text and numbers are organized in labeled columns and numbered rows, they are in graphical format. (1 point) True False
false
color is the background color of a cell.
fill
An example of a ________ is (C5+D5)/100
formula
A ________ is a built-in program that performs operations on data. (1 point) a.function b.parameter c.formula d.subroutine
function
An example of a ________ is SUM(A1:A10)
function
To have a better sense of how the worksheet is structured, you can ________. (1 point) a.unhide gridlines b.hide rows c.hide columns d.show the formulas
show the formulas
There are ________ types of cell alignment in Excel. (1 point) a.six b.four c.nine d.seven
six
A ________ cell is the cell that contains the data supplied to a function. (1 point) a.active b.adjacent c.source d.destination
source
A ________ application is a computer program with a user interface comprised of a grid of rows and columns.
spreadsheet
The format that organizes information in labeled columns and numbered rows is ________ format a.graphical b.container c.tabular d.matrix
tabular
By default, _________ data is left-aligned in a cell.
text
If you enter a date or time that is not recognized, Excel treats the information as ________ and left-aligns it in the cell.
text
Which of the following data types is NOT automatically right-aligned by Excel?
text
Headers and footers contain ________ section(s).
three
You should use at most ________ fonts in a worksheet. (1 point) a.four b.three c.five d.two
three
Represented as a decimal value
time data
In _______ , the ribbon and shortcut menus are enlarged to make selecting commands with your fingertip easier.
touch mode
A constant is a value that never changes, such as months in a year. (1 point) True False
true
A destination cell is the location cell to be modified by a move or paste operation. (1 point) True False
true
Conditional formatting can be used to highlight information by changing formats such as cell fill color, font color, and font style. (1 point) True False
true
Each table column in Excel must have a unique name. (1 point) True False
true
Excel is specifically designed to present information in tabular and graphical formats. (1 point) True False
true
Excel presents information graphically via charts and graphs based on the tabular information in worksheets. (1 point) True False
true
Excel stores time values as decimal portions of one day. (1 point) True False
true
Fill color can be used to categorize information. (1 point) True False
true
In Excel, formulas and functions always begin with equal sign. (1 point) True False
true
In a function, arguments are included inside the parentheses following the function name. (1 point) True False
true
One of the most efficient ways of moving data from oe cell to another is to drag and drop. True or False
true
Tables allow for calculations in a total row such as summations, averages, or counts. (1 point) True False
true
The Accounting Number format structures a cell with a comma at the thousand and two decimal places. (1 point) True False
true
To make rapid and accurate changes to the appearance of a workbook with very little effort, you can use built-in cell styles. (1 point) True False
true
To paint a format to more than one nonadjacent cell, you can double-click Format Painter and then select nonadjacent cells. (1 point) True False
true
Worksheets can be oriented to print on paper in one of ________ ways
two
Which of the following is an alternative to using a space when naming a range?
use an underscore
A file that contains one or more worksheets is a _____
workbook
A ________ is a grid of columns and rows in which data is entered
worksheet
When using Excel, a spreadsheet is also referred to as a ________
worksheet
Formulas always begin with ________. (1 point) a.= b.$ c.~ d.%
=
Formulas and functions begin with a(n) ________ sign
=
When cell A4 containing the formula =$B$5/$C$6 is copied to cell F6, the formula in cell F6 is ___
=$B$5/$C$6
When cell B2 containing the formula =A4*B6 is copied to cell C1, the formula in cell C1 is __
=B3*C5
Which of the following functions returns the number in the middle of a set of numbers?
Median
Data formatted as a date takes the form of a serial number, with the number 1 representing January 1, 1900. True or False
True
Functions can be created by using the Function Arguments dialog box or by typing the function in the cell.
True
Gray worksheet tabs identify inactive worksheets. True or False
True
If you incorrectly name a range, you can rename it by selecting the data and naming the range again.
True
If you type =C, a list of functions and named ranges beginning with the letter "C" appears.
True
In Excel, date and time data are special forms of numeric data. True or False
True
In Microsoft Excel 2019, workbooks have a file extension of .xlsx. True or False
True
Page Break Preview allows you to manually adjust the location of page breaks. True or False
True
The TRIM function returns text from which any leading, trailing, or extra spaces between words have been removed.
True
When constructing a formula, Excel's default reference type is relative cell referencing.
True
When using a what-if analysis, you change values in spreadsheet cells to see the effects on calculated values of interest. True or False
True
White space refers to blank areas of a worksheet that do not contain data or documentation, regardless of the actual color. True or False
True
10) Approximately ________ of men of European descent are color-blind. (1 point) a.3% - 6% b.10% - 15% c.10% - 12% d.8% - 12%
8% - 12%
Which of the following is NOT a common error message in Excel?
#NPV?
The file extension for Microsoft Excel 2019 workbooks is ________
.xls
Normal margins for Excel are ________ inch on the left and right sides of the page.
0.7
The result of =CONCAT("12", "34") is ____
1234
All of the following are valid cell ranges EXCEPT: (1 point) a.C1:C25 b.12E c.A1:B3 d.C2
12E
Excel has more than ________ functions organized into several categories. (1 point) a.700 b.1,000 c.400 d.600
400
Constant How Excel processes calculations in a formula that contains more than one operator Formula How Excel processes calculations in a formula that contains more than one operator Mathematical operator How Excel processes calculations in a formula that contains more than one operator Order of operations Applies formatting to cells or specific controls as determined by the rule outcome Conditional formatting How Excel processes calculations in a formula that contains more than one operator
Constant :The cells in the worksheet that have been selected formula:Can contain cell references, constants, functions, and mathematical operators Mathematical operator:Parentheses, exponentiation, division, multiplication, addition, or subtraction Order of operations:How Excel processes calculations in a formula that contains more than one operator Conditional formatting:Applies formatting to cells or specific controls as determined by the rule outcome
A range consisting of multiple selected cells, all of which are directly adjacent to at least one other
Contiguous Cell range
There are more than functions built into Excel.
Correct Answer: 400
The function is used to find the mean value for a range of cells.(1 point)
Correct Answer: AVERAGE
The function returns the number of cells in a cell range that contain numbers
Correct Answer: COUNT
formatting allows the specification of rules that apply formatting to cells or specific controls, as determined by the rule outcome.
Correct Answer: Conditional
To find the greatest numerical value in a range of cells, you would use the function. (1 point)
Correct Answer: MAX
86)To find the smallest numerical value in a range of cells, you would use the function.
Correct Answer: MIN
When you filter table data, the values will automatically be recalculated.
Correct Answer: SUBTOTAL
83)The function is a commonly used function or totaling cell value.
Correct Answer: SUM
To hide gridlines, check the Gridlines box in the Show group on the tab.
Correct Answer: View
Cell allows cell content to be arranged horizontally as well as vertically.
Correct Answer: alignment
The values inside a function's parentheses are called
Correct Answer: arguments
A built-in is a predefined and named combination of cell-formatting and content-formatting that can be applied to a cell or range of cells. (1 point)
Correct Answer: cell style
A number that never changes is a(n)
Correct Answer: constant
Cell formats that are automatically in place unless you specify otherwise are called settings.
Correct Answer: default
The cell that receives the result of an operation such as Paste or the AutoSum function is the cell.
Correct Answer: destination cell
A(n) performs a mathematical calculation using information in the active worksheet and other worksheets to calculate new values. (1 point)
Correct Answer: formula
In Excel, a(n) is a built-in program.
Correct Answer: function
+, *, and ^ are examples of Excel(1 point)
Correct Answer: mathematical operators
If multiple mathematical operands are included in a function or formula, Excel processes the calculations based on the
Correct Answer: order of operations
C12 is an example of a cell
Correct Answer: reference
A useful feature of a(n) style is the ability to "band" rows and columns.
Correct Answer: table
The presentation of text and numbers in tables is called format.
Correct Answer: tabular
A(n) is a collection of fonts, styles, colors, and effects applied to a worksheet.
Correct Answer: theme
The ________ command produces multiple named ranges at one time from the headings in rows, columns, or both from the data set.
Create from Selection
You can select a noncontiguous range of cells by pressing and holding the ________ key when using it in combination with other navigation keys and/or the mouse.
Ctrl
After selecting a row, pressing the shortcut key ________ will insert a new row above the selected row.
Ctrl + +
Match the following terms with their definition. (5 points) Format Painter A predefined set of formatting properties that determine the appearance of a table Built-in cell style Predefined and named combination of cell and content formatting properties Banding Predefined and named combination of cell and content formatting properties Table A predefined set of formatting properties that determine the appearance of a table Table style Predefined and named combination of cell and content formatting properties
Format Painter A tool that allows you to copy a format and apply it to other selections Built-in cell style: Predefined and named combination of cell and content formatting properties banding: Alternating the background color of rows and/or columns to assist in tracking information table:An organized grid of information, arranged in rows and columns table style: A predefined set of formatting properties that determine the appearance of a table
A _______ is an equation that produces results such as numbers or text.
Formula
A(n) _______ is a built-in program that performs a task such as finding the sum of a series of numbers.
Function
Match the following terms with their definition. (5 points) Graphical format Position on the horizontal and vertical axes Tabular format The presentation of information such as text and numbers in tables Cell alignment A setting that is automatically in place unless you specify otherwise Default A setting that is automatically in place unless you specify otherwise Fill color The background hue of a cell
Graphical format:he presentation of information in charts, graphs, and pictures Tabular format: The presentation of information such as text and numbers in tables Cell alignment:Position on the horizontal and vertical axes Default A setting that is automatically in place unless you specify otherwise Fill color The background hue of a cell
________ worksheet tabs identify inactive worksheets.
Gray
Which of the following is NOT a unit value option for the DATEDIF function?
H
When using __________ Orientation, the horizontal dimension of the paper is longer.
Landscape
If you wanted to find which value occurs most often in a cell range, you would use the ________ function.
MODE.SNGL
Match the following functions with their description. (5 points) Sum Examines all numeric values in a specified range and returns the lowest value Average Returns the number of cells in a range of cells that contain numeric data Count Examines all numeric values in a specified range and returns the highest value Min Returns the number of cells in a range of cells that contain numeric data Max Returns a mean from a specified range of cells
Sum :Adds of all numeric information in a specified range, list of numbers, list of cells, or any combination average:Returns a mean from a specified range of cells count: Returns the number of cells in a range of cells that contain numeric data min:Examines all numeric values in a specified range and returns the lowest value max cells:Examines all numeric values in a specified range and returns the highest value
Can contain any combination of printable characters
Text data
There are how many different types of cell references
Three
Which of the following is NOT true about working with formulas? (1 point) a.When a formula that contains cell references is copied to another cell, the cell reference will change to reflect the destination cell relative to the original cell. b.In Excel, formulas always begin with an equal sign. c.Cells that contain formulas can be treated like any other worksheet cell. d.To copy a formula and not change relative references, select the formula in the formula bar, click Shift + Esc, select the destination cell, and then click Insert.
To copy a formula and not change relative references, select the formula in the formula bar, click Shift + Esc, select the destination cell, and then click Insert.
A destination cell is the location cell to be modified by a move or paste operation. True or False
True
A name of a range CANNOT contain any spaces
True
A named range is a group of cells that have been given a name, which you can use when writing a formula or function.
True
Adobe System's PDF reader application CANNOT be used to edit a document that was saved with the pdf extension. True or False
True
By default, numeric data is right-aligned in a cell. True or False
True
Match the following terms with their definition. (5 points) Function Variables or values a function requires in order to calculate a solution Argument Variables or values a function requires in order to calculate a solution Built-in function Variables or values a function requires in order to calculate a solution Cell reference Variables or values a function requires in order to calculate a solution Destination cell A preprogrammed formula
function:A preprogrammed formula argument:Variables or values a function requires in order to calculate a solution bulit in function: A function included in Excel that can be categorized as financial, statistical, mathematical, date and time, text, or so on cell reference:Placing a particular cell or cell range within a formula or function instead of a value destination cell:The cell that receives the result of an operations such as Paste or an AutoSum function
A(n) format is used to present information in charts, graphs, and pictures.
graphical
Excel uses the ________ presentation of information via charts and graphs. a.graphical b.sectioned c.tabular d.container
graphical
The result of =MID("Tallahassee",6,3) is ____
has
To hide a row or column in Excel, click the row or column heading, point to the selected row or column heading(s), right-click, and then select ________ on the displayed shortcut menu. (1 point) a.Hide b.Filter c.Plain Formatting d.Adjust
hide
If you click ________, the insertion point is displayed in the formula bar
in the formula bar
The base date for date and time data in Excel 2016 is ________. (1 point) a.January 1, 1000 b.January 1, 1900 c.December 31, 1899 d. December 31, 999
janurary 1, 1900
If you want to see which employee had the highest sale, you could use the ________ function. (1 point) a.SUM b.COUNT c.MIN d.MAX
max
A ___________ range is an extension of a cell reference and provides a way to identify commonly used cell references or ranges.
named
Names for ranges CANNOT begin with a(n) ___
number
All arguments in a function are enclosed in a pair of __
parentheses ()
In Excel, the height of the rows is measured in ________
points
To select noncontiguous rows, click the header of the first row, ________ the header of each additional row.
press and hold Ctrl, and click
To select several contiguous columns, click the header of the first column, ________ the header of the last column.
press and hold Shift, and click
The cells on a worksheet that have been selected are a cell ______
range
In a worksheet, a comment is indicated by the presence of a ________ in the upper-right corner of a cell.
red triangle
When someone is said to be color-blind, they have trouble distinguishing between ________. (1 point) a.blues and oranges b.reds and oranges c.reds and greens d.blues and greens
reds and greens
An example of a cell _________is K12
reference
