Microsoft Excel 2019/365 Essentials

Microsoft Excel 2019/365 Essentials

Quiz

start>

question 1 of 14

What tools are available in the "Get and Transform Data" group on the Data tab in Excel?

Tools for forecasting trends in data

Tools for connecting to live data sources and transforming data

Tools for sorting and filtering data

CORRECT!

>

question 2 of 14

In Excel 365, what is the purpose of the "Analysis" section in the "Home" tab's ribbon, and what does it provide?

Gives you ideas for analysing your data; It suggests ways to visualise your data effectively.

Calculates mathematical equations; It provides options for page layout.

Offers advanced charting options; It provides tools for data encryption.

CORRECT!

>

question 3 of 14

What type of information can be found in the "Info" option page in the backstage view of Excel?

Data analysis tools, formula functions, and formatting options

Properties about the workbook, related dates, and options for protecting the workbook

Chart customization and data visualization settings

CORRECT!

>

question 4 of 14

When you click "Save" for the first time in an unsaved Excel workbook, what happens, and how does "Save As" differ from "Save"?

"Save" opens a new worksheet; "Save As" creates a copy of the workbook.

"Save" saves the workbook without any further options; "Save As" lets you choose a location and name for the workbook.

"Save" immediately closes the workbook; "Save As" allows you to rename the workbook.

CORRECT!

>

question 5 of 14

How do you manually input data in Excel, and what does the status bar show when you're ready?

Type in a cell; Status: "Enter" for data, "Edit" for editing.

Double-click a cell; Status: "Ready" to enter.

Open formula bar; Status: "Editing."

CORRECT!

>

question 6 of14

How to search for text or numbers in Excel, and what tool is employed?

Use "Find & Select" tool; Input and find with "Find Next.".

Manual scrolling only; No specific search tool.

Use "Sort" function; Scan the worksheet manually.

CORRECT!

>

question 7 of14

How do you add a column to an Excel table, and what happens to existing columns?

No column insertion; Only row addition.

Right-click, choose "Insert"; Existing columns shift left.

Delete a column first; Existing columns shift right.

Of course, you are right!

>

question 8 of 14

What happens when you hide a column or row in Excel, and how can you unhide it?

Completely deletes it; You can only unhide it by re-entering the data.

Makes it read-only; To unhide, you must select both sides and choose "Unhide."

Makes it invisible but still present; To unhide, you can right-click and choose "Unhide."

CORRECT!

>

question 9 of 14

What is Excel's Auto Fill, and how do you swiftly fill a column with it?

Auto Fill populates data; Grab Fill Handle, drag to fill series or pattern.

Auto Fill applies number formats; Select cells, click Auto Fill in Number group.

Auto Fill searches data; Enter keywords, click Auto Fill.

CORRECT!

>

question 10 of 14

Which formatting style in Excel adds a dollar sign, commas, and decimal places to numbers?

Accounting

Number

Currency

CORRECT!

>

question 11 of 14

What function is used in Excel to automatically add a range of numbers, and where can you find the AutoSum feature?

"SUM", and you can find AutoSum in the Editing section of the Home tab.

"AutoAdd," and it's in the Formulas tab.

"SumTotal," and it's in the Insert tab.

CORRECT!

>

question 12 of 14

How does Excel's AutoFill interact with formulas, and what occurs when you drag the Fill Handle for a series?

AutoFill for one cell only; No formula capability.

AutoFill with formulas calculates results; Dragging copies and adjusts formulas.

AutoFill works only with numbers; No formula support.

CORRECT!

>

question 13 of 14

What is the purpose of clicking the "Save" icon in Excel's Quick Access Toolbar when you haven't saved a workbook before?

It opens the Save As menu.

It opens the workbook.

It saves the workbook with its existing name.

CORRECT! ALMOST THERE!

>

question 14 of 14

Which Excel file format is the default version for Excel 2007 and later?

.xls

.csv

.xlsx

CORRECT! 🎉🌟 You did it! Congratulations on completing the quiz! 🌟🎉

>

Quiz completed

<

>

¡Oh, no! Missed a few on : Ribbon Tabs: Data. No worries! Want to try the quiz again or review the lesson?

Review lesson

>

Try again

¡Oh, no! Missed a few on : Ribbon Updates 365. No worries! Want to try the quiz again or review the lesson?

Review lesson

>

Try again

¡Oh, no! Missed a few on : Backstage View: Info Option No worries! Want to try the quiz again or review the lesson?

Review lesson

>

Try again

¡Oh, no! Missed a few on : Backstage View: Save and Save As Options. No worries! Want to try the quiz again or review the lesson?

Review lesson

>

Try again

¡Oh, no! Missed a few on : Entering and Editing Data No worries! Want to try the quiz again or review the lesson?

Review lesson

>

Try again

¡Oh, no! Missed a few on : Searching for Data. No worries! Want to try the quiz again or review the lesson?

Review lesson

>

Try again

¡Oh, no! Missed a few on : Inserting Rows and Columns No worries! Want to try the quiz again or review the lesson?

Review lesson

>

Try again

¡Oh, no! Missed a few on : Hiding and Unhiding Columns or Rows No worries! Want to try the quiz again or review the lesson?

Review lesson

>

Try again

¡Oh, no! Missed a few on : Using Autofill and the Fill Handle. No worries! Want to try the quiz again or review the lesson?

Review lesson

>

Try again

¡Oh, no! Missed a few on : Number, Currency, and Accounting Formats. No worries! Want to try the quiz again or review the lesson?

Review lesson

>

Try again

¡Oh, no! Missed a few on : Working with AutoSum. No worries! Want to try the quiz again or review the lesson?

Review lesson

>

Try again

¡Oh, no! Missed a few on : Using Auto Fill with Formulas. No worries! Want to try the quiz again or review the lesson?

Review lesson

>

Try again

¡Oh, no! Missed a few on : Using Save and Save As. No worries! Want to try the quiz again or review the lesson?

Review lesson

>

Try again

¡Oh, no! Missed a few on : Working with File Formats. No worries! Want to try the quiz again or review the lesson?

Review lesson

>

Try again