Question

tick write the correct answer and fill in the blanks:

1. To use the sheet reference, which address is appropriate out of the following options?
a. D4!sheet1 ( ). b.sheet1,D4( )
c.sheet1!D4( )

2. which key combination is used to get the sum of the values of adjacent cells?
a . shift+S( ). b.ctrl+' ( )
c.alt+ equals to ( )

3. which function finds the largest number in a range ?
a. AVERAGE ( ). b. COUNT( )
c.MAX ( )

4. which of the given cell references can be used in a relative reference?
a.$D6( ). b. A3( )
c.A$1( )

5. which function is used to count the number of numeric values in a range?
a. COUNT( ). b. SUM( )
c. MAX( )

please give the answer fast I need​

Answer 1

Answer:

no answer ugkjojojjohcy

Answer 2

1. sheet1!D4( )

2.c.alt+ equals to ( )

3.c.MAX ( )

4.b. A3( )

5.a. COUNT()

Explanation:

To reference a cell or range of cells in another worksheet in the same workbook, put the worksheet name followed by an exclamation mark (!) before the cell address.

The key combination which is "used to get" the "total of adjacent cells" is "Alt+=".

The Excel MAX function returns the largest numeric value in the data provided.

Relative reference is the default cell reference in Excel.

Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.