CSC final

Which of the following functions inserts the total of a range?

Group of answer choices

SUM

ROUND

AVERAGE

AUTOSUM

SUM

To combine multiple cells into one and center its content, you change the cells' style.

Group of answer choices

True

False

false

Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?

Group of answer choices

The formula =TOTAL(B6-B10)

The formula +SUM(B6-B10)

The formula =B6+B7+B8+B9+B10.

The formula =SUM(B6:B10)

 

The formula =SUM(B6:B10)

When you cut or copy a cell, it is cut or copied to which of the following?

Group of answer choices

Only the Office Clipboard

Only the Windows Clipboard

Both the Windows and Office Clipboard

Neither the Windows or Office Clipboard

 

Both the Windows and Office Clipboard

1

How many actions does the Undo button let you reverse?

Group of answer choices

75

50

100

24

100

A predesigned combination of formats, such as font size and color, is called a cell default.

Group of answer choices

True

False

false

The default worksheet text is _____-point Calibri.

Group of answer choices

11

10

12

14

11

Which of the following is the temporary Windows storage area that holds selections you copy or cut?

Group of answer choices

Clipboard

Name box

Worksheet window

Backstage

Clipboard

You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell?

Group of answer choices

Page  Break Preview

mode indicator

Fill handle

scroll bar

 

Fill handle

To align currency symbols and decimal points in a column of numbers, you can apply the ____ number format.

Group of answer choices

General

Percentage

Accounting

Currency

 

Accounting

You can start Excel using the Start button on the Windows taskbar or a shortcut on your desktop.

Group of answer choices

True

False

True

Which of the following tabs lets you set worksheet print options?

Group of answer choices

Home

View

File

Page Layout

 

file

Which of the following can you use to insert a formula using a function?

Group of answer choices

Copy and paste a cell containing a function

AutoSum button on the Ribbon

Insert Function dialog box

AutoSum list arrow on the Ribbon

Copy and paste a cell containing a function

 

AutoSum button on the Ribbon

 

Insert Function dialog box

 

AutoSum list arrow on the Ribbon

To change the color of cell content, you use the ________ color list arrow.

Group of answer choices

Pattern

Text

Cell

Font

font

Where can you see a preview of how your worksheet will look when printed, including headers?

Group of answer choices

File preview

Page Break preview

Print tab in Backstage view

Normal view

 

Print tab in Backstage view

To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?

Group of answer choices

Page Layout

View

Home

Insert

Page Layout

To customize the status bar, right click on the status bar to open the Customize Status Bar menu and uncheck the items that you don't  want to show.

Group of answer choices

False

True

true

Which of the following lets you search for a function or select one from a category?

Group of answer choices

formula bar

clipboard

Insert Function dialog box

Function Arguments dialog box

 

Insert Function dialog box

When you double-click a cell's right column border, which of the following occurs?

Group of answer choices

AutoFit resizes the column to the widest cell entry.

AutoFit resizes the column to 8.43 characters wide.

The column is deleted.

A column is added to the right of the column's border.

 

AutoFit resizes the column to the widest cell entry.

Which of the following lets you apply bold formatting to a selected cell? Select all the options that apply.

Group of answer choices

Insert tab

Format Cells dialog box

Home tab

Mini toolbar

Format Cells dialog box

 

Home tab

 

Mini toolbar