COM S WEEk 1 QUIZ 1

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

Which of the following would not be considered text?

= 2*2

The position of data between the cell margins.

Alignment.

Which of the following is not a valid keystroke for navigating around a worksheet?

Alt + Up arrow

What is a fast way to apply several formats at one time?

Apply a cell style.

Helps complete a logical sequence

Auto Fill

Enables you to copy the contents of a cell or cell range or to continue a sequence by dragging the fill handle over an adjacent cell or range of cells.

Auto Fill.

Matches the letters you type to another value in the column if the letters match

AutoComplete

Given the formula =B1*B2+B3/B4^2, what operation is calculated first?

B4^2

Reverts back to previous data

Cancel

The intersection of a column and a row.

Cell.

You selected and copied worksheet data containing formulas. However, you want the pasted copy to contain the current formula results rather than formulas. What do you do?

Click the Paste arrow in the Clipboard group and select Values & Source Formatting

The letter in the cell reference "F4"

Column heading

The horizontal measurement of a column.

Column width.

Moves active cell to column A, row 1

Ctrl + Home

Which of the following characteristics is not applicable to the Accounting Number Format?

Dollar sign immediately on the left side of the value

This does nothing by itself

End

Accepts the data

Enter

Looks like a check mark next to the formula bar

Enter icon

Which step is not part of planning a worksheet design?

Enter labels, values, and formulas

In Excel, columns are identified by numbers and rows by letters.

False

The cell at row 4 and column B, would be identified as 4B.

False

The contents of a cell can be seen in the naming box.

False

You cannot hide column A or row 1 because they cannot be unhidden.

False

Which of the following is not an alignment option?

Fill Color

The background color appearing behind data in a cell.

Fill color.

Small green square used to perform various actions

Fill handle

A small green square at the bottom-right corner of a cell.

Fill handle.

Displays the content (text, value, date, or formula) in the active cell.

Formula Bar.

Shows the contents of the active cell

Formula bar

A combination of cell references, operators, values, and/or functions used to perform a calculation.

Formula.

Always begins with an equals sign (=)

Formulas

Moves active cell to column A in that row

Home

What should you do if you see pound signs (###) instead of values or results of formulas?

Increase the column width

Assume that the data on a worksheet consume a whole printed page and a couple of columns on a second page. You can do all of the following except what to force the data to print all on one page?

Increase the left and right margins

A range of cells containing values for variables used in formulas.

Input area.

Besides the Page Setup dialog box, where else can you create headers or footers?

Insert tab, Text group, Header & Footer

What is not one of the tabs in Excel?

Mailings

Displays the address of the active cell

Name Box

Identifies the address of the current cell.

Name Box.

Does not display margins or page breaks.

Normal view

Rules that control the sequence in which Excel performs arithmetic operations.

Order of operations.

A range of cells containing results based on manipulating the variables.

Output area.

Displays data and page breaks

Page Break Preview

Moves active cell down one screen

Page Down

Displays data and margins

Page Layout view

Also known as semi-selection

Pointing

How can you display formulas within the cells instead of the cell results?

Press Ctrl + `

A group of cells selected at the same time.

Range

A rectangular group of cells.

Range.

Moves right one cell in the same row

Right arrow

The number in the cell reference "F4"

Row heading

The vertical measurement of a row.

Row height.

Also called pointing.

Semi-selection

Allows you to go to the first, previous, next, or last sheet in a workbook

Sheet tab navigation

Displays the name of a worksheet within a workbook.

Sheet tab.

Displays information about a command or operation as it is being performed

Status bar

A combination of letters not used in calculations.

Text

Includes letters, numbers, symbols, and spaces.

Text.

What does pressing the Enter key while in a cell, do?

The value is set, and the cell below becomes the active cell

The fill handle allows you to copy and paste formulas to adjacent cells.

True

Using Alt + Enter is a text wrapping option.

True

You can hide or delete multiple rows or columns by using the Ctrl or Shift key and then selecting the rows or columns you want to hide or delete.

True

A measurable amount.

Value

A number that represents a quantity or an amount.

Value.

You just copied a range of data containing formulas. However, you want to preserve the formula results and the original number and text formatting in the pasted range. Which paste option would you select?

Values & Source Formatting

Icons that let you change views

View controls

A file containing related worksheets.

Workbook.

A spreadsheet that contains formulas, functions, values, text, and visual aids.

Worksheet.

Formatting that enables a label to appear on multiple lines within the current cell.

Wrap text.

The last possible column in a worksheet.

XFD

Allows you to see more or less on the screen at one time

Zoom control

The best way to apply Page Setup options to multiple worksheets is to ...

group worksheets

A range is specified by its ...

top left and bottom right cells


Kaugnay na mga set ng pag-aaral

Human Physio Ch. 11 Auto and Somatic Motor Control

View Set

Chapter 10- Customer Relationship Management

View Set

LC13: LearningCurve - Ch. 13: Monopoly

View Set

Rational and irrational numbers step by step

View Set

Module 12 Helping and prosocial behavior

View Set