AnswersGA-Business and TechnologyManaging Workbook Properties

Managing Workbook Properties — Unit test Answers

0 verified answers
1
Free Preview

Which character will always precede an Excel formula?

A
+
B
!
C
=
D
/=
2
Free Preview

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

A
Format Cells dialog box
B
Quick Access tool bar
C
Format Painter
D
Ribbon
3

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

A
=SUM(F2:F5,Sheet2A10)
B
=SUM(F2:F5,Sheet2!A10)
C
=SUM(F2:F5,!Sheet2A10)
D
=SUM(F2:F5,_Sheet2A10)
4

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

A
Ctrl+F
B
Ctrl+H
C
Ctrl+K
D
Ctrl+End
5

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

A
The data in all of the cells is deleted.
B
The data in only some of the cells is deleted.
C
The cells can no longer be referenced in functions or formulas.
D
The cells can still be referenced in functions or formulas.
6

Excel 2016 is primarily what type of program?

A
word processor
B
presentations
C
database management
D
spreadsheet
7

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

A
status bar
B
View tab
C
search field
D
Quick Access tool bar
8

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?

A
Hide the column heading rows.
B
Freeze the column heading rows.
C
Split the worksheet.
D
Merge the worksheet.
9

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

A
Ctrl+H
B
Ctrl+R
C
Ctrl+F
D
Ctrl+E
10

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

A
Page Setup
B
Backstage view
C
Print Area
D
Option
11

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

A
The worksheets that are hidden will retain data, but references to those worksheets will no longer function.
B
The worksheets that are hidden will have their data removed.
C
The worksheets that are hidden will retain their data, and references will continue to function as normal
D
You will have to unhide the worksheets to make references function correctly.
12

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

A
Collation Settings
B
Orientation Settings
C
Margin Settings
D
Scaling Settings
13

What is required to utilize Excel Online?

A
local administrative account
B
product key for Excel
C
Office 365 user account
D
compact disc version of Excel

Did you find these answers helpful?