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)
What combination/shortcut keys will help you select the entire row of the active cell?
In MS-Excel, how is the range of cells in column A and rows 2 through 12 represented?
Which shortcut key will access the entire column of an active cell?
Signup and view all the answers
Which key should be pressed to activate the extend indicator (EXT) in the status bar?
Signup and view all the answers
The intersection of rows and columns is known as?
Signup and view all the answers
An Excel workbook is a collection of?
Signup and view all the answers
Select the correct example of a cell address:
Signup and view all the answers
Which is an example of a function?
Signup and view all the answers
Formulas in Excel start with:
Signup and view all the answers
The Name Box:
Signup and view all the answers
Which area in an Excel window allows entering values and formulas?
Signup and view all the answers
Excel displays the current cell address in the:
Signup and view all the answers
A _____ is a grid with labelled columns and rows.
Signup and view all the answers
Shortcut keys will help you to go to the top of the worksheet?
Signup and view all the answers
Shortcut keys will help you to go to the end of the worksheet?
Signup and view all the answers
Shortcut keys will help you to apply number format in MS Excel?
Signup and view all the answers
Default column width in Excel is:
Signup and view all the answers
Default row height in Excel is:
Signup and view all the answers
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.