MS Excel Shortcuts and Concepts
19 Questions
3 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

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?

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

  • A2:A12 (correct)
  • A2:A10
  • A10/A12

Which shortcut key will access the entire column of an active cell?

<p>Ctrl + Spacebar (C)</p> Signup and view all the answers

Which key should be pressed to activate the extend indicator (EXT) in the status bar?

<p>F8 (C)</p> Signup and view all the answers

The intersection of rows and columns is known as?

<p>Cell (A)</p> Signup and view all the answers

An Excel workbook is a collection of?

<p>Worksheet (D)</p> Signup and view all the answers

Select the correct example of a cell address:

<p>A25 (D)</p> Signup and view all the answers

Which is an example of a function?

<p>=sum(B1:B5) (A)</p> Signup and view all the answers

Formulas in Excel start with:

<p>= (D)</p> Signup and view all the answers

The Name Box:

<p>Appears to the left of the formula bar. (B)</p> Signup and view all the answers

Which area in an Excel window allows entering values and formulas?

<p>Formula Bar (A)</p> Signup and view all the answers

Excel displays the current cell address in the:

<p>Name box (B)</p> Signup and view all the answers

A _____ is a grid with labelled columns and rows.

<p>Worksheet (B)</p> Signup and view all the answers

Shortcut keys will help you to go to the top of the worksheet?

<p>CTRL + HOME (D)</p> Signup and view all the answers

Shortcut keys will help you to go to the end of the worksheet?

<p>CTRL + END (B)</p> Signup and view all the answers

Shortcut keys will help you to apply number format in MS Excel?

<p>CTRL + SHIFT + 1 (C)</p> Signup and view all the answers

Default column width in Excel is:

<p>8.43 (C)</p> Signup and view all the answers

Default row height in Excel is:

<p>12.75 (B)</p> 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.

Quiz Team

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.

More Like This

Excel Shortcuts and Functions Quiz
5 questions
Microsoft Excel Shortcuts
24 questions
Excel Functions and Shortcuts Quiz
20 questions

Excel Functions and Shortcuts Quiz

SucceedingLapisLazuli2023 avatar
SucceedingLapisLazuli2023
Excel Shortcuts and Features
7 questions

Excel Shortcuts and Features

PromisingStonehenge avatar
PromisingStonehenge
Use Quizgecko on...
Browser
Browser