Ch4 Microsoft Excel 2013

Question 1

In Excel the intersection of a column and a row is called

Answer 1

Cell

Question 2

Excel workbooks have what file extension

Answer 2

.xlsx

Question 3

How deep (how many rows) is an excel worksheet?

Answer 3

1,048,566

Question 4

A new blank workbook contains how many worksheets?

Answer 4

1

Question 5

A rectangular block of cells is called a

Answer 5

Range

Question 6

If you change a cell entry upon which a formula depends (which a formula refers to), what will happen?

Answer 6

The formula will automatically recalculate to reflect the changed data

Question 7

In Excel, what is the result of the formula 3+(4-2)*3 =

Answer 7

9

Question 8

The way information appears in a cell (such as its alignment, font) is referred to as

Answer 8

the cell’s format

Question 9

What happens when you close a workbook that you work with in Excel?

Answer 9

if you made changes to the workbook since you last saved, a dialog box will appear and give you the opportunity to save again

Question 10

What is the shorter way of computing = C1+C2+C3+C4+C5+C6+C7+C8 ?

Answer 10

SUM(C1:C8)

Question 11

What tool can be used to quickly create SUM formula?

Answer 11

AutoSum

Question 12

What feature can be used to get detailed information on a particular cell?

Answer 12

the formula bar

Question 13

Excel displays number signs (####) in a cell when

Answer 13

a formatted number is too long to fit in the column

Question 14

Writing an incorrect formula that attempts to perform math by referring to a text entry causes excel to display what in the formula cell?

Answer 14

VALUE

Question 15

On a Chart, what is used to indicate what each color or symbol stands for?

Answer 15

a legend

Question 16

Line charts are most appropriate for

Answer 16

showing trends or changes over time

Question 17

Column charts are most appropriate for

Answer 17

comparing individual values at specific times

Question 18

Pie charts are most appropriate for

Answer 18

showing relationships among portions of a whole

Question 19

A data file created by a spreadsheet program is called a

Answer 19

Workbook

Question 20

What is the combination of keys required to come back to the top of the worksheet?

Answer 20

Ctrl + HOME

Question 21

What key is used to select multiple different ranges of cells?

Answer 21

Ctrl

Question 22

To edit existing data in a cell without having to retype it all, you should

Answer 22

click the Edit button on the Formula bar

Question 23

If you select a cell with a date in it and drag the fill handle down across several cells, what happens is that

Answer 23

the date is increased by 1 day into each cell

Question 24

To remove the contents of several cells at once, you can:

Answer 24

1. Select the cells and press DELETE
2. Select the cells and right click and choose Clear Contents
3. Select the cells and drag the fill handle back up over them

Question 25

The formula that will add the value of cell D4 to the value of C2 and then multiply by the value in B2 is

Answer 25

(D4+C2)*B2

Question 26

Cell A4=2 and A5=4, You select both cells and drag the fill handle down to A8. The contents of cells A6, A7, and A8 are

Answer 26

(احفظها ) 6,8,10

Question 27

You can automatically resize the column to fit the width of the column’s contents by

Answer 27

double clicking on the column boundary line

Question 28

To save an existing file with a new name, what command should you use?

Answer 28

Save as

Question 29

How many cells are included in the range A1:B3?

Answer 29

6 (if you writhe anything in A1 cell and anything in B3 cell then you highlight the cells from A1 to B3 you will find that they are 6 cells

Question 30

The black box in the lower-right corner of a selection that is used to copy cells is called the

Answer 30

Fill handle

Question 31

Which of the following functions is written in the correct syntax?

1. NOW(today)
2. SUM(D2-A2)
3. =SUM(A1:D1)
4. =SUM(A1=D1)

Answer 31

SUM(A1:D1)