Excel | MCQs

Explanation

Excel 2003 and earlier 65,536 Rows.

Excel 2007 and higher 1,048,576 Rows.

and 16,384 columns

ND5-2-2023

Explanation

The SUMIF function is a premade function in Excel, which calculates the sum of values in a range based on a true or false condition.

The condition is referred to as criteria , which can check things like: If a number is greater than another number >

***

RY24012023

Explanation

Data form  effective ways to record time of data entry in Excel

****

ND20-1-2023

Explanation

• Basic functions formulae (SUM, AVERAGE, COUNT, MAX & MIN)
***

• The Average function calculates the average, or arithmetic mean, of its arguments.
• The Max function finds the maximum value.
• The Min function finds the minimum value.
• The Sum function calculates the sum of its arguments.
  
  

Explanation

• In a computer spreadsheet, cell range A3 through G3 should be keyed in as  A3:G3
  

Explanation

The formatting and Drawing toolbar is a toolbar in Microsoft Office 2003 and earlier applications, that gives the user the ability to change the formatting of selected text or cell.

Explanation

Data sheet can not be a sheet in workbook.

Explanation

To removes a sheet from workbook select the sheet, then choose Edit > Delete Sheet these options available in excel 2003 and earlier version.

Explanation

Ctrl + P is the shortcut key to print.

Explanation

Dragging is used to move an object from one position to another position on the computer screen.