Duplicate of CSA II + Unit Final Exam

Question 1

Superbowl commercials - What did we want to know/track?

Accepted Answer

Q1/Q2/Q3/Q4, Celebrity/Animals in commercial

Question 2

When keying a formula, what key must you use to inform the program you are entering a formula?

Accepted Answer

Equal Sign

Question 3

In our CYBG spreadsheet, which field should NOT be a Columns heading (not the best choice)

Accepted Answer

Student's Name

Question 4

For Field Day, what fields did our Tracker Jackers track/calculate for the 4 person relay race?

Accepted Answer

Time (how long it took)

Question 5

Are used to integrate spreadsheet data with other software applications

Accepted Answer

Linking

Question 6

There is information in the cell range A1 to K1. Where is this sales information displayed?

Accepted Answer

Row

Question 7

The sales manager has requested the lowest sale for the first quarter. Which function is used?

Accepted Answer

MIN

Question 8

After entering the number of sales for the first quarter, where will they align?

Accepted Answer

Right

Question 9

In math operations these symbols are used for Multiplication.

Accepted Answer

*

Question 10

A group/block of cells (A1: A16) is called?

Accepted Answer

Cell Range

Question 11

Used to ADD identifying information to a spreadsheet (Title, date created, file name, etc..)

Accepted Answer

Header/Footer

Question 12

Mr. McLean wants to know the top scorer for the soccer team. Which function should be used?

Accepted Answer

SUM

Question 13

It represents the cell that is selected and ready to receive data. Its name...

Accepted Answer

Active Cell

Question 14

Used to clarify information by adding emphasis to titles, column headings, and totals...

Accepted Answer

Pitch/Size, Font, Font Size, Color

Question 15

Paul entered zip codes for a client. How will this data be classified?

Accepted Answer

Label

Question 16

What can you do with Excel/Google Sheets?

Accepted Answer

Sort Data

Question 17

Applied to spreadsheet components for the purpose of organizing and clarifying information.

Accepted Answer

Formatting

Question 18

An arrangement of cells used to organize, sort, and file data.

Accepted Answer

Spreadsheet

Question 19

National Anthems Tracker Jackers - What did we track?

Accepted Answer

Location, Song Title

Question 20

What is your favorite feature in Excel/Google Sheets?

Accepted Answer

Filtering, Sorting

Question 21

Samantha needs to total the cell range A1 to A10. What is the MOST efficient method to find it?

Accepted Answer

Function

Question 22

ABC Corporation has listed all of its products in the cell A1 to A45. Where are the products?

Accepted Answer

Column

Question 23

These math operator symbols are used in formulas for Addition (Adding)

Accepted Answer

+

Question 24

Excel/Google Sheet calculations are performed according to a specific order

Accepted Answer

PEMDAS

Question 25

These are used for classifying cells that are text or numbers NOT used in calculations.

Accepted Answer

Label

Question 26

In a worksheet these are identified by letters of the alphabet (and are vertical).

Accepted Answer

Columns

Question 27

A file which contains one or more spreadsheets

Accepted Answer

Workbook

Question 28

In math operations these symbols are used for Subtraction.

Accepted Answer

-

Question 29

A specific location (A4) is known as...

Accepted Answer

Cell Address

Question 30

A sales manager has requested the highest sale for the first quarter. Which function is used?

Accepted Answer

MAX

Duplicate of CSA II + Unit Final Exam

Questions 30

Duplicate of CSA II + Unit Final Exam

Questions 30