Microsoft Excel Fundamentals Quiz

An application program that helps the user to change any number and immediately see the result of that change is Spreadsheet.

spreadsheet programs. Today, Microsoft Excel is the most popular and widely used spreadsheet program, but there are also many alternatives. Below is a list of spreadsheet programs that can be used to create a spreadsheet. Google Sheets - (Online and free) iWork Numbers - Apple Office Suite.

A spreadsheet is an interactive computer application for organization, analysis and storage of data in tabular form. Spreadsheets are developed as computerized simulations of paper accounting worksheets. The program operates on data entered in cells of a table.

An application is any program, or group of programs, that is designed for the end user. Applications software (also called end-user programs) include such things as database programs, word processors, Web browsers and spreadsheets.

A spreadsheet is an interactive computer application for organization, analysis and storage of data in tabular form. Spreadsheets are developed as computerized simulations of paper accounting worksheets. The program operates on data entered in cells of a table.

Circular reference occurs when a cell in worksheet refers to itself, the formula $=A1+A2+A3$ is entered in cell $A1$, so it will generate a circular reference warning.

The intersection of a column and row in a spreadsheet is called a bon of Cell.

The INTERSECTION of a row and column is called a CELL. Also called a spreadsheet. The intersection of a column and row on a worksheet. You enter data into cells to create a worksheet. The active cell contains the cell pointer. Alternatively, in a table (which I assume you're referring to),

rows are "horizontal" collections of items belonging to a certain category; columns are "vertical" collections. Each item (orange) in the table "belongs" to one row (yellow) and one column (red).

In a Spreadsheet, a Value is a number you will use in a calculation.

A spreadsheet program is Electronic paper  also called a Worksheet. With MS Excel, you can have multiple worksheets contained in a WorkBook .

The REPLACE function syntax is REPLACE(old_text, start_num, num_chars, new_text). Here, it starts at the 3rd character of 2016 (which is '1') and replaces 2 characters ('16') with '17', resulting in 2017.

In table in excel, there are typical labels along with Number’s.

Entering data into a spreadsheet is just like typing in a word processing program, but you have to first click the cell in which you want the data to be placed before typing the data.  All words describing the values (numbers) are called labels. The numbers, which can later be used in formulas, are called values.

CTRL+ Pagedown : Move to the next sheet in a workbook. 

ALT+Pagedown: Move one screen to the right in a worksheet.

• You can press Ctrl+0 to hide the column where the cursor is located. 
  
• Ctrl+A, Ctrl+Shift+0 unhides all the columns in the sheet.
  

ALT+F4 is the shortcut key to exit from excel. This shortcut will close Excel.On a Mac, you can use Command + Q to quit almost any application.On Windows, you can use Alt + F4 for Excel. Also, you can press ALT + F followed by the X key.

CTRL+Spacebar is the shortcut key used to select column. In Excel, hit Ctrl plus the Space Bar to select the entire column of your active or selected cells.

• To insert a cell/row/column in Excel, first select that cell/ entire row/entire column. 
  
• Then press Ctrl + Shift += (equal sign) (all at the same time) on your keyboard.

Page Up: Move one screen up in a worksheet.

SHIFT+Spacebar is the shortcut key used to select row.

Press and hold down the Shift key on the keyboard.Use the Left or Right arrow keys on the keyboard toselect additional columns on either side of the highlighted column.

If you want a shortcut to delete a cell/row/column in Excel, first select that cell/ entire row/entire column. 

Then press “Ctrl” followed by the minus button “-” (all at the same time) on your keyboard.

In MS-Excel, the three primary types of data that can be entered into a cell are numbers, text (labels), and formulas.

Row and Columns are data organized in a spreadsheet.

The best layout for your data within a spreadsheet is as a single big rectangle with rows corresponding to subjects and columns corresponding to variables. The first row should contain variable names, and please do not use more than one row for the variable names. An example of a rectangular layout is shown in Figure 4.

To check if data that is being entered does not have blanks, we have competencies check.

Competency mapping is the process of identification of the competencies required to perform successfully a given job/role/a set of tasks at a given point of time. Competency mapping is used as the basis for any competency assessment that can be done at a later stage.