Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

AIS Final Exam > Chapter 6 > Flashcards

Chapter 6 Flashcards

1
Q

Father of the electronic spreadsheet

A

Daniel Bricklin

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

They co-invented or co-created in 1978 the VisiCalc

A

Daniel Bricklin and Bob Frankston

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

The first killer application for personal computers

A

VisiCalc

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

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

It is a rectangular group of cells

A

Block/range

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

He pioneered the development of computerized spreadsheets for use in business accounting

A

Professor Richard Mattessich

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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)

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

When did Bricklin program the first working prototype of his concept in integer basic

A

Fall of 1978

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

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

How many copies of the spreadsheet program were sold during VisiCalc’s product lifetime?

A

1 million

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

Excel was originally written for the…

A

512k Apple Macintosh

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

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

Microsoft documents show the launch of Excel 2.0 for

A

MS-DOS version 3.0

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

When did Microsoft launch the Windows operating system

A

1987

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

It had acquired Software Arts and the rights to VisiCalc

A

Lotus

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

It is a spreadsheet program that allows you to store, organize, and analyze information.

A

Excel 2013

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

When you open Excel 2013 for the first time, what will appear?

A

Excel Start Screen

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

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

From here, you can access your Microsoft account information, view your profile, and switch accounts.

A

Microsoft Account

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

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

Displays the location or name of a selected cell.

A

Name Box

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

You can enter or edit data, or a formula, or a function that will appear in a specific cell.

A

Formula Bar

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

Each rectangle in a workbook

A

Cell

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

It is the intersection of row and column.

A

Cell

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

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.

A

Row

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

Excel files are called ____

A

Workbooks

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

It is selected by default and shows you an unlimited number of cells and columns.

A

Normal view

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

It divides your spreadsheet into pages.

A

Page Layout View

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

It lets you see an overview of your worksheet, which is especially helpful when adding page breaks.

A

Page Break View

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

Click and drag the slider to use the zoom control. The number to the right of the slider reflects the zoom percentage.

A

Zoom Control

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

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.

A

Vertical and Horizontal Scroll Bars

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

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.

A

Column

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

T or F: Excel 2013 uses a tabbed Ribbon system instead of traditional menus.

A

T

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

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.

A

Home

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

The ____ tab is selected by default whenever you open Excel.

A

Home

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

The ____ tab allows you to insert charts, tables, sparklines, filters, and more, which can help you visualize and communicate your workbook data graphically.

A

Insert

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

The ____ tab allows you to change the print formatting of your workbook, including margin width, page orientation, and themes.

A

Page Layout

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

These commands will be especially helpful when preparing to print a workbook.

A

Page Layout tab

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

The ____ tab gives you access to the most commonly used functions and formulas in Excel. .

A

Formulas

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

These commands will help you calculate and analyze numerical data, such as averages and percentages

A

Formulas tab

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

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.

A

Data

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

You can use the ____ tab to access Excel’s powerful editing features, including comments and track changes.

A

Review

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

These features make it easy to share and collaborate on workbooks.

A

Review tab

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

The ____ tab allows you to switch between different views for your workbook and freeze panes for easy viewing.

A

View

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

These commands will also be helpful when preparing to print a workbook.

A

View tab

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

____ tabs will appear on the Ribbon when working with certain items, like tables and pictures.

A

Contextual

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

These tabs contain special command groups that can help you format these items as needed.

A

Contextual tabs

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

It gives you various options for saving, opening a file, printing, and sharing your workbooks.

A

Backstage View

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

You can use the arrow to close Backstage view and return to Excel.

A

Return to Excel

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

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.

A

Info

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

From here you can create new, blank workbook or choose from a larger selection or template.

A

New

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

From here, you can open recent workbook, as well as workbooks saved to your OneDrive or on your computer.

A

Open

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

Use _____ to save your workbook to your computer or to your OneDrive

A

Save and save as

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

From ____ pane, you can change the print settings and print your workbook. You can also see a preview of your workbook.

