Have an account?
Skip to Content
Introducing new Paper mode
No student devices needed. Know more
10 questions
Show Answers
See Preview
- Multiple ChoicePlease save your changes before editing any questions.
Which function returns the count of days between two dates?
STARTDATE
ENDDATE
DAYS()
DAYS ( )
ISOWEEKNUM()
- Multiple ChoicePlease save your changes before editing any questions.
Which tool do you use to trace the relationship between two cells in a worksheet?
Conditional Formatting
Formula Auditing
Watch Window
What-If Analysis
Sparkline
- Multiple ChoicePlease save your changes before editing any questions.
Which feature do you use to create an active email address in a worksheet?
Link to External Recipient
Create Email Link
Insert Hyperlink
Add Conditional Formatting to Cell
Add External User
- Multiple ChoicePlease save your changes before editing any questions.
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?
Normal
Page Layout
Page Break Preview
Custom Views
Gridline
- Multiple ChoicePlease save your changes before editing any questions.
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.
- Multiple ChoicePlease save your changes before editing any questions.
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.
- Multiple ChoicePlease save your changes before editing any questions.
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.
- Multiple ChoicePlease save your changes before editing any questions.
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
- Multiple ChoicePlease save your changes before editing any questions.
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.
- Multiple ChoicePlease save your changes before editing any questions.
Based on the image above, which cell format category do you apply to the zip code data displayed if the original value was 902108767?
Special
Number
Scientific
Accounting
Data