Advanced Formatting — Unit test Answers

0 verified answers
1
Free Preview

Which character will always precede an Excel formula?

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

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

A
=
B
$
C
!
D
( )
3

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.
4

Excel 2016 is primarily what type of program?

A
word processor
B
presentations
C
database management
D
spreadsheet
5

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
6

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.
7

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

A
Backstage view
B
Format tab
C
Insert tab
D
Worksheet context menu
8

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)
9

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

A
=
B
MAX
C
(B2:B6,C4,100)
D
( ,

Did you find these answers helpful?