What are three ways to create a new workbook in Excel 2019?
1. Using an existing template
2. Using an online template
3. Create a blank workbook from
... [Show More] scratch
Users can save a workbook in Excel 2019 using which item?
Quick Access Toolbar
Which data format in Excel 2019 treats text as text and numbers as numbers?
General
Which are ways to add worksheets to a workbook in Excel 2019? Choose three answers.
1. Right-click an existing sheet, click Insert, and click the OK button
2. Click the plus sign button near the existing worksheets
3. Open the Home tab, click the Insert drop-down arrow, and click Insert Sheet
Which are two ways to copy a worksheet in Excel 2019?
1. While holding the Ctrl key on the keyboard, click and drag the worksheet to a new location
2. Right-click a worksheet tab and click Move or Copy
The Find and Select feature in Excel 2019 is located in which tab on the ribbon?
Home
Which feature on the Excel 2019 ribbon is used to navigate to the last cell of a worksheet?
Go To Special
The Format drop-down menu is found under which group on the ribbon?
Cells
Which symbol indicates where a worksheet will be placed during the click and drag method of moving a worksheet in Excel 2019?
Black arrow
Rows and columns can be inserted and deleted using the ribbon under the ___________ tab or by right-clicking the row or column
Home
Users can change the theme of an Excel 2019 workbook using which tab?
Page Layout
Which are two ways to add headers and footers in an Excel 2019 document?
1. Click the Page Layout tab, click the Page Setup dialog box launcher, and click the Header/Footer tab
2. Click the View tab and Page Layout
Which signifies that there is a hidden worksheet in an Excel document?
The Unhide Sheets option under Hide & Unhide in the Format drop-down menu will not be grayed out
Which item is used to add commands to the Quick Access toolbar?
Drop-down arrow on the Quick Access toolbar
In addition to the ribbon, users can change workbook views by using the formula bar
False
The Freeze Panes feature is located under which tab in Excel 2019?
View
In Excel 2019, document properties can be modified from which location?
Advanced Properties
In order to set a print area, users need to go to the __________ tab in Excel 2019.
Page Layout
Which is the default setting for printing documents in Excel 2019?
Excel will only print the active worksheet
Which are items Excel 2019 will look into when checking for accessibility issues? Choose two answers.
1. Colors
2. Font size
Initially, how many worksheets does a user have access to in a blank Excel 2019 workbook?
One
Which two file formats are used to import delimited data?
1. .csv
2. .txt
Which tab on the ribbon is used to add sheets to an Excel 2019 workbook?
Home
Which drop-down arrow is used to move or copy a worksheet?
Format [Show Less]