An electronic ____ is an application you use to perform numeric calculations and

Question

An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.

project

spreadsheet

dataform

database

1 points   

QUESTION 2

In Excel, the electronic spreadsheet you work in is called a ____.

numericsheet

databook

tablet

worksheet

1 points   

QUESTION 3

In Excel, a worksheet is contained in a file called a ____.

workpad

datapad

notebook

workbook

1 points   

QUESTION 4

You can use predesigned, formatted files called ____ to create new worksheets quickly.

layouts

templates

screens

formatsheets

1 points   

QUESTION 5

You can use a spreadsheet to ____ by using variable values to investigate and sample different outcomes.

create what-if data scenarios

perform calculations

represent values graphically

organize data

1 points   

QUESTION 6

____ below the worksheet grid let you switch from sheet to sheet in a workbook.

Sheet tabs

Scroll bars

Cell pointers

Mode indicators

1 points   

QUESTION 7

You can use ____ to move around in a document that is too large to fit on the screen at once.

scroll bars

cell pointers

mode indicators

sheet tabs

1 points   

QUESTION 8

All Excel formulas begin with the ____.

asterisk (*)

slash (/)

plus sign (+)

equal sign (=)

1 points   

QUESTION 9

The Excel operator for exponent is ____.

^

/

%

1 points   

QUESTION 10

The Excel operator for division is ____.

/

%

^

1 points   

QUESTION 11

A(n) ____ is an entry in a cell that contain text such as “2011 Sales” or “Travel Expenses.”

argument

label

value

formula

1 points   

QUESTION 12

A(n) ____ is a built-in formula that uses arguments to calculate information.

indicator

function

label

template

1 points   

QUESTION 13

Excel recognizes an entry as a value if it is a number or it begins with ____.

+

=

$

All of the above

1 points   

QUESTION 14

You can use the ____ key(s) on the keyboard to navigate a worksheet.

arrow

[Enter]

Zoom

[Ctrl]

1 points   

QUESTION 15

To quickly jump to the first cell in a worksheet press ____.

[Ctrl][Home]

[Shift][Home]

[Page Up]

[Alt][Page Up]

1 points   

QUESTION 16

To move one screen to the left press ____.

[Ctrl][Page Left]

[Alt][Page Down]

[Alt][Page Up]

[Ctrl][Home]

1 points   

QUESTION 17

To quickly jump to the last cell in a worksheet press _____.

[Page Down]

[Ctrl][End]

[Shift][Down]

[Alt][Page Down]

1 points   

QUESTION 18

You can edit the contents of the active cell by ____.

pressing the [Ctrl] key and the [Home] key and starting to type

just starting to type

pressing the [Enter] key and starting to type

pressing the [Home] key and starting to type

1 points   

QUESTION 19

In a worksheet, the ____ is called the formula prefix.

minus sign (-)

equal sign (=)

plus sign (+)

