Excel 2019 Level 1 Course Overview

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What happens when you click [Don’t Save] in the warning box?

You are prompted to save the workbook again.
Excel will automatically revert to the last saved state.
All changes made to the workbook are saved.
The workbook is closed without any changes being saved. (correct)

Which keyboard shortcut can be used to close a workbook in Excel?

[Ctrl + W] (correct)
[Shift + X]
[Ctrl + N]
[Alt + F4]

What will occur if you attempt to close Book1 after making changes?

You will be able to save changes without any warnings.
The workbook will close automatically without any prompts.
The changes will be saved to a new workbook automatically.
A warning will appear asking if you want to save changes. (correct)

What is the expected outcome after closing Student Grades while My_List is still open?

Only the Student Grades workbook will close. (B) Signup and view all the answers

What does pressing an underlined letter on a keyboard accomplish in message windows?

It triggers the corresponding button on the message window. (A) Signup and view all the answers

What format does Excel 2019 use by default to save files?

.xlsx (B) Signup and view all the answers

Which of the following file extensions is associated with an Excel macro-enabled workbook?

.xlsm (D) Signup and view all the answers

Which of the following actions would allow you to quickly display the Save As dialog in Excel 2019?

Press [F12] (A) Signup and view all the answers

If you want to save a file that can be opened in Excel 2007, 2010, or 2013, which format should you choose?

.xlsx (A) Signup and view all the answers

Which file extension would you use to create a template that can contain macros?

.xltm (A) Signup and view all the answers

What will you find in the Save As dialog regarding your file's path?

Address Bar with folder name and path (B) Signup and view all the answers

What is the purpose of improved controls in Excel 2019 regarding personal information?

To manage hidden data and document profiles before sharing (A) Signup and view all the answers

Which file extension represents an Excel add-in file?

.xlam (C) Signup and view all the answers

What is the purpose of the Mini Toolbar and Shortcut Menus in Excel 2019?

To allow quick access to common commands without changing tabs. (D) Signup and view all the answers

How can you access the Mini Toolbar in Excel 2019?

By right-clicking on a selected cell or range of cells. (D) Signup and view all the answers

What visual cue indicates an active cell in Excel 2019?

A thick black border surrounding the cell. (D) Signup and view all the answers

Which action will make text bold in Excel 2019?

Pressing [Ctrl + B]. (A) Signup and view all the answers

What happens when you type in a cell and press [Ctrl + Enter]?

The content is added and the cell remains active. (D) Signup and view all the answers

What is associated with documents in a document library?

Document properties (B) Signup and view all the answers

What feature provides a description of a button in the Ribbon when hovered over?

Tooltip. (B) Signup and view all the answers

Which tab must you click on to access the Font Group in Excel 2019?

Home Tab. (A) Signup and view all the answers

Which property is NOT typically included when adding documents to a library?

File Size (C) Signup and view all the answers

What does pressing the [Up Arrow] key do after selecting a cell in Excel 2019?

It moves the selection to the cell directly above. (B) Signup and view all the answers

What must users do if they need to correct a document property after adding it?

Update the properties (A) Signup and view all the answers

How can a user access the additional document properties in the Backstage view?

Select the Info category (A) Signup and view all the answers

What happens when a user clicks on the 'Show All Properties' link?

The list of properties expands (D) Signup and view all the answers

What happens if the 'Show the Start screen when this application starts' option is turned off in Excel?

Excel will open a new Blank Workbook automatically. (B) Signup and view all the answers

Which key combination can be used to create a new Blank Workbook in Excel?

[Ctrl + N] (B) Signup and view all the answers

How can you access the option to create a new Blank Workbook once an Excel file is already open?

Use the File tab and select New. (C) Signup and view all the answers

What is the purpose of Featured Templates in Excel when creating a new Workbook?

To present pre-existing formats for specific data types. (C) Signup and view all the answers

Which action will NOT create a new Blank Workbook in Excel?

Selecting a template from the Featured Templates. (B) Signup and view all the answers

What can you do to create a new Workbook if Excel is already open and you wish to start from scratch?

Click on the QAT to access the New button. (A) Signup and view all the answers

What is a key feature of Custom Properties in Excel?

They enable searching for files using these properties. (A) Signup and view all the answers

Which of the following statements is true regarding the Auto Fill feature in Excel?

It allows for the automatic completion of cell entries based on patterns. (A) Signup and view all the answers

What happens if a file created in Excel 2007 or 2010 is opened in Excel 2019 without conversion?

The file may appear locked and uneditable. (C) Signup and view all the answers

What is the function of the 'Switch Windows' drop-down button in Excel?

It helps to switch between opened workbooks. (D) Signup and view all the answers

What does the Message Bar indicate when a file is opened in Protected View?

The file may contain malware. (B) Signup and view all the answers

How can you temporarily disable Protected View for a file?

By clicking the 'Enable Editing' button in the Message Bar. (B) Signup and view all the answers

What must be done to use Excel 2019 features with an older file format?

You need to convert or save it as .xlsx format. (D) Signup and view all the answers

What represent a method to switch between applications in Windows?

[Alt + Tab] allows switching between workbooks and programs. (C) Signup and view all the answers

What is a potential action after disabling Protected View permanently?

It prevents warnings when opening files from unsafe locations. (B) Signup and view all the answers

Where can you select the option to disable Protected View for the program?

On the [File] tab, then [Options]. (D) Signup and view all the answers

Flashcards

Mini Toolbar

A floating toolbar in Excel providing quick access to common commands for selected objects.

Shortcut Menu

A context-sensitive menu that appears when you right-click on an object, providing relevant options.

Ribbon

The set of toolbars located at the top of the Excel window, organizing various commands and tools.

Home Tab

The first tab on the Ribbon in Excel, containing frequently used commands like font styles and clipboard options.