Chapter 6 Flashcards
1
Q
Father of the electronic spreadsheet
A
Daniel Bricklin
2
Q
They co-invented or co-created in 1978 the VisiCalc
A
Daniel Bricklin and Bob Frankston
3
Q
The first killer application for personal computers
A
VisiCalc
4
Q
A large sheet of paper with columns and rows that lays everything out about transactions for a business person to examine.
A
Spreadsheet
5
Q
It spreads or shows all of the costs, income, taxes, etc. on a single sheet of paper for a manager to look at when making a decision.
A
Spreadsheet
6
Q
It is a rectangular group of cells
A
Block/range
7
Q
He pioneered the development of computerized spreadsheets for use in business accounting
A
Professor Richard Mattessich
8
Q
Some historical information on the computerization of accounting spread sheets using mainframe computers is discussed on what Mattessich’s page?
A
Spreadsheet: Its First Computerization (19611964)
9
Q
When did Bricklin program the first working prototype of his concept in integer basic
A
Fall of 1978
10
Q
It became an almost instant success and provided many business people with an incentive to purchase a personal computer or an H-P 85 or 87 calculator from Hewlett-Packard.
A
VisiCalc
11
Q
How many copies of the spreadsheet program were sold during VisiCalc’s product lifetime?
A
1 million
12
Q
Excel was originally written for the…
A
512k Apple Macintosh
13
Q
The Excel spreadsheet with a graphical user interface was easier for most people to use than the command line interface of
A
PC-DOS spreadsheet products
14
Q
Microsoft documents show the launch of Excel 2.0 for
A
MS-DOS version 3.0
15
Q
When did Microsoft launch the Windows operating system
A
1987
16
Q
It had acquired Software Arts and the rights to VisiCalc
A
Lotus
17
Q
It is a spreadsheet program that allows you to store, organize, and analyze information.
A
Excel 2013
18
Q
When you open Excel 2013 for the first time, what will appear?
A
Excel Start Screen
19
Q
Lets you access to common commands no matter which tab is selected. By default, it includes Save, Undo and Redo commands. You can add other commands depending on your preference.
A
Quick Access Toolbar
20
Q
Contains all the commands you will need to perform common task in Excel. It has multiple tabs, each with several groups of commands
A
The Ribbon
21
Q
From here, you can access your Microsoft account information, view your profile, and switch accounts.
A
Microsoft Account
22
Q
Each group contains a series of different commands. Simply click any command to apply it. Some groups also have an arrow in the bottom right corner, which you can click to see even more commands.
A
Command Group
23
Q
Displays the location or name of a selected cell.
A
Name Box
24
Q
You can enter or edit data, or a formula, or a function that will appear in a specific cell.
A
Formula Bar
25
Each rectangle in a workbook
Cell
26
It is the intersection of row and column.
Cell
27
It is a group of cells that runs from the left of the page to the right. In Excel, it is identified by a number.
Row
28
Excel files are called ____
Workbooks
29
It is selected by default and shows you an unlimited number of cells and columns.
Normal view
30
It divides your spreadsheet into pages.
Page Layout View
31
It lets you see an overview of your worksheet, which is especially helpful when adding page breaks.
Page Break View
32
Click and drag the slider to use the zoom control. The number to the right of the slider reflects the zoom percentage.
Zoom Control
33
Your spreadsheet may frequently have more data than you see on the screen at once. Click, hold and drag the vertical or horizontal scroll bar depending on what part of the page you want to see.
Vertical and Horizontal Scroll Bars
34
It is a group of cells that runs from the top of the page to the bottom. In Excel, it is identified by a letter.
Column
35
T or F: Excel 2013 uses a tabbed Ribbon system instead of traditional menus.
T
36
The ____ tab gives you access to some of the most commonly used commands for working with data in Excel 2013, including copying and pasting, formatting, and number styles.
Home
37
The ____ tab is selected by default whenever you open Excel.
Home
38
The ____ tab allows you to insert charts, tables, sparklines, filters, and more, which can help you visualize and communicate your workbook data graphically.
Insert
39
The ____ tab allows you to change the print formatting of your workbook, including margin width, page orientation, and themes.
Page Layout
40
These commands will be especially helpful when preparing to print a workbook.
Page Layout tab
41
The ____ tab gives you access to the most commonly used functions and formulas in Excel. .
Formulas
42
These commands will help you calculate and analyze numerical data, such as averages and percentages
Formulas tab
43
The ____ tab makes it easy to sort and filter information in your workbook, which can be especially helpful if your project contains a large amount of data.
Data
44
You can use the ____ tab to access Excel's powerful editing features, including comments and track changes.
Review
45
These features make it easy to share and collaborate on workbooks.
Review tab
46
The ____ tab allows you to switch between different views for your workbook and freeze panes for easy viewing.
View
47
These commands will also be helpful when preparing to print a workbook.
View tab
48
____ tabs will appear on the Ribbon when working with certain items, like tables and pictures.
Contextual
49
These tabs contain special command groups that can help you format these items as needed.
Contextual tabs
50
It gives you various options for saving, opening a file, printing, and sharing your workbooks.
Backstage View
51
You can use the arrow to close Backstage view and return to Excel.
Return to Excel
52
The ____ pane will appear whenever you access Backstage view. It contains information about the current workbook. You can also inspect the workbook and set protection.
Info
53
From here you can create new, blank workbook or choose from a larger selection or template.
New
54
From here, you can open recent workbook, as well as workbooks saved to your OneDrive or on your computer.
Open
55
Use _____ to save your workbook to your computer or to your OneDrive
Save and save as
56
From ____ pane, you can change the print settings and print your workbook. You can also see a preview of your workbook.
Print
57
From here, you can invite People to view and collaborate on your workbook. You can also share your workbook by emailing it as an attachment.
Share
58
You can choose to export your workbook into another format, such as PDF/XPS or Excel 1997 – 2003
Export
59
Click here to close the current workbook.
Close
60
From the ____ pane, you can access your Microsoft Account information, modify your theme and background and sign out of your account.
Account
61
Here you can change Excel options. For example, you can control the Quick Analysis preferences, Autorecover settings or Language preferences
Options
62
This view can help you visualize how your worksheet will appear when printed.
Page Layout View
63
You can also add headers and footers from this view.
Page Layout View
64
This view makes it easy to change the location of page breaks in your workbook, which is especially helpful when printing a lot of data from Excel.
Page Break View
65
These are the basic building blocks of a worksheet.
Cells
66
A group of cells is known as a
Cell range
67
Cells can contain ____ such as letters, numbers, and dates.
Text
68
Cells can contain ____ that change the way letters, numbers, and dates are displayed. For example, percentages can appear as 0.15 or 15%. You can even change a cell's background color.
Formatting attributes
69
Cells can contain ____ that calculate cell values
Formulas and functions
70
It appears as a small square in the bottom-right corner of the selected cell(s).
Fill handle
71
A new feature in Excel 2013, ___ can enter data automatically into your worksheet, saving you time and effort.
Flash Fill
72
Merges the selected cells into one cell and centers the text.
Merge & Center
73
Merges the selected cells into larger cells while keeping each row separate.
Merge Across
74
Merges the selected cells into one cell but does not center the text.
Merge Cells
75
Unmerges selected cells
Unmerge Cells
76
Mathematical operator for addition
Plus sign
77
Mathematical operator for subtraction
Minus sign
78
Mathematical operator for multiplication
Asterisk
79
Mathematical operator for division
Forward slash
80
Mathematical operator for exponent
Caret
81
Excel formulas must begin with
Equals sign
82
Most of the time you will use cell addresses to create a formula. This is known as making a ____
Cell reference
83
Finds the sum of the numbers in the specified cells
SUM
84
Finds the average of the numbers in the specified cells
AVERAGE
85
Finds the number of entries in the specified cells
COUNT
86
Finds the largest value in the specified cells
MAX
87
Finds the smallest value in the specified cells
MIN
88
Finds the average of values within a cell range that meet a given criterion
AVERAGEIF
89
Finds the average of values within a cell range that meet multiple criteria
AVERAGEIFS
90
Counts the number of cells in a range that contain a numerical value
COUNT
91
Counts the number of cells in a range that are not empty
COUNTA
92
Counts the number of cells in a range that are empty
COUNTBLANK
93
Counts the number of cells in a range that meet a given criterion
COUNTIF
94
Counts the number of cells in a range that meet multiple criteria
COUNTIFS
95
Displays one value if a formula results in an error and another if it doesn’t
IFERROR
96
Finds the sum of values in a range that meet a single criterion
SUMIF
97
Finds the sum of values in a range that meet multiple criteria
SUMIFS
98
The column isn’t wide enough to display the value.
#####
99
The formula has the wrong type of argument (such as text in a cell where a numerical value is required).
#VALUE!
100
The formula contains text that Excel doesn’t recognize (such as an unknown named range).
#NAME?
101
The formula refers to a cell that doesn’t exist (which can happen whenever cells are deleted).
#REF!
102
The formula attempts to divide by zero.
#DIV/0!
103
Creates new blank workbook based on the default template.
New
104
Opens or finds the files
Open
105
Saves the active file with its current file name, location and file format.
Save
106
Copies the selected items to the clipboard
Copy
107
Removes the selection and places it on the clipboard
Cut
108
Places the content of the clipboard at the insertion point
Paste
109
Print the active file
Print
110
Shows how the document/ workbook will look when you print
Print preview
111
Reverses the action of the Undo button, use the pull down menu to redo several steps.
Redo
112
Reverses the last command, use pull down menu to undo several steps.
Undo
113
Adds numbers automatically and suggests the range of numbers to be added.
Auto Sum
114
Sorts selected items from the beginning of the alphabet, the lowest number or the earliest date.
Sort Ascending
115
Sorts selected items from the end of the alphabet, the highest number of the latest date.
Sort Descending
116
Change the font color of your text
Font Color
117
Change the size of selected text and numbers
Font Size
118
Changes the font of the selected text
Font Style
119
Color the background of the cell to make them stand out
Fill Color
120
Makes selected text and numbers bold
Bold
121
Makes selected text and numbers italic
Italic
122
Underline selected text and numbers
Underline
123
Merges two or more selected cells and center the entry.
Merge and Center
124
Formats selected cells to display percent
Percentage Style
125
Make your text a bit bigger
Increase Font Size
126
Make your text a bit smaller
Decrease Font Size
127
Increase the number of decimals displayed after the decimal point
Increase Decimal
128
Decreases the number of decimals displayed after the decimal point
Decrease Decimal
129
Indents the selected paragraph to the next tab stop
Increase Indent
130
Decreases the indent to the previous tab stop
Decrease Indent
131
Add or moves a border around selected text or objects
Borders
132
Center the selected text
Center Align
133
Aligns to the left with ragged right margin
Left Align
134
Aligns to the right with a ragged left margin
Right Align
135
Vertically aligns the data entered into the current cell selection with the top edge of the cell.
Top Align button
136
Aligns the data entered in the current cell selection with the bottom edge of the cell.
Bottom Align button
137
Vertically centers the data entered into the current cell selection.
Middle Align button
138
Format selected cells to display commas in large numbers
Comma Style
139
Rotate you text diagonally or vertically. This is a great way to label narrow columns.
Orientation
140
Opens a pop-menu of orientation options that enable you to change the direction of the text entered into the current cell selection (by angling it up or down, converting it to vertical text, or rotating it up or down) and open the Alignment tab of the Format Cells dialog box.
Orientation
141
Applies wrap text to the current cell selection so that Excel expands the row heights as needed to fit all its text within the current column widths.
Wrap Text button
142
Enables you to select among several different currency formats from U.S. dollars to Swiss Francs, as well as to open the Number tab of the Format Cells dialog box with the Accounting number format selected.
Accounting Number Format button
143
Opens a pop-up menu of different number options from General through Text, as well as opens the Number tab in the Format Cells dialog box when you select its More Number Formats option.
Number Format button
144
Easily spot trends and patterns in your data using bars, colors and icons to visually highlight important values.
Conditional Formatting
145
Quickly convert a range of cells to a table with its own style.
Format as Table
146
A colorful style is a great way to make important data stand out on the sheet
Cell Styles
147
Continue a series or pattern into neighboring cells in any direction
Fill
148
Delete everything in the cell or remove just the formatting, contents, comments or hyperlinks.
Clear
149
Options for finding text in your documents.
Find and Select
150
Select a cell or range. This is always used to select data before applying formatting commands.
Select Cursor
151
Use this cursor to copy formulas or values
Fill Handle
152
Excel cursor that only appears when you are in the lower right corner of the current selection.
Fill Handle
153
Use this to drag and drop the selected cell or range. The white arrow only appears when you are at the edge of the current selection.
White Arrow with a smaller 4-headed Black Arrow
154
Use this to enter or edit data. The cursor (vertical line inside the cell) blinks.
I-Beam
155
Excel cursor to resize column width
2-headed Arrow (Horizontal)
156
Excel cursor to resize row height
2-Headed Arrow (Vertical)
