BUS 1305 Exam 2
Relative Cell reference (B4)
Cell address in a formula that automatically changes to reflect the new location when the formula is copied or moved
MacOS
Macintosh desktop computer and laptops
FV (rate, period, payment)
Returns the future value of an investment based on periodic constant payment and a constant interest rate
FV function
Returns the future value of an investment based on periodic, constant payments and a constant interest rate
cell
A box formed by the intersection of a row and column in a worksheet or a table, in which you enter information.
Gallery
A collection of choices you can browse through to make a selection. Often available with Live Preview.
Goal seek
problem-solving method in which you specify a solution and then find the input value that produces the answer you want
Debugging
process of finding and correcting errors in the worksheet
Uninterrupted power supply
protect against blackouts and brownouts
Start menu
provides access to all applications and apps installed on your device
Destination range
range is used as a destination
One-input data table
range of cells that shows resulting values when one input value in a formula is changed
RV (rate, period, payment)
returns the present value of an investment the present value is the total amount that a series of future payments now is worth
Pane
section of a window, such as navigation pane
Order of operations
sequence in which operators are applied in calculation
Data series
set of values represent in a chart
Cycle
show a continual process
matrix
show how part relate to a whole
list
show non-sequential information
Pyramid
show proportional relationships with the largest component at the top or bottom
Process
show steps in a process or timeline
Conditional formatting
special formatting that is applied to values that satisfy some criterion
Function
special predefined formula that provides a shortcut for a commonly used calculation; SUM or COUNT
Layout
specifies the arrangement of placeholder on slide
MacOS server
supports all sizes of networks and servers. One unique feature is that it lets authorized users access servers in their iPhone or other apple devices
Environment
toxic electronic component of computer that expose device to discarded
Office.com
use additional layout available for office.com
Memory
volatile memory, nonvolatile memory, RAM, Cache, Virtual memory, ROM, Flash memory
source range
when a range is used as a source
IF function
when you want to assign a value to a cell based on a logical test
Justified
where the first and last characters of each line are aligned and extra space is inserted between words to spread the characters evenly across the line
Format symbols
which assign a format to numbers as they are entered
Direct circular reference
A formula refers to the same cell in which is entered.
Boot process
1. Computer receives power and sends it to the circuitry 2. Processor runs the boot strap program 3. Bootstrap program executes a series of tests to check the components 4. computer loads the operating system files into RAM including kernals 5. Computer loads system configuration info and loads start up program
Point
1/72 inches of a height
AVERAGE function
Calculates the arithmetic mean, or average, of values in a range.
Absolute cell reference ($B$4)
Cell address that refers to a specific cell and does not change when you copy the formula
Mixed cell reference ($B4, or B4$)
Cell reference combines both absolute and relative cell addressing
Resources
Components required to perform work, window task manager, interact with a GUI
What is Excel
Excel is a powerful app that allows user to organize data, complete calculations, make decisions, graph data, develop professional looking reports, publish organized data to web, and access real-time data from websites
Overtype mode
Excel replaces or overtypes the characters
Picture
Include a placeholder for picture within the graphic
NOW function
Returns a number that corresponds to the system date and time beginning with December 31, 1899
PMT function
The financial function to calculate the amount paid into an investment or loan during each payment period
System Software
The software that runs the computer, and includes the operating system and utility programs.
Windows Server
a version of Windows that has been specially designed and configured for server use
Slide master
all five slides are created by starting with a overall template that is formatted with a theme and customized title and text font
Web support
allows user to save excel worksheet or parts of a worksheet in a format that user can view on web
point mode
allows you to select cells for use in a formula by using the pointer on screen top
two-input data table
allows you to vary the values in two cells, but you can apply a two-input data table to only one formula
Number
amount or value using any of the following characters; 1,2,3,4,5,6,7,8,9,+,-,(),/,.,$,E,e
Input
any data and instructions entered into the memory of a computer
Tool tabs/Contextual tabs
appear in addition to main tabs on the ribbon when you perform certain task
Column heading
appears above each worksheet column to identify it
standard properties
associated with all office files
Insertion point
blink vertical line that indicates where test are to be inserted
PMT (rate, period, loan amount)
calculate the payment for a loan based on the loan amount, constant payment, and constant interest rate
Relative reference
cells that automatically change to reflect the new location when the formulas are copied or moved
Unprotected cells
cells whose values you can change at any time
Protected cells
cells you cannot change
Sepia
changes the photo colors into brown, gold, and yellow, reminiscent of a faded photo
Spelling checker
checks a worksheet for spelling errors
Range Finder
checks which cells are referenced in the formula assigned to the active cell
Chrome OS
chromebook laptops
Deck
collection of slides in a presentation
Cell reference
column letter and row number location that identifies a cell within a worksheet (such as A1)
data series
column or row in a datasheet and also the set of values repented in a chart
Ribbon
contains tabs of grouped command button
LINUX
desktop computers, laptops, and some tablets
Document properties
details about a file such as project author, title and subject
MIN function
determines the lowest number in the range
Cluster Column Chart
displays in the insert chart dialog box
MAX function
displays the highest value in a range
Standard Properties
document properties associated with all microsoft office files, includes author, title, subject
Operating system features
graphical user interface, utilities, software as a service, open/closed source
status bar
grey bar that show status info about current worksheet
table
grid consisting of rows and columns that can contain test and graphics
Scroll bar
let you view a doc that is too large to fit screen
Cell name
name you assign a cell or range
Nested IF function
one in which the action to be taken for the true or false case includes another IF function
Variant
one of the easier methods of developing a custom show
Command
performs a specific action
Accessibility
refers to the practice of removing barriers that may prevent individuals with disabilities from interacting with data or an app
Range
series of two or more adjacent cells
Risks to behavior
tech addiction sedentary lifecycle psychological development social interaction
Output
information processed into a useful form
Sceentip
label that appears when you point to a button or object
Charts
Excel can draw a variety of charts, column charts and pie
Flash fill
Excel feature that looks for patterns in the data and automatically fills or formats data in remaining cells.
Workbook/worksheet
like a notebook, inside sheets that let you enter and manipulate data
Gridlines
make worksheet easier to read
Formula
mathematical statement in a speadsheet or table cell that calculates a value using cell references number, and arithmetic operators such as +,-,*,/
Tables
organize and store date within worksheets
Menu
A list of related items, including folders, programs, and commands.
level
A position within a structure, such as an outline, that indicates the magnitude of importance.
SmartArt style
A pre-set combination of formatting options that follows the design theme that you can apply to a SmartArt graphic.
Operating system (OS)
A program that manages and controls a computer's activities (e.g., Windows, Linux, Solaris).
Office Clipboard
A temporary storage area where a selection may be held until it is pasted into a new location.
Windows
Desktop computers, laptops and some tablets
Fill without formatting
Fill destination area with contents without formatting
Fill months
Fill destination area with series of months using format of source area
Three main types of hazards from computers
Information, Environment, Health
Color Cast
One color dominates the picture
Online Risk
Online banking e-commerce shopping fake website social media data mining
Page layout view
Provides an accurate view of how a worksheet will look when printed, including headers and footers.
Attackers
Script kitties Hactivist Cyberterrories nation state actors Insiders
Fill handle
The box that appears in the lower-right corner of a selected cell or range
Merge Cells
To combine two or more cells into one.
Malware
Viruses, worms, Trojan horses, spyware, and adware.
Dialog Box Launcher
When clicked, displays a dialog box before returning to the database object
4 major parts of Excel
Workbooks and worksheets, charts, tables, web support
Active Cell
Worksheet cell into which you are entering data
Start button
a clickable button at in the lower left corner of the Windows 10 screen that you click to open the Start menu
What-if analysis
a decision making tool in which data is changed and formulas are recalculated, in order to predict various possible outcomes
Indirect circular reference
a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell
UNIX
a multitasking operating system developed in the early 1970s
Hierarchy
create an organizational chart
Information
data comes from attackers who want to steal infor
Surge Protector
defend computer from spikes, surges, noise
Handout master
designates the placement of text, such as page number, on a sheet of paper intended to distribute to audience members
Animated
effect applied to text
Folders
electronic container that helps you organize computer files
#REF!
error message
Circular reference
error occurs if a formula refers to itself
Health
eye strain, poor posture muscle fatigue
Best fit
feature that automatically increases or decreases the width of column
Fill formatting only
fill destination area using format of source area
Copy cell
fill destination area with content using format of source area
Fill series
fill destination area with series using format of sourcing area
PowerPoint
full-featured presentation app that allows you to produce compelling presentations to deliver and share with an audience
Row heading
identifies each row
Relationship
illustrate connections
Sheet tab
indicator at bottom of the window that identifies a worksheet