Business Info Manage Second Six weeks Part 1

A spreadsheet can generally be defined as a _____.

• a. row-and-column arrangement of data

• b. chart that can be used to prepare business reports

• c. grid arrangement of data used by modern calculators to solve equations

• d. worksheet used by mathematicians and engineers to help solve problems

In a spreadsheet program, a collection of worksheets saved in a single spreadsheet file is called a _____.

• project

• Workbook

• workstation

• document book

Which of the following is a correctly formatted absolute cell reference for both column and row in Microsoft Excel or Google Sheets?

• a. $C5

• b. =#A$7

• c. =$M$3

• d. =$89:$S

What is the default way data is organized in a spreadsheet?

• In List

• In Charts

• In Graphs

• By rows and columns

=IF is an example of a _____ function.

• logical

• database

• financial

• calculation

Which choice BEST describes the meaning of the formula =AVERAGE(c1:c10)?

• a. Average of values in cells C1 through C10

• b. Average of values in cells C1 and C10 only

• c. Average of all cells in columns 1 through 10

• d. Average of column C, excluding values in cell C1 and C10

=SUM (B6…B10) is an example of a preset formula, or _____.

• graph

• marco

• routine

• function

In _____ cell referencing, the formula does not change when it is copied and pasted to other cells.

• pure

• relative

• absolute

• dependent

As treasurer of the Prom Committee, Maria must prepare a budget for prom expenses. To handle this task efficiently, Maria will use formulas in a spreadsheet program to calculate the totals. Which symbol below should she ALWAYS use to start her formulas?

• /

• *

• =

• %

A mathematical equation that is used to calculate values in a spreadsheet program is called a _____.

• marco

• routine

• formula

• function