Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

work > bitm > Flashcards

bitm Flashcards

(57 cards)

Start Studying
1
Q

What a Spreadsheet is

A

an electronic file that contains grids made up of columns and rows

  • to organize related data and to display results of calculations, enabling interpretation of quantitative data for decision making
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Cell

A

the intersections of columns and rows

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Cell reference and cell address

A

ref.: used in formulas to refer to a specific cell

add.: location of cells

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Active cell

A

the current cell in a worksheet, found in the name box

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Name box

A

displays the address(or name) of the active cell, selected chart, or selected table

used to go to cells and ranges or assign a name

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Range

A

a group of adjacent or contiguous cells in a worksheet (close to each other)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

formula

A

combines cell references, arithmetic operations, values, and/or functions used in calculation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is a worksheet and a workbook

A

worksheet: spreadsheet that usually contains descriptive labels, numeric values, formulas, functions, and charts.

workbook: a collection of one or more related worksheets contained within a single file.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

How is the sum function written

A

=SUM()

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is a fill handle

A

small green square in the bottom right corner of the active cell

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is the cause of ##### in a cell

A

the data in the cell is too large to fit in the cell, the column width needs to be increased

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

How many worksheets are available by default when you create a workbook

A

1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What does a double horizontal or vertical line indicate

A

hidden rows or columns

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is a way to change a cell without affecting the content?

A

cell style

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is merge and center and wrap text for

A

merge and center: to combine selected cells together only cells from the far left cell are remained

wrap text: word-wrapping data on multiple lines within a cell

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

How do negative numbers appear when using accounting or currency formatting

A

acc: number within the parenthesis, NO negative sign

cur: negative sign in front of the dollar sign

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What can be present while using special format style

A

hypen or parenthases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Why might hiding cells be useful

A

data you wont want to display

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What is a backstage view in terms of printing

A

displays print options and the worksheet in print preview mode.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Why might a header or footer be useful

A

additional information about the worksheet. You can include your name, the date the worksheet was prepared, and page numbers, for example.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

What does a range finder do

A

Highlights and color codes each cell as you type its address

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Excel follows PEMDAS but why

A

to control the sequence in which arithmetic operations are performed, which affects the result of the calculation.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

What is a relative reference and an example of one

Study These Flashcards
A

change when a formula is copied. A1

24
Q

What is an absolute reference and an example of one

Study These Flashcards
A

the opposite, remain constant, no matter where they are copied
$A$1

25
What is a mixed cell reference and an example of one
a combo, either the column letter or the row number that has the absolute reference remains fixed while the other part of the cell reference that is relative changes when the formula is copied. A$1 or $A1
26
What is a 3D reference, an example of one, and what types of references can it use
includes the name of the worksheet and can be absolute, mixed, or relative. Ex: =Sheet2!$B$2
27
What are the 6 different category of functions
sum average median min mina (NA=0) max maxa (NA=) count a(cells with some data) count blank (blank cells)
28
What is a round function an example
used when you want to change the stored value to a specified number of decimal places
29
What function can you use to get today's exact date and time
=NOW()
30
What is the difference between VLOOKUP and HLOOKUP formulas
VLOOKUP function looks for the value in the left column of a specified table array, and then returns a related value located in the same row HLOOKUP function.This data must be arranged in ascending order from left to right.
31
XLOOKUP and its match modes
like vlookup XLOOKUP can also return approximate matches if no exact match is found, it can look up data on either the left or right of table array. all of the following look for exact matches, if not found 0: #NA -1:next smaller value 1: next larger value 2:wild card
32
=PMT(rate, nper, pv, [fv], [type]) what is this type of function for
calculates payments for a loan with a fixed amount at a fixed periodic rate for a fixed time period.
33
the IF conditional function
=IF(Logical Test, Value if True, Value if False)
34
What is the difference between column, bar, and line charts
column: displays vertical bars where the height represents the value, used to compare values across categories bar: same as column but displays category names in an easy-to-read format line charts: shows data to depict trends over time
35
What is a combo chart 100% stacked column chart
combination of 2 charts such as, column and line charts 100%: converts individual data points (values) into percentages of the total value.
36
What is the difference between category axis & value axis
Category axis: displays descriptive labels for the data points Value axis: displays incremental numbers to identify the approximate value of data points
37
What is a legend
it identifies the color or pattern assigned to each data series and displays when a multiple series chart is created
38
What happens when a combo chart contains two types of data
it turns into a dual-axis chart
39
What is a scatterplot chart
shows the relationship between two numeric variables using their X and Y coordinates.
40
Sunburst chart(2 in 1)
hierarchy chart illustrating category and subcategory relationship has one data series no axes
41
What is alt text used for
a description displayed when the pointer is moved over a chart or image good for people with disabilities
42
What is a sparkline
A small line, column, or win/loss chart contained in a single cell
43
What happens when you freeze column/row label
They stay visible no matter where you are on the worksheet
44
what is helpful when printing large datasets 3:
if every page contains descriptive ($) column and row labels using print title option
45
What is a table
structured range that contains related data organized to increase capability to read and analyze information - column headings remain onscreen
46
What are structured, unqualified, and fully qualified structured references and some examples
Structured: uses table names and column headers to refer to data, they automatically adjust when the table structure changes ex: =SUM(sales data[Quantity]*sales data[Price]) Unqualified:used within the same table and refer to columns directly ex: =[Quantity]*[Price] Fully qualified structured reference: Includes both and ensures clarity and specificity ex: =SUM(Sheet1!sales data[Quantity]*Sheet1!sales data[Price]
47
What does a total row display and what function does it use
Summary stats SUBTOTAL(function_num, ref1, …)
48
What does it mean to sort data provide examples
It means putting data into a certain sequence Text, A-Z or Z-A Dates, Oldest-Newest or Newest-Oldest Values, Smallest-Largest Color, by cell color or font color
49
What does it mean to filter data
the process of displaying only records that meet specific conditions
50
What is conditional formatting and examples
The process of cells changing formats after meeting specific conditions Highlight cells rules, <,>, =, or duplicate, if met font, border, or fill color is changed top/bottom rules, above average or below it Data bars, width of bar determines value Color scales, uses relative values and shades cells differently based on values Icon sets. symbols that classify data in 3-5 categories based values
51
what happens when. you explode a slice of a pie chart
it literally stands out
52
what is quick layout used for
to apply predefined layouts to a chart
53
what is quick analysis
a set of analytical tools you can use to apply formatting, create charts or tables, and insert basic functions.
54
1900 date system
considers each new day as a plus 1 to the value
55
shortcut to create absolute references
f4
56
what is a data series
a collection of data points (An individual value in a cell that is plotted in a chart)
57
why is the recommended charts option or Quick analysis helpful
use if you are unsure which type of chart would effectively represent the data

work (28 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions