Deck 6: Spreadsheets

Question 1

Workbooks are:

A) as horizontal cell in a spreadsheet
B) a collection of worksheets
C) a vertical set of cells in a spreadsheet
D) chronological listings of facts of a case

Answer 1

B

Question 2

Resources for learning to use electronic spreadsheets include:

A) online search engines
B) online tutorials
C) online templates
D) all of the above

Answer 2

D

Question 3

Many offices save spreadsheet ________ in the same way that sample word processing documents are saved for future use.

A) templates
B) programs
C) information
D) formulas

Answer 3

A

Question 4

Electronic spreadsheets can be used for very simple operations,like adding two numbers,or ________ functions,like calculating the present or future value of a number.

A) Intermediate-level
B) complex
C) reasonable
D) impossible

Question 5

A cell in a spreadsheet is:

A) the box at the intersection of a row and column.
B) a collection of worksheets.
C)a vertical set of cells in a spreadsheet
D) a horizontal cell in a spreadsheet

Question 6

The first step in creating a basic spreadsheet is to:

A) enter a formula
B) create the column labels
C) decide what you want the spreadsheet to show or calculate
D) click the start button

Question 7

Microsoft offers a number of online ________ as a resource for learning and using electronic spreadsheets.

A) sample programs
B) tutorials
C) help operators
D) vendors

Question 8

Data in a spreadsheet can be explained in the form of:

A) a database.
B) a memo of law.
C) an embedded file.
D) a graph.

Question 9

Most office suite applications can be password controlled:

A) by the IT department.
B) only if you request it.
C) for security.
D) by a remote login device.

Question 10

Many areas of legal practice involve calculating and presenting ________ information

A) discoverable
B) financial
C) case law
D) updated

Question 11

In Quattro Pro,the property bar is the area at the top of the spreadsheet for:

A) entering formulas and data into the Network.
B) entering time and billing information for client matters.
C) entering formulas and data into spreadsheet cells.
D) entering facts and issues of the client's case.

Question 12

The changes and updates to existing spreadsheet programs are often made to maintain ________,but minimize the number of ________ required.

A) features; functions
B) formulas; keystrokes
C) functions; keystrokes
D) keystrokes; functions

Question 13

Although many spreadsheet templates are available for download,the user should always check for ________ before downloading or installing them.

A) compatibility
B) expiration dates
C) viruses
D) pricing information

Question 14

A spreadsheet in its most basic form is any two items with some relationship that is acted upon mathematically,with the result presented:

A) in a third location
B) in a database
C) in court
D) for use by a third party

Question 15

The ________ spreadsheet,when laid out in a format acceptable to the court,can be printed without re-entering the data,or copied into Word documents.

A) multipurpose
B) computerized
C) individualized
D) client's

Question 16

A ___________ and a __________ can be entered or changed by editing it in the Excel formula bar.

A) label, formula
B) template, tutorial
C) CPU, label
D) RAM, template

Question 17

All spreadsheets use a set of standard terms to describe the parts of the spreadsheet,such as:

A) lines, paragraphs, bullets, and points.
B) rows, columns, cells, formula bars, and workbooks
C) groups, options, insert, and toolbar.
D) rows, columns, groups, points, and toolbars.

Question 18

A label can be entered by typing it in a cell or by selecting the cell and:

A) typing it in the toolbar.
B) copying it and pasting it under Favorites.
C) allowing computers to connect to other computers.
D) typing it in the property bar

Question 19

Most software vendors provide help in learning how to use their software.

Question 20

A row is a:

A) vertical set of cells in a spreadsheet
B) computerized format utilizing a series of 1s and 0s
C) horizontal set of cells in a spreadsheet
D) a template

Question 21

Each spreadsheet has a choice of tools and features that may be displayed on the toolbars for quick use.

Question 22

A horizontal set of cells in a spreadsheet is called a ____________.

Question 23

In a spreadsheet,the cell is the box at the intersection of a row and a column for text or numerical data.

Question 24

A spreadsheet can simplify the task of making computations.

Question 25

Most office suite applications cannot be password-controlled for security.

Question 26

In a spreadsheet,the __________ is the box at the intersection of a row and a column for text or numerical data.

Question 27

In Excel,the area at the top of the ________ for entering formulas and data into a spreadsheet is called the formula bar.

Question 28

Offices do not save spreadsheet templates in the same way they save sample word processing documents for future use.

Question 29

In Excel,a selection of cells can be converted to a graph using the Insert tab's Charts tools.

Question 30

Data in a spreadsheet is rarely better expressed in the form of a graph

Question 31

The cell in which an answer will be calculated does not need to contain the desired formula.

Question 32

A cell is a collection of worksheets

Question 33

Spreadsheets have standard terms to describe their parts,such as rows,columns,cells,formula bar,active cell,formula and workbooks

Question 34

A ______________ in its most basic form is any two items with some relationship that is acted upon mathematically,with the result presented:

Question 35

A collection of worksheets is called a _____________.

Question 36

The formulas used in spreadsheets can be very simple or can be complex.

Question 37

Just as a formula can be entered or changed by editing it in the property bar,so can a label.

Question 38

A document,in its most basic form,is any two items with some mathematical relationship,with the result presented in a specific location called a cell.

Question 39

A ________ is a vertical set of cells in a spreadsheet.

Question 40

A column is a horizontal set of cells in a spreadsheet.

Question 41

Any selection of cells can be converted to a _________ using the Chart tool.

Question 42

Explain how spreadsheets can streamline routine paperwork in a specialized law practice,such as a residential real-estate practice.What software is available,and how can it improve efficiency?

Question 43

Many offices save spreadsheet _____________ in the same way they save sample word processing documents for future use.

Question 44

Matching

Question 45

Explain how to find resources for learning how to use a spreadsheet and its features.

Question 46

Spreadsheets use basic __________ for math functions.

Question 47

Data in a spreadsheet can be explained in the form of _____________.

Question 48

Each spreadsheet has tools and features that are displayed on _____________.

Question 49

__________,will add up the selected cells in any row or column without the user needing to type any formula.

Question 50

How can the legal team avoid ethical problems with sensitive information in Excel?

Question 51

Jack Parsons is preparing for a settlement conference with Greenway Chemicals,the company accused of poisoning his clients.The settlement figure involves many different factors,such as medical expenses,pain and suffering,lost wages,punitive damages,and legal fees and costs.Although he had already worked out a bottom-line figure with his clients before going into the conference,he needs a way to be able to quickly calculate the figures as the conference progresses and alternative amounts are discussed.What technology would help Jack have these calculations and figures at his fingertips?

Question 52

Luke Jacob's personal injury practice has continued to grow.However,he and his assistant waste valuable time filling out the settlement statements by hand.These statements are virtually identical in each transaction,varying only in the amounts of a fixed set of figures.How can they use technology to streamline this process?