MS-Office BCCA-SEM-I Unit I Quiz
5 Questions
4 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 feature in Excel is used to automatically fill cells based on patterns in adjacent columns?

  • Flash Fill (correct)
  • Pivot Table
  • Filter
  • Sort

In Microsoft Excel, what is used to change the appearance of data?

  • Pivot Table
  • Filtering
  • Sorting
  • Formatting (correct)

What feature in Excel is used to find and select specific data within the workbook?

  • Pivot Table
  • Go To (correct)
  • Hlookup
  • Subtotal

Which function in Excel is used to look up a value in a table based on a vertical lookup?

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

What feature in Excel is used to analyze, summarize, and present data from a worksheet?

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

Flashcards

Excel's Autofill Feature

Automatically fills cells with data based on patterns in adjacent columns.

Excel Formatting

Used to change the appearance of data (e.g., font, colors, alignment).

Excel's Go To Feature

Finds and selects specific data or cells in the worksheet.

Excel VLOOKUP Function

Looks up a value in a table based on a vertical lookup.

Signup and view all the flashcards

Excel Pivot Table

Analyzes, summarizes and presents data in a worksheet.

Signup and view all the flashcards

More Like This

MS Office Training
5 questions

MS Office Training

AffordableAlmandine avatar
AffordableAlmandine
MS Office Word Sənədləri
8 questions
MS Office Word İcmalı
8 questions
Use Quizgecko on...
Browser
Browser