Microsoft Excel 2019/365 Essentials

start>

Quiz

Microsoft Excel 2019/365 Essentials

Tools for forecasting trends in data

Tools for connecting to live data sources and transforming data

Tools for sorting and filtering data

question 1 of 14

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

CORRECT!

>

Calculates mathematical equations; It provides options for page layout.

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

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

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?

CORRECT!

>

Chart customization and data visualization settings

Data analysis tools, formula functions, and formatting options

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

question 3 of 14

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

CORRECT!

>

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

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

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

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

CORRECT!

>

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

Open formula bar; Status: "Editing."

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

question 5 of 14

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

CORRECT!

>

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

Use "Sort" function; Scan the worksheet manually.

Manual scrolling only; No specific search tool.

question 6 of14

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

CORRECT!

>

No column insertion; Only row addition.

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

Delete a column first; Existing columns shift right.

question 7 of14

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

Of course, you are right!

>

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."

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

question 8 of 14

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

CORRECT!

>

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

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

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

question 9 of 14

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

CORRECT!

>

Accounting

Currency

Number

question 10 of 14

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

CORRECT!

>

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

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

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

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?

CORRECT!

>

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.

question 12 of 14

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

CORRECT!

>

It opens the Save As menu.

It saves the workbook with its existing name.

It opens the workbook.

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?

CORRECT! ALMOST THERE!

>

.xlsx

.csv

.xls

question 14 of 14

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

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

>

>

<

Quiz completed

Review lesson

Try again

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

>