A

Print

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

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.

A

Share

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

You can choose to export your workbook into another format, such as PDF/XPS or Excel 1997 – 2003

A

Export

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

Click here to close the current workbook.

A

Close

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

From the ____ pane, you can access your Microsoft Account information, modify your theme and background and sign out of your account.

A

Account

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

Here you can change Excel options. For example, you can control the Quick Analysis preferences, Autorecover settings or Language preferences

A

Options

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

This view can help you visualize how your worksheet will appear when printed.

A

Page Layout View

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

You can also add headers and footers from this view.

A

Page Layout View

64
Q

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.

A

Page Break View

65
Q

These are the basic building blocks of a worksheet.

A

Cells

66
Q

A group of cells is known as a

A

Cell range

67
Q

Cells can contain ____ such as letters, numbers, and dates.

A

Text

68
Q

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.

A

Formatting attributes

69
Q

Cells can contain ____ that calculate cell values

A

Formulas and functions

70
Q

It appears as a small square in the bottom-right corner of the selected cell(s).

A

Fill handle

71
Q

A new feature in Excel 2013, ___ can enter data automatically into your worksheet, saving you time and effort.

A

Flash Fill

72
Q

Merges the selected cells into one cell and centers the text.

A

Merge & Center

73
Q

Merges the selected cells into larger cells while keeping each row separate.

A

Merge Across

74
Q

Merges the selected cells into one cell but does not center the text.

A

Merge Cells

75
Q

Unmerges selected cells

A

Unmerge Cells

76
Q

Mathematical operator for addition

A

Plus sign

77
Q

Mathematical operator for subtraction

A

Minus sign

78
Q

Mathematical operator for multiplication

A

Asterisk

79
Q

Mathematical operator for division

A

Forward slash

80
Q

Mathematical operator for exponent

A

Caret

81
Q

Excel formulas must begin with

A

Equals sign

82
Q

Most of the time you will use cell addresses to create a formula. This is known as making a ____

A

Cell reference

83
Q

Finds the sum of the numbers in the specified cells

A

SUM

84
Q

Finds the average of the numbers in the specified cells

A

AVERAGE

85
Q

Finds the number of entries in the specified cells

A

COUNT

86
Q

Finds the largest value in the specified cells

A

MAX

87
Q

Finds the smallest value in the specified cells

A

MIN

88
Q

Finds the average of values within a cell range that meet a given criterion

A

AVERAGEIF

89
Q

Finds the average of values within a cell range that meet multiple criteria

A

AVERAGEIFS

90
Q

Counts the number of cells in a range that contain a numerical value

A

COUNT

91
Q

Counts the number of cells in a range that are not empty

A

COUNTA

92
Q

Counts the number of cells in a range that are empty

A

COUNTBLANK

93
Q

Counts the number of cells in a range that meet a given criterion

A

COUNTIF

94
Q

Counts the number of cells in a range that meet multiple criteria

A

COUNTIFS

95
Q

Displays one value if a formula results in an error and another if it doesn’t

A

IFERROR

96
Q

Finds the sum of values in a range that meet a single criterion

A

SUMIF

97
Q

Finds the sum of values in a range that meet multiple criteria

A

SUMIFS

98
Q

The column isn’t wide enough to display the value.

A

#####

99
Q

The formula has the wrong type of argument (such as text in a cell where a numerical value is required).

A

VALUE!

100
Q

The formula contains text that Excel doesn’t recognize (such as an unknown named range).

A

NAME?

101
Q

The formula refers to a cell that doesn’t exist (which can happen whenever cells are deleted).

A

REF!

102
Q

The formula attempts to divide by zero.

A

DIV/0!

103
Q

Creates new blank workbook based on the default template.

A

New

104
Q

Opens or finds the files

A

Open

105
Q

Saves the active file with its current file name, location and file format.

A

Save

106
Q

Copies the selected items to the clipboard

A

