Excel 1

Ace your homework & exams now with Quizwiz!

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 Page Setup options lets you set the Print area by selecting a specified range of cells?

AutoFit

What name does Excel automatically assign to a new workbook that you open?

Book1

To select non-adjacent worksheets, which key must you press?

CTRL

Once you have saved a workbook for the first time, which of the following keyboard shortcuts can you use to save it again?

Ctrl+S

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

Ctrl+X

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

F12

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

Fill handle tool

Which of the following Spelling dialog box options skips all occurrences of the same spelling of a word in the worksheet?

Ignore All

What is True of a workbook that is opened or copied from an online source?

It will open in protected view

Which of the following paste options is the same as the "Paste" option?

Keep Source Formatting

Which of the following features would you want to use to center worksheet titles over multiple cells?

Merge & Center

Which of the following Page Setup options lets you change the orientation of a worksheet to Portrait or Landscape?

Page layout

To select adjacent worksheets, which key must you press?

SHIFT

Which of the following Page Setup options lets you set the Print area by selecting a specified range of cells?

Sheet

Which of the following statements is False?

Sheet tab names cannot be more than 15 characters

Which of the following displays the result of a formula?

cell

By default, Excel 2016 workbooks are saved as .xlsm files.

false

Which of the following describes the section of the worksheet that prints?

print area

Which of the following can't be added to the Info pane in the Backstage view of a Microsoft Excel file?

timing

A "print title" is a row or column of data that is repeated on each printed page.

true

In Excel, a rectangular group of cells is called a range.

true

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

true

The header and footer margins for a worksheet are 0.3.

true


Related study sets

Practice and Learn: Posttraumatic Stress Disorder

View Set

Chapter 37 Hematological Disorders

View Set

Marketing Management - Iacobucci - Ch 9

View Set

Chapter 4 - Development of dominant-minority group relations in pre-industrial America

View Set

Ch. 5: Planning the Foundation of Successful Management

View Set

ACT 5. Romeo and Juliet All Study Guide Questions and Answers

View Set