Microsoft Excel Basics
30 Questions
0 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

What is the procedure to select a range of cells in a worksheet?

  • Drag from the first cell to the last cell, and then press the Shift key
  • Click the first cell, hold down the Ctrl key, and then click the last cell
  • Click the first cell, hold down the Shift key, and then click the last cell (correct)
  • Click the first cell, hold down the Alt key, and then click the last cell

How do you deselect a range of cells?

  • Press any arrow key or click any cell in the worksheet (correct)
  • Press the F1 key
  • Hold down the Shift key and click the first cell
  • Hold down the Ctrl key and click the last cell

What is the shortcut to select nonadjacent cells or ranges?

  • Hold down the Shift key
  • Hold down the Alt key
  • Press the F2 key
  • Hold down the Ctrl key (correct)

How do you select a single row or column?

<p>Click the header of the row or column (D)</p> Signup and view all the answers

What is the purpose of pressing the Esc key during editing?

<p>To return the cell to its previous state (C)</p> Signup and view all the answers

What is the procedure to select multiple adjacent rows or columns?

<p>Click the header of the first row or column, hold down the Shift key, and then click the header of the last row or column (B)</p> Signup and view all the answers

How can you undo an action in Excel?

<p>By clicking the Undo button on the Quick Access toolbar or by pressing Ctrl + Z (D)</p> Signup and view all the answers

How do you select multiple nonadjacent rows or columns?

<p>Hold down the Ctrl key and click the headers of the rows or columns (C)</p> Signup and view all the answers

What is the function of the Clipboard group on the Home tab?

<p>To access temporary storage area (C)</p> Signup and view all the answers

How do you move a cell to a new location?

<p>Select the cell, click the Cut button, and then click the Paste button (B)</p> Signup and view all the answers

What is the purpose of the Font group on the Home tab?

<p>To contain the most commonly used formatting commands (A)</p> Signup and view all the answers

What is the result of pressing the Backspace key while editing?

<p>Deletes the character to the left of the cursor (C)</p> Signup and view all the answers

How can you change the font size of a cell?

<p>By clicking the Font button on the Home tab and selecting a font size (C)</p> Signup and view all the answers

What is the purpose of the Number group on the Home tab?

<p>To contain the most commonly used commands for formatting numbers (A)</p> Signup and view all the answers

What is the purpose of pressing the Enter key after editing?

<p>To save the changes made (C)</p> Signup and view all the answers

How do you copy a cell?

<p>Select the cell, click the Copy button, and then click the Paste button (D)</p> Signup and view all the answers

How can you remove all borders from a selected cell?

<p>By clicking the Borders arrow and selecting No Border on the menu (A)</p> Signup and view all the answers

What is the shortcut key to redo an action in Excel?

<p>Ctrl + Y (B)</p> Signup and view all the answers

What is the primary function of the Alignment group in the Home tab of the Ribbon?

<p>To change the horizontal and vertical alignment of cell contents (D)</p> Signup and view all the answers

What is the effect of clicking the Centre button in the Alignment group?

<p>The cell contents are centred horizontally within the cell (C)</p> Signup and view all the answers

What is the purpose of indenting data in a cell?

<p>To indicate a level of less importance (C)</p> Signup and view all the answers

How do you indent data in a cell?

<p>By clicking the Increase Indent button (C)</p> Signup and view all the answers

What is the effect of clicking the Align Right button in the Alignment group?

<p>The cell contents are aligned with the right edge of the cell (D)</p> Signup and view all the answers

What is the function of the Top Align button in the Alignment group?

<p>To align the cell contents with the top edge of the cell (A)</p> Signup and view all the answers

What is the purpose of rotating data in a cell?

<p>To label narrow columns or add visual impact (C)</p> Signup and view all the answers

How do you restore the data to its default orientation after rotating it?

<p>By clicking the Orientation button and selecting the currently selected orientation (D)</p> Signup and view all the answers

What happens to the row height when you wrap data within a cell?

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

What is the result of merging cells with data in more than one cell?

<p>The data in the upper-left cell remains (D)</p> Signup and view all the answers

Where is the Orientation button located?

<p>In the Alignment group on the Home tab (A)</p> Signup and view all the answers

What is the purpose of wrapping data within a cell?

<p>To display data on multiple lines within a cell (B)</p> Signup and view all the answers

More Like This

Microsoft Excel Fundamentals
10 questions
Formulas and Charts in Microsoft Excel
5 questions
Microsoft Excel Basics
12 questions
Microsoft Excel Basics
28 questions

Microsoft Excel Basics

SparklingUkiyoE6607 avatar
SparklingUkiyoE6607
Use Quizgecko on...
Browser
Browser