Tag: introduction to excel

Questions Related to introduction to excel

To hide the columns ________ is the shortcut key.

introduction to excel information communication technology (ict) physics

  1. CTRL$+3$

  2. CTRL$+2$

  3. CTRL$+1$

  4. CTRL$+0$

Show answer
Correct Option: D
Explanation:

  • 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.

__________ is the shortcut key to exit from excel.

introduction to excel information communication technology (ict) physics

  1. ALT$+$F$2$

  2. ALT$+$F$3$

  3. ALT$+$F$4$

  4. ALT$+$F$5$

Show answer
Correct Option: C
Explanation:

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.

__________ is the shortcut key used to select column.

introduction to excel information communication technology (ict) physics

  1. SHIFT$+$TAB

  2. SHIFT$+$Spacebar

  3. CTRL$+$Spacebar

  4. SHIFT$+$Enter

Show answer
Correct Option: C
Explanation:

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 cells, rows or columns ________ the keyboard shortcut key.

introduction to excel information communication technology (ict) physics

  1. CTRL$+$Minus Sign

  2. CTRL$+$SHIFT$+$Plus Sign

  3. CTRL$+$Star Sign

  4. CTRL$+$Greater than Sign

Show answer
Correct Option: B
Explanation:

  • 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.
(The above shortcut is actually CTRL+ + (Plus sign). To insert plus sign, we need SHIFT+ = )

___________ is the short-key to move to the previous worksheet.

introduction to excel information communication technology (ict) physics

  1. CTRL$+$Pagedown

  2. CTRL$+$Pageup

  3. CTRL$+$Right arrow

  4. CTRL$+$Left arrow

Show answer
Correct Option: B
Explanation:

Page Up: Move one screen up in a worksheet.

CTRL + Page Up: Move to the previous sheet in a workbook. Keep pressing this key combination to move across excel sheets till the first sheet.

___________ is the shortcut key used to select row.

introduction to excel information communication technology (ict) physics

  1. SHIFT$+$TAB

  2. SHIFT$+$Spacebar

  3. CTRL$+$Spacebar

  4. SHIFT$+$Enter

Show answer
Correct Option: B
Explanation:

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.

__________ is the shortcut key to delete cells, rows or columns.

introduction to excel information communication technology (ict) physics

  1. CTRL$+$Minus Sign

  2. CTRL$+$Plus Sign

  3. CTRL$+$Star Sign

  4. CTRL$+$Greater than sign

Show answer
Correct Option: A
Explanation:

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.

How many types of data can be entered in a worksheet?

introduction to excel information communication technology (ict) physics

  1. Three

  2. Four

  3. Two

  4. Five

  5. Six

Show answer
Correct Option: A

How are data organized in a spreadsheet?

introduction to excel information communication technology (ict) physics

  1. Line & spaces

  2. Layers & Planes

  3. Height & Width

  4. Rows & Columns

  5. None

Show answer
Correct Option: D
Explanation:

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

introduction to excel information communication technology (ict) physics

  1. A mathematically calculated check digit

  2. Control check to verify if the data is in accordance to a predetermined criteria

  3. Competences check

  4. None of these

Show answer
Correct Option: C
Explanation:

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.