Excel Tutorial​ Quiz

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

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

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 average female ("Gender" = F) "wingspan"?

62.4

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 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

Voir tous les ensembles d'études

Ensembles d'études connexes

Chapter 6 Learnsmart Biomechanics

View Set

Chapter 12 Nervous System Nervous Tissue

View Set

Chapter 02-QUIZ-Professional Standards

View Set

Types of Policies and Riders (Ch. 3)

View Set