CIS Exam

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

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.

PDF

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


संबंधित स्टडी सेट्स

BPK 310 Study Question Post Midterm

View Set