Excel Tutorial​ Quiz

Réussis tes devoirs et examens dès maintenant avec 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

Voir tous les ensembles d'études

Ensembles d'études connexes

Chapter 12 Nervous System Nervous Tissue

View Set

Chapter 02-QUIZ-Professional Standards

View Set

Types of Policies and Riders (Ch. 3)

View Set