Have an account?
No student devices needed. Know more
Which function returns the count of days between two dates?
DAYS ( )
Which tool do you use to trace the relationship between two cells in a worksheet?
Which feature do you use to create an active email address in a worksheet?
Link to External Recipient
Create Email Link
Add Conditional Formatting to Cell
Add External User
Based on the image above, which Workbook view do you choose to change options for displaying the file name on each page of a printout?
Page Break Preview
Based on the image above, where Data Set A and Data Set B are pasted as pictures, why is it that after both source files are edited the changes are applied to Data Set B and not to Data Set A?
Data Set A is pasted as a transposed table.
Data Set A is pasted with conditional formatting.
Data Set B is pasted as a linked picture.
Data Set B is pasted as a scaled picture.
Data Set B is pasted with source formatting.
You use Backstage view to:
enter VBA code.
simultaneously see two files.
manage files and the information about them.
create what-if scenarios without making changes to the file.
set the default PivotTable and PivotChart styles.
You have multiple worksheets and want to create a watch window to keep track of values in the spreadsheets.
Based on the scenario above, how do you create a watch window for multiple worksheets?
Set up watch windows for each individual worksheet.
Set up one watch window that references multiple worksheets.
Incorporate a watch window into the ribbon.
Choose Watch Multiple Worksheets from the watch window.
Set up the initial watch window and copy it to multiple locations in the worksheets.
Which of the following do you select to manually adjust margins in the Backstage view?
Change Margins Manually button in the Info group
Options button at the bottom of the menu list
Show Margins button on the Print page
Print Preview button in the Options group
Page Setup link in the Print group
When you use the Mark As Final command, it:
makes the workbook read-only.
allows editing only by an enterprise-level user.
creates a history of all changes made to the workbook.
creates a backup version of the workbook that is saved to a temporary folder.
keeps formulas from importing data from linked spreadsheets.
Based on the image above, which cell format category do you apply to the zip code data displayed if the original value was 902108767?