BUSINESS AND TECHNOLOGY 4.5 WEEK EXAM
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.
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.