STA641 Quiz by S Khan Academy

SOLVED BY SANAULLAH KHAN · Quiz No 1 · The cell reference for cell range of G2 to M12 is_____ · STA641 QUIZ FILE · Subject Enrolment · 1. Online classes are available (Mathematics) · 2. Solved graded activities · Assignment’s · Quizzes · GDB’s · 3. Solved quiz files · 4. Past papers · 5. Any info about virtual university of · Pakistan · Final project (MTH620) · Email: · Mr.khan.1431 · S KHAN ACADEMY · G2:M12 The first cell in EXCEL is labeled as:

A1 The______ Is the value you calculate when you want the arithmetic average.

Mean When data is arranged, middle value in set of observations is classified as

Median Extent to which values are dispersed around central observation is considered as

Variation What will Excel display when calculating =1/8. Show the answer in two decimal places

Q0. 13 What is meant by precision of data?

The number of decimals places store in computer The basic unit of worksheet into which you enter data in EXCEL is called:

Cell Given the following set of data, what is the range [12, 23, 34, 54, 21, 8, 9, 67]

Which of the following formulas is not entered correctly?

10 + 50 In EXCEL, which function is used to calculate standard deviation?

=STDEV() Which one is not a function in MS EXCEL?

AVG Function in MS EXCEL must begin with______

An equal sign Getting data from a cell located in a different sheet is called?

Referencing · The cell reference for cell range of B2 to B10is____ · B2:B10

In Excel, to calculate the Arithmetic Mean of given data which functions we use?

AVERAGE Which is an example of correct formula?

= A1+A2 Method used to compute average or central value of collected data is considered as Measures of central tendency In Excel, which one denoted a range of cells from B1 through E5.

B1:E5 In Excel, what will be the value of this formula =2+2*2

In excel, Columns are labelled as_____

A, B, C, etc In Excel, what will be the value of this formula =2+2/2

What are the two components of any Excel formula?

Operator and = sign

In excel, Rows are labeled as.___

1, 2, 3, etc The Plus sign (+) is an example of. operator.