Brainscape's Knowledge GenomeTM

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


See full index

OPRE 6332 > Unit 1 > Flashcards

Unit 1 Flashcards

1
Q

An excel file is a

A

workbook

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

A worksheet has _________ rows arranged horizontally

A

1,048,576

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

A worksheet has ________ columns arranged vertically

A

16,384

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

The number of rows and columns are fixed.

A

You can’t add or reduce number of columns, but you can hide them.

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

Columns are represented by letters. The first column is A. A…Z, AA…AZ, …… AAB….., AAB….., The last column is

A

XFD (also column 16,384)

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

The intersection of a row and column is a

A

cell

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

In the R1C1 referencing system,

A

a cell is addressed with the row number first, followed by the column number.

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

R1C1 Reference Style uses

A

numbers for both rows and columns.

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

A1 referencing is the default which uses

A

letters for columns and numbers for rows

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

How many worksheets can a workbook have?

A

As many worksheets as can be held by computers memory.

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

How many cells are there?

A

Over 17 billion cells

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

The ribbon system refers to

A

the collections (or strips) of command buttons.

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

Within any ribbon, commands are organized in

A

groups.

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

The default ribbons are

A 
Home,
Insert,
Page Layout, 
Formulas,
Data,
Review,
View
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

We can adjust the display of the ribbon to show:

A
  • No ribbon,
  • Ribbon tabs only,
  • Ribbon tabs + commands
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

We cannot remove _____ from the default Excel groups in a ribbon.

A

buttons

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

We can remove an entire default group.

A

Can also remove individual buttons from a custom group in a ribbon.

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

Excel does not allow us to modify built-in groups in the ribbon.

A

We can’t remove or add buttons to an existing group.

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

To add a button, we have to create a ______ ______.

A

custom group.

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

The custom group can be created within an existing ribbon or

A

added to a new ribbon that we create.

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

We can also add a ____ or _____ to the existing ribbon system.

A

tab or group

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

Each tab can have one or more ______ of commands

A

groups

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

Couple of options to remove buttons-

A

1) reset all customization

2) reset only selected ribbon tabs

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

Reset all customization

A

this will help remove all customizations made to the tabs, groups, and the Quick Access Toolbar (QAT)

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

Reset only selected ribbon tabs

A

this will remove the customizations on a particular ribbon tab

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

We cannot remove ______ buttons from the default excel groups in a ribbon

A

individual

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

We can remove the _______ default excel group as well as individual buttons from a custom group in a ribbon

A

whole

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

The Quick access toolbar (QAT) can be positioned

A

above or below the toolbar

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

The quick access toolbar (QAT) comes with

A

a few commonly used commands.

30
Q

The user can add a command from __________ to the QAT, or remove existing commands from the QAT

A

any ribbon

31
Q

the QAT can simultaneously have _______ commands from different ribbons

A

multiple

32
Q

In effect, the QAT providers the user with a ribbon of commands that are

A

relevant to the user

33
Q

Adding to, or removing a command from the QAT _________ have any effect on the availability of the command in its original location.

A

does NOT

34
Q

Excel file names are made up of two parts,

A

the file name and file extension

35
Q

the file extensions tells us

A

what type of file it is

36
Q

The file extension _____ indicates it is an excel file/workbook.

A

.xlsx

37
Q

The file extension ____ indicates it is a macro-enabled workbook

A

.xlsm

38
Q

The file extension ____- indicates it is a macro-enabled add in

A

.xlam

39
Q

Macros are computer programs within a computer program. These are created by third party developers to facilitate various actions in excel.

A

As macros can be written for malicious purposes, there are usually security concerns around macros. For this reason, the separate file type is required to indicate that the excel file contains macros.

40
Q

An excel add-in is a program designed to provide additional functionality within excel.

A

May be created by microsoft as part of excel package, or by a third party delevoper, or by user himself.

41
Q

Add-ins are extensions of ________. An add-in may itself have several macros embedded in it.

A

macros.

42
Q

The information we enter in a cell can be one of several data types:

A 
number, 
text,
date,
time,
and forumla
are the most common
43
Q

a number permits

A

mathematical operations.

44
Q

A number can be presented in different ways:

A

in decimals, fractions, in scientific notation, etc.

45
Q

A number can also be represented with a _______ symbol

A

currency

46
Q

By default, excel aligns numbers to

A

the right.

however, the user can align the number differently.

47
Q

Text refers to information that does not permit mathematical operations.

A

this includes letters, punctuation marks, symbols, and also includes numbers.

48
Q

text can be formatted to be in a particular

A

font, font size, color, underlined, bold, italics, etc.

49
Q

different parts of text can be presented in different formats even

A

within the same cell.

by default, excel aligns text to the left.
user can align text differently.

50
Q

a date can be represented in different formats.

A

dates are considered numbers in excel

51
Q

time can be represented in

A

hours, minutes, and seconds; in hours and minutes only; in 12-hour or 24-hour formats.

52
Q

Like dates, times are considered _____ in excel

A

numbers

53
Q

a formula can be a combination of

A
  • numbers with operators
  • letters with operators
  • letters, numbers, and operations
54
Q

in addition to those data types, there are also

A

hyperlinks and images but aren’t commonly used

55
Q

In general, navigating with the mouse is ______ than navigating with keyboard keys.

A

slower

56
Q

It is _________ to create your own keyboard short-cuts

A

possible

57
Q

One advantage of using keyboard short-cuts is that some of these short-cuts

A

are available in other applications.

58
Q

Methods of populating a worksheet with data

A
  • entering data directly into a worksheet
  • copying and pasting data
  • importing data from another file
  • filing data in a pattern
  • linking a worksheet to an internet source
59
Q

embedding a value in a formula is known as ________ and contribute to errors

A

hard-coding

60
Q

precedence of operations makes it clear which sequence is required - PEMDAS:

A 
P-parenthesis
E-exponents
M-multiplication
D-division
A-addition
S-subtraction
61
Q

If you have multiple spaces separating two values you need to check

A

treat consecutive delimiters as one

62
Q

A file with values that are separated by commas is often referred to as a _____ file

A

.csv
which stands for comma separated values
(also character separated values)

63
Q

an advantage to storing data as a .csv or .txt file is that it makes the size of the file much smaller.

A

another advantage of storing data as a .csv or .txt file is that the data can be read by programs that are meant to read text (e.g. notepad or word)

64
Q

when importing data from text files, we need to know what character is used to separate different values.

A

a commonly used separator is a comma.

65
Q

importing a file is usually a one time event.

A

if the source data changes we will want to import the updated data. in such cases rather than importing data, we may want to link excel to the source data once the data is linked, we can refresh the linked data so that it is updated to reflect changes in the source data

66
Q

excel allows you to create what type of series?

A

growth series
linear series
data series

67
Q

a number that may be used a formula should be

A

placed in an individual cell

68
Q

what shows when you use the “split” command?

A

all rows above the active cell and all columns to the left of the active cell

69
Q

which command is used to put delimited values in separate columns

A

text to columns

70
Q

if I want to create a split view of my worksheet, and i only want a vertical split

A

the active cell must be anywhere in row 1 after column A

71
Q

Excel defaults to a relative referencing system. That is,

A

when we copy a formula from one cell to the other, excel changes the cells to which the formula refers, relative to the cell containing the formula.

OPRE 6332 (1 decks)

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