Excel Tutorial​ Quiz

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

In the Excel_tutorial.xls Quiz Data: What is average female ("Gender" = F) "wingspan"?

62.4

In the Excel_tutorial.xls Quiz Data: After sorting the data by "DadHt," highest values listed first, what is the value of cell H12?

63.3

An Excel file can have multiple ...

Worksheets

Data in Excel is usually in the format of _______ in columns and _________ in rows.

kinds of data, individual observations or things

Opps! You just deleted data from a cell in your spreadsheet. What Apple keyboard shortcut will undo this?

Command - Z

In the Excel_tutorial.xls Quiz Data: What is the single formula that sums all "heights", sums all "weights", and calculates a height to weight ratio, and what is the result?

=SUM(A2:A25)/SUM(B2:B25), 0.46270

In the Excel_tutorial.xls Quiz Data: What is the formula for the sum of the "Wingspan" data?

=SUM(H2:H25)

To select multiple non-adjacent cells of data, I should ...

Hold down Command and click the cells

Lihat semua set pelajaran

Set pelajaran terkait

Chapter 12 Nervous System Nervous Tissue

View Set

Chapter 02-QUIZ-Professional Standards

View Set

Types of Policies and Riders (Ch. 3)

View Set

Chapter 6 - Abnormalities of Blood Coagulation

View Set