practice quiz

Question 1

enters text based on patterns it finds in the data

Answer 1

flash fill

Question 2

group of cells in a rectangular block

Answer 2

range

Question 3

mm/dd/yyyy

Answer 3

a date format

Question 4

• makes it easier to enter repetitive text in cells

Answer 4

autofill

Question 5

you can - the width or the height of the printout so that all of the columns or all of the rows fit on a single page

Answer 5

scale

Question 6

the characters +,-,* are examples of

Answer 6

arithmetic operates

Question 7

whenever you click the save button on the quick access toolbar or press the - keys, the workbook file is updated to reflect the latest content

Answer 7

ctrl+s

Question 8

to make a1 the active cell, you should press which of the following keys

Answer 8

ctrl+home

Question 9

an excell formula always begins w

Answer 9

equals sign

Question 10

an excel formula always begins with an

Answer 10

equal sign

Question 11

to make a1 the active cell you should press which of the following keys

Answer 11

ctrl+home

Question 12

in - orientation, a page id taller than it is wide

Answer 12

portrait

Question 13

an adjacent is a collection ranc=ges

Answer 13

false

Question 14

when you insert a new row, the existing rows shifted down and the new row has the same width as the row above it

Answer 14

false

Question 15

what is the result of the expression =50+20/10*5

Answer 15

60

Question 16

when you copy a selection of cells using drag and drop, which appears before you release the mouse button

Answer 16

an outline of the new location of the selected

Question 17

numeric data is any number that can be used in a mathematical calculation

Answer 17

true

Question 18

the advantage of an electronic - spreadsheet is that the content can be easily edited and update to reflect changing financial conditions

Answer 18

spreadsheet

Question 19

the formula bar displays the value or formula of the active cell

Answer 19

true

Question 20

a common business practice is to include a worksheet named documentation that contains a description of the workbook, the name of the person who prepared the workbook and the date it was created

Answer 20

true

Question 21

what is the syntax for a SUM formula adding the values of cell f6 to f9

Answer 21

=sum(f6:f9)

Question 22

if you want to create a new line within a cell, press the - keys to move the insertion point to next line within the cell

Answer 22

alt+enter

Question 23

ctrl+g is used to access the

Answer 23

go to a location in the worksheet command

Question 24

normal view shows how the worksheet will appear when printed

Answer 24

false

Question 25

a screentip is a box with descriptive text about a command that appears when you point to a button on the ribbon

Answer 25

true