Computer Applications Unit Text

Other than the New Sheet button, which method can be used to add an additional worksheet to a workbook?

a. Backstage view

Which setting is used to determine the order of printing pages?

a. Collation Settings

Which character is used to create an absolute reference to a cell?

b. $

Anna needs to reference a cell on another worksheet in her workbook. What is the correct syntax for this operation?

b. =SUM(F2:F5,Sheet2!A10)

Which key(s) will launch the Spelling Checker dialog box?

b. F7

On which tab are the print commands in Excel 2016 accessed?

b. File (Backstage)

In addition to the format commands that are found in the ribbon, which option is available for more extensive formatting?

b. Format Cells dialog box

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?

b. Freeze the column heading rows.

Which characters in the function shown represent the arguments? =MAX(B2:B6,C4,100)

c. (B2:B6,C4,100)

Which character will always precede an Excel formula?

c. =

Which combination of options is the keyboard shortcut to access the Find dialog box and search a worksheet for particular values?

c. Ctrl+F

Which keyboard shortcut will create a hyperlink in an Excel document?

c. Ctrl+K

Liam would like to duplicate the formatting of cells in an easy fashion. Which option should he use?

c. Format Painter

What is required to utilize Excel Online?

c. Office 365 user account

Donte needs to print specific sections in the workbook, as opposed to the entire workbook. Which feature should he use?

c. Print Area

Nick has chosen to hide a worksheet that contains sensitive data when presenting information from his workbook. Which statement is correct?

c. The worksheets that are hidden will retain their data, and references will continue to function as normal

Where are commonly accessed commands located by default in Excel 2016?

d. Quick Access tool bar

Lisa intends to use the Hide command on a column in her spreadsheet. How are the cells in this column affected by this command?

d. The cells can still be referenced in functions or formulas.

Excel 2016 is primarily what type of program?

d. spreadsheet