Unit 1

Question 1

An excel file is a

Answer 1

workbook

Question 2

A worksheet has _________ rows arranged horizontally

Answer 2

1,048,576

Question 3

A worksheet has ________ columns arranged vertically

Answer 3

16,384

Question 4

The number of rows and columns are fixed.

Answer 4

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

Question 5

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

Answer 5

XFD (also column 16,384)

Question 6

The intersection of a row and column is a

Answer 6

cell

Question 7

In the R1C1 referencing system,

Answer 7

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

Question 8

R1C1 Reference Style uses

Answer 8

numbers for both rows and columns.

Question 9

A1 referencing is the default which uses

Answer 9

letters for columns and numbers for rows

Question 10

How many worksheets can a workbook have?

Answer 10

As many worksheets as can be held by computers memory.

Question 11

How many cells are there?

Answer 11

Over 17 billion cells

Question 12

The ribbon system refers to

Answer 12

the collections (or strips) of command buttons.

Question 13

Within any ribbon, commands are organized in

Answer 13

groups.

Question 14

The default ribbons are

Answer 14

Home,
Insert,
Page Layout, 
Formulas,
Data,
Review,
View

Question 15

We can adjust the display of the ribbon to show:

Answer 15

• No ribbon,
• Ribbon tabs only,
• Ribbon tabs + commands

Question 16

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

Answer 16

buttons

Question 17

We can remove an entire default group.

Answer 17

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

Question 18

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

Answer 18

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

Question 19

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

Answer 19

custom group.

Question 20

The custom group can be created within an existing ribbon or

Answer 20

added to a new ribbon that we create.

Question 21

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

Answer 21

tab or group

Question 22

Each tab can have one or more ______ of commands

Answer 22

groups

Question 23

Couple of options to remove buttons-

Answer 23

1) reset all customization

2) reset only selected ribbon tabs

Question 24

Reset all customization

Answer 24

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

Question 25

Reset only selected ribbon tabs

Answer 25

this will remove the customizations on a particular ribbon tab

Question 26

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

Answer 26

individual

Question 27

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

Answer 27

whole

Question 28

The Quick access toolbar (QAT) can be positioned

Answer 28

above or below the toolbar

Question 29

The quick access toolbar (QAT) comes with

Answer 29

a few commonly used commands.

Question 30

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

Answer 30

any ribbon

Question 31

the QAT can simultaneously have _______ commands from different ribbons

Answer 31

multiple

Question 32

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

Answer 32

relevant to the user

Question 33

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

Answer 33

does NOT

Question 34

Excel file names are made up of two parts,

Answer 34

the file name and file extension

Question 35

the file extensions tells us

Answer 35

what type of file it is

Question 36

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

Answer 36

.xlsx

Question 37

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

Answer 37

.xlsm

Question 38

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

Answer 38

.xlam

Question 39

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

Answer 39

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.

Question 40

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

Answer 40

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

Question 41

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

Answer 41

macros.

Question 42

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

Answer 42

``` number, text, date, time, and forumla are the most common ```

Question 43

a number permits

Answer 43

mathematical operations.

Question 44

A number can be presented in different ways:

Answer 44

in decimals, fractions, in scientific notation, etc.

Question 45

A number can also be represented with a _______ symbol

Answer 45

currency

Question 46

By default, excel aligns numbers to

Answer 46

the right. however, the user can align the number differently.

Question 47

Text refers to information that does not permit mathematical operations.

Answer 47

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

Question 48

text can be formatted to be in a particular

Answer 48

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

Question 49

different parts of text can be presented in different formats even

Answer 49

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

Question 50

a date can be represented in different formats.

Answer 50

dates are considered numbers in excel

Question 51

time can be represented in

Answer 51

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

Question 52

Like dates, times are considered _____ in excel

Answer 52

numbers

Question 53

a formula can be a combination of

Answer 53

- numbers with operators - letters with operators - letters, numbers, and operations

Question 54

in addition to those data types, there are also

Answer 54

hyperlinks and images but aren't commonly used

Question 55

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

Answer 55

slower

Question 56

It is _________ to create your own keyboard short-cuts

Answer 56

possible

Question 57

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

Answer 57

are available in other applications.

Question 58

Methods of populating a worksheet with data

Answer 58

- 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

Question 59

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

Answer 59

hard-coding

Question 60

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

Answer 60

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

Question 61

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

Answer 61

treat consecutive delimiters as one

Question 62

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

Answer 62

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

Question 63

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

Answer 63

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)

Question 64

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

Answer 64

a commonly used separator is a comma.

Question 65

importing a file is usually a one time event.

Answer 65

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

Question 66

excel allows you to create what type of series?

Answer 66

growth series linear series data series

Question 67

a number that may be used a formula should be

Answer 67

placed in an individual cell

Question 68

what shows when you use the "split" command?

Answer 68

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

Question 69

which command is used to put delimited values in separate columns

Answer 69

text to columns

Question 70

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

Answer 70

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

Question 71

Excel defaults to a relative referencing system. That is,

Answer 71

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.