Testmoz
Home
Features
Pricing
FAQs
Build a Test
Login/Sign Up

CBA Unit 3 vocabulary Spreadsheets

Is this your test? Login to manage it. If not, you can build an assessment just like it.

This is a non-interactive preview of the quiz content.

1.
1 point
The workspace made up of columns and rows where data is entered to create an electronic spreadsheet.
2.
1 point
_____ returns the number of cells in a range that contains numbers.
3.
1 point
To sort ________ is to arrange text or numbers from A to Z, from smallest to largest, or from earliest to latest.
4.
1 point
A grid of rows and columns containing numbers, text, and formulas used to preform calculation is a ______.
5.
1 point
A graphic representation of values and their relations: pie, line, column, bar, scatter are _______.
6.
1 point
Arranging the shape, size type, and general makeup of a cell or group of cells to to ______.
7.
1 point
Keeps selected rows or columns visible on the screen as the rest of the worksheet scrolls.
8.
1 point
A collection of related worksheets (sheet 1, sheet 2, etc) together is in a ______.
9.
1 point
Selected group of cells in a worksheet identified by the cell in the upper left corner and the cell in the lower right corner, separated by a colon (B4:B15) is an example of ______
10.
1 point
_____ returns the largest value in a set of values.
11.
1 point
A prewritten formula that makes it easy to perform conmnom calculations is a _____.
12.
1 point
____ is a horizontal group of cells in a worksheet identified by numbers.
13.
1 point
A chart that uses bars of varying height to illustrate values in a worksheet is a _____ chart.
14.
1 point
To copy a cell's contents and/or formatting into an adjacent cell or range is to _____.
15.
1 point
Value, cell reference, range, or text that acts as an operand in a function formular is a(n) ________.
16.
1 point
The space formed by the intersection of a row and column is a _____. This is the basic unit of a worksheet.
17.
1 point
A chart that shows the relationship of a part to a whole is a _____ chart.
18.
1 point
A cell reference that contains both relative and absolute references is a ________ __________ ________.
19.
1 point
A unique identifier for a cell which is formed by combining the cell's column letter and row number is a _______.
20.
1 point
A cell reference that adjusts to a new location when copied or moved is a _______ cell reference.
21.
1 point
To sort arranging text or numbers from Z to A, largest to smallest or latest to earliest is to sort _____.
22.
1 point
The position of data within a cell is
23.
1 point
A function that automatically adds the values in the cells directly above or to the left of the active cell is _____.
24.
1 point
Numeric characters that can be used in a calucation is ______.
25.
1 point
To arrange a list of words or numbers in ascending or descending order is to _____.
26.
1 point
_____ returns the smallest value in a set of values.
27.
1 point
Alphanumeric text that will not be used in calculations is called a _____.
28.
1 point
A chart that uses points connected by a line to illustrate values in a worksheet is a _____ chart.
29.
1 point
The process of changing values in cells to see how those changes affect the outcome of formulas in the worksheet is _____.
30.
1 point
The mathematical rules used for calculating the value of a formula is _____.
31.
1 point
Cell reference that does not adjust to the new cell location when copied or moved is a(n) _______.
32.
1 point
_____ returns the average (arithmetic means) of its arguments.
33.
1 point
The symbol that indicates what mathematical operation to perform on the operands: plus (+), minus (-), multiply (*), divide (?) is known as a _______.
34.
1 point
This adds all the numbers in a range of cells.
35.
1 point
A selected worksheet cell that is ready for data entry. This is outlined in black.
36.
1 point
A number or cell reference used in a formula is a ____.
37.
1 point
A _____ is an equation that calculates a new value using values currently on a worksheet.
38.
1 point
A vertical group of cells in a worksheet identifited by letters is a _______.
Home Features Pricing FAQs Legal Sample Tests Build a Test Login/Sign Up