pound sign (#)

1 points   

QUESTION 20

____ operators perform mathematical calculations such as adding and subtracting.

Reference

Comparison

Text concatenation

Arithmetic

1 points   

QUESTION 21

Possible paper orientations for printing a worksheet are landscape and ____.

page break

preview

normal

portrait

1 points   

QUESTION 22

The ____ option helps fit the data on a single page without making changes to individual margins.

Squeeze

Scale to Fit

Page Break View

Paginate

1 points   

QUESTION 23

You can use the ______________ slider on the status bar to enlarge your view of specific areas of your worksheet.

Zoom

Preview

Orientation

Layout

1 points   

QUESTION 24

You can change, or ________, the contents of an active cell at any time.

navigate

edit

calculate

recover

1 points   

QUESTION 25

The Undo button allows you to reverse up to _________ previous actions, one at a time.

100

1

1,000

10

1 points   

QUESTION 26

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2, what would cell A3 show on the worksheet?

=10/2

5

=5

=A1/A2

1 points   

QUESTION 27

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1^A2, what would cell A3 show on the worksheet?

=A1^A2

20

10^2

100

1 points   

QUESTION 28

The ____ of a cell determines how the labels and values look.

formula

value

label

format

1 points   

QUESTION 29

To format a cell or range, first you select it, and then you apply the formatting using the ____ or a keyboard shortcut.

formula box

Ribbon

Name box

Sheet tabs

1 points   

QUESTION 30

The default Accounting number format adds dollar signs and ____ decimal places to the data.

one

two

three

four

1 points   

QUESTION 31

Cells and ranges in a worksheet can be formatted ____.

only after data is entered

only before data is entered

before or after data is entered

at the same time data is entered

1 points   

QUESTION 32

To apply a table style, select the data to be formatted or click anywhere within the intended range (Excel can automatically detect a range of cells), click the Format as Table button in the ____ group on the Home tab, and then click a style in the gallery.

Cells

Editing

Styles

Alignment

1 points   

QUESTION 33

The ____ size is the physical size of the text.

serif

font

style

format

1 points   

QUESTION 34

A ____ is an individual media file, such as art, sound, animation, or a movie.

template

point

clip

cell style

1 points   

QUESTION 35

You can apply attributes and alignment options using the ____ tab of the Ribbon.

View

Page Layout

Insert

Home

1 points   

QUESTION 36

You can apply attributes and alignment options using the ____ dialog box.

Insert

Conditional Formatting

AutoCorrect

Format Cells

1 points   

QUESTION 37

Font ____ are formats such as bold, italic, and underlining that you can apply to affect the way text and numbers look in a worksheet.

Fonts

Clip arts

Formats

styles

1 points   

QUESTION 38

The Format Painter button is found in the ____ group on the Home tab of the Ribbon.

Styles

Clipboard

Font

Alignment

1 points   

QUESTION 39

You can change the ____ of labels and values in cells to be left, right, or center.

alignment

cell style

font

font size

1 points   

QUESTION 40

Double-clicking the column line to the right of a column activates the ____ feature for the column.

Format as Table

Format

AutoCorrect

AutoFit

1 points   

QUESTION 41

You insert a comment in a worksheet by using the ____ tab on the Ribbon.

Insert

View

Home

Review

1 points   

QUESTION 42

A small, ____ triangle appears in the upper-right corner of a cell containing a comment.

blue

yellow

red

green

1 points   

QUESTION 43

You can use colors, patterns, and borders to enhance the overall appearance of a worksheet and to make it easier to read. One of the ways of adding these enhancements is by using the Border and Fill Color buttons in the Font group on the ____ tab of the Ribbon.

Page Layout

Review

Home

Data

1 points   

QUESTION 44

You can change colors, patterns, and borders of cells by using the Fill tab and the Border tab in the ____ dialog box.

Page Setup

Format Cells

AutoCorrect

Insert

1 points   

QUESTION 45

A theme can be applied using the Themes button in the Themes group on the ____ tab on the Ribbon.

Home

Page Layout

Review

Data

1 points   

QUESTION 46

The formatting due to ____ formatting is automatically updated if you change data in the worksheet.

dynamic

conditional

data

spatial

1 points   

QUESTION 47

The Spelling button is found in the Proofing group on the ____ tab on the Ribbon.

Review

Page Layout

Data

Home

1 points   

QUESTION 48

The Find & Select button is found in the Editing group on the ____ tab on the Ribbon.

Page Layout

Home

Review

Data

1 points   

QUESTION 49

###### in a cell means that the ____________.

formula contains an error

value contains an error

column is too narrow to display the value completely

label has a spelling error

1 points   

QUESTION 50

____ marks indicate the scale of measure for each value on the y-axis.

Tick

Axis

Datapoint

Legend

1 points   

QUESTION 51

A(n) ____ identifies each data series in a chart, generally with a different color.

legend

data marker

data point

axis

1 points   

QUESTION 52

The x-axis and y-axis are, respectively, the ____.

vertical and horizontal axes

horizontal and vertical axes

tick markers and data series

data series and gridlines

1 points   

QUESTION 53

A collection of related data points is called a ____.

tick mark

data point

data marker

data series

1 points   

QUESTION 54

Each value in a cell selected for a chart is called a ____.

data point

tick mark

data marker

data series

1 points   

QUESTION 55

On a chart created in Excel, the horizontal axis is called the ____.

data marker

legend

y-axis

x-axis

1 points   

QUESTION 56

On a chart created in Excel, the vertical axis is called the ____.

x-axis

y-axis

data marker

legend

1 points   

QUESTION 57

A(n) ____ chart compares distinct object levels using vertical bars; is the Excel default.

column

area

line

pie

1 points   

QUESTION 58

To show how individual volume changes over time in relation to total volume, use a(n) ____.

area chart

bar chart

line chart

column chart

1 points   

QUESTION 59

A pie chart ____.

compares trends over uneven time or measurement intervals

compares trends over even time intervals

compares distinct, unrelated objects over time using a horizontal format

compares sizes of pieces as part of a whole

1 points   

QUESTION 60

Which two charts compare trends over time intervals?

Bar and pie

Area and line

Pie and area

Line and scatter

1 points   

QUESTION 61

Which chart type would you use to compare distinct objects over time using horizontal bars?

Area

Bar

Line

Column

1 points   

QUESTION 62

A scatter chart ____.

compares trends over uneven time or measurement intervals

compares trends over even time intervals

compares distinct, unrelated objects over time using a horizontal format

combines a column and line chart to compare data requiring different scales of measure

1 points   

QUESTION 63

Which chart type would be the best candidate to emphasize sales trends over a period of 6 months?

Pie

Line

Area

Scatter

1 points   

QUESTION 64

Which chart type would be the best candidate to spot trends and extrapolate information based on research data?

Scatter

Pie

Area

Hi-Low

1 points   

QUESTION 65

A chart that is inserted directly in the current worksheet is called a(n) ____ chart.

inner

sub

embedded

interactive

1 points   

QUESTION 66

You can apply a chart type to an existing data series in a chart to create a(n) ____ chart.

combination

nested

exploded

complex

1 points   

QUESTION 67

Which of the following will not be affected or rearranged by choosing a new layout on the Chart Tools Design tab?

Titles

Legend

Data

Gridlines

1 points   

QUESTION 68

A combination chart adds a(n) ____ axis to chart related data.

combo

secondary

clustered

tertiary

1 points   

QUESTION 69

The phrase “in 3-D” refers to

a true, 3-D chart.

a chart with two axes

a chart that is only formatted in 3-D

a combination chart

1 points   

QUESTION 70

Major ____ represent the values at the value axis tick marks.

Arrows

Gridlines

Axis lines

Categories

1 points   

QUESTION 71

Which of the following is not an option that the Data Labels can produce?

legend name

value of the data point

series name

category name

1 points   

QUESTION 72

Shape ____ make it possible to apply multiple formats to a data series, such as an outline, fill color, and text color, all with a single click.

Markers

Styles

Gridlines

Text annotations

1 points   

QUESTION 73

You can add a text box using the Chart Tools ____ tab.

Format

Design

Layout

Text

1 points   

QUESTION 74

Text annotations are ____ that you can add to further describe the data in your chart.

arrows

titles

notes

labels

1 points   

QUESTION 75

In a pie chart, slices that are pulled away are said to be ____.

opened

exploded

identified

extracted

1 points   

QUESTION 76

In the formula =D1+C1/F3, which calculation will be performed first?

C1/F3

D1/F3

D1+F3

D1+C1

1 points   

QUESTION 77

The COUNTA function is used to count the number of cells in a range that contain which type of data?

numbers

text

formulas

All of the above

1 points   

QUESTION 78

Which of the following is a complex formula?

=SUM(B4:B8)

=(B4/B8)*10

both a. and b.

neither a. nor b.

1 points   

QUESTION 79

Which formula contains a mixed cell reference?

=($A6+$A$7)*0.20

=(A6+A7)*0.20

=($A$6+$A$7)*0.20

=($A$6+A7)*0.20

1 points   

QUESTION 80

Which type of cell reference preserves the exact cell address in a formula?

absolute

mixed

relative

All of the above

1 points   

QUESTION 81

In the formula =(G15-G14)*$M$3/4, which mathematical operation is performed first?

(G15-G14)

(G15-G14)/4

$M$3/4

(G15-G14)*$M$3

1 points   

QUESTION 82

In the formula =ROUND(D4:F4,0), what does the zero indicate?

the number of times the formula should be repeated

a null value

the number of decimal places in the rounded number

the value for cell F4

1 points   

QUESTION 83

Excel templates make creating a professional looking spreadsheet easier by including all of the following except ____ in the template.

data

labels

formulas

formatting

1 points   

QUESTION 84

Excel templates include which of these categories?

budgets

timesheets

expense reports

All of the above

1 points   

QUESTION 85

To continue a sequence in adjacent cells, such as months of the year, use the ____ feature of Excel.

redo

SUM function

fill handle

copy/paste

1 points   

QUESTION 86

Which keyboard shortcut turns on Edit mode?

[F1]

[F2]

[F4]

[F8]

1 points   

QUESTION 87

Functions may be entered for formulas using all of the following methods except _____?

the Sum list button

the Insert Function button

typing the function

typing the function argument

1 points   

QUESTION 88

How can the order of precedence in this formula, =C12+C13*F4, be changed so that cells C12 and C13 are added together as the first operation that occurs?

=C12+(C13*F4)

=C12*F4+C13

=(C12+C13)*F4

=$C12+$C13*F4

1 points   

QUESTION 89

In Excel, MAX and AVERAGE are examples of _____.

arguments

buttons

lists

functions

1 points   

QUESTION 90

When cells are copied using Excel’s copy function, what happens to the data in the copied cells?

the data is temporarily deleted from the copied cells

the data remains in its original location

the data is moved to another location and removed from its original location

the data is permanently deleted from the copied cells

1 points   

QUESTION 91

An Excel user may paste a range of cells in which of the following locations?

the same worksheet where the cells were copied

a different worksheet

both a. and b.

neither a. nor b.

1 points   

QUESTION 92

When cells or rows are inserted or deleted in an Excel worksheet, how are cell references affected by the insertion or deletion?

the user must insert new cell references

cell references are not affected

the user is prompted to enter new cell references

cell references are automatically adjusted

1 points   

QUESTION 93

An Excel user should use a relative cell reference when it is important to ____.

preserve the exact cell address in a formula

never change the formula

memorize the formula

preserve the relationship to the formula location

1 points   

QUESTION 94

Which function key on the keyboard allows the Excel user to cycle through all possible combinations of relative, mixed, and absolute cell references for a formula?

[F1]

[F10]

[F4]

[F12]

1 points   

QUESTION 95

The file extension .xltx indicates what type of Excel file?

Excel template

Excel worksheet

Excel formulas only worksheet

Excel workbook

1 points   

QUESTION 96

The default file extension for an Excel 2010 workbook is ____.

.xlts

.xlsx

.xslx

.xltx

1 points   

QUESTION 97

Which tab and group will allow the insertion of rows and columns in a worksheet?

Page Layout tab, Page Format group

Home tab, Cells group

Home tab, Styles group

Page Layout tab, Cells group

1 points   

QUESTION 98

All functions begin with the formula prefix ____.

# (number symbol)

+ (plus sign)

= (equals sign)

@ (at symbol)

1 points   

QUESTION 99

Which method of entering a function requires the user to know the name and initial characters of a function?

using the Insert Function button

using the Sum button

using the Sum list arrow

manually typing the function

1 points   

QUESTION 100

Once the Office Clipboard reaches its maximum of 24 items, how does it handle new items that are copied or cut?

the clipboard automatically deletes the oldest item on the clipboard

the clipboard automatically deletes all items and starts over with the new item

the clipboard prompts the user to delete items

the user sees a “clipboard full” message

1 points   

a.

project

b.

spreadsheet

c.

dataform

d.

database

Explanation / Answer

Question1: The correct option (b) spreadsheet
Question2: The correct option (d) worksheet
Question3: The correct option (d) workbook
Question4: The correct option (b) templates
Question5: The correct option (a) create what - if data scenarios
Question6: The correct option (a) sheet tabs
Question7: The correct option (a) scrolll bars
Question8: The correct option (d) eaual sign(=)
Question9: The correct option (b) ^
Question10: The correct option (a) /
Question11: The correct option (c) value
Question12: The correct option (b) function
Question13: The correct option (d) All of the above
Question14: The correct option (a) arrow
Question15: The correct option (a) [Ctrl][Home]
Question16: The correct option (c) [Alt][Page Up]
Question17: The correct option (b) [Ctrl][End]
Question18: The correct option (b) just starting to type
Question19: The correct option (b) equal sign(=)
Question20: The correct option (d) Arithmetic
Question21: The correct option (d) portrait
Question22: The correct option (b) scale to Fit
Question23: The correct option (a) Zoom
Question24: The correct option (b) edit
Question25: The correct option (a) 100
Question26: The correct option (b)5
Question27: The correct option (d) 100
Question28: The correct option (d) format
Question29: The correct option (b) Ribbon
Question30: The correct option (b) two
Question31: The correct option (a) only after data is entered
Question32: The correct option (c) Styles
Question33: The correct option (b) font
Question34: The correct option (c) clip
Question35: The correct option (d) Home
Question36: The correct option (d) Format Cells
Question37: The correct option (d) styles
Question38: The correct option (b) Clipboard
Question39: The correct option (a) alignment
Question40: The correct option (d) AutoFit
Question41: The correct option (d) Review
Question42: The correct option (c) red
Question43: The correct option (c) Home
Question44: The correct option (b) Format Cells
Question45: The correct option (b) Page Layout
Question46: The correct option (b) conditional
Question47: The correct option (a) Review
Question48: The correct option (b) Home
Question49: The correct option (c) column is too narrow to display the value completely
Question50: The correct option (a) Tick

Note : Please post remaining 50 in another post.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.