Excel Test
What is the order arithmetic operation?
(), E, *,/, +,- (please excuse my dear aunt shelly)
In an Excel worksheets, the rectangular area where a column and a row intersect (such as A1) is called a ______,
Cell
A cell referenced in a formula that does not change when copied to another cell is a(n) ______reference.
absolute
A ____ shows the name of a worksheet contained in the workbook.
sheet tab
The name box can be used to:
*go to a cell *assign a name to one or more cells *select a function
What is the default extension that Excel 2013 assigns to files?
.xlsx
Write the resulting value of the expression =3+4*5
23
A ___ workbook is a workbook that has multiple worksheets containing one or more linking formulas.
3D workbook
Write the formula used to multiply cell B6 by cell H1.
=B6*H1
The ____ cell is the current cell, which is indicated by a dark green border.
Active
As you begin typing a label into a cell, the _____ feature searches for and automatically displays any other label in that column that matches the letters you typed.
AutoComplete
How to insert a new worksheet to the right of the current worksheet?
Click Box + at the bottom
To get ot of edit mode without making any changes, press the _____ key.
ESC
When you enter or edit data, click ____ to accept data typed in the active cell and keep the current cell active.
Enter (Blue check mark)
The fill handle is simply a tool used to select multiple cells. (T or F)
False. This is a copy tool.
_____ combine cell references, arithmetic operations, values, and/or functions used in a calculation and must begin with an (=) sign.
Formulas
The ____ _____ feature in Excel allows you to keep one or more rows and/or columns visible on the screen when scrolling a worksheet.
Freeze Panes
Click the _____ to display the dialog box to search for and select a function to insert into the active cell.
Insert Function (Green Fx)
Column headings are ______ at the top of each column.
Lettered
The _____ is an identifier that displays the address of the current cell in the worksheet.
Name Box
________ indicates where the worksheet will be divided into pages.
Page Break Preview
What view shows the margins, header and footer area, and a ruler.
Page layout view.
D5:k27 represents a group of cells, otherwise commonly referred to as a _____ in Excel.
Range
The ______ button is the rectangle with a triangle in it located in the upper-left corner of the worksheet where the row and column headings meet.
Select All- Click it to select everything contained in the active worksheet.
If you workbook contains several worksheets, use the ________ to display the first,previous, next, or last worksheet.
Sheet tab navigation bottons
When you create a new Excel workbook, the default worksheet is named ____.
Sheet1
The ______ displays information about a selected command or operation in progress.
Status bar
When in a cell and you add a row or column, where is it placed.
The added row is above the cell and the column is to the left of the cell.
By default, the formula bar displays formulas the user has entered into a cell, while the result of the formula displays in the worksheet cell. (T or F)
True
Double click on a cell puts you in edit mode and edit is displayed at bottom of the worksheet. (T or F)
True
Formulas always start with an = sign or excel will think it is text. (T or F)
True
Numbers are right aligned by default. (T or F)
True
Text is left aligned by default. (T or F)
True
To select a nonadjacent range, you begin by selecting an adjacent range, and then you press and hold sown the Ctrl key and select other adjacent ranges. (T or F)
True. (only after the first range is selected)
Click the ______to display the worksheet in Normal,Page Layout or Page Break Preview.
View Control
Excel Stores its "documents" as files called______.
Workbooks
The ____ is the current cell.
active cell
When you enter or edit date, click ___ to cancel the data entry or edit and revert back to the previous data in the cell.
cancel (RED X)
The intersection of a of column & a row is a ___.
cell
Each cell has a unique ________.
cell address
In Excel charting, the chart legend identifies the format or color of each ______ series.
data
The forward slash (/) symbol is used as an arithmetic operator in Excel to perform a ____ operation.
division
You can enter or ____ cell contents here or directly in the active cell.
edit
The _____ shows the contents of the active cell.
formula bar
A specific region you create in the worksheet to store and change the variables used in calculations
input area
In Excel charting, the chart ______ identifies the for format or color of each data series.
legend
Numeric values may appear as #### if a column is too _____.
narrow
Row heading are ____ to the left of the rows.
numbered
The region in the worksheet to contain formulas dependent on the values in the input area .
output area
A _____ is an electronic file that contains a grid of columns and rows used to organize related data and to display results of calculations, enabling interpretation of quantitative data for decision making.
spreadsheet
In Excel, formulas and functions must be written according to specific set of rules called the ___.
syntax
Normal view displays the worksheet _____ showing margins, headers, footers, and page breaks.
without
A ______ is a collection of one or more related worksheets contained within a single file.
workbook
In Excel, a _____ is a single spreadsheet that typically contains descriptive labels, numeric values, formulas, functions, and graphical representations of data.
worksheet
