Tag: information communication technology (ict)

Quizzes (10) Questions (45)

Questions Related to information communication technology (ict)

Multiple choice introduction to excel information communication technology (ict) physics

__________ is the shortcut key to exit from excel.

  1. ALT$+$F$2$

  2. ALT$+$F$3$

  3. ALT$+$F$4$

  4. ALT$+$F$5$
Reveal answer Fill a bubble to check yourself
C Correct answer
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.

Multiple choice introduction to excel information communication technology (ict) physics

__________ is the shortcut key used to select column.

  1. SHIFT$+$TAB

  2. SHIFT$+$Spacebar

  3. CTRL$+$Spacebar

  4. SHIFT$+$Enter
Reveal answer Fill a bubble to check yourself
C Correct answer
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.

Multiple choice introduction to excel information communication technology (ict) physics

To insert cells, rows or columns ________ the keyboard shortcut key.

  1. CTRL$+$Minus Sign

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

  3. CTRL$+$Star Sign

  4. CTRL$+$Greater than Sign
Reveal answer Fill a bubble to check yourself
B Correct answer
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+ = )

Multiple choice introduction to excel information communication technology (ict) physics

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

  1. CTRL$+$Pagedown

  2. CTRL$+$Pageup

  3. CTRL$+$Right arrow

  4. CTRL$+$Left arrow
Reveal answer Fill a bubble to check yourself
B Correct answer
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.

Multiple choice introduction to excel information communication technology (ict) physics

___________ is the shortcut key used to select row.

  1. SHIFT$+$TAB

  2. SHIFT$+$Spacebar

  3. CTRL$+$Spacebar

  4. SHIFT$+$Enter
Reveal answer Fill a bubble to check yourself
B Correct answer
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.

Multiple choice introduction to excel information communication technology (ict) physics

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

  1. CTRL$+$Minus Sign

  2. CTRL$+$Plus Sign

  3. CTRL$+$Star Sign

  4. CTRL$+$Greater than sign
Reveal answer Fill a bubble to check yourself
A Correct answer
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.

Multiple choice introduction to excel information communication technology (ict) physics

How are data organized in a spreadsheet?

  1. Line & spaces

  2. Layers & Planes

  3. Height & Width

  4. Rows & Columns

  5. None
Reveal answer Fill a bubble to check yourself
D Correct answer
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.

Multiple choice introduction to excel information communication technology (ict) physics

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

  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
Reveal answer Fill a bubble to check yourself
C Correct answer
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.