module 1

Question 1

a spreadsheet program used to enter, analyze and present quantitative data

Answer 1

microsoft excel 2016

Question 2

a grouping of text and numbers in a rectangular grid or table

Answer 2

spreadsheet

Question 3

the rile tab of the ribbon, which proviides access to various screens w commands that allow you to manage files and excel options

Answer 3

backstage view

Question 4

name for excel documents

Answer 4

workbooks

Question 5

a preformatted workbook with many design features and some content already filled in

Answer 5

template

Question 6

a key or combination of keys that you press to access a feature or perform a command

Answer 6

keyboard shortcut

Question 7

a box w descriptive text about a command

Answer 7

screentip

Question 8

display the key tips for the commands and tools on the ribbom

Answer 8

alt

Question 9

select all objects in a range

Answer 9

ctrl+a

Question 10

copy the selected objects

Answer 10

ctrl+c

Question 11

go to a location in the workbook

Answer 11

ctrl+g

Question 12

open a new blank workbook

Answer 12

ctrl+n

Question 13

open a saved workbook file

Answer 13

ctrl+o

Question 14

print the current workbook

Answer 14

ctrl+p

Question 15

save the current workbook

Answer 15

ctrl+s

Question 16

paste content that was cut or copied

Answer 16

ctrl+v

Question 17

close the current workbook

Answer 17

ctrl+w

Question 18

cut the selected objects

Answer 18

ctrl+x

Question 19

repeat the last command

Answer 19

ctrl+y

Question 20

undo the last comman

Answer 20

ctrl+z

Question 21

open the excel help window

Answer 21

f1

Question 22

go to a location in the workbook

Answer 22

f5

Question 23

save the current workbook with anew name or to a new location

Answer 23

f12

Question 24

the mode in which the ribbon increases in height, the buttons are bigger and more space appears around each button so you can more easily use your finger or stylus to tap the button on a touchscreen

Answer 24

touch mode

Question 25

a sheet that contains only a chart that provides a visual representation of worksheet data

Answer 25

chart sheet

Question 26

contains a grid of rows and columns into which you can enter text, numbers, dates and formula and display charts

Answer 26

worksheet

Question 27

the column and row location that identifies a cell within a worksheet

Answer 27

cell reference

Question 28

to column A of the current row

Answer 28

home

Question 29

to cell a1

Answer 29

ctrl+home

Question 30

to the last cell in the worksheet that contains data

Answer 30

ctrl+end

Question 31

down one row or to the start of the new row of data

Answer 31

enter

Question 32

up one row

Answer 32

shift enter

Question 33

one column to the right

Answer 33

tab

Question 34

one column to the left

Answer 34

shift+tab

Question 35

up or down one screen

Answer 35

pgup, pgdn

Question 36

to the previous or next sheet in the workbook

Answer 36

ctrl+pgup, ctrl+pgdn

Question 37

the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a colon

Answer 37

range reference