Excel Test 1

Question 1

Spreadsheet

Answer 1

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

Question 2

Backstage view

Answer 2

the File tab of the ribbon, contains various screens with commands that allow you to manage files and options for the Excel

Question 3

template

Answer 3

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

Question 4

Getting help- what button

Answer 4

if you are unsure about a function, press the F1 key

Question 5

Go to - button

Answer 5

F5

Question 6

Save the current workbook with a new name - button

Answer 6

F12

Question 7

New workbook - button

Answer 7

Ctrl + N

Question 8

Repeat the last action

Answer 8

Ctrl + Y

Question 9

Undo

Answer 9

Ctrl + Z

Question 10

Save

Answer 10

Ctrl + S

Question 11

Screen tip

Answer 11

a label that appears next to an object, providing information about that object or giving a link to associated help topic

Question 12

Chart sheet

Answer 12

a sheet that contains only a chart that is linked to data within the workbook

Question 13

Cell reference

Answer 13

indicates the column and row in which the cell is located

Question 13

you can include a ____ sheet that contains a description of the workbook, etc.

Answer 13

requirement/documentation

Question 14

Shortcut to move up one row

Answer 14

Shift + Enter

Question 14

Range reference

Answer 14

includes 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

Question 15

How do you rename a Sheet tab at the bottom of the Excel window

Answer 15

double click (or right click) the Sheet1 tab to select the text of the sheet name

Question 16

text data

Answer 16

any combination of letters, numbers, and symbols

Question 16

numeric data

Answer 16

any number that can be used in a mathematical operation

Question 17

Text is ___ aligned

Answer 17

left aligned. includes postal codes

Question 18

Values/numbers, dates, and times, are _____ aligned

Answer 18

right

Question 19

Edit mode

Answer 19

if you want to replace only part of a cell’s content, you can switch to Edit Mode to make the changes directly in the cell. Double click cell

Question 20

a postal code is ____

Answer 20

text. begin with apostrophe ‘

Question 21

AutoComplete

Answer 21

displays text that begins with same letters as previous entry in same column to make entering repetitive text easier and reduce data entry errors

Question 22

Shortcut to wrap text

Answer 22

Alt + Enter

Question 23

What button do you press to select non-adjacent text

Answer 23

Ctrl

Question 24

Numeric data

Answer 24

any number that can be used in a math calculation. commonly recognized formats for date and time values.

Question 25

Button to edit data

Answer 25

F2 or double click

Question 26

Autocomplete

Answer 26

when you type Jan and computer automatically fills in remainder of January

Question 27

What color is triangle for zipcode

Answer 27

Green

Question 28

How many views in Excel

Answer 28

Three

Question 29

Function

Answer 29

=SUM(A1:A10) named operation that replaces arithmetic expression

Question 30

Formula

Answer 30

=A1+A2 - mathematical expression

Question 31

Arithmetic operators

Answer 31

Addition, =B1+B2+B3, - / * exponents

Question 32

A ____ is a named operation that replaces action of arithmetic expression

Answer 32

function (avg, max, min, count, sum)

Question 33

Page Break Preview

Answer 33

shows location of page breaks in the printed worksheet

Question 34

Page Layout View

Answer 34

shows how the worksheet will appear when printed

Question 35

The order of operations

Answer 35

set of predefined rules - the sequence in which operators are applied in a calculation

Question 36

Clipboard

Answer 36

temporary storage location for text and graphics

Question 37

drag and drop

Answer 37

select text and drag the text to a new location - dra by its bottom border to new location

Question 38

Clearing

Answer 38

removes the data from the selected cells, leaving those cells blank but preserving the current worksheet structure

Question 39

formatting

Answer 39

enhances the appearance of the worksheet data by changing its font, size, color, or alignment

Question 40

Scaling

Answer 40

resizes the worksheet to fit within a single page or set of pages

Question 41

AutoSum

Answer 41

the button that inserts functions (sum,avg,max,etc)

Question 42

border

Answer 42

aline you can add along an edge of cell that prints

Question 43

cell

Answer 43

intersection of a row and a column

Question 44

cell range

Answer 44

group of cells in rectangular block

Question 45

cell reference

Answer 45

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

Question 46

*chart sheet

Answer 46

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

Question 47

column headings

Answer 47

the letters along the top of the worksheet window that identify the different columns in the worksheet

Question 48

flash fill

Answer 48

the feature that enters text based on patterns it finds in the data

Question 49

formula bar

Answer 49

bar located below the ribbon that displays value or formula entered in active cell

Question 50

name box

Answer 50

box located at left side of formula bar that displays cell reference of active cell

Question 50

normal view

Answer 50

the Excel view that shows the contents of the active sheet in the workbook window

Question 51

operator

Answer 51

a mathematical symbol used in formula to combine diff values, resulting in single value displayed in cell

Question 52

row headings

Answer 52

the numbers along the left side of the workbook window that identify the diff rows of ws

Question 52

ribbon

Answer 52

the main set of commands organized into tabs and groups with buttons that you click to execute commands

Question 53

scale

Answer 53

to change size of worksheet on printed page

Question 54

ScreenTip

Answer 54

a box with descriptive text about a command that appears when you point to a button the ribbon - tip

Question 55

sheet tab

Answer 55

the area at the bottom of ws that identifies the sheet by name

Question 56

syntax

Answer 56

a set of rules that specifies how a function should be written