Shared Flashcard Set

Details

Excel Chapters 1-3
Excel Exam
26
Other
Not Applicable
01/23/2017

Additional Other Flashcards

 


 

Cards

Term
_ are a collection of worksheets.
Definition
Workbooks
Term
What is the title of the blank workbook that opens when you first start Excel from the windows start menu?
Definition
Book1
Term
The number of worksheets that a workbook can contain is _
Definition
Limited by computer memory
Term
In excel, any set of characters containing a letter, hyphen (as in telephone number), or space is considered _.
Definition
Text
Term
If you prefer using the keyboard, instead of the mouse, you can press ALT key on the keyboard to display a (n)_.
Definition
Key tip badge
Term
In excel, anumber can contain the characters
Definition
All of the above
Term
To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 or you can type _.
Definition
6K000
Term
A _ is a series of two or more adajacent cells in a column or row or a rectangular group of cells.
Definition
Range
Term
Saving the workbook frequently is important for the following reason:
Definition
If you lose power, the worksheet could be lost
Term
Changing the font type, changing the font style to bold, increasing the font size, and changing the font color is called _.
Definition
Adjusting, coloring and sizing and formatting
Term
Combining two or more cells together is called _ cells.
Definition
Merging
Term
Dividing a cell into more than one cell is called _.
Definition
Splitting
Term
What effect does the Accounting Number Format have on the selected cells?
Definition
Causes cells with two decimal places to align vertically correct.
Term
What effect does the Comma Style Format have on the selected cells?
Definition
Causes the cells to display with two decimal places and commas as thousands seperators
Term
which key on the keyboard toggles between insert and overtype mode?
Definition
Insert
Term
which keyboard key moves the insertion point to the beginning of a data in a cell?
Definition
Home
Term
The _ button on the home tab is the only command that clears btoh the cell entry and the cell formatting.
Definition
Delete
Term
When you click the _, located in the upper left corner of the woindow as shown in the accompying figure, Excel diplays the office button
Definition
Office Button
Term
The commandsto insert a chart are located on the _ tab.
Definition
Insert
Term
To start a new line in a cell, press _ after each line,
Definition
Tab+Enter
Term
If a cell has a two-digit year of 32, Excel automatically changes it to a four-digit year of_
Definition
1932
Term
Every time you enter a value into a cell in the worksheet, Excel automatically _ formulas
Definition
Recalculates all
Term
When excel follows the order of operations, the formula 8*3+2, equals
Definition
26
Term
All of the following are valid excel arithmetic operators except _.
Definition
>
Term
When an error occurs in a formula in a cell, excel displays the _ buttonnext to the cell and identifies the cell with the error by placing a green triangle in the upper left of the cell.
Definition
Trace Error
Term
Using the _ button on the ribbon instructs Excel to display additional decimal places ina cell.
Definition
Increase Decimal
Supporting users have an ad free experience!