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

Study Notes

Excel 2019 Level 1 Course Information

Course number: 0200-100-19-W
Course release number: 1
Software release number: 2019
Release date: April 26, 2019
Developed by: Brian Ireson, Marissa Kain, Thelma C. Tippie
Edited by: Suzanne Hixon, Thelma Tippie, and Jeffrey DeRamus
Published by: The Computer Workshop, Inc.
Address: 5200 Upper Metro Place, Suite 140, Dublin, Ohio 43017
Phone number: (614) 798-9505
Company DBA: RoundTown Publishing

Excel 2019 Level 1 Course Details

Contains 6 lessons (1-6)
Rel 1, 4/26/2019
Lesson 1: Getting Started
- About Excel
Starting Excel
- Using the Shortcut on the Desktop
- Using the Taskbar
- Using the Start Menu
- Using the Search
Excel Elements
- Interface Elements
  - Quick Access Toolbar (QAT)
  - User Account Information
  - Ribbon
  - Formula Bar
  - Name Box
  - Scroll Bars
  - Sheet Tabs
- Worksheet Elements
  - Worksheet
  - Columns
  - Rows
  - Cell
  - Active Cell
  - Cell Address
The Ribbon
- Mini Toolbar and Shortcut Menu
- Quick Access Toolbar (QAT)
- Customizing the Ribbon
- Opening and Viewing Workbooks
- Cursor Movement
- Saving a Workbook
- Workbook Conversion and Compatibility
- Closing a Workbook
Lesson 2: Creating a Workbook
- Creating a Workbook
- Document Properties
- Custom Properties
- Searching for Files Using Properties
- Entering Information
- Auto Fill
- Custom Lists
- Flash Fill
- Editing Cells
- Entering Numbers
Lesson 3: Introduction to Formulas
- Creating a Formula
- Creating a Function Formula
- AutoSum
- Formula Errors
- Cell Addressing
- Inspecting Documents
Lesson 4: Formatting a Worksheet
- Inserting Rows & Columns
- Inserting Cells
- Deleting Rows, Columns & Cells
- Undo and Redo
- Changing Column Width
- Changing Row Height
- Font Formatting
- Aligning Text
- Cell Formatting
Lesson 5: Viewing, Page Layout and Printing
- Excel Views
- Print Preview
- Headers and Footers
- Page Setup
- Sheet Options
- Scale to Fit
- Printing
Lesson 6: Proofing and Editing
- Checking Spelling
- AutoCorrect and AutoComplete
- Find
- Replace
- Smart Lookup

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Description

This quiz covers the fundamental concepts of Excel 2019 as outlined in the Level 1 course. Get ready to explore the essential features, functionalities, and the layout of the Excel interface. Perfect for beginners looking to enhance their spreadsheet skills!