Podcast
Questions and Answers
Which of the following keys is pressed in order to move between the cells in MS-Excel? (Select all that apply)
Which of the following keys is pressed in order to move between the cells in MS-Excel? (Select all that apply)
- Tab key
- Arrow key
- Enter key
- All of these (correct)
What combination/shortcut keys will help you select the entire row of the active cell?
What combination/shortcut keys will help you select the entire row of the active cell?
- Shift + Space bar (correct)
- Ctrl + F1
- Ctrl + Space bar
- Alt + Space bar
In MS-Excel, how is the range of cells in column A and rows 2 through 12 represented?
In MS-Excel, how is the range of cells in column A and rows 2 through 12 represented?
- A2:A12 (correct)
- A2:A10
- A10/A12
Which shortcut key will access the entire column of an active cell?
Which shortcut key will access the entire column of an active cell?
Which key should be pressed to activate the extend indicator (EXT) in the status bar?
Which key should be pressed to activate the extend indicator (EXT) in the status bar?
The intersection of rows and columns is known as?
The intersection of rows and columns is known as?
An Excel workbook is a collection of?
An Excel workbook is a collection of?
Select the correct example of a cell address:
Select the correct example of a cell address:
Which is an example of a function?
Which is an example of a function?
Formulas in Excel start with:
Formulas in Excel start with:
The Name Box:
The Name Box:
Which area in an Excel window allows entering values and formulas?
Which area in an Excel window allows entering values and formulas?
Excel displays the current cell address in the:
Excel displays the current cell address in the:
A _____ is a grid with labelled columns and rows.
A _____ is a grid with labelled columns and rows.
Shortcut keys will help you to go to the top of the worksheet?
Shortcut keys will help you to go to the top of the worksheet?
Shortcut keys will help you to go to the end of the worksheet?
Shortcut keys will help you to go to the end of the worksheet?
Shortcut keys will help you to apply number format in MS Excel?
Shortcut keys will help you to apply number format in MS Excel?
Default column width in Excel is:
Default column width in Excel is:
Default row height in Excel is:
Default row height in Excel is:
Study Notes
MS Excel Shortcuts
- Move Between Cells: Use
Tab
,Enter
, or arrow keys. - Select Entire Row: Use
Shift + Space bar
. - Select Entire Column: Use
Ctrl + Spacebar
. - Activate Extend Indicator (EXT): Use
F8
. - Go to Top of Worksheet: Use
Ctrl + Home
. - Go to End of Worksheet: Use
Ctrl + End
. - Apply Number Format: Use
Ctrl + Shift + 1
.
MS Excel Concepts
- Cell: The intersection of a row and a column.
- Worksheet: A grid with labelled columns and rows, forming part of an Excel workbook.
- Workbook: A collection of worksheets.
- Formula Bar: Area where you enter values and formulas.
- Name Box: Displays the current cell address.
- Function: A pre-defined calculation, e.g.,
=SUM(B1:B5)
. - Default Column width: 8.43.
- Default Row Height: 12.75.
MS Excel Cell Reference
- Cell addresses consist of a column letter and row number (e.g.,
A25
). - A range of cells is represented by the starting cell, a colon, and the ending cell (e.g.,
A2:A12
).
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Related Documents
Description
Test your knowledge of MS Excel shortcuts and key concepts with this quiz. Explore cell references, workbooks, and basic functionalities that make Excel an essential tool for data management. Perfect for beginners and intermediate users.