BUSINESS AND TECHNOLOGY 4.5 WEEK EXAM

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

range

A _____ of cells is simply a group of move than one cell. They can be adjacent or nonadjacent.

False

A worksheet can contain a maximum of 1,000 columns and 10,000 rows.

keywords

Assigning _____ to the document properties makes it easier to organize and find documents.

Print Preview pane

Backstage view includes a ______ in the Print dialog box so you can preview your workbook as you choose Print options.

True

Backstage view's left-side navigation pane gives you access to workbook and file-related commands such as Save, Save As, and Close.

all of the above

By clicking the arrow to the Insert button in the Cells group of the Home tab, you can insert________. cells, rows, or new worksheet.

Save, Undo, amd Redo

By default, the Quick Access Toolbar contains the commands:

natural series

By definition, a ______ is a formatted series of text or numbers.

all of the above

Cell styles may contain predefined formatting for which of the following? font face, font size, or special effects

Dialog Box Launcher

Certain command group headers in the Ribbon tabs have an arrow in the lower right corner called a ______.

text

Characters such as "a","&", and "G" are examples of which type of data?

KeyTips

Depressing amd holding the Alt key will display the ______ on the Ribbon?

number

Each row in a worksheet is identified by a unique _______.

False

Fast Commands in the Backstage View include Save, Save As, and Close.

Save As

How do you save an existing workbook as a new name after changes are made?

Switch Windows

If you have teo differnt workbooks open at the same time, which of these commands lets you move from one to the other?

230970

If you key $230,970 into a worksheet cell, what appears in the Formula bar?

More

If you want to add commands to the Quick Access Toolbar that do not appear in the drop down list, click _____ Commands on the drop-down list.

Select first cell, hold down Ctrl key, select additional cells.

Nonadjacent cells may be selected by using which of the following methods?

a manual line break

Pressing Alt + Enter while a cell is in edit mode will result in ________.

formatting

The Format Painter can copy and paste which of the following?

False

The Quick Access Toolbar cannot be altered in any way.

four

The Split command enables you to overcome this limitation by viewing the worksheet in _____ quadrants.

Print

The _____ command in Backstage view offers a number of options for customizing printed workbooks.

Home

The _____ tab contains formatting commands used to enhance a worksheet's appearance.

Calibri

The default, or predefined, font for Excel 2010 is 11-point_______.

click the row heading

The easiest way to select an entire row is to _______.

False

The main purpose of the Ribbon is to allow you to move easily from the one worksheet to another within a given workbook.

True

The navigation pane contains a series of tabs --- Recent, Info, New, Print, Save &Send, Help, and Options--- that you can click to access functions akd commands.

delete

To erase the contents of cell M25, select the cell and then press_____.

name box

To quickly move from cell D20 to cell R42, you can key "R42" into the ________ and press Enter.

Ctrl+O

Use the following command to open a workbook.

1) Click drop down arrow in the Quick Access Toolbar. 2) Backstage and Options 3) Right click on any tools Quick easier access that have what you need.

What are the steps in customizing the Quick Access Toolbar? What is an advantage to customizing this toolbar?

Format Cells

What dialog box let's you change the font used in a cell?

April, May, amd June are automatically entered into the three cells.

What happens if you key Match in cell B4 and then drag the full handle to select the next three cells in row B?

The text extend into the next cell.

What happens if you key text that is longer than the width of a cell?

A1

What is the address of the first cell in a worksheet?

clear

What is the default background of an Excel worksheet?

Split is when you can split and look at multiples parts of the same document. New Window is a new window of the same document. - Charts

What is the difference between the Split command and the New Window command? Give an example of a situation in which the Split command would be useful.

wrap

When a cell is formatted to _______ text, any data in the cell automatically breaks to fit the column width.

down

When inserting a new cell into a worksheet, existing cells in the same column will shift _______.

right

When inserting a new cell into a worksheet, existing cells in the same row will shift ______?

enter

When keying data, pressing _______ moves you to the beginning of the next row.

Sheet 1

When you create a new workbook, what is the default name for its first worksheet?

File tab Fast and Definitive commands

Where can you locate Backstage View on Excel and what is the importance of Backstage View?

In the active cell

Where does the information you key into a worksheet appear?

I'm in the lower-right corner of each worksheet cell

Where is the full handle located?

Tab

Which is the following would you press to move form G3 to H3?

blank workbook

Which of the following appears when you first launch Excel?

Fill

Which of the following is not a command in the Clipboard group on the Home tab?

Ctrl+:

Which of the following will insert the current time into a worksheet cell?

font used in the document

Which of the following would not be listed in a document's properties?

Close

Which of these commands can be accessed by clicking the File tab?

False

While you can print only one worksheet in a workbook, you cannot print only a portion of a worksheet.

right-click

You can ______ any icon on the Ribbon and instantly add it to the Quick Access Toolbar.

Backstage

You can use the Print options in _____ to point only a selected portion, or print area, of an Excel workbook.

As

You can use the Save ______ command to permanently save a workbook so that you can access it again at a later time.

adding and subtracting

You can't change the size of the Quick Access Toolbar, but you can customize it by ______ command buttons.

Backstage view

_____ enable you to access your workbook properties more easily and view them in one window.


संबंधित स्टडी सेट्स

Chapter 12 Management of patients with oncologic disorders

View Set

test over Daniel,Ezra, Esther and Nehemiah

View Set

ch 71 Care of Patients with Acute Kidney Injury and Chronic Kidney Disease

View Set

Sociology 101 final ch.11,12,13,14&17

View Set