Excel Chapter 1

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

Excel remembers the last ____ actions you have completed

100

How many chart types does Excel offer

15

To get the the next line, click

ALT + ENTER

Pressing the ____ key to complete an entry activates the adjacent cell the the right.

Arrow

The _____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.

Auto Correct

The _____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.

Auto Fill Option

The _____ button allows you to choose whether you want to copy the values from the source area to the destination area with or without formatting.

Auto Fill Option

Which of the following features helps Anita be more productive by automatically reducing the number of misspelled or mistyped words.

AutoCorrect

To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key

BACKSPACE

While typing in a cell, you can press the ____ key to erase all the characters back to and including the incorrect character you just typed.

Backspace

You can apply the Bold font style by pressing the ____ keyboard shortcut keys.

CTRL + B

Pressing the ____ keyboard shortcut key selects cell A1.

CTRL + Home

To move to the first cell

CTRL + Home

To get current date

CTRL + Semicolon

The deault font for a new workbook is _____ 11 point regular black

Calibri

To use he AutoCalculate area, first select the range of cells containing the numbers you want to check. Next, right-click the AutoCalculate area to display the Customize status Bar shortcut menu.

Commonly used: average, count, numerical count, minimum, maximum, and sum.

____ properties are associated with all Microsoft Office files and include author, title, and subject.

Document

Which of the following Excel features helps Anita be more productive by helping her more easily organize and identify her workbook files.

Document properties

Which of the following keys moves the insertion point to the end of data in a cell.

End

_____ indicates how characters are emphasized.

Font style

Which of the following keys moves the insertion point to the beginning of data in a cell?

HOME

Which of the following is the Ribbon path to the Cell Styles button

HOME tab / Styles group

Which of the following keys toggles between Insert mode and Overtype mode.

Insert

_____ cells involves creating a single cell by combining two or more selected cells.

Merging

The active cell reference appears in the _____ on the left side of the formula bar.

Name box

Excel's ____ function, which adds all of the numbers in a range of cells, provides a convenient means to calculate a total

SUM

____ is/are used to place worksheet, column, and row titles on a worksheet.

Text

A character with a point size of 10 is about 10/72 of one inch in height

True

A requirements document includes a need statement, source of data, summary of calculations, and any other special requirements for a worksheet

True

The group of adjacent cells beginning with B4 and ending with B8, written as B4, is called a range.

True

The opposite of merging cells is splitting a merged cell.

True

The ___ button allows you to erase recent cell entries.

Undo

=NOW()

Updates current date

You use _____ to view an XPS file.

XPS Viewer

What effect does the Account Number Format have on the select cells

assigns a fixed # sign to the numbers in the range and rounds the figure to the nearest 100th

The date you change a file is an example of a

automatically updated property.

To enter data in a cell, you must first select the

cell

A _____ conveys a visual representation of data.

chart

You can enter the correct range in a function by typing the beginning and ending cell references separated by a

colon

A given range contains the data that determines the size of slices in a corresponding pie chart; these entries are called

data series

The range of cells receiving the content of copied cells is called the

destination area or paste area

Clicking the ____ box completes an entry.

enter

A pie chart with one or more slices offset is referred to an an ___ pie chart.

exploding

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

format

As you type, Excel displays the entry (and the Cancel and Enter box) in the

formula bar

_____ involves reducing the electricity consumed

green computing

Like an area chart, a ____ chart often is used to illustrate changes in data over time.

line

What effect does the Comma Style format have on the selected cells

makes larger numbers easier to read

Combining two or more selected cells into one cell is called ____ cells.

merging

The easiest way to select a cell is to move the block _____ plus sign

pointer to a cell and then click.

Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY

recognizes letter, hyphen and space

A ____ reference is an adjusted cell reference in a copied and pasted formula

relative

The automatically adjusted cell reference in a pasted formula is called a

relative reference.

The person or persons requesting the worksheet shoul supply their requirements in a _____ document.

requirements

Perry decides that before either of his employees creates a new workbook he must give them a

requirements document

In a worksheet, ______ typically contain information that is similar to a list.

rows

Perry also decides that he should approve ____ of any proposed worksheet.

sketch

The first step in creating an effective worksheet is to make sure you

understand what is required.

An Excel ____ allows data to be summarized and charted easily.

worksheet


Set pelajaran terkait

Reproduction and Clotting NUR 2712C

View Set

Molecule 3 Chapter 16-18 questions

View Set

Chapter 13 Molecular Microbiology

View Set