Spreadsheet | MCQs

Explanation

• Microsoft office spreadsheet program is:  Microsoft Excel
• ***
• Microsoft Excel is a spreadsheet program that features calculation, graphic tools, pivot tables
  
  

Explanation

A range is identified by the cell references of the cells in the upper left and lower right corners of the range.

These two references are separated by a colon ( : ) which tells Excel to include all the cells between these start and end points.

Explanation

Explanation

We can be edited a cell through Press the F2 key or Click the formula bar or Double click the cell.

Explanation

Data, sort is used for arranging data in ascending/descending order in MS Excel

 Sort A to Z to perform an ascending sort (A to Z or smallest number to largest).

 Sort Z to A to perform a descending sort (Z to A or largest number to smallest).

***

Explanation

•  In a computer spreadsheet, each cell contains a Label, value, formula
• in a computer spreadsheet, SUM, AVERAGE, MIN, and MAX are examples of formulas
• n a computer spreadsheet block of numbers is called a range
• In a computer, spreadsheet rows are labeled: By numbers
• In a spreadsheet, letters are used to represent Columns
  
• In a computer spreadsheet, a function that is used to count a number of entries in a given range is called length
• 
  

Explanation

 Columns are denoted and identified by a unique alphabetical header letter, which is located at the top of the worksheet.

Explanation

 To copy the contents of a cell using drag and drop, you need to hold down the Ctrl key while dragging the cell

Explanation

The DATEDIF() function is used to get days, months, or years between two dates.

Syntax: =DATEDIF (start_date, end_date, unit).

Additional information:

 DATEDIFF()

The DATEDIFF() function returns the difference between two dates.

Syntax. DATEDIFF(interval, date1, date2).

*

DAYSBETWEEN

The daysBetween function takes startDateValue and endDateValue 

Syntax. daysBetween( date1 , date2 ).

Explanation

The AVERAGEIF function returns the average of cells in a range that meet the criteria you provide.

****

ND20-1-2023