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