Copy

107
Q

Removes the selection and places it on the clipboard

A

Cut

108
Q

Places the content of the clipboard at the insertion point

A

Paste

109
Q

Print the active file

A

Print

110
Q

Shows how the document/ workbook will look when you print

A

Print preview

111
Q

Reverses the action of the Undo button, use the pull down menu to redo several steps.

A

Redo

112
Q

Reverses the last command, use pull down menu to undo several steps.

A

Undo

113
Q

Adds numbers automatically and suggests the range of numbers to be added.

A

Auto Sum

114
Q

Sorts selected items from the beginning of the alphabet, the lowest number or the earliest date.

A

Sort Ascending

115
Q

Sorts selected items from the end of the alphabet, the highest number of the latest date.

A

Sort Descending

116
Q

Change the font color of your text

A

Font Color

117
Q

Change the size of selected text and numbers

A

Font Size

118
Q

Changes the font of the selected text

A

Font Style

119
Q

Color the background of the cell to make them stand out

A

Fill Color

120
Q

Makes selected text and numbers bold

A

Bold

121
Q

Makes selected text and numbers italic

A

Italic

122
Q

Underline selected text and numbers

A

Underline

123
Q

Merges two or more selected cells and center the entry.

A

Merge and Center

124
Q

Formats selected cells to display percent

A

Percentage Style

125
Q

Make your text a bit bigger

A

Increase Font Size

126
Q

Make your text a bit smaller

A

Decrease Font Size

127
Q

Increase the number of decimals displayed after the decimal point

A

Increase Decimal

128
Q

Decreases the number of decimals displayed after the decimal point

A

Decrease Decimal

129
Q

Indents the selected paragraph to the next tab stop

A

Increase Indent

130
Q

Decreases the indent to the previous tab stop

A

Decrease Indent

131
Q

Add or moves a border around selected text or objects

A

Borders

132
Q

Center the selected text

A

Center Align

133
Q

Aligns to the left with ragged right margin

A

Left Align

134
Q

Aligns to the right with a ragged left margin

A

Right Align

135
Q

Vertically aligns the data entered into the current cell selection with the top edge of the cell.

A

Top Align button

136
Q

Aligns the data entered in the current cell selection with the bottom edge of the cell.

A

Bottom Align button

137
Q

Vertically centers the data entered into the current cell selection.

A

Middle Align button

138
Q

Format selected cells to display commas in large numbers

A

Comma Style

139
Q

Rotate you text diagonally or vertically. This is a great way to label narrow columns.

A

Orientation

140
Q

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.

A

Orientation

141
Q

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.

A

Wrap Text button

142
Q

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.

A

Accounting Number Format button

143
Q

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.

A

Number Format button

144
Q

Easily spot trends and patterns in your data using bars, colors and icons to visually highlight important values.

A

Conditional Formatting

145
Q

Quickly convert a range of cells to a table with its own style.

A

Format as Table

146
Q

A colorful style is a great way to make important data stand out on the sheet

A

Cell Styles

147
Q

Continue a series or pattern into neighboring cells in any direction

A

Fill

148
Q

Delete everything in the cell or remove just the formatting, contents, comments or hyperlinks.

A

Clear

149
Q

Options for finding text in your documents.

A

Find and Select

150
Q

Select a cell or range. This is always used to select data before applying formatting commands.

A

Select Cursor

151
Q

Use this cursor to copy formulas or values

A

Fill Handle

152
Q

Excel cursor that only appears when you are in the lower right corner of the current selection.

A

Fill Handle

153
Q

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.

A

White Arrow with a smaller 4-headed Black Arrow

154
Q

Use this to enter or edit data. The cursor (vertical line inside the cell) blinks.

A

I-Beam

155
Q

Excel cursor to resize column width

A

2-headed Arrow (Horizontal)

156
Q

Excel cursor to resize row height

A

2-Headed Arrow (Vertical)

AIS Final Exam (1 decks)

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