Katerina wants to save all of her print settings along with any display settings she currently has configured for a worksheet. Which of the following allows her to do this?
Nick has chosen to hide a worksheet that contains sensitive data when presenting information from his workbook. Which statement is correct?
Which of the following functions returns the total of all values in a range of cells?
Which of the following mouse actions selects a range of cells C4:G4?
The top left corner of the Excel UI contains commands that are frequently used and is customizable. What is the name of this area?
Liam would like to duplicate the formatting of cells in an easy fashion. Which option should he use?
Which characters in the function shown represent the arguments? =MAX(B2:B6,C4,100)
In addition to the format commands that are found in the ribbon, which option is available for more extensive formatting?
Which of the following keys on the keyboard moves the position of the cursor from one cell to the next cell on the right?
What is the term used to identify an individual page within the Excel 2019 program?
Other than the New Sheet button, which method can be used to add an additional worksheet to a workbook?
The File tab on the ribbon opens a new view in the Excel UI that has access to various options and customization. What is this area called?
Xavier wants to ensure that if he scrolls down through a worksheet that contains numerous rows of data that the initial column headings are not scrolling, making it easier to read the information in the spreadsheet. Which step should Xavier follow?
Which keyboard shortcut will create a hyperlink in an Excel document?
Lily has a cell value in a formula listed as $C$4. Which of the following is the correct term to describe this?
Did you find these answers helpful?