Completed
Spreadsheet Checks
In this video, learn how to create quality spreadsheet templates and process spreadsheet quality checks.
Rating
0
0
There are no comments for now.
Join this Course
to be the first to leave a comment.
1.
How do I make the value of a specific spreadsheet cell dependent on the values of multiple other cells?
Click on the cell, and type in the names of the other cells
Right-click on the cell, select ‘Dependencies’, and enter the names of the other cells in the pop-up window that appears
Click on the cell, and type an equation in the formula field above the spreadsheet
It is not possible to make a cell’s value dependent on the values of other cells
2.
For a spreadsheet check to pass, what must the value of the spreadsheet’s success cell be?