Random Quiz Flashcards
A group of adjacent cells in an Excel worksheet is called a
Range
A predefined formula that is a shortcut for commonly used calculations is a
Function
The _______ in an Excel file is the individual page
Worksheet
The characters +, -, *, and / are examples of
Operators
Assigned alphabetic labels
Excel columns
Begins with equal sign
Excel Formula
Displays the cell reference for the active cell
Name box
Represented by numbers
Excel rows
View that allows you to see your worksheet as it appear when printed
Print preview
This part of the excel screen displays the contents of the active cell
Formula bar
Opening an excel file using, excel 2013, although the file was created in an earlier version causes excel to
Switch to compatibility mode, in which you can work with the file in its original format
A cell reference in a formula that DOES NOT change when it is copied is called
Absolute reference
Inserted rows are placed _____ the selected row and inserted columns are placed to the ______ of the selected column
Above; left
What command button automatically creates a formula that contains a sum function
AutoSum
Suppose a cell in your worksheet contains this formula: =B$7*0.5. How would this formula change if it were copied to another cell?
The column will change, but the row will remain fixed at row 7
To create an absolute cell address, type this character in front of the column letter or row number that you do not want to change
Dollar sign $
Microsoft _____ is a computerized spreadsheet program
Excel
A cell reference in a formula that DOES change when it is copied is called
Relative reference
When excel starts, a new file, called a _____ is created
Workbook
You change the name of a worksheet by
Double- clicking the sheet tab
A pie chart with one or more slices separated from the whole
Exploded
