Excel Unit A Flashcards
Excel
An application you use to perform numeric calculations and to analyze and present numeric data?
Electronic Spread Sheet
In excel, the electronic spread sheet you work in is called a?
Worksheet
Where a worksheet is saved and contained in a xlsx
Workbook
Any Time you use a worksheet to ask the question what if you are preforming a?
What-if Analysis
You can use Predesigned, formatted files called
Templates
The intersection of a column and a row is called a
Cell
A combination of a letter and a number that specifies the column and row in which a cell is located on a spreadsheet
Cell address
Displays the active cell address “A1” appears in the
Name Box
Allows you to enter or edit data in the worksheet
Formula Bar
Contains a grid of columns and rows
Worksheet Window
A dark rectangle that outlines the cell you are working in
Cell Pointer
The cell pointer outlines cell A1, so A1 is the
Active Cell
Below the worksheet grid let you switch from sheet to sheet in a workbook
Sheet Tabs
Located at the bottom of the excel window, it provides a brief description of the active command or task in progress
Status bar
In the lower left corner of the status bar provides additional information about certain tasks
Mode indicator
A selection of two or more cells such as b5:b14: is called a
Range
An equation in a worksheet
Formula
Are entries that contain text and numerical information not used in calculations
Labels
Are numbers, formulas, and function that can be used in calculations
Values
The information necessary to calculate an answer, as well as cell references and other unique information
Arguments
A built in formula that includes the arguments
Function
You can change the contents of an active cell at any time
Edit
You can use excels feature to automatically save your work as often as you want
Auto Recover
Excel worksheet start with the equal sign followed by cell addresses, range names, values, and calculation operators
Formula Prefix
Indicate what type of calculation you want to perform on the cells, ranges, or values
Calculator Operators
Perform mathematical calculations
Arithmetic Operators
Join strings of text in different cells
Text concatenation Operators
enable you to use ranges in calculations
Reference Operators
Shows the worksheet without including certain details like headers and footers, or tools like rulers and a page number indicator
Normal View
Provides a more accurate view of how a worksheet will look as printed
Page Layout View
Options to reduce the size of the worksheet to better fit the printed box
Scale To Fit