Excel Quiz 1

Ace your homework & exams now with Quizwiz!

What are Excel's default top and bottom margin settings?

.75

By default, what file name extension is given to Excel workbook files?

.xlsx

How many items can the Office Clipboard hold?

24

Which of the following characters precedes Excel functions?

=

Which of the following displays in a cell when you click AutoSum?

=SUM()

Which of the following methods inserts a manual line break in a cell?

Alt+Enter

Which of the following features resizes column width or row height to fit the width or height of the longest or tallest entry?

AutoFit

What key do you press to select non-adjacent worksheets?

Ctrl

Which of the following keyboard shortcuts opens the Format Cells dialog box?

Ctrl+1

Which of the following keyboard shortcuts opens a new blank workbook?

Ctrl+N

Which of the following keyboard shortcuts cuts cells or a range?

Ctrl+X,

Which format should you use to save a file if you want it to be compatible with earlier versions of Microsoft Excel?

Excel 97-2003 Workbook

In Excel, which of the following keys opens the Save As dialog box?

F12

Which of the following activates edit mode?

F2

The default paste option is Keep Source Formatting.

FALSE

Which of the following options simplifies the process of entering the months of the year in a worksheet?

Fill Handle

Which of the following options copies formatting attributes and styles from one cell to another cell or range?

Format Painter

Which of the following paste options copies all data and formulas from the source cell(s), but not the formatting?

Formulas

Which of the following statements is not true when hiding rows?

Hiding a row deletes the data from the row

Which of the following Spelling dialog box options skips all occurrences of the same spelling of a label?

Ignore All

Which of the following Page Setup dialog box tabs includes an option to set margins for headers and footers?

Margins

Which of the following Page Setup dialog box tabs are used to change the orientation of a worksheet?

Page

Which of the following is the default paste option?

Paste

Which of the following commands enlarges or shrinks printed data to fit a specific number of pages or a particular paper size?

Scale to Fit

Which of the following Page Setup dialog box tabs are used to identify a Print area other than the entire worksheet?

Sheet

What key do you press to select adjacent worksheets?

Shift

Which of the following keyboard shortcuts inserts a worksheet to the left of the active sheet?

Shift+F11

In the Excel window, which of the following continuously displays the buttons for switching worksheet views?

Status bar

A print area is the data that prints from a print command.

TRUE

Which of the following is not true when inserting and deleting columns?

To insert multiple columns or rows, each column or row is inserted individually

A cell style is a set of formatting elements that includes font style, size, color, alignment, borders, and fill, as well as number formats.

True

In Excel, an indent moves cell contents away from the left edge of the cell.

True

How do you enter a number as a label in a cell?

Type an apostrophe before the number

Which of the following best describes the size of an Excel worksheet?

Type an apostrophe before the number

Which of the following commands displays a label on multiple lines within a cell?

Wrap text

What is selected when you click the Select All button located above the row 1 heading and to the left of the column A heading?

all worksheet cells

By default, how does Excel align labels in a cell?

bottom left of a cell

By default, how does Excel align values in a cell?

bottom right of a cell

Which of the following displays the result of a formula?

cell

Which of the following displays when you place the pointer on the border of a selected cell or range?

move pointer

Which of the following is the name used to describe a rectangular group of cells?

range

Which of the following appears when you move the pointer over a cell?

selection pointer

What is selected when you point to and click a column heading?

the entire column

Before using the Merge & Center command, what cell should contain the data?

upper-left cell of the selection


Related study sets

Texas Principles of Real Estate 1 (Second Set)

View Set

To Kill A Mockingbird Characters Chapters 1-7

View Set

Chapter 38: A World Without Borders

View Set

Ch 20 - Hematologic Disorders : PrepU

View Set

Topic 7: Final Test: The Business of IT

View Set

Computer Science 102 Final Study 1

